superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
3 rows where PARK_NAME = "King Park"
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
5739 | 5739 | 5738 | {"type": "Polygon", "coordinates": [[[-122.32626, 37.57414], [-122.32507, 37.57497], [-122.32376, 37.57378], [-122.32497, 37.57295], [-122.32626, 37.57414]]]} | Open Access 1 | King Park | 20655 | 324 | San Mateo County Parks and Recreation Dept., County of 28 | County 3 | County Agency - Parks 7 | http://www.co.sanmateo.ca.us/portal/site/parks/ | County 3 | 6.08 | King Park | 1940 | |
5740 | 5740 | 5739 | {"type": "Polygon", "coordinates": [[[-121.72108, 37.94512], [-121.72097, 37.94543], [-121.72086, 37.94556], [-121.7208, 37.9457], [-121.72078, 37.9459], [-121.72077, 37.94628], [-121.72073, 37.94643], [-121.72069, 37.94645], [-121.72067, 37.94649], [-121.72069, 37.94652], [-121.72068, 37.94658], [-121.71946, 37.94658], [-121.71946, 37.94628], [-121.71953, 37.94627], [-121.71959, 37.94624], [-121.71962, 37.9462], [-121.71964, 37.94614], [-121.71963, 37.94545], [-121.71958, 37.94537], [-121.71953, 37.94534], [-121.71946, 37.94533], [-121.71946, 37.94531], [-121.71996, 37.94531], [-121.72028, 37.94528], [-121.72066, 37.94522], [-121.72108, 37.94512]]]} | Open Access 1 | King Park | 20656 | 1034 | Brentwood, City of 348 | City 2 | City Agency 2 | http://www.brentwoodca.gov/gov/parks/default.asp | City 2 | 3.946 | King Park | ||
5741 | 5741 | 5740 | {"type": "Polygon", "coordinates": [[[-121.47993, 38.41812], [-121.47992, 38.41815], [-121.4796, 38.41836], [-121.4777, 38.41986], [-121.47762, 38.41985], [-121.47711, 38.41945], [-121.4771, 38.41941], [-121.47712, 38.41938], [-121.4789, 38.41797], [-121.47907, 38.41781], [-121.47922, 38.41764], [-121.47927, 38.41762], [-121.47932, 38.41763], [-121.47946, 38.41771], [-121.47971, 38.41789], [-121.47992, 38.41809], [-121.47993, 38.41812]]]} | Open Access 1 | King Park | 20657 | 2194 | Consumnes Community Services District 559 | Special District 4 | Community Services District 17 | http://www.yourcsd.com/parks/parks_list.asp | Special District 4 | 5.184 | King 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]);