units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
116 rows where DES_TP = 19 sorted by ACRES
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_LEV, AGNCY_TYP, COUNTY, YR_EST
MNG_AGENCY >30
- Fremont, City of 6
- Kern, County of 5
- Exeter Cemetery District 3
- Selma Cemetery District 3
- Long Beach, City of 3
- Santa Barbara, County of 2
- Santa Maria Cemetery District 2
- Lindsay-Strathmore Cemetery District 2
- Orange, County of 2
- Riverside, County of 2
- Rio Vista, City of 2
- Mono, County of 2
- Sanger/Del Rey Cemetery District 2
- Merced Cemetery District 2
- Oakdale, City of 1
- San Diego, City of 1
- Los Angeles, County of 1
- Monterey, County of 1
- Los Angeles, City of 1
- San Jose, City of 1
- Monterey, City of 1
- Turlock, City of 1
- Jamestown Cemetery District 1
- Santa Barbara Cemetery Association 1
- Shaws Flat Cemetery District 1
- San Ramon, City of 1
- Oak Grove Cemetery District 1
- Rancho Simi Recreation and Park District 1
- East Bay Regional Park District 1
- San Juan Capistrano, City of 1
- …
MNG_AG_TYP 4
MNG_AG_LEV 3 ✖
- Special District 58
- City 37
- County 21
LAYER 3 ✖
- Special District 57
- City 38
- County 21
ACCESS_TYP 2
- Open Access 113
- Restricted Access 3
DES_TP 1
- Local Historic or Cultural Area · 116 ✖
Link | rowid | id | map | ACCESS_TYP | UNIT_ID | UNIT_NAME | SUID_NMA | AGNCY_ID | AGNCY_NAME | AGNCY_LEV | AGNCY_TYP | AGNCY_WEB | LAYER | MNG_AG_ID | MNG_AGENCY | MNG_AG_LEV | MNG_AG_TYP | PARK_URL | COUNTY | ACRES ▼ | LABEL_NAME | YR_EST | DES_TP | GAP_STS |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
12422 | 12422 | 12421 | {"type": "Polygon", "coordinates": [[[-122.45638, 37.68223], [-122.45632, 37.68224], [-122.45604, 37.68209], [-122.4562, 37.68199], [-122.45636, 37.68214], [-122.45638, 37.68223]]]} | Open Access 1 | 27027 | Colma Historical | 17523 | 1456 | Colma, City of 968 | City 2 | City Agency 2 | http://www.colma.ca.gov/ | City 2 | 1456 | Colma, City of 934 | City 2 | City Agency 2 | San Mateo 15 | 0.098 | Colma Historical | 0 | Local Historic or Cultural Area 19 | 4 | |
4352 | 4352 | 4351 | {"type": "Polygon", "coordinates": [[[-122.15012, 39.15433], [-122.14972, 39.15449], [-122.1496, 39.15431], [-122.15001, 39.15415], [-122.15012, 39.15433]]]} | Open Access 1 | 45673 | Williams Historic Town Square | 28702 | 1381 | Williams, City of 752 | City 2 | City Agency 2 | http://www.cityofwilliams.org/parks-rec/index.htm | City 2 | 1381 | Williams, City of 738 | City 2 | City Agency 2 | Colusa 49 | 0.22 | Williams Historic Town Square | 0 | Local Historic or Cultural Area 19 | 4 | |
7127 | 7127 | 7126 | {"type": "Polygon", "coordinates": [[[-118.24292, 33.94311], [-118.24258, 33.94313], [-118.24261, 33.94276], [-118.24292, 33.94277], [-118.24292, 33.94311]]]} | Restricted Access 2 | 6216 | Watts Historic Train Station | 29326 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 1717 | Los Angeles - Community Redevelopment Agency, City of 829 | City 2 | City Agency 2 | Los Angeles 6 | 0.287 | Watts Historic Train Station | 0 | Local Historic or Cultural Area 19 | 4 | |
11279 | 11279 | 11278 | {"type": "Polygon", "coordinates": [[[-118.15783, 34.11516], [-118.15741, 34.1155], [-118.15725, 34.11565], [-118.15722, 34.11553], [-118.15722, 34.11543], [-118.15741, 34.11524], [-118.15742, 34.11513], [-118.15783, 34.11513], [-118.15783, 34.11516]]]} | Open Access 1 | 48041 | Ironwork Historical Museum and Park | 32534 | 1340 | South Pasadena, City of 309 | City 2 | City Agency 2 | http://www.ci.south-pasadena.ca.us/ | City 2 | 1340 | South Pasadena, City of 306 | City 2 | City Agency 2 | https://www.southpasadenaca.gov/government/departments/community-services/administration/south-pasadena-historical-museum | Los Angeles 6 | 0.327 | Ironwork Historical Museum and Park | 0 | Local Historic or Cultural Area 19 | 4 |
2224 | 2224 | 2223 | {"type": "MultiPolygon", "coordinates": [[[[-119.78067, 34.4404], [-119.78035, 34.4404], [-119.78034, 34.44016], [-119.78067, 34.44016], [-119.78067, 34.4404]]], [[[-119.78168, 34.43949], [-119.78168, 34.4396], [-119.78068, 34.4396], [-119.78068, 34.43949], [-119.78168, 34.43949]]]]} | Open Access 1 | 16611 | Goleta Cemetery | 19380 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | http://cosb.countyofsb.org/parks/ | County 3 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | Santa Barbara 7 | 0.487 | Goleta Cemetery | 0 | Local Historic or Cultural Area 19 | 4 | |
9587 | 9587 | 9586 | {"type": "Polygon", "coordinates": [[[-120.45155, 34.63055], [-120.45154, 34.63089], [-120.45128, 34.63077], [-120.45087, 34.63037], [-120.45125, 34.63029], [-120.45155, 34.63055]]]} | Open Access 1 | 17395 | Lompoc Cemetery | 21418 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | http://cosb.countyofsb.org/parks/ | County 3 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | Santa Barbara 7 | 0.518 | Lompoc Cemetery | 0 | Local Historic or Cultural Area 19 | 4 | |
8360 | 8360 | 8359 | {"type": "Polygon", "coordinates": [[[-121.98613, 37.54673], [-121.98584, 37.5471], [-121.98512, 37.54673], [-121.98542, 37.54636], [-121.98613, 37.54673]]]} | Open Access 1 | 12957 | Williams Historical Park | 27563 | 1113 | Fremont, City of 381 | City 2 | City Agency 2 | http://www.fremont.gov/316/Parks | City 2 | 1113 | Fremont, City of 376 | City 2 | City Agency 2 | Alameda 17 | 0.894 | Williams Historical Park | 1973 | Local Historic or Cultural Area 19 | 4 | |
14399 | 14399 | 14398 | {"type": "Polygon", "coordinates": [[[-121.91219, 37.50432], [-121.91168, 37.50446], [-121.91141, 37.50375], [-121.91142, 37.50369], [-121.91146, 37.50366], [-121.91188, 37.50352], [-121.91219, 37.50432]]]} | Open Access 1 | 47143 | Weibel Historic Park | 30824 | 1113 | Fremont, City of 381 | City 2 | City Agency 2 | http://www.fremont.gov/316/Parks | City 2 | 1113 | Fremont, City of 376 | City 2 | City Agency 2 | Alameda 17 | 1.058 | Weibel Historic Park | 0 | Local Historic or Cultural Area 19 | 4 | |
8688 | 8688 | 8687 | {"type": "Polygon", "coordinates": [[[-118.47884, 35.13979], [-118.4787, 35.14035], [-118.47877, 35.14051], [-118.47839, 35.14065], [-118.47798, 35.13995], [-118.4781, 35.13977], [-118.47884, 35.13979]]]} | Open Access 1 | 14050 | Old Tehachapi Cemetery | 23105 | 303 | Kern, County of 399 | County 3 | County Agency 3 | http://www.co.kern.ca.us/parks/ | County 3 | 303 | Kern, County of 393 | County 3 | County Agency 3 | Kern 36 | 1.254 | Old Tehachapi Cemetery | 0 | Local Historic or Cultural Area 19 | 4 | |
8683 | 8683 | 8682 | {"type": "Polygon", "coordinates": [[[-122.32986, 37.56138], [-122.32912, 37.5622], [-122.32894, 37.56233], [-122.32844, 37.56238], [-122.32831, 37.56247], [-122.32823, 37.56284], [-122.32781, 37.56315], [-122.32743, 37.56319], [-122.32742, 37.56305], [-122.32757, 37.56302], [-122.32772, 37.56297], [-122.32787, 37.56289], [-122.328, 37.56279], [-122.32812, 37.56262], [-122.32821, 37.56237], [-122.32832, 37.56226], [-122.32847, 37.56218], [-122.32876, 37.56213], [-122.32893, 37.56205], [-122.32912, 37.56187], [-122.32922, 37.56173], [-122.32935, 37.56164], [-122.32946, 37.56162], [-122.32953, 37.56157], [-122.32957, 37.56149], [-122.32952, 37.5614], [-122.3297, 37.56137], [-122.32986, 37.56138]]]} | Open Access 1 | 14040 | DeAnza Historical Area | 17979 | 1310 | San Mateo, City of 98 | City 2 | City Agency 2 | http://www.cityofsanmateo.org/index.aspx?nid=324 | City 2 | 1310 | San Mateo, City of 96 | City 2 | City Agency 2 | San Mateo 15 | 1.425 | DeAnza Historical Area | 1940 | Local Historic or Cultural Area 19 | 4 | |
2368 | 2368 | 2367 | {"type": "Polygon", "coordinates": [[[-120.41878, 34.85391], [-120.41878, 34.85526], [-120.41827, 34.85526], [-120.41827, 34.85391], [-120.41878, 34.85391]]]} | Open Access 1 | 18541 | Pine Grove Cemetery | 23677 | 2145 | Santa Maria Cemetery District 68 | Special District 4 | Cemetery District 11 | http://www.countyofsb.org/pwd/pwsurveyor.aspx | Special District 4 | 2145 | Santa Maria Cemetery District 66 | Special District 4 | Cemetery District 11 | Santa Barbara 7 | 1.717 | Pine Grove Cemetery | 0 | Local Historic or Cultural Area 19 | 4 | |
2454 | 2454 | 2453 | {"type": "Polygon", "coordinates": [[[-117.66179, 33.49999], [-117.66168, 33.50071], [-117.66109, 33.50064], [-117.66106, 33.50059], [-117.66064, 33.50046], [-117.6607, 33.5], [-117.66083, 33.50002], [-117.66099, 33.49984], [-117.66179, 33.49999]]]} | Open Access 1 | 12330 | Historic Town Center (HTC) Park | 20008 | 1305 | San Juan Capistrano, City of 92 | City 2 | City Agency 2 | http://www.sanjuancapistrano.org/ | City 2 | 1305 | San Juan Capistrano, City of 90 | City 2 | City Agency 2 | Orange 3 | 1.879 | Historic Town Ctr. (HTC) Park | 0 | Local Historic or Cultural Area 19 | 4 | |
9771 | 9771 | 9770 | {"type": "Polygon", "coordinates": [[[-121.24325, 36.3164], [-121.24255, 36.31678], [-121.24189, 36.31602], [-121.24259, 36.31563], [-121.24325, 36.3164]]]} | Open Access 1 | 16676 | Greenfield Cemetery | 19477 | 2040 | Greenfield Cemetery District 925 | Special District 4 | Cemetery District 11 | http://www.co.monterey.ca.us/factfinder/specdistr.htm | Special District 4 | 2040 | Greenfield Cemetery District 898 | Special District 4 | Cemetery District 11 | Monterey 14 | 1.939 | Greenfield Cemetery | 0 | Local Historic or Cultural Area 19 | 4 | |
8354 | 8354 | 8353 | {"type": "MultiPolygon", "coordinates": [[[[-118.23804, 34.05665], [-118.23761, 34.05703], [-118.23757, 34.05704], [-118.23752, 34.05703], [-118.23751, 34.05698], [-118.23761, 34.05653], [-118.23783, 34.05657], [-118.23804, 34.05665]]], [[[-118.23804, 34.05645], [-118.23761, 34.05638], [-118.23763, 34.05623], [-118.23763, 34.05623], [-118.23804, 34.05645]]], [[[-118.23843, 34.05598], [-118.23816, 34.05631], [-118.23813, 34.05632], [-118.23806, 34.05631], [-118.23784, 34.05617], [-118.23768, 34.05611], [-118.23767, 34.05608], [-118.23775, 34.05566], [-118.23786, 34.05564], [-118.23797, 34.05568], [-118.23843, 34.05598]]], [[[-118.23875, 34.05625], [-118.23891, 34.05628], [-118.23901, 34.05635], [-118.23907, 34.05644], [-118.23909, 34.05655], [-118.23906, 34.05667], [-118.23897, 34.05676], [-118.23885, 34.05682], [-118.23872, 34.05683], [-118.23858, 34.0568], [-118.23849, 34.05673], [-118.23842, 34.05664], [-118.2384, 34.05653], [-118.23842, 34.05643], [-118.2385, 34.05634], [-118.23861, 34.05627], [-118.23875, 34.05625]]]]} | Open Access 1 | 12941 | El Pueblo de Los Angeles Historic Monument | 28788 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | Los Angeles 6 | 2.002 | El Pueblo de Los Angeles Historic Monument | 0 | Local Historic or Cultural Area 19 | 4 | |
3649 | 3649 | 3648 | {"type": "Polygon", "coordinates": [[[-119.16573, 34.21387], [-119.16566, 34.21391], [-119.16562, 34.21398], [-119.16561, 34.21418], [-119.16528, 34.21418], [-119.16528, 34.21381], [-119.16436, 34.2138], [-119.16437, 34.2133], [-119.16439, 34.21328], [-119.16571, 34.21329], [-119.1657, 34.21382], [-119.16573, 34.21387]]]} | Open Access 1 | 48804 | Oxnard Historic Farm Park | 33526 | 1237 | Oxnard, City of 95 | City 2 | City Agency 2 | https://www.oxnard.org/ | City 2 | 1237 | Oxnard, City of 93 | City 2 | City Agency 2 | Ventura 8 | 2.107 | Oxnard Historic Farm Park | 0 | Local Historic or Cultural Area 19 | 4 | |
615 | 615 | 614 | {"type": "Polygon", "coordinates": [[[-117.87482, 33.89648], [-117.87514, 33.89647], [-117.87518, 33.89649], [-117.87521, 33.89653], [-117.87521, 33.89758], [-117.87518, 33.89763], [-117.87514, 33.89764], [-117.87508, 33.89764], [-117.87503, 33.8976], [-117.87496, 33.89757], [-117.87445, 33.89756], [-117.87443, 33.89649], [-117.87482, 33.89648]]]} | Open Access 1 | 944 | George Key Ranch Historic Park | 19269 | 312 | Orange, County of 142 | County 3 | County Agency 3 | http://ocparks.com/ | County 3 | 312 | Orange, County of 138 | County 3 | County Agency 3 | Orange 3 | 2.158 | George Key Ranch Historic Park | 0 | Local Historic or Cultural Area 19 | 4 | |
5737 | 5737 | 5736 | {"type": "Polygon", "coordinates": [[[-119.5816, 36.67854], [-119.58049, 36.67855], [-119.58052, 36.67774], [-119.58158, 36.67773], [-119.5816, 36.6778], [-119.5816, 36.67854]]]} | Open Access 1 | 1770 | Bethel Cemetery | 16047 | 2138 | Sanger/Del Rey Cemetery District 815 | Special District 4 | Cemetery District 11 | Special District 4 | 2138 | Sanger/Del Rey Cemetery District 794 | Special District 4 | Cemetery District 11 | Fresno 9 | 2.179 | Bethel Cemetery | 0 | Local Historic or Cultural Area 19 | 4 | ||
15078 | 15078 | 15077 | {"type": "MultiPolygon", "coordinates": [[[[-118.55697, 34.47401], [-118.55687, 34.47405], [-118.55682, 34.47398], [-118.55671, 34.47402], [-118.55648, 34.47366], [-118.55626, 34.47374], [-118.55607, 34.4736], [-118.55577, 34.47347], [-118.55556, 34.47333], [-118.55558, 34.47306], [-118.55594, 34.4727], [-118.55656, 34.47312], [-118.55676, 34.47328], [-118.55694, 34.47345], [-118.55684, 34.47354], [-118.55681, 34.47366], [-118.55686, 34.47383], [-118.55697, 34.47401]]], [[[-118.55698, 34.47342], [-118.55697, 34.47342], [-118.55694, 34.47339], [-118.55695, 34.47339], [-118.55698, 34.47342]]]]} | Open Access 1 | 45858 | Tesoro Adobe Historic Park | 28905 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov/wps/portal/dpr/Parks/Tesoro_Adobe_Historic_Park | Los Angeles 6 | 2.26 | Tesoro Adobe Historic Park | 0 | Local Historic or Cultural Area 19 | 4 |
182 | 182 | 181 | {"type": "Polygon", "coordinates": [[[-120.40136, 38.00555], [-120.40072, 38.00607], [-120.40064, 38.00615], [-120.40061, 38.00621], [-120.40038, 38.00615], [-120.40036, 38.00603], [-120.39992, 38.00605], [-120.39963, 38.00604], [-120.40009, 38.00557], [-120.40036, 38.00524], [-120.40055, 38.00505], [-120.40073, 38.00515], [-120.40136, 38.00555]]]} | Open Access 1 | 579 | Cemetery | 17015 | 2150 | Shaws Flat Cemetery District 69 | Special District 4 | Cemetery District 11 | Special District 4 | 2150 | Shaws Flat Cemetery District 67 | Special District 4 | Cemetery District 11 | Tuolumne 21 | 2.301 | Cemetery | 0 | Local Historic or Cultural Area 19 | 4 | ||
9986 | 9986 | 9985 | {"type": "MultiPolygon", "coordinates": [[[[-120.47014, 37.28804], [-120.47013, 37.28838], [-120.4698, 37.28836], [-120.4698, 37.28804], [-120.47014, 37.28804]]], [[[-120.47272, 37.28809], [-120.4723, 37.28882], [-120.4702, 37.28805], [-120.47272, 37.28809], [-120.47272, 37.28809]]]]} | Open Access 1 | 17246 | Merced Cemetery | 22158 | 308 | Merced, County of 476 | County 3 | County Agency 3 | http://www.co.merced.ca.us/index.aspx?NID=757 | County 3 | 308 | Merced, County of 469 | County 3 | County Agency 3 | Merced 37 | 2.519 | Merced Cemetery | 0 | Local Historic or Cultural Area 19 | 4 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE units_with_maps( id INT, map, ACCESS_TYP INT, UNIT_ID INT, UNIT_NAME TEXT, SUID_NMA INT, AGNCY_ID INT, AGNCY_NAME INT, AGNCY_LEV INT, AGNCY_TYP INT, AGNCY_WEB TEXT, LAYER INT, MNG_AG_ID INT, MNG_AGENCY INT, MNG_AG_LEV INT, MNG_AG_TYP INT, PARK_URL TEXT, COUNTY INT, ACRES REAL, LABEL_NAME TEXT, YR_EST INT, DES_TP INT, GAP_STS TEXT, FOREIGN KEY([ACCESS_TYP]) REFERENCES [ACCESS_TYP]([id]), FOREIGN KEY([AGNCY_NAME]) REFERENCES [AGNCY_NAME]([id]), FOREIGN KEY([AGNCY_LEV]) REFERENCES [AGNCY_LEV]([id]), FOREIGN KEY([AGNCY_TYP]) REFERENCES [AGNCY_TYP]([id]), FOREIGN KEY([LAYER]) REFERENCES [LAYER]([id]), FOREIGN KEY([MNG_AGENCY]) REFERENCES [MNG_AGENCY]([id]), FOREIGN KEY([MNG_AG_LEV]) REFERENCES [MNG_AG_LEV]([id]), FOREIGN KEY([MNG_AG_TYP]) REFERENCES [MNG_AG_TYP]([id]), FOREIGN KEY([COUNTY]) REFERENCES [COUNTY]([id]), FOREIGN KEY([DES_TP]) REFERENCES [DES_TP]([id]) ); CREATE INDEX [idx_units_with_maps_DES_TP] ON [units_with_maps] ([DES_TP]); CREATE INDEX [idx_units_with_maps_COUNTY] ON [units_with_maps] ([COUNTY]); CREATE INDEX [idx_units_with_maps_MNG_AG_TYP] ON [units_with_maps] ([MNG_AG_TYP]); CREATE INDEX [idx_units_with_maps_MNG_AG_LEV] ON [units_with_maps] ([MNG_AG_LEV]); CREATE INDEX [idx_units_with_maps_MNG_AGENCY] ON [units_with_maps] ([MNG_AGENCY]); CREATE INDEX [idx_units_with_maps_LAYER] ON [units_with_maps] ([LAYER]); CREATE INDEX [idx_units_with_maps_AGNCY_TYP] ON [units_with_maps] ([AGNCY_TYP]); CREATE INDEX [idx_units_with_maps_AGNCY_LEV] ON [units_with_maps] ([AGNCY_LEV]); CREATE INDEX [idx_units_with_maps_AGNCY_NAME] ON [units_with_maps] ([AGNCY_NAME]); CREATE INDEX [idx_units_with_maps_ACCESS_TYP] ON [units_with_maps] ([ACCESS_TYP]);