superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
2 rows where ACCESS_TYP = 1 and ACRES = "4.969"
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3704 | 3704 | 3703 | {"type": "Polygon", "coordinates": [[[-118.24836, 33.84879], [-118.24832, 33.84883], [-118.24633, 33.84884], [-118.24631, 33.84881], [-118.24631, 33.84826], [-118.24634, 33.84812], [-118.24633, 33.84802], [-118.24666, 33.84785], [-118.24675, 33.84787], [-118.24836, 33.84786], [-118.24836, 33.84879]]]} | Open Access 1 | Dr. Thomas G. Mills Memorial Park | 18268 | 1048 | Carson, City of 300 | City 2 | City Agency 2 | http://ci.carson.ca.us/content/department/pub_service/parks_rec_parks.asp | City 2 | 4.969 | Dr. Thomas G. Mills Memorial Park | ||
8596 | 8596 | 8595 | {"type": "Polygon", "coordinates": [[[-121.52917, 38.63073], [-121.52914, 38.63075], [-121.52898, 38.63077], [-121.52857, 38.6308], [-121.52711, 38.63079], [-121.52709, 38.63076], [-121.5271, 38.62983], [-121.52712, 38.62979], [-121.52717, 38.62977], [-121.5291, 38.62977], [-121.52914, 38.62983], [-121.52914, 38.63054], [-121.52917, 38.63073]]]} | Open Access 1 | Redtail Hawk Park | 24244 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 4.969 | Redtail Hawk 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]);