units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
113 rows where ACCESS_TYP = 1 and DES_TP = 19 sorted by ACRES
This data as json, copyable, CSV (advanced)
MNG_AGENCY >30
- Fremont, City of 4
- Kern, County of 4
- Exeter Cemetery District 3
- Selma Cemetery District 3
- Riverside, County of 2
- Long Beach, City of 2
- Rio Vista, City of 2
- Mono, County of 2
- Merced Cemetery District 2
- Oakdale, City of 1
- San Diego, City of 1
- Monterey, County of 1
- San Jose, City of 1
- Monterey, City of 1
- Turlock, City of 1
- Jamestown Cemetery District 1
- Santa Barbara Cemetery Association 1
- Santa Maria 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 Diego, County of 1
- Rialto, City of 1
- Mariposa, County of 1
- Ventura, City of 1
- Lindsay-Strathmore Cemetery District 1
- Carlsbad, City of 1
- Woodlake Public Cemetery District 1
- Soledad Cemetery District 1
- …
MNG_AG_TYP 4
DES_TP 1
- Local Historic or Cultural Area · 93 ✖
ACCESS_TYP 1
- Open Access · 93 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | ||
3577 | 3577 | 3576 | {"type": "Polygon", "coordinates": [[[-121.90718, 37.34301], [-121.90614, 37.34373], [-121.90546, 37.34312], [-121.90653, 37.3424], [-121.90718, 37.34301]]]} | Open Access 1 | 29148 | Historic Orchard | 20007 | 1303 | San Jose, City of 33 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | Santa Clara 19 | 2.747 | Historic Orchard | 0 | Local Historic or Cultural Area 19 | 4 | |
7176 | 7176 | 7175 | {"type": "Polygon", "coordinates": [[[-118.80554, 34.41483], [-118.80553, 34.41552], [-118.8039, 34.41551], [-118.8039, 34.41481], [-118.80554, 34.41483]]]} | Open Access 1 | 18596 | Piru Cemetery | 23745 | 2110 | Piru Cemetery District 851 | Special District 4 | Cemetery District 11 | Special District 4 | 2110 | Piru Cemetery District 830 | Special District 4 | Cemetery District 11 | Ventura 8 | 2.875 | Piru 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 | |
430 | 430 | 429 | {"type": "Polygon", "coordinates": [[[-117.69087, 33.64713], [-117.69085, 33.64716], [-117.69051, 33.64729], [-117.68995, 33.64727], [-117.68923, 33.64768], [-117.68869, 33.64759], [-117.68877, 33.64738], [-117.68882, 33.64717], [-117.68975, 33.64643], [-117.69027, 33.64681], [-117.69087, 33.64713]]]} | Open Access 1 | 1728 | Heritage Hill Historic Site | 19835 | 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 | 3.228 | Heritage Hill Historic Site | 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 | |
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 | |
3667 | 3667 | 3666 | {"type": "Polygon", "coordinates": [[[-120.63151, 35.14694], [-120.63138, 35.14758], [-120.63074, 35.14764], [-120.63031, 35.14745], [-120.63006, 35.14668], [-120.6304, 35.1465], [-120.63082, 35.14618], [-120.63134, 35.14628], [-120.63127, 35.14651], [-120.63141, 35.14683], [-120.63151, 35.14694]]]} | Open Access 1 | 48812 | Price Historical Park | 33532 | 1253 | Pismo Beach, City of 423 | City 2 | City Agency 2 | http://www.pismobeach.org/69/Parks-Halls | City 2 | 1253 | Pismo Beach, City of 417 | City 2 | City Agency 2 | https://www.pismobeach.org/307/Price-Regional-Park | San Luis Obispo 1 | 3.772 | Price Historical Park | 0 | Local Historic or Cultural Area 19 | 4 |
10099 | 10099 | 10098 | {"type": "Polygon", "coordinates": [[[-121.89403, 36.60846], [-121.89279, 36.60845], [-121.89238, 36.60732], [-121.89352, 36.60702], [-121.89403, 36.60846]]]} | Open Access 1 | 17491 | Lower Presidio Historic Park | 21563 | 1212 | Monterey, City of 37 | City 2 | City Agency 2 | http://monterey.org/en-us/Departments/Monterey-Recreation/Parks-and-Beaches | City 2 | 1212 | Monterey, City of 36 | City 2 | City Agency 2 | Monterey 14 | 3.927 | Lower Presidio Historic Park | 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 | |
7348 | 7348 | 7347 | {"type": "Polygon", "coordinates": [[[-118.17741, 33.80621], [-118.17642, 33.80621], [-118.17642, 33.80452], [-118.17647, 33.80448], [-118.1774, 33.80448], [-118.17741, 33.80621]]]} | Open Access 1 | 6670 | Long Beach Municipal Cemetery | 21448 | 1184 | Long Beach, City of 298 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | Los Angeles 6 | 4.336 | Long Beach Municipal Cemetery | 0 | Local Historic or Cultural Area 19 | 4 | |
1942 | 1942 | 1941 | {"type": "Polygon", "coordinates": [[[-121.43074, 36.49462], [-121.42983, 36.49537], [-121.42837, 36.49418], [-121.4298, 36.49384], [-121.43074, 36.49462]]]} | Open Access 1 | 16639 | Gonzales Cemetery | 19393 | 2038 | Gonzales Cemetery District 457 | Special District 4 | Cemetery District 11 | Special District 4 | 2038 | Gonzales Cemetery District 451 | Special District 4 | Cemetery District 11 | Monterey 14 | 4.437 | Gonzales Cemetery | 0 | Local Historic or Cultural Area 19 | 4 | ||
1928 | 1928 | 1927 | {"type": "Polygon", "coordinates": [[[-121.69947, 38.16059], [-121.69822, 38.1616], [-121.69725, 38.16089], [-121.69786, 38.16039], [-121.69803, 38.16032], [-121.69864, 38.15988], [-121.69947, 38.16059]]]} | Open Access 1 | 14905 | St. Joseph Cemetery | 31581 | 1276 | Rio Vista, City of 327 | City 2 | City Agency 2 | http://riovistacity.com/parks-dept/ | City 2 | 1276 | Rio Vista, City of 324 | City 2 | City Agency 2 | Solano 26 | 4.479 | St. Joseph Cemetery | 0 | Local Historic or Cultural Area 19 | 4 | |
1713 | 1713 | 1712 | {"type": "MultiPolygon", "coordinates": [[[[-121.97999, 37.5644], [-121.98024, 37.56435], [-121.9804, 37.56434], [-121.98046, 37.56437], [-121.98049, 37.56446], [-121.98046, 37.56449], [-121.98039, 37.56453], [-121.9797, 37.56477], [-121.97952, 37.56481], [-121.97943, 37.56451], [-121.97999, 37.5644]]], [[[-121.98121, 37.5663], [-121.98119, 37.56634], [-121.98115, 37.56638], [-121.98079, 37.56649], [-121.98073, 37.56649], [-121.98067, 37.56646], [-121.98059, 37.56633], [-121.98044, 37.56604], [-121.98016, 37.56567], [-121.98005, 37.56548], [-121.97984, 37.56491], [-121.97984, 37.56487], [-121.97986, 37.56484], [-121.98051, 37.5646], [-121.98057, 37.5646], [-121.98063, 37.56462], [-121.98078, 37.5648], [-121.98102, 37.56501], [-121.98114, 37.56519], [-121.98121, 37.56537], [-121.98121, 37.56555], [-121.98115, 37.56583], [-121.98113, 37.56599], [-121.98115, 37.56614], [-121.98121, 37.5663]]]]} | Open Access 1 | 12857 | Shin Historic Park | 30828 | 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 | 4.615 | Shin Historic Park | 1984 | Local Historic or Cultural Area 19 | 4 | |
239 | 239 | 238 | {"type": "Polygon", "coordinates": [[[-119.19796, 36.31684], [-119.19795, 36.31782], [-119.19604, 36.31789], [-119.196, 36.31689], [-119.19796, 36.31684]]]} | Open Access 1 | 773 | Deep Creek Cemetery | 17988 | 2033 | Exeter Cemetery District 99 | Special District 4 | Cemetery District 11 | Special District 4 | 2033 | Exeter Cemetery District 97 | Special District 4 | Cemetery District 11 | Tulare 29 | 4.704 | Deep Creek Cemetery | 0 | Local Historic or Cultural Area 19 | 4 | ||
9973 | 9973 | 9972 | {"type": "Polygon", "coordinates": [[[-120.28195, 34.73211], [-120.28188, 34.73339], [-120.2803, 34.73332], [-120.2804, 34.73204], [-120.28195, 34.73211]]]} | Open Access 1 | 17408 | Los Alamos Cemetery | 21471 | 2064 | Los Alamos Cemetery District 940 | Special District 4 | Cemetery District 11 | Special District 4 | 2064 | Los Alamos Cemetery District 913 | Special District 4 | Cemetery District 11 | Santa Barbara 7 | 5.019 | Los Alamos Cemetery | 0 | Local Historic or Cultural Area 19 | 4 | ||
749 | 749 | 748 | {"type": "Polygon", "coordinates": [[[-119.62108, 36.558], [-119.62104, 36.55974], [-119.62088, 36.55974], [-119.62087, 36.55979], [-119.61988, 36.55979], [-119.61991, 36.558], [-119.62036, 36.55799], [-119.62108, 36.558]]]} | Open Access 1 | 4873 | West Selma Cemetery | 27375 | 2148 | Selma Cemetery District 251 | Special District 4 | Cemetery District 11 | Special District 4 | 2148 | Selma Cemetery District 247 | Special District 4 | Cemetery District 11 | Fresno 9 | 5.109 | West Selma Cemetery | 0 | Local Historic or Cultural Area 19 | 4 | ||
4025 | 4025 | 4024 | {"type": "Polygon", "coordinates": [[[-119.2436, 34.24393], [-119.24298, 34.24398], [-119.24187, 34.24402], [-119.24185, 34.24357], [-119.24184, 34.24356], [-119.24183, 34.24303], [-119.2422, 34.24282], [-119.24288, 34.24238], [-119.24343, 34.24302], [-119.24348, 34.24318], [-119.2436, 34.24393]]]} | Open Access 1 | 46896 | Olivas Adobe Historical Park | 30398 | 1366 | Ventura, City of 113 | City 2 | City Agency 2 | http://www.cityofventura.net/prcp | City 2 | 1366 | Ventura, City of 110 | City 2 | City Agency 2 | Ventura 8 | 5.374 | Olivas Adobe Historical Park | 0 | Local Historic or Cultural Area 19 | 4 | |
389 | 389 | 388 | {"type": "Polygon", "coordinates": [[[-118.80196, 34.27578], [-118.801, 34.27578], [-118.80023, 34.27408], [-118.80034, 34.2741], [-118.80041, 34.27419], [-118.80046, 34.27422], [-118.80057, 34.27424], [-118.80064, 34.27422], [-118.80071, 34.27418], [-118.80074, 34.27413], [-118.80076, 34.27408], [-118.80183, 34.27407], [-118.80196, 34.27578]]]} | Open Access 1 | 1158 | Strathearn Historical Park & Museum | 25908 | 2118 | Rancho Simi Recreation and Park District 80 | Special District 4 | Recreation/Parks District 4 | http://www.rsrpd.org/ | Special District 4 | 2118 | Rancho Simi Recreation and Park District 78 | Special District 4 | Recreation/Parks District 4 | Ventura 8 | 5.386 | Strathearn Historical Park & Museum | 0 | Local Historic or Cultural Area 19 | 4 | |
5217 | 5217 | 5216 | {"type": "Polygon", "coordinates": [[[-118.76793, 34.2654], [-118.76793, 34.26719], [-118.76722, 34.26733], [-118.76684, 34.26739], [-118.76684, 34.26455], [-118.76694, 34.26455], [-118.76694, 34.2654], [-118.76793, 34.2654]]]} | Open Access 1 | 818 | Simi Cemetery | 25504 | 2151 | Simi Valley Public Cemetery District 798 | Special District 4 | Cemetery District 11 | Special District 4 | 2151 | Simi Valley Public Cemetery District 778 | Special District 4 | Cemetery District 11 | Ventura 8 | 5.453 | Simi 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]);