units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
116 rows where DES_TP = 19 sorted by COUNTY descending
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_LEV, AGNCY_TYP, LAYER, MNG_AG_LEV, 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
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |
14339 | 14339 | 14338 | {"type": "Polygon", "coordinates": [[[-124.15133, 40.79915], [-124.15105, 40.79916], [-124.15088, 40.79986], [-124.15065, 40.8], [-124.15066, 40.80016], [-124.1508, 40.80014], [-124.15074, 40.80036], [-124.15062, 40.80038], [-124.15061, 40.80046], [-124.15071, 40.80045], [-124.15058, 40.80093], [-124.15051, 40.80095], [-124.15012, 40.80067], [-124.14902, 40.79999], [-124.14903, 40.79819], [-124.14961, 40.79821], [-124.15103, 40.7982], [-124.15132, 40.79816], [-124.15133, 40.79915]]]} | Open Access 1 | 47011 | Myrtle Grove Cemetery | 30645 | 1419 | Eureka, City of 715 | City 2 | City Agency 2 | http://www.ci.eureka.ca.gov/depts/pnr/default.asp | City 2 | 1419 | Eureka, City of 698 | City 2 | City Agency 2 | Humboldt 45 | 10.734 | Myrtle Grove Cemetery | 0 | Local Historic or Cultural Area 19 | 4 | |
1403 | 1403 | 1402 | {"type": "Polygon", "coordinates": [[[-119.78424, 36.31712], [-119.78421, 36.3183], [-119.78422, 36.31887], [-119.78171, 36.3189], [-119.7817, 36.31897], [-119.78093, 36.31891], [-119.78091, 36.31714], [-119.78424, 36.31712]]]} | Open Access 1 | 8812 | Lemoore Cemetery | 21157 | 304 | Kings, County of 360 | County 3 | County Agency 3 | http://www.countyofkings.com/departments/public-works | County 3 | 304 | Kings, County of 357 | County 3 | County Agency 3 | Kings 44 | 14.396 | Lemoore Cemetery | 0 | Local Historic or Cultural Area 19 | 4 | |
2948 | 2948 | 2947 | {"type": "Polygon", "coordinates": [[[-121.31264, 36.77495], [-121.31177, 36.77534], [-121.31044, 36.77535], [-121.31017, 36.77441], [-121.30945, 36.77355], [-121.30916, 36.77298], [-121.30903, 36.77276], [-121.3088, 36.77156], [-121.31091, 36.77051], [-121.31165, 36.7714], [-121.31178, 36.77174], [-121.31197, 36.77188], [-121.31214, 36.77188], [-121.31264, 36.77495]]]} | Open Access 1 | 48645 | San Benito County Historical and Recreational Park | 33391 | 317 | San Benito, County of 197 | County 3 | County Agency 3 | http://sbcparks.org/ | County 3 | 317 | San Benito, County of 193 | County 3 | County Agency 3 | https://www.cosb.us/business/county-business-parks/ | San Benito 38 | 29.721 | San Benito County Historical and Recreational Park | 0 | Local Historic or Cultural Area 19 | 4 |
1401 | 1401 | 1400 | {"type": "Polygon", "coordinates": [[[-120.859, 37.04879], [-120.85833, 37.0488], [-120.85834, 37.04941], [-120.8539, 37.04946], [-120.85391, 37.04617], [-120.85899, 37.04611], [-120.859, 37.04879]]]} | Open Access 1 | 16916 | Cemetery | 17012 | 2069 | Los Banos Cemetery District 358 | Special District 4 | Cemetery District 11 | http://www.co.merced.ca.us/index.aspx?NID=1329 | Special District 4 | 2069 | Los Banos Cemetery District 355 | Special District 4 | Cemetery District 11 | Merced 37 | 39.929 | Cemetery | 0 | Local Historic or Cultural Area 19 | 4 | |
2298 | 2298 | 2297 | {"type": "Polygon", "coordinates": [[[-120.33032, 37.236], [-120.329, 37.236], [-120.32896, 37.23284], [-120.32958, 37.23283], [-120.32959, 37.23288], [-120.33029, 37.23288], [-120.33032, 37.236]]]} | Open Access 1 | 16928 | Plainsburg Cemetery | 23766 | 2111 | Plainsburg Cemetery District 507 | Special District 4 | Cemetery District 11 | http://www.co.merced.ca.us/index.aspx?NID=1329 | Special District 4 | 2111 | Plainsburg Cemetery District 499 | Special District 4 | Cemetery District 11 | Merced 37 | 10.119 | Plainsburg Cemetery | 0 | Local Historic or Cultural Area 19 | 4 | |
9856 | 9856 | 9855 | {"type": "Polygon", "coordinates": [[[-120.63928, 36.98336], [-120.63928, 36.98477], [-120.63698, 36.98476], [-120.63697, 36.98408], [-120.63568, 36.98408], [-120.63567, 36.98192], [-120.63822, 36.98193], [-120.63823, 36.98335], [-120.63928, 36.98336]]]} | Open Access 1 | 16870 | Cemetery | 17009 | 2029 | Dos Palos Cemetery District 932 | Special District 4 | Cemetery District 11 | Special District 4 | 2029 | Dos Palos Cemetery District 905 | Special District 4 | Cemetery District 11 | Merced 37 | 19.154 | Cemetery | 0 | Local Historic or Cultural Area 19 | 4 | ||
9867 | 9867 | 9866 | {"type": "Polygon", "coordinates": [[[-121.04115, 37.18702], [-121.04113, 37.18781], [-121.03979, 37.18782], [-121.03981, 37.18701], [-121.04115, 37.18702]]]} | Open Access 1 | 16900 | Cemetery | 17010 | 2047 | Hills Ferry Cemetery District 934 | Special District 4 | Cemetery District 11 | Special District 4 | 2047 | Hills Ferry Cemetery District 907 | Special District 4 | Cemetery District 11 | Merced 37 | 2.605 | Cemetery | 0 | Local Historic or Cultural Area 19 | 4 | ||
9870 | 9870 | 9869 | {"type": "Polygon", "coordinates": [[[-120.4723, 37.28882], [-120.47021, 37.29245], [-120.46974, 37.29228], [-120.46974, 37.29222], [-120.46756, 37.29221], [-120.46759, 37.28885], [-120.46978, 37.28886], [-120.4698, 37.28836], [-120.47013, 37.28838], [-120.47014, 37.28804], [-120.4702, 37.28805], [-120.4723, 37.28882]]]} | Open Access 1 | 16923 | Merced Cemetery | 22159 | 2076 | Merced Cemetery District 935 | Special District 4 | Cemetery District 11 | http://www.co.merced.ca.us/index.aspx?NID=1329 | Special District 4 | 2076 | Merced Cemetery District 908 | Special District 4 | Cemetery District 11 | Merced 37 | 33.39 | Merced Cemetery | 0 | Local Historic or Cultural Area 19 | 4 | |
9884 | 9884 | 9883 | {"type": "Polygon", "coordinates": [[[-120.48745, 37.28615], [-120.48741, 37.28801], [-120.48736, 37.28814], [-120.48725, 37.28825], [-120.48715, 37.28825], [-120.48709, 37.28835], [-120.48474, 37.28825], [-120.48474, 37.2882], [-120.48468, 37.2882], [-120.48471, 37.28645], [-120.48561, 37.28647], [-120.48563, 37.28612], [-120.48745, 37.28615]]]} | Open Access 1 | 16920 | Cemetery | 17013 | 2076 | Merced Cemetery District 935 | Special District 4 | Cemetery District 11 | http://www.co.merced.ca.us/index.aspx?NID=1329 | Special District 4 | 2076 | Merced Cemetery District 908 | Special District 4 | Cemetery District 11 | Merced 37 | 13.619 | Cemetery | 0 | Local Historic or Cultural Area 19 | 4 | |
9952 | 9952 | 9951 | {"type": "Polygon", "coordinates": [[[-120.63123, 37.3803], [-120.62725, 37.38031], [-120.6272, 37.38206], [-120.62483, 37.38206], [-120.62482, 37.38031], [-120.62279, 37.38031], [-120.62281, 37.3785], [-120.62812, 37.37849], [-120.63036, 37.37943], [-120.63093, 37.37997], [-120.63123, 37.3803]]]} | Open Access 1 | 17120 | Winton Cemetery | 27657 | 2183 | Winton Cemetery District 939 | Special District 4 | Cemetery District 11 | http://www.co.merced.ca.us/index.aspx?NID=1329 | Special District 4 | 2183 | Winton Cemetery District 912 | Special District 4 | Cemetery District 11 | Merced 37 | 41.911 | Winton 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 | |
1638 | 1638 | 1637 | {"type": "Polygon", "coordinates": [[[-119.43775, 35.1571], [-119.43547, 35.15711], [-119.43547, 35.15585], [-119.43514, 35.15584], [-119.43497, 35.15576], [-119.43496, 35.15468], [-119.43774, 35.15467], [-119.43775, 35.1571]]]} | Open Access 1 | 14097 | Westside Cemetery | 27421 | 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 | 15.293 | Westside Cemetery | 0 | Local Historic or Cultural Area 19 | 4 | |
1839 | 1839 | 1838 | {"type": "Polygon", "coordinates": [[[-118.46441, 35.13789], [-118.4644, 35.13906], [-118.46227, 35.13906], [-118.46228, 35.13789], [-118.46441, 35.13789]]]} | Open Access 1 | 14074 | Tehachapi West Side Cemetery | 26219 | 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 | 6.23 | Tehachapi West Side Cemetery | 0 | Local Historic or Cultural Area 19 | 4 | |
3718 | 3718 | 3717 | {"type": "Polygon", "coordinates": [[[-118.71748, 35.7406], [-118.71739, 35.74167], [-118.71616, 35.74208], [-118.71604, 35.74172], [-118.71606, 35.74166], [-118.71616, 35.74142], [-118.7163, 35.74117], [-118.71656, 35.74078], [-118.71668, 35.74063], [-118.71748, 35.7406]]]} | Open Access 1 | 14029 | Oak Grove Cemetery | 22970 | 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 | 3.555 | Oak Grove Cemetery | 0 | Local Historic or Cultural Area 19 | 4 | |
8676 | 8676 | 8675 | {"type": "Polygon", "coordinates": [[[-119.25839, 35.76429], [-119.25672, 35.76457], [-119.25645, 35.76341], [-119.25645, 35.76146], [-119.25834, 35.76146], [-119.25837, 35.7623], [-119.25839, 35.76429]]]} | Open Access 1 | 14006 | North Kern Cemetery | 22826 | 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 | 13.858 | North Kern Cemetery | 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 | |
3004 | 3004 | 3003 | {"type": "MultiPolygon", "coordinates": [[[[-119.21773, 38.26101], [-119.21772, 38.26138], [-119.21574, 38.262], [-119.21587, 38.26217], [-119.2175, 38.26167], [-119.21749, 38.26324], [-119.21747, 38.26342], [-119.21741, 38.2636], [-119.21732, 38.26377], [-119.2172, 38.26393], [-119.21705, 38.26407], [-119.21697, 38.26414], [-119.21663, 38.26433], [-119.21626, 38.26448], [-119.21587, 38.26458], [-119.21558, 38.26462], [-119.21324, 38.26461], [-119.21322, 38.26099], [-119.21773, 38.26101]]], [[[-119.21774, 38.26347], [-119.21774, 38.26467], [-119.21634, 38.26465], [-119.21661, 38.26457], [-119.2169, 38.26444], [-119.21718, 38.26428], [-119.21727, 38.26421], [-119.21742, 38.26407], [-119.21754, 38.26391], [-119.21768, 38.26365], [-119.21774, 38.26347]]]]} | Open Access 1 | 20745 | Bridgeport Ballfields / Bridgeport Cemetery | 16378 | 309 | Mono, County of 538 | County 3 | County Agency 3 | http://www.monocounty.ca.gov/facilities/page/parks-recreation-areas | County 3 | 309 | Mono, County of 531 | County 3 | County Agency 3 | Mono 32 | 36.12 | Bridgeport Ballfields / Bridgeport Cemetery | 0 | Local Historic or Cultural Area 19 | 4 | |
10885 | 10885 | 10884 | {"type": "Polygon", "coordinates": [[[-119.13709, 38.02189], [-119.13517, 38.02197], [-119.13505, 38.02141], [-119.13531, 38.02064], [-119.13597, 38.02076], [-119.13709, 38.02189]]]} | Open Access 1 | 20771 | Mono Lake Cemetery | 22371 | 309 | Mono, County of 538 | County 3 | County Agency 3 | http://www.monocounty.ca.gov/facilities/page/parks-recreation-areas | County 3 | 309 | Mono, County of 531 | County 3 | County Agency 3 | Mono 32 | 4.074 | Mono Lake Cemetery | 0 | Local Historic or Cultural Area 19 | 4 | |
269 | 269 | 268 | {"type": "Polygon", "coordinates": [[[-120.10404, 37.44406], [-120.10403, 37.44496], [-120.10267, 37.44507], [-120.10278, 37.44409], [-120.10404, 37.44406]]]} | Open Access 1 | 47348 | Catheys Valley Cemetery | 31064 | 307 | Mariposa, County of 110 | County 3 | County Agency 3 | https://www.mariposacounty.org/index.aspx?NID=207 | County 3 | 307 | Mariposa, County of 107 | County 3 | County Agency 3 | Mariposa 31 | 2.97 | Catheys Valley 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]);