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 UNIT_ID
This data as json, copyable, CSV (advanced)
MNG_AGENCY >30
- Fremont, City of 6
- Kern, County of 5
- Selma Cemetery District 3
- Santa Barbara, County of 2
- Riverside, County of 2
- Long Beach, City 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
- Santa Maria Cemetery District 1
- San Ramon, City of 1
- Rancho Simi Recreation and Park District 1
- East Bay Regional Park District 1
- San Juan Capistrano, City of 1
- Oxnard, City of 1
- San Mateo, City of 1
- San Diego, County of 1
- Rialto, City of 1
- Mariposa, County of 1
- Ventura, City of 1
- Carlsbad, City of 1
- Orange, County of 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
366 | 366 | 365 | {"type": "Polygon", "coordinates": [[[-119.18856, 36.09471], [-119.18594, 36.09472], [-119.18594, 36.09315], [-119.18855, 36.09314], [-119.18856, 36.09471]]]} | Open Access 1 | 1046 | Woodville Cemetery | 27750 | 2185 | Woodville Public Cemetery District 150 | Special District 4 | Cemetery District 11 | Special District 4 | 2185 | Woodville Public Cemetery District 146 | Special District 4 | Cemetery District 11 | Tulare 29 | 10.155 | Woodville Cemetery | 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 | |
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 | |
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 | ||
5260 | 5260 | 5259 | {"type": "Polygon", "coordinates": [[[-121.09494, 35.57501], [-121.09451, 35.57558], [-121.09347, 35.57506], [-121.09278, 35.57593], [-121.09109, 35.57504], [-121.09181, 35.57412], [-121.09133, 35.57387], [-121.09398, 35.57389], [-121.09494, 35.57501]]]} | Open Access 1 | 1946 | Cambria Public Cemetery | 16751 | 2011 | Cambria Public Cemetery District 800 | Special District 4 | Cemetery District 11 | http://www.cambriacemetery.com/ | Special District 4 | 2011 | Cambria Public Cemetery District 780 | Special District 4 | Cemetery District 11 | San Luis Obispo 1 | 12.234 | Cambria Public Cemetery | 0 | Local Historic or Cultural Area 19 | 4 | |
6431 | 6431 | 6430 | {"type": "Polygon", "coordinates": [[[-117.23992, 33.11868], [-117.23968, 33.12004], [-117.23953, 33.12006], [-117.23882, 33.12], [-117.23835, 33.11991], [-117.23795, 33.12013], [-117.23771, 33.12034], [-117.23735, 33.12062], [-117.23697, 33.12084], [-117.23701, 33.12088], [-117.23698, 33.12091], [-117.23632, 33.12138], [-117.23525, 33.12035], [-117.23528, 33.12033], [-117.23525, 33.12019], [-117.23525, 33.12012], [-117.23532, 33.11989], [-117.2357, 33.11951], [-117.23574, 33.11935], [-117.23573, 33.11929], [-117.23562, 33.11916], [-117.23573, 33.11901], [-117.23569, 33.11894], [-117.23563, 33.11888], [-117.23551, 33.11886], [-117.23545, 33.11884], [-117.23531, 33.11875], [-117.23541, 33.11845], [-117.23546, 33.11814], [-117.23543, 33.11795], [-117.23535, 33.11772], [-117.23527, 33.11758], [-117.2353, 33.11753], [-117.23553, 33.11743], [-117.23577, 33.11762], [-117.23577, 33.11765], [-117.23599, 33.11774], [-117.23602, 33.11778], [-117.23625, 33.11783], [-117.23627, 33.11786], [-117.23636, 33.11788], [-117.23655, 33.11782], [-117.23665, 33.11761], [-117.23783, 33.11779], [-117.23816, 33.11782], [-117.23812, 33.11828], [-117.23831, 33.11843], [-117.23851, 33.11847], [-117.23868, 33.11847], [-117.23992, 33.11868]]]} | Open Access 1 | 1950 | Leo Carillo Ranch Historic Park | 21165 | 1045 | Carlsbad, City of 123 | City 2 | City Agency 2 | http://www.carlsbadca.gov/services/depts/parks/default.asp | City 2 | 1045 | Carlsbad, City of 120 | City 2 | City Agency 2 | http://www.carlsbadca.gov/services/depts/parks/facilities/south/carrillo.asp | San Diego 4 | 27.397 | Leo Carillo Ranch Historic Park | 0 | Local Historic or Cultural Area 19 | 4 |
6501 | 6501 | 6500 | {"type": "Polygon", "coordinates": [[[-119.51068, 36.72515], [-119.51076, 36.72766], [-119.51065, 36.7279], [-119.51046, 36.72803], [-119.51022, 36.72806], [-119.5047, 36.72801], [-119.50437, 36.72815], [-119.50388, 36.72815], [-119.50402, 36.7275], [-119.50459, 36.72719], [-119.50611, 36.72693], [-119.50694, 36.72718], [-119.50716, 36.72722], [-119.508, 36.72703], [-119.50884, 36.72654], [-119.50976, 36.7258], [-119.51068, 36.72515]]]} | Open Access 1 | 2373 | Sanger Cemetery | 25027 | 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 | 21.934 | Sanger 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 | |
6525 | 6525 | 6524 | {"type": "Polygon", "coordinates": [[[-119.62216, 36.57616], [-119.61991, 36.57617], [-119.61986, 36.57615], [-119.61984, 36.57612], [-119.61982, 36.57405], [-119.62216, 36.57616]]]} | Open Access 1 | 3223 | Floral Memorial Cemetery | 18958 | 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 | 6.039 | Floral Memorial 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 | |
6599 | 6599 | 6598 | {"type": "Polygon", "coordinates": [[[-119.54108, 34.41138], [-119.54104, 34.41331], [-119.5386, 34.41327], [-119.53861, 34.4125], [-119.53904, 34.41046], [-119.54094, 34.41042], [-119.54094, 34.41137], [-119.54108, 34.41138]]]} | Open Access 1 | 4088 | Carpinteria Cemetery | 16894 | 2014 | Carpinteria Cemetery District 838 | Special District 4 | Cemetery District 11 | http://www.carpinteriacemetery.com/ | Special District 4 | 2014 | Carpinteria Cemetery District 815 | Special District 4 | Cemetery District 11 | Santa Barbara 7 | 16.22 | Carpinteria Cemetery | 0 | Local Historic or Cultural Area 19 | 4 | |
6588 | 6588 | 6587 | {"type": "Polygon", "coordinates": [[[-119.61964, 36.57633], [-119.61961, 36.57808], [-119.6152, 36.57812], [-119.61521, 36.5764], [-119.61535, 36.5764], [-119.61536, 36.57643], [-119.61541, 36.5764], [-119.61964, 36.57633]]]} | Open Access 1 | 4094 | Selma Cemetery | 25290 | 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 | 18.807 | Selma 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 | ||
6731 | 6731 | 6730 | {"type": "Polygon", "coordinates": [[[-121.7877, 36.79149], [-121.78737, 36.79341], [-121.785, 36.79391], [-121.78428, 36.79221], [-121.7877, 36.79149]]]} | Open Access 1 | 5075 | Castroville Cemetery | 16967 | 2015 | Castroville Cemetery District 843 | Special District 4 | Cemetery District 11 | Special District 4 | 2015 | Castroville Cemetery District 820 | Special District 4 | Cemetery District 11 | Monterey 14 | 13.068 | Castroville Cemetery | 0 | Local Historic or Cultural Area 19 | 4 | ||
5106 | 5106 | 5105 | {"type": "Polygon", "coordinates": [[[-120.28304, 36.15116], [-120.28139, 36.15118], [-120.28136, 36.14926], [-120.283, 36.14924], [-120.28304, 36.15116]]]} | Open Access 1 | 5450 | Pleasant Valley Cemetery | 23799 | 2020 | Coalinga Cemetery District 795 | Special District 4 | Cemetery District 11 | Special District 4 | 2020 | Coalinga Cemetery District 775 | Special District 4 | Cemetery District 11 | Fresno 9 | 7.802 | Pleasant Valley Cemetery | 0 | Local Historic or Cultural Area 19 | 4 | ||
994 | 994 | 993 | {"type": "Polygon", "coordinates": [[[-118.25629, 33.79377], [-118.25421, 33.79388], [-118.2541, 33.79231], [-118.25461, 33.79228], [-118.25462, 33.79225], [-118.25616, 33.79216], [-118.25616, 33.79219], [-118.25618, 33.79219], [-118.25629, 33.79377]]]} | Open Access 1 | 6195 | Wilmington Cemetery | 27598 | 2182 | Wilmington Public Cemetery District 302 | Special District 4 | Cemetery District 11 | Special District 4 | 2182 | Wilmington Public Cemetery District 298 | Special District 4 | Cemetery District 11 | Los Angeles 6 | 8.461 | Wilmington Cemetery | 0 | Local Historic or Cultural Area 19 | 4 | ||
1136 | 1136 | 1135 | {"type": "Polygon", "coordinates": [[[-118.10845, 33.77696], [-118.10812, 33.77733], [-118.10811, 33.77767], [-118.1074, 33.77768], [-118.1063, 33.7776], [-118.10633, 33.77741], [-118.10608, 33.77704], [-118.10604, 33.77647], [-118.10563, 33.77642], [-118.10564, 33.77625], [-118.10604, 33.77629], [-118.10686, 33.77626], [-118.10722, 33.77607], [-118.10745, 33.77636], [-118.10787, 33.77635], [-118.10794, 33.77631], [-118.10845, 33.77696]]]} | Open Access 1 | 6659 | Rancho Los Alamitos Historic Site | 24152 | 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 | 7.405 | Rancho Los Alamitos Historic Site | 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 | |
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 | |
8127 | 8127 | 8126 | {"type": "Polygon", "coordinates": [[[-117.68379, 33.64177], [-117.68361, 33.64242], [-117.68314, 33.64365], [-117.68303, 33.64446], [-117.68101, 33.64482], [-117.68049, 33.64436], [-117.67955, 33.6437], [-117.68281, 33.64044], [-117.68379, 33.64177]]]} | Open Access 1 | 12304 | El Toro Memorial Park Cemetery | 18544 | 2104 | Orange County Cemetery District 885 | Special District 4 | Cemetery District 11 | http://www.occemeterydistrict.com/ | Special District 4 | 2104 | Orange County Cemetery District 861 | Special District 4 | Cemetery District 11 | Orange 3 | 25.36 | El Toro Memorial Park 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]);