units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
116 rows where DES_TP = 19 sorted by AGNCY_WEB
This data as json, copyable, CSV (advanced)
MNG_AGENCY >30
- Fremont, City of 6
- Kern, County of 5
- Long Beach, City of 3
- Santa Barbara, County of 2
- Santa Maria Cemetery District 2
- Orange, County of 2
- Riverside, County of 2
- Selma Cemetery District 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
- 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
- …
MNG_AG_TYP 4
ACCESS_TYP 2
DES_TP 1
- Local Historic or Cultural Area · 96 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2793 | 2793 | 2792 | {"type": "Polygon", "coordinates": [[[-121.76676, 36.92508], [-121.76492, 36.92663], [-121.7632, 36.92467], [-121.76454, 36.92389], [-121.76432, 36.92363], [-121.76487, 36.92332], [-121.76462, 36.92303], [-121.76486, 36.92289], [-121.76531, 36.92344], [-121.76676, 36.92508]]]} | Open Access 1 | 18569 | Pioneer Cemetery | 23711 | 2107 | Pajaro Valley Public Cemetery District 554 | Special District 4 | Cemetery District 11 | Special District 4 | 2107 | Pajaro Valley Public Cemetery District 547 | Special District 4 | Cemetery District 11 | Santa Cruz 5 | 15.079 | Pioneer Cemetery | 0 | Local Historic or Cultural Area 19 | 4 | ||
5018 | 5018 | 5017 | {"type": "Polygon", "coordinates": [[[-119.30799, 36.33786], [-119.30696, 36.33786], [-119.30696, 36.338], [-119.30721, 36.33801], [-119.30723, 36.34003], [-119.30546, 36.34002], [-119.30545, 36.34006], [-119.30335, 36.34005], [-119.30332, 36.33602], [-119.30438, 36.33602], [-119.30437, 36.33463], [-119.30565, 36.33464], [-119.30566, 36.33527], [-119.30637, 36.33527], [-119.30637, 36.33464], [-119.30693, 36.33465], [-119.30694, 36.33508], [-119.30752, 36.33508], [-119.30753, 36.33557], [-119.30797, 36.33558], [-119.30797, 36.33586], [-119.30739, 36.33586], [-119.30741, 36.33769], [-119.30799, 36.33771], [-119.30799, 36.33786]]]} | Open Access 1 | 1036 | Visalia Cemetery | 27161 | 2173 | Visalia Cemetery District 793 | Special District 4 | Cemetery District 11 | Special District 4 | 2173 | Visalia Cemetery District 771 | Special District 4 | Cemetery District 11 | Tulare 29 | 48.629 | Visalia 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 | ||
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 | ||
5224 | 5224 | 5223 | {"type": "Polygon", "coordinates": [[[-118.90503, 36.42081], [-118.90499, 36.42148], [-118.90499, 36.42203], [-118.90271, 36.42198], [-118.90281, 36.42075], [-118.90503, 36.42081]]]} | Open Access 1 | 957 | Blossom Peak Cemetery | 16174 | 2165 | Three Rivers Public Cemetery District 799 | Special District 4 | Cemetery District 11 | Special District 4 | 2165 | Three Rivers Public Cemetery District 779 | Special District 4 | Cemetery District 11 | Tulare 29 | 6.762 | Blossom Peak Cemetery | 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 | ||
5987 | 5987 | 5986 | {"type": "Polygon", "coordinates": [[[-119.4628, 36.57774], [-119.4621, 36.57883], [-119.46146, 36.57935], [-119.46083, 36.58102], [-119.45916, 36.58435], [-119.45766, 36.58435], [-119.45776, 36.58144], [-119.45776, 36.58062], [-119.4579, 36.57789], [-119.4628, 36.57774]]]} | Open Access 1 | 589 | Reedley Cemetery | 24260 | 2119 | Reedley Cemetery District 822 | Special District 4 | Cemetery District 11 | Special District 4 | 2119 | Reedley Cemetery District 800 | Special District 4 | Cemetery District 11 | Fresno 9 | 48.695 | Reedley Cemetery | 0 | Local Historic or Cultural Area 19 | 4 | ||
6069 | 6069 | 6068 | {"type": "Polygon", "coordinates": [[[-119.07762, 36.1962], [-119.07557, 36.19623], [-119.07559, 36.19823], [-119.07329, 36.19825], [-119.0732, 36.19629], [-119.07535, 36.19628], [-119.07532, 36.19505], [-119.07759, 36.19504], [-119.07762, 36.1962]]]} | Open Access 1 | 807 | Olive Cemetery | 23121 | 2060 | Lindsay-Strathmore Cemetery District 122 | Special District 4 | Cemetery District 11 | Special District 4 | 2060 | Lindsay-Strathmore Cemetery District 119 | Special District 4 | Cemetery District 11 | Tulare 29 | 17.89 | Olive Cemetery | 0 | Local Historic or Cultural Area 19 | 4 | ||
6073 | 6073 | 6072 | {"type": "MultiPolygon", "coordinates": [[[[-118.99563, 36.06685], [-118.99394, 36.06686], [-118.99391, 36.06574], [-118.99563, 36.06575], [-118.99563, 36.06685]]], [[[-118.99749, 36.06564], [-118.99527, 36.06567], [-118.99526, 36.06442], [-118.99747, 36.06442], [-118.99749, 36.06564]]]]} | Open Access 1 | 819 | Porterville Cemetery | 23902 | 2115 | Porterville Public Cemetery District 823 | Special District 4 | Cemetery District 11 | Special District 4 | 2115 | Porterville Public Cemetery District 801 | Special District 4 | Cemetery District 11 | Tulare 29 | 11.434 | Porterville Cemetery | 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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
9794 | 9794 | 9793 | {"type": "Polygon", "coordinates": [[[-120.57648, 34.95764], [-120.57647, 34.95894], [-120.57408, 34.95892], [-120.57408, 34.95762], [-120.57648, 34.95764]]]} | Open Access 1 | 16696 | Guadalupe Cemetery | 19541 | 2043 | Guadalupe Cemetery District 927 | Special District 4 | Cemetery District 11 | Special District 4 | 2043 | Guadalupe Cemetery District 900 | Special District 4 | Cemetery District 11 | Santa Barbara 7 | 7.795 | Guadalupe 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 | ||
9860 | 9860 | 9859 | {"type": "Polygon", "coordinates": [[[-119.79074, 36.62769], [-119.79073, 36.63053], [-119.78905, 36.63053], [-119.78908, 36.62705], [-119.78953, 36.62705], [-119.78954, 36.62767], [-119.79074, 36.62769]]]} | Open Access 1 | 16875 | Washington Colony Cemetery | 27268 | 2176 | Washington Colony Cemetery District 933 | Special District 4 | Cemetery District 11 | Special District 4 | 2176 | Washington Colony Cemetery District 906 | Special District 4 | Cemetery District 11 | Fresno 9 | 12.379 | Washington Colony 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 | ||
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 | ||
10329 | 10329 | 10328 | {"type": "Polygon", "coordinates": [[[-120.11248, 34.63311], [-120.11247, 34.63324], [-120.11225, 34.63369], [-120.11229, 34.6339], [-120.11233, 34.6339], [-120.11242, 34.63432], [-120.11242, 34.63476], [-120.11203, 34.63477], [-120.11178, 34.63565], [-120.11113, 34.63565], [-120.11115, 34.63281], [-120.11073, 34.6328], [-120.11074, 34.63167], [-120.11247, 34.63167], [-120.11248, 34.63311]]]} | Open Access 1 | 18192 | Oak Hill Cemetery | 22976 | 2099 | Oak Hill Cemetery District 946 | Special District 4 | Cemetery District 11 | Special District 4 | 2099 | Oak Hill Cemetery District 918 | Special District 4 | Cemetery District 11 | Santa Barbara 7 | 12.84 | Oak Hill 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]);