Saved query b83a9a3adde08dbc

Data Explorer

Query the US Nationwide Parcel Dataset

$1.75 / 1,000 records$100 minimum

40/80

Live SQL

SELECT * 
FROM "lr_parcel_us" 
WHERE statefp = '06' 
  AND countyfp = '019'

310,699 matching parcels

Data Preview

parcelid	statefp	countyfp	parceladdr	parcelstate	ownername	countyname	cousubfp	cousubname	tractce	tractname	calcarea	fldzone	elevmin	elevmax	elevavg	ownertype	parceltype	accesstype	iucnclass	placename	placetype	lrversion
30346043	06	019	NONE NONE NONE NONE	CA		FRESNO	91080	FRESNO	004406	44.0600	18172.4844	—	108.6028	109.8041	109.1067					7675 N. 1ST STREET # 108		2026.2
	06	019		CA	CITY GOVERNMENT	FRESNO	91080	FRESNO	005801	58.0100	1623.1504	—	108.4899	109.3315	109.0846	PERSON	GOVT LOCAL	OPEN		BASIN IE PARK	LOCAL PARK	2026.2
	06	019		CA	UNITED STATES NATIONAL PARK SER…	FRESNO	93010	SIERRA	006411	64.1100	6.7981	—	3935.5561	3937.3837	3936.4945	GOVERNMENT	GOVT FEDERAL	OPEN	II	KINGS CANYON NATIONAL PARK	NATIONAL PARK	2026.2
	06	019		CA	UNITED STATES FOREST SERVICE	FRESNO	93010	SIERRA	006411	64.1100	23.6875	—	400.0304	403.1831	401.8526	GOVERNMENT	GOVT FEDERAL	OPEN	OTHER	SEQUOIA NATIONAL FOREST	NATIONAL FOREST	2026.2
	06	019		CA	UNITED STATES FOREST SERVICE	FRESNO	93010	SIERRA	006408	64.0800	40.4950	—	2394.5256	2400.8544	2397.3543	GOVERNMENT	GOVT FEDERAL	OPEN	OTHER	SIERRA NATIONAL FOREST	NATIONAL FOREST	2026.2
	06	019		CA	UNITED STATES FOREST SERVICE	FRESNO	93010	SIERRA	006411	64.1100	30.4944	—	384.9797	389.0498	386.4522	GOVERNMENT	GOVT FEDERAL	OPEN	OTHER	SEQUOIA NATIONAL FOREST	NATIONAL FOREST	2026.2
	06	019		CA	UNITED STATES FOREST SERVICE	FRESNO	93010	SIERRA	006408	64.0800	50.1295	—	2912.2053	2917.6530	2913.8559	GOVERNMENT	GOVT FEDERAL	OPEN	OTHER	SIERRA NATIONAL FOREST	NATIONAL FOREST	2026.2
	06	019		CA	UNITED STATES FOREST SERVICE	FRESNO	93010	SIERRA	006411	64.1100	13.0975	—	1082.4221	1082.8206	1082.5745	GOVERNMENT	GOVT FEDERAL	OPEN	OTHER	KINGS RIVER ROADLESS AREA	INVENTORIED ROADLESS AREA	2026.2
	06	019		CA	UNITED STATES FOREST SERVICE	FRESNO	93010	SIERRA	006411	64.1100	26.2792	—	852.8345	855.8057	854.0254	GOVERNMENT	GOVT FEDERAL	OPEN	OTHER	KINGS RIVER ROADLESS AREA	INVENTORIED ROADLESS AREA	2026.2
	06	019		CA	CITY GOVERNMENT	FRESNO	91080	FRESNO	005804	58.0400	11984.2860	—	105.1639	107.4709	106.2409	PERSON	GOVT LOCAL	OPEN		CLOVIS OLD TOWN TRAIL	LOCAL RECREATION AREA	2026.2
	06	019		CA	CITY GOVERNMENT	FRESNO	91080	FRESNO	004211	42.1100	77.9895	—	95.4067	95.6344	95.5371	PERSON	GOVT LOCAL	OPEN		GREENWAY	LOCAL OTHER OR UNKNOWN	2026.2
	06	019		CA	STATE OF CALIFORNIA	FRESNO	93010	SIERRA	006405	64.0500	1663.2539	—	274.3949	384.5410	349.3145	GOVERNMENT	GOVT STATE	OPEN		MILLERTON LAKE STATE RECREATION…	STATE RECREATION AREA	2026.2
	06	019		CA	NON-GOVERNMENTAL ORGANIZATION	FRESNO	93010	SIERRA	006406	64.0600	523.2165	—	750.5044	776.2404	763.3939	PERSON	NGO	CLOSED		BLACK MOUNTAIN EASEMENT	CONSERVATION EASEMENT	2026.2
49508402	06	019	4063 N PHILLIP AVE	CA		FRESNO	91080	FRESNO	005804	58.0400	709.0138	—	107.2108	107.8557	107.5161							2026.2
51115228	06	019	5432 W DAYTON AVE	CA		FRESNO	91080	FRESNO	003811	38.1100	573.3553	—	86.0677	86.9768	86.4959							2026.2
41033603	06	019	3037 E FREMONT AVE	CA		FRESNO	91080	FRESNO	005605	56.0500	672.3178	—	107.5254	107.8480	107.6454							2026.2
42438220	06	019	4549 N HOLT AVE	CA		FRESNO	91080	FRESNO	004706	47.0600	557.4266	—	94.7999	95.5394	95.0512							2026.2
44217221	06	019	2813 N CRYSTAL AVE	CA		FRESNO	91080	FRESNO	003702	37.0200	585.4336	—	91.1134	91.5109	91.3316							2026.2
41020201	06	019	3339 E SIERRA AVE	CA		FRESNO	91080	FRESNO	005605	56.0500	761.6257	—	107.2666	107.8958	107.4941							2026.2
44417206	06	019	1546 E YALE AVE	CA		FRESNO	91080	FRESNO	003500	35	783.0288	—	92.2700	92.8690	92.5896							2026.2
31240024	06	019	1171 N HAYES AVE	CA		FRESNO	91080	FRESNO	003812	38.1200	9627.2221	—	79.3718	81.6116	80.3489							2026.2
41725136	06	019	281 W SAN JOSE AVE	CA		FRESNO	91080	FRESNO	004505	45.0500	336.9408	—	98.5293	98.9225	98.6614							2026.2
44411110	06	019	717 W YALE AVE	CA		FRESNO	91080	FRESNO	003701	37.0100	612.8712	—	90.7434	91.3852	90.9943							2026.2
56838047	06	019	2859 E CHRISTOPHER DR	CA		FRESNO	91080	FRESNO	005505	55.0500	585.1797	—	113.1220	113.8281	113.5625							2026.2
31059216	06	019	3171 N REDDA RD	CA		FRESNO	91080	FRESNO	005904	59.0400	433.1849	—	108.3508	108.9867	108.7127							2026.2