superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
4 rows where ACRES = "0.343" and MNG_AG_TYP = 2
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
518 | 518 | 517 | {"type": "MultiPolygon", "coordinates": [[[[-121.26306, 37.78131], [-121.26305, 37.78131], [-121.26305, 37.78131], [-121.26305, 37.78131], [-121.26306, 37.78131]]], [[[-121.26389, 37.78023], [-121.26379, 37.7806], [-121.26342, 37.78054], [-121.26353, 37.78016], [-121.26389, 37.78023]]]]} | Open Access 1 | Dutra Estates Mini Park | 33521 | 1195 | Manteca, City of 481 | City 2 | City Agency 2 | http://www.ci.manteca.ca.us/parks/ | City 2 | 0.343 | Dutra Estates MP | ||
4710 | 4710 | 4709 | {"type": "Polygon", "coordinates": [[[-118.37797, 33.86434], [-118.37796, 33.86475], [-118.37764, 33.86475], [-118.37763, 33.86434], [-118.37797, 33.86434]]]} | Open Access 1 | Gregg Parkette | 19500 | 1270 | Redondo Beach, City of 242 | City 2 | City Agency 2 | http://www.redondo.org | City 2 | 0.343 | Gregg Parkette | ||
7928 | 7928 | 7927 | {"type": "Polygon", "coordinates": [[[-118.47532, 34.03118], [-118.47521, 34.03127], [-118.47452, 34.03068], [-118.47463, 34.03059], [-118.47532, 34.03118]]]} | Open Access 1 | Park Drive Park | 23428 | 1323 | Santa Monica, City of 180 | City 2 | City Agency 2 | http://santa-monica.org/departments/ccs/content.aspx?id=32599 | City 2 | 0.343 | Park Drive Park | ||
13609 | 13609 | 13608 | {"type": "Polygon", "coordinates": [[[-117.6212, 33.96792], [-117.62116, 33.96804], [-117.621, 33.96806], [-117.621, 33.96848], [-117.62076, 33.96848], [-117.62075, 33.96806], [-117.62093, 33.96801], [-117.62113, 33.9679], [-117.6212, 33.96792]]]} | Open Access 1 | Mulberry Park | http://www.cityofchino.org/government-services/community-services/parks/mulberry-park | 31069 | 1053 | Chino, City of 261 | City 2 | City Agency 2 | http://www.cityofchino.org/residents/parks | City 2 | 0.343 | Mulberry Park |
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]);