Saved query 1ca1966d5f903949

Data Explorer

Query the US Nationwide Parcel Dataset

$1.75 / 1,000 records$100 minimum

0/80

Live SQL

SELECT * 
FROM "parcel_layer" 
WHERE statefp = '01' 
  AND countyfp = '087'

20,113 matching parcels

Data Preview

parcelid	taxacctnum	statefp	countyfp	parceladdr	parcelcity	parcelstate	parcelzip	countyname	cousubfp	cousubname	tractce	tractname	calcarea	numbldgs	firmid	firmdate	fldzone	zonesubty	elevmin	elevmax	elevavg	usecode	taxacres	naicscode	book	parceltype	accesstype	iucnclass	placename	placetype
0701120000001000	172412	01	087			AL	36083	Macon	92403	Notasulga	231500	2315	78716.2071		01087C	2026-01-23	X	AREA OF MINIMAL FLOOD HAZARD	101.3353	130.7862	113.0838	500	19.4501	1132	0701	GOVT FEDERAL	RESTRICTED	OTHER	TUSKEGEE NATIONAL FOREST	NATIONAL FOREST
0709303001054000	172430	01	087	GENE & SONS AUTO REPAIR	TUSKEGEE	AL	36083	Macon	93230	Tuskegee	231800	2318	895.2327		01087C	2026-01-23	X	AREA OF MINIMAL FLOOD HAZARD	122.1622	124.3125	123.6112	500	0.2212	4911	0709303				1 STOP CASH	FINANCIAL_SERVICE
0706130000004000	172413	01	087	43 SPRATLIN HOLW	TUSKEGEE	AL	36083	Macon	92403	Notasulga	231500	2315	69130.8372	5	01087C	2026-01-23	X	AREA OF MINIMAL FLOOD HAZARD	130.3596	155.9647	142.6720	500	17.0813		0706
0605160000005002	172516	01	087	8674 UNITED STATES HIGHWAY 80 E…	TUSKEGEE	AL	36083	Macon	91917	Little Texas-Society Hill	231400	2314	161496.8222	3	01087C	2026-01-23	X	AREA OF MINIMAL FLOOD HAZARD	141.1152	156.8960	149.5322	500	39.9044		0605
0504190000009000	172619	01	087	1245 ROGERS RD	AUBURN	AL	36830	Macon	91917	Little Texas-Society Hill	231400	2314	11046.6391	2	01087C	2026-01-23	X	AREA OF MINIMAL FLOOD HAZARD	127.9639	135.7359	132.4867	500	2.7293		0504
0309310000009000	182431	01	087	5497 STATE HIGHWAY 81	NOTASULGA	AL	36866	Macon	92403	Notasulga	231500	2315	9207.9806	1	01087C	2026-01-23	X	AREA OF MINIMAL FLOOD HAZARD	84.2489	89.8283	87.0850	500	2.2750		0309
2306230000004000	152223	01	087	50 COUNTY ROAD 23	HARDAWAY	AL	36039	Macon	92898	Shorter-Hardaway	232200	2322	148789.5618	2	01087C	2026-01-23	X	AREA OF MINIMAL FLOOD HAZARD	73.5511	85.4951	80.0656	500	36.7641		2306
0906140000017002	172214	01	087	945 COUNTY ROAD 9	TUSKEGEE	AL	36083	Macon	93230	Tuskegee	231603	2316.0300	4317.1779	1	01087C	2026-01-23	X	AREA OF MINIMAL FLOOD HAZARD	122.0074	127.8081	125.0056	500	1.0666		0906
0802030000017000	172303	01	087	140 OLIVER CARLIS RD	TUSKEGEE	AL	36083	Macon	93230	Tuskegee	231603	2316.0300	45512.7943	3	01087C	2026-01-23	X	0.2 PCT ANNUAL CHANCE FLOOD HAZ…	71.9245	74.6230	72.7157	500	11.2454		0802
0902030000004000	172203	01	087	5676 COUNTY ROAD 56	TALLASSEE	AL	36078	Macon	92403	Notasulga	231500	2315	323520.4697	3	01087C	2026-01-23	X	AREA OF MINIMAL FLOOD HAZARD	56.2574	86.7103	70.4009	500	79.9375		0902
0605160000007002	172516	01	087	726 JACK JOHNSTON RD	TUSKEGEE	AL	36083	Macon	91917	Little Texas-Society Hill	231400	2314	64802.4969	1	01087C	2026-01-23	X	AREA OF MINIMAL FLOOD HAZARD	131.0963	146.4969	136.1271	500	16.0117		0605
1301020001041000	162102	01	087	15227 UNITED STATES HIGHWAY 80 …	SHORTER	AL	36075	Macon	92898	Shorter-Hardaway	232200	2322	51881.1317	2	01087C	2026-01-23	X	AREA OF MINIMAL FLOOD HAZARD	98.3232	109.8378	105.1126	500	12.8189		130102
0806130000021002	172313	01	087	1360 ROSENWALD HEIGHTS RD	TUSKEGEE	AL	36083	Macon	93230	Tuskegee	231603	2316.0300	39826.3058	1	01087C	2026-01-23	X	AREA OF MINIMAL FLOOD HAZARD	104.0444	120.5070	112.2984	500	9.8407		0806
1502040000017000	162304	01	087	SOLOMON CHAPEL AFRICAN METHODIS…	TUSKEGEE	AL	36083	Macon	93230	Tuskegee	231602	2316.0200	1738.8770	2	01087C	2026-01-23	X	AREA OF MINIMAL FLOOD HAZARD	111.9169	113.9202	112.7464	500	0.4296		1502
0303072000002005	182407	01	087	371 CEMETERY RD	NOTASULGA	AL	36866	Macon	92403	Notasulga	231500	2315	2461.6311	1	01087C	2026-01-23	X	AREA OF MINIMAL FLOOD HAZARD	155.1702	158.2811	157.0288	500	0.6082		0303072
1404180000004001	162218	01	087	291 COUNTY ROAD 6	SHORTER	AL	36075	Macon	92898	Shorter-Hardaway	232200	2322	92604.4011	1	01087C	2026-01-23	X	AREA OF MINIMAL FLOOD HAZARD	78.0353	88.8135	84.3675	500	22.8814		1404
0203080000007001	182308	01	087	7414 TALLAPOOSA ST	NOTASULGA	AL	36866	Macon	92403	Notasulga	231500	2315	19401.9886	3	01087C	2026-01-23	X	AREA OF MINIMAL FLOOD HAZARD	150.4427	153.9678	152.3028	500	4.7939		0203
0303083003020000	182408	01	087	80 W COLLEGE ST S	NOTASULGA	AL	36866	Macon	92403	Notasulga	231500	2315	3880.7659	2	01087C	2026-01-23	X	AREA OF MINIMAL FLOOD HAZARD	151.3059	155.9022	154.4404	500	0.9588		0303083
0303083003017000	182408	01	087	71 W COLLEGE ST S	NOTASULGA	AL	36866	Macon	92403	Notasulga	231500	2315	3124.0126	1	01087C	2026-01-23	X	AREA OF MINIMAL FLOOD HAZARD	154.2971	155.5753	155.0083	500	0.7719		0303083
1301020001001020	162102	01	087	15 COUNTRY VIEW DR	SHORTER	AL	36075	Macon	92898	Shorter-Hardaway	232200	2322	3518.9592	1	01087C	2026-01-23	X	AREA OF MINIMAL FLOOD HAZARD	94.2131	96.4958	95.0834	500	0.8695		130102
1301020001001013	162102	01	087	57 COUNTRY VIEW DR	SHORTER	AL	36075	Macon	92898	Shorter-Hardaway	232200	2322	3046.5063	1	01087C	2026-01-23	X	AREA OF MINIMAL FLOOD HAZARD	95.4780	97.1859	96.2428	500	0.7527		130102
0806240001010000	172324	01	087	535 ROSENWALD HEIGHTS RD	TUSKEGEE	AL	36083	Macon	93230	Tuskegee	232000	2320	8152.3175	1	01087C	2026-01-23	X	AREA OF MINIMAL FLOOD HAZARD	121.4841	126.8996	124.5675	500	2.0142		080624
0303071000016000	182407	01	087	556 HARDWICH ST	NOTASULGA	AL	36866	Macon	92403	Notasulga	231500	2315	13476.0184	1	01087C	2026-01-23	X	AREA OF MINIMAL FLOOD HAZARD	149.6943	156.6548	152.4438	500	3.3297		0303074
0304173000009001	182417	01	087	9071 TUSKEGEE ST	NOTASULGA	AL	36866	Macon	92403	Notasulga	231500	2315	3623.6564	1	01087C	2026-01-23	X	AREA OF MINIMAL FLOOD HAZARD	138.4800	141.1002	140.0298	500	0.8953		0304173
1603060001008000	162406	01	087	1844 COUNTY ROAD 45	TUSKEGEE	AL	36083	Macon	93230	Tuskegee	231900	2319	3750.4365	1	01087C	2026-01-23	X	AREA OF MINIMAL FLOOD HAZARD	111.9438	115.7305	113.1009	500	0.9267		160306