superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
7 rows where MNG_AG_TYP = 11 and PARK_NAME = "Cemetery"
This data as json, copyable, CSV (advanced)
Link | rowid ▼ | id | map | ACCESS_TYP | PARK_NAME | PARK_URL | SUID_NMA | MNG_AG_ID | MNG_AGENCY | MNG_AG_LEV | MNG_AG_TYP | AGNCY_WEB | LAYER | ACRES | LABEL_NAME | YR_EST |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2101 | 2101 | 2100 | {"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 | Cemetery | 17009 | 2029 | Dos Palos Cemetery District 905 | Special District 4 | Cemetery District 11 | Special District 4 | 19.168 | Cemetery | |||
2210 | 2210 | 2209 | {"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 | Cemetery | 17010 | 2047 | Hills Ferry Cemetery District 907 | Special District 4 | Cemetery District 11 | Special District 4 | 2.605 | Cemetery | |||
2736 | 2736 | 2735 | {"type": "Polygon", "coordinates": [[[-120.4259, 37.94699], [-120.42564, 37.9476], [-120.4255, 37.94811], [-120.42551, 37.94822], [-120.42504, 37.94841], [-120.42471, 37.94817], [-120.42435, 37.94782], [-120.42412, 37.94745], [-120.42349, 37.94692], [-120.42464, 37.94646], [-120.42483, 37.94684], [-120.42539, 37.94659], [-120.42558, 37.94679], [-120.4259, 37.94699]]]} | Open Access 1 | Cemetery | 17011 | 2050 | Jamestown Cemetery District 64 | Special District 4 | Cemetery District 11 | Special District 4 | 6.085 | Cemetery | |||
2737 | 2737 | 2736 | {"type": "Polygon", "coordinates": [[[-120.859, 37.04879], [-120.85833, 37.0488], [-120.85834, 37.04941], [-120.8539, 37.04946], [-120.85391, 37.04617], [-120.85899, 37.04611], [-120.859, 37.04879]]]} | Open Access 1 | Cemetery | 17012 | 2069 | Los Banos Cemetery District 355 | Special District 4 | Cemetery District 11 | http://www.co.merced.ca.us/index.aspx?NID=1329 | Special District 4 | 39.932 | Cemetery | ||
2738 | 2738 | 2737 | {"type": "Polygon", "coordinates": [[[-120.48745, 37.28615], [-120.48741, 37.28801], [-120.48736, 37.28814], [-120.48725, 37.28825], [-120.48715, 37.28826], [-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 | Cemetery | 17013 | 2076 | Merced Cemetery District 908 | Special District 4 | Cemetery District 11 | http://www.co.merced.ca.us/index.aspx?NID=1329 | Special District 4 | 13.623 | Cemetery | ||
2739 | 2739 | 2738 | {"type": "Polygon", "coordinates": [[[-120.2455, 37.82767], [-120.24545, 37.82809], [-120.24528, 37.82907], [-120.24525, 37.82917], [-120.24352, 37.82889], [-120.24371, 37.82745], [-120.2455, 37.82767]]]} | Open Access 1 | Cemetery | 17014 | 2098 | Oak Grove Cemetery District 69 | Special District 4 | Cemetery District 11 | Special District 4 | 6.427 | Cemetery | |||
2740 | 2740 | 2739 | {"type": "Polygon", "coordinates": [[[-120.40136, 38.00555], [-120.40072, 38.00607], [-120.40064, 38.00615], [-120.40061, 38.00621], [-120.40038, 38.00615], [-120.40036, 38.00603], [-120.39992, 38.00605], [-120.39963, 38.00604], [-120.40009, 38.00557], [-120.40036, 38.00524], [-120.40055, 38.00505], [-120.40073, 38.00515], [-120.40136, 38.00555]]]} | Open Access 1 | Cemetery | 17015 | 2150 | Shaws Flat Cemetery District 67 | Special District 4 | Cemetery District 11 | Special District 4 | 2.302 | Cemetery |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE superunits_with_maps( id INT, map, ACCESS_TYP INT, PARK_NAME TEXT, PARK_URL TEXT, SUID_NMA INT, MNG_AG_ID INT, MNG_AGENCY INT, MNG_AG_LEV INT, MNG_AG_TYP INT, AGNCY_WEB TEXT, LAYER INT, ACRES REAL, LABEL_NAME TEXT, YR_EST INT, FOREIGN KEY([ACCESS_TYP]) REFERENCES [ACCESS_TYP]([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([LAYER]) REFERENCES [LAYER]([id]) ); CREATE INDEX [idx_superunits_with_maps_LAYER] ON [superunits_with_maps] ([LAYER]); CREATE INDEX [idx_superunits_with_maps_MNG_AG_TYP] ON [superunits_with_maps] ([MNG_AG_TYP]); CREATE INDEX [idx_superunits_with_maps_MNG_AG_LEV] ON [superunits_with_maps] ([MNG_AG_LEV]); CREATE INDEX [idx_superunits_with_maps_MNG_AGENCY] ON [superunits_with_maps] ([MNG_AGENCY]); CREATE INDEX [idx_superunits_with_maps_ACCESS_TYP] ON [superunits_with_maps] ([ACCESS_TYP]);