units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
21 rows where DES_TP = 19 and MNG_AG_TYP = 3 sorted by COUNTY
This data as json, copyable, CSV (advanced)
MNG_AGENCY 11
MNG_AG_TYP 1
- County Agency · 18 ✖
DES_TP 1
- Local Historic or Cultural Area · 18 ✖
ACCESS_TYP 1
- Open Access 18
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 |
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 | |
6507 | 6507 | 6506 | {"type": "Polygon", "coordinates": [[[-117.42105, 33.99374], [-117.42104, 33.99393], [-117.42094, 33.99387], [-117.42032, 33.99432], [-117.41971, 33.9945], [-117.41891, 33.99527], [-117.41837, 33.99521], [-117.41467, 33.99321], [-117.41633, 33.99213], [-117.4184, 33.99191], [-117.42105, 33.99374]]]} | Open Access 1 | 2430 | Jensen-Alvarado Ranch Historical Park | 20393 | 315 | Riverside, County of 169 | County 3 | County Agency 3 | http://www.rivcoparks.org/ | County 3 | 315 | Riverside, County of 165 | County 3 | County Agency 3 | Riverside 10 | 30.063 | Jensen-Alvarado Ranch Historical Park | 0 | Local Historic or Cultural Area 19 | 4 | |
11352 | 11352 | 11351 | {"type": "Polygon", "coordinates": [[[-116.90313, 33.94334], [-116.89857, 33.94333], [-116.89827, 33.94266], [-116.89791, 33.94223], [-116.89766, 33.9413], [-116.89702, 33.9398], [-116.89651, 33.93845], [-116.8965, 33.93756], [-116.8943, 33.93447], [-116.8943, 33.93254], [-116.89922, 33.93253], [-116.89923, 33.93542], [-116.89855, 33.93543], [-116.89855, 33.93599], [-116.89923, 33.936], [-116.89923, 33.9367], [-116.90309, 33.93967], [-116.90313, 33.94334]]]} | Open Access 1 | 22147 | Gilman Historic Ranch Park | 19295 | 315 | Riverside, County of 169 | County 3 | County Agency 3 | http://www.rivcoparks.org/ | County 3 | 315 | Riverside, County of 165 | County 3 | County Agency 3 | Riverside 10 | 131.555 | Gilman Historic Ranch Park | 0 | Local Historic or Cultural Area 19 | 4 | |
10247 | 10247 | 10246 | {"type": "MultiPolygon", "coordinates": [[[[-121.62949, 36.69255], [-121.62807, 36.69314], [-121.62759, 36.69261], [-121.62828, 36.69163], [-121.62949, 36.69255]]], [[[-121.63889, 36.69555], [-121.63869, 36.6957], [-121.63826, 36.69613], [-121.63693, 36.69582], [-121.6374, 36.69534], [-121.63679, 36.69491], [-121.63689, 36.69488], [-121.63697, 36.69493], [-121.63754, 36.69473], [-121.63767, 36.69474], [-121.63889, 36.69555]]]]} | Open Access 1 | 17939 | Monterey County Cemetery | 22419 | 310 | Monterey, County of 23 | County 3 | County Agency 3 | http://www.co.monterey.ca.us/parks/ | County 3 | 310 | Monterey, County of 23 | County 3 | County Agency 3 | Monterey 14 | 7.401 | Monterey County Cemetery | 0 | Local Historic or Cultural Area 19 | 4 | |
6551 | 6551 | 6550 | {"type": "Polygon", "coordinates": [[[-117.33255, 34.59773], [-117.33125, 34.59826], [-117.33077, 34.59754], [-117.33206, 34.5969], [-117.33255, 34.59773]]]} | Open Access 1 | 3283 | Oro Grande Historic Memorial Park | 23207 | 318 | San Bernardino, County of 368 | County 3 | County Agency 3 | http://cms.sbcounty.gov/parks/Home.aspx | County 3 | 318 | San Bernardino, County of 363 | County 3 | County Agency 3 | San Bernardino 22 | 3.266 | Oro Grande Historic Memorial Park | 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 | |
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 | |
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 | |
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 | |
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 |
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 |
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]);