Saved query 83c711033a073192

Data Explorer

Query the US Nationwide Parcel Dataset

$1.75 / 1,000 records$100 minimum

39/80

Live SQL

SELECT * 
FROM "lr_parcel_us" 
WHERE statefp = '27' 
  AND countyfp = '123'

165,012 matching parcels

Data Preview

parcelid	statefp	countyfp	parceladdr	parcelstate	ownername	owneraddr	ownercity	ownerstate	ownerzip	countyname	cousubfp	cousubname	tractce	tractname	calcarea	fldzone	elevmin	elevmax	elevavg	usecode	usedesc	taxacres	ownertype	legaldesc	township	section	qtrsection	range	plssdesc	parceltype	accesstype	iucnclass	placename	placetype	lrversion
033022110009	27	123	1600 COUNTY ROAD J E	MN	RAMSEY COUNTY GOVERNMENT	2015 VAN DYKE ST N	SAINT PAUL	MN	55109	RAMSEY	69916	WHITE BEAR	040101	401.0100	614292.8806	—	277.3299	292.5529	279.9916	641	EXEMPT, VACANT LAND	151.8000	PERSON	SECTION 3 TOWN 30 RANGE 22 LOT …	30	03	NWNE	22	T30N, R22W, SEC 03, NWNE	GOVT LOCAL	RESTRICTED		BALD EAGLE-OTTER LAKES - BALD E…	LOCAL PARK	2026.2
037-360160006010	27	123		MN	METRO SEWER BOARD	390 ROBERT ST N, SAINT PAUL MN …				RAMSEY	58000	ST. PAUL	980000	9800	75603.2478	—	211.6000	213.2929	211.9685		METROPOLITAN WASTE CONTROL COMM…	18.6800	PERSON												2026.2
	27	123		MN	UNITED STATES NATIONAL PARK SER…					RAMSEY	58000	ST. PAUL	980000	9800	472.9994	—	211.5681	211.7018	211.6397				GOVERNMENT							GOVT FEDERAL	OPEN	OTHER	MISSISSIPPI NATIONAL RIVER AND …	WILD AND SCENIC RIVER	2026.2
	27	123		MN	UNITED STATES FISH AND WILDLIF…					RAMSEY	02026	ARDEN HILLS	040801	408.0100	14321.0705	—	273.3548	278.2498	275.2902				GOVERNMENT							GOVT FEDERAL	CLOSED	V	MINNESOTA VALLEY NATIONAL WILDL…	CONSERVATION EASEMENT	2026.2
	27	123		MN	CITY GOVERNMENT					RAMSEY	58000	ST. PAUL	037601	376.0100	169.7953	—	250.0727	251.0614	250.5290				PERSON							GOVT LOCAL	OPEN		HOMECROFT REC CENTER	LOCAL RECREATION AREA	2026.2
	27	123		MN	CITY GOVERNMENT					RAMSEY	37502	LITTLE CANADA	042101	421.0100	2373.8630	—	275.4317	277.9544	276.9377				PERSON							GOVT LOCAL	OPEN		NADEAU PARK	LOCAL PARK	2026.2
	27	123		MN	CITY GOVERNMENT					RAMSEY	58000	ST. PAUL	034601	346.0100	653.7965	—	259.5785	261.8528	261.2582				PERSON							GOVT LOCAL	OPEN		AMERICAN INDIAN MAGNET AT MOUND…	LOCAL PARK	2026.2
	27	123		MN	CITY GOVERNMENT					RAMSEY	58000	ST. PAUL	036900	369	6109.2774	—	217.8858	237.8679	233.3965				PERSON							GOVT LOCAL	OPEN		SPECIAL EDUCATION)	LOCAL PARK	2026.2
	27	123		MN	CITY GOVERNMENT					RAMSEY	58000	ST. PAUL	037403	374.0299	530.7604	—	290.8285	293.8107	292.3144				PERSON							GOVT LOCAL	OPEN		HIGHWOOD HILLS ELEMENTARY	LOCAL PARK	2026.2
	27	123		MN	CITY GOVERNMENT					RAMSEY	58000	ST. PAUL	036900	369	737.5703	—	236.8319	238.1009	237.4019				PERSON							GOVT LOCAL	OPEN		SPECIAL EDUCATION)	LOCAL PARK	2026.2
	27	123		MN	CITY GOVERNMENT					RAMSEY	58000	ST. PAUL	030500	305	122.7275	—	264.5401	265.2720	264.8649				PERSON							GOVT LOCAL	OPEN		NORTH END ELEMENTARY	LOCAL PARK	2026.2
	27	123		MN	CITY GOVERNMENT					RAMSEY	58000	ST. PAUL	034601	346.0100	2410.8995	—	261.8158	267.1853	264.3707				PERSON							GOVT LOCAL	OPEN		AMERICAN INDIAN MAGNET AT MOUND…	LOCAL PARK	2026.2
	27	123		MN	CITY GOVERNMENT					RAMSEY	58000	ST. PAUL	034601	346.0100	148.4665	—	261.1905	261.7908	261.4377				PERSON							GOVT LOCAL	OPEN		AMERICAN INDIAN MAGNET AT MOUND…	LOCAL PARK	2026.2
	27	123		MN	CITY GOVERNMENT					RAMSEY	58000	ST. PAUL	033900	339	558.1628	—	275.1860	278.8872	276.6206				PERSON							GOVT LOCAL	OPEN		RONDO EDUCATION CENTER	LOCAL PARK	2026.2
	27	123		MN	CITY GOVERNMENT					RAMSEY	58000	ST. PAUL	034602	346.0200	14285.0379	—	270.7882	278.5781	276.1970				PERSON							GOVT LOCAL	OPEN		HARDING SENIOR HIGH	LOCAL PARK	2026.2
	27	123		MN	CITY GOVERNMENT					RAMSEY	58000	ST. PAUL	034602	346.0200	56201.1629	—	270.9020	283.1557	274.9310				PERSON							GOVT LOCAL	OPEN		HARDING SENIOR HIGH	LOCAL PARK	2026.2
	27	123		MN	CITY GOVERNMENT					RAMSEY	58000	ST. PAUL	034602	346.0200	828.8164	—	274.5240	276.7007	275.8367				PERSON							GOVT LOCAL	OPEN		HARDING SENIOR HIGH	LOCAL PARK	2026.2
	27	123		MN	RAMSEY COUNTY GOVERNMENT					RAMSEY	58000	ST. PAUL	031000	310	6601.6151	—	269.3309	271.0011	270.1054				PERSON							GOVT LOCAL	RESTRICTED		GUSTAFSON-PHALEN ICE ARENA	LOCAL PARK	2026.2
	27	123		MN	CITY GOVERNMENT					RAMSEY	58000	ST. PAUL	031000	310	314.2821	—	275.2047	275.6690	275.3748				PERSON							GOVT LOCAL	OPEN		JOHNSON SENIOR HIGH	LOCAL PARK	2026.2
	27	123		MN	CITY GOVERNMENT					RAMSEY	58000	ST. PAUL	031000	310	4580.5006	—	268.0711	274.6994	271.0657				PERSON							GOVT LOCAL	OPEN		JOHNSON SENIOR HIGH	LOCAL PARK	2026.2
	27	123		MN	CITY GOVERNMENT					RAMSEY	58000	ST. PAUL	030500	305	713.5219	—	263.3709	264.6558	263.7107				PERSON							GOVT LOCAL	OPEN		MCDONOUGH REC CENTER	LOCAL RECREATION AREA	2026.2
	27	123		MN	CITY GOVERNMENT					RAMSEY	58000	ST. PAUL	030602	306.0200	4416.2042	—	272.7478	274.2870	273.4619				PERSON							GOVT LOCAL	OPEN		WHEELOCK PKWY TRIANGLES	LOCAL PARK	2026.2
	27	123		MN	CITY GOVERNMENT					RAMSEY	58000	ST. PAUL	030602	306.0200	2780.7282	—	273.4187	275.1638	274.3320				PERSON							GOVT LOCAL	OPEN		WHEELOCK PKWY TRIANGLES	LOCAL PARK	2026.2
	27	123		MN	CITY GOVERNMENT					RAMSEY	58000	ST. PAUL	030702	307.0200	695.4257	—	301.1328	303.0289	302.3864				PERSON							GOVT LOCAL	OPEN		HAYDEN HEIGHTS ELEMENTARY	LOCAL PARK	2026.2
	27	123		MN	CITY GOVERNMENT					RAMSEY	58000	ST. PAUL	037604	376.0400	6534.2545	—	239.3770	241.2940	240.2486				PERSON							GOVT LOCAL	OPEN		CROSBY FARM REGIONAL PARK	LOCAL PARK	2026.2