superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
2 rows where ACRES = "4.762"
This data as json, copyable, CSV (advanced)
These facets timed out: ACCESS_TYP, MNG_AGENCY, MNG_AG_TYP
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2211 | 2211 | 2210 | {"type": "Polygon", "coordinates": [[[-121.8621, 37.70646], [-121.86208, 37.70653], [-121.86183, 37.70671], [-121.86144, 37.70709], [-121.86133, 37.70717], [-121.86114, 37.70727], [-121.86087, 37.70735], [-121.86059, 37.70738], [-121.86024, 37.70734], [-121.86018, 37.70728], [-121.8602, 37.70708], [-121.86021, 37.70671], [-121.86019, 37.70645], [-121.86014, 37.7062], [-121.86019, 37.70614], [-121.86096, 37.706], [-121.86117, 37.70599], [-121.86136, 37.70601], [-121.8616, 37.70608], [-121.86177, 37.70616], [-121.86196, 37.7063], [-121.8621, 37.70646]]]} | Open Access 1 | Bray Commons Park | 16337 | 1090 | Dublin, City of 160 | City 2 | City Agency 2 | http://www.ci.dublin.ca.us/index.aspx?nid=1458 | City 2 | 4.762 | Bray Commons Park | ||
4811 | 4811 | 4810 | {"type": "Polygon", "coordinates": [[[-117.0893, 32.71155], [-117.08929, 32.7132], [-117.08822, 32.7132], [-117.0882, 32.71148], [-117.08903, 32.71149], [-117.08918, 32.71151], [-117.0893, 32.71155]]]} | Open Access 1 | Guymon Arms Open Space | 19577 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 4.762 | Guymon Arms OS |
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]);