units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
116 rows where DES_TP = 19 sorted by MNG_AGENCY 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
13497 | 13497 | 13496 | {"type": "MultiPolygon", "coordinates": [[[[-118.09532, 33.8702], [-118.09532, 33.87013], [-118.09532, 33.87013], [-118.09532, 33.87013], [-118.09532, 33.8702]]], [[[-118.09533, 33.87063], [-118.09533, 33.87057], [-118.09533, 33.87038], [-118.09533, 33.87057], [-118.09533, 33.87063]]], [[[-118.09689, 33.87286], [-118.09535, 33.87287], [-118.09533, 33.87087], [-118.09644, 33.87086], [-118.09644, 33.87106], [-118.09686, 33.87106], [-118.09689, 33.87286]]]]} | Open Access 1 | 45696 | Artesia Cemetery | 28595 | 2356 | Artesia Cemetery District 1061 | Special District 4 | Cemetery District 11 | http://artesiacemeterydistrict.com/ | Special District 4 | 2356 | Artesia Cemetery District 1019 | Special District 4 | Cemetery District 11 | Los Angeles 6 | 7.557 | Artesia Cemetery | 0 | Local Historic or Cultural Area 19 | 4 | |
12422 | 12422 | 12421 | {"type": "Polygon", "coordinates": [[[-122.45638, 37.68223], [-122.45632, 37.68224], [-122.45604, 37.68209], [-122.4562, 37.68199], [-122.45636, 37.68214], [-122.45638, 37.68223]]]} | Open Access 1 | 27027 | Colma Historical | 17523 | 1456 | Colma, City of 968 | City 2 | City Agency 2 | http://www.colma.ca.gov/ | City 2 | 1456 | Colma, City of 934 | City 2 | City Agency 2 | San Mateo 15 | 0.098 | Colma Historical | 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 | ||
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 | ||
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 | |
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 | |
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 | ||
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 | ||
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 | ||
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 | ||
9771 | 9771 | 9770 | {"type": "Polygon", "coordinates": [[[-121.24325, 36.3164], [-121.24255, 36.31678], [-121.24189, 36.31602], [-121.24259, 36.31563], [-121.24325, 36.3164]]]} | Open Access 1 | 16676 | Greenfield Cemetery | 19477 | 2040 | Greenfield Cemetery District 925 | Special District 4 | Cemetery District 11 | http://www.co.monterey.ca.us/factfinder/specdistr.htm | Special District 4 | 2040 | Greenfield Cemetery District 898 | Special District 4 | Cemetery District 11 | Monterey 14 | 1.939 | Greenfield 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 | |
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 | ||
7127 | 7127 | 7126 | {"type": "Polygon", "coordinates": [[[-118.24292, 33.94311], [-118.24258, 33.94313], [-118.24261, 33.94276], [-118.24292, 33.94277], [-118.24292, 33.94311]]]} | Restricted Access 2 | 6216 | Watts Historic Train Station | 29326 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 1717 | Los Angeles - Community Redevelopment Agency, City of 829 | City 2 | City Agency 2 | Los Angeles 6 | 0.287 | Watts Historic Train Station | 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 | ||
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 | |
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 | ||
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 | ||
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 |
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]);