superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where ACRES = "13.788" and MNG_AGENCY = 21
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
9113 | 9113 | 9112 | {"type": "Polygon", "coordinates": [[[-122.42226, 37.73435], [-122.42175, 37.73471], [-122.42177, 37.73475], [-122.42174, 37.73506], [-122.42008, 37.73497], [-122.42016, 37.73406], [-122.41919, 37.734], [-122.41925, 37.73328], [-122.41931, 37.73301], [-122.41929, 37.733], [-122.41929, 37.73252], [-122.41954, 37.73251], [-122.41956, 37.73231], [-122.42009, 37.7323], [-122.42011, 37.73232], [-122.42027, 37.73232], [-122.42079, 37.73229], [-122.42085, 37.73243], [-122.42095, 37.7324], [-122.42091, 37.73226], [-122.421, 37.73225], [-122.42145, 37.7331], [-122.4217, 37.73332], [-122.42178, 37.73343], [-122.4221, 37.73413], [-122.42226, 37.73435]]]} | Open Access 1 | Saint Mary's Playground | 24791 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 13.788 | Saint Mary's Playground |
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]);