superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where ACCESS_TYP = 1 and ACRES = "1.723"
This data as json, copyable, CSV (advanced)
These facets timed out: MNG_AGENCY
MNG_AG_TYP 1
ACCESS_TYP 1
- Open Access · 1 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
7462 | 7462 | 7461 | {"type": "Polygon", "coordinates": [[[-121.45979, 38.65635], [-121.45981, 38.65646], [-121.45983, 38.65691], [-121.4598, 38.65703], [-121.45975, 38.65714], [-121.45968, 38.65724], [-121.45959, 38.65733], [-121.45949, 38.65741], [-121.45936, 38.65748], [-121.4591, 38.65757], [-121.45889, 38.65759], [-121.45847, 38.65759], [-121.45842, 38.65756], [-121.4584, 38.65753], [-121.4584, 38.65736], [-121.45844, 38.65721], [-121.4585, 38.65709], [-121.45866, 38.65689], [-121.45871, 38.65689], [-121.45907, 38.65697], [-121.45946, 38.65698], [-121.4596, 38.65704], [-121.45966, 38.65703], [-121.45972, 38.657], [-121.45974, 38.65697], [-121.45975, 38.65692], [-121.45979, 38.65692], [-121.4598, 38.65685], [-121.45978, 38.6565], [-121.45975, 38.65632], [-121.45979, 38.65635]]]} | Open Access 1 | North Pointe Park | 22848 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 1.723 | North Pointe 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]);