superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
2 rows where ACRES = "3.917" 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
5816 | 5816 | 5815 | {"type": "MultiPolygon", "coordinates": [[[[-117.27679, 32.84226], [-117.27638, 32.84236], [-117.27637, 32.84232], [-117.27634, 32.84231], [-117.27618, 32.84182], [-117.2764, 32.84185], [-117.27665, 32.84183], [-117.27679, 32.84226]]], [[[-117.27836, 32.84308], [-117.27824, 32.84329], [-117.27784, 32.84366], [-117.27774, 32.84378], [-117.27766, 32.84398], [-117.27705, 32.84221], [-117.27754, 32.84211], [-117.27764, 32.84237], [-117.27812, 32.84227], [-117.27836, 32.84308]]]]} | Open Access 1 | La Jolla Community Park | 20763 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 3.917 | La Jolla Community Park | ||
11273 | 11273 | 11272 | {"type": "Polygon", "coordinates": [[[-119.09318, 36.42005], [-119.09313, 36.42009], [-119.09313, 36.42107], [-119.09217, 36.42107], [-119.09218, 36.4193], [-119.09283, 36.4193], [-119.09284, 36.41953], [-119.09299, 36.41966], [-119.09299, 36.41972], [-119.09302, 36.41978], [-119.09309, 36.41983], [-119.09314, 36.41989], [-119.09317, 36.41997], [-119.09318, 36.42005]]]} | Open Access 1 | Willow Court Park | 27573 | 1383 | Woodlake, City of 171 | City 2 | City Agency 2 | http://www.cityofwoodlake.com/ | City 2 | 3.917 | Willow Court 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]);