superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
3 rows where LABEL_NAME = "French 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4414 | 4414 | 4413 | {"type": "Polygon", "coordinates": [[[-120.63819, 35.24749], [-120.63787, 35.24753], [-120.63786, 35.24756], [-120.63747, 35.24762], [-120.63741, 35.24765], [-120.63736, 35.24762], [-120.63677, 35.24801], [-120.63677, 35.24803], [-120.63614, 35.24844], [-120.63513, 35.24743], [-120.63512, 35.24739], [-120.63514, 35.24736], [-120.63584, 35.24689], [-120.6361, 35.24668], [-120.63633, 35.24646], [-120.63664, 35.24608], [-120.6367, 35.24606], [-120.63735, 35.24636], [-120.63757, 35.2465], [-120.63774, 35.24665], [-120.6379, 35.24684], [-120.63804, 35.24704], [-120.63813, 35.24726], [-120.63819, 35.24749]]]} | Open Access 1 | French Park | 19106 | 1307 | San Luis Obispo, City of 22 | City 2 | City Agency 2 | http://www.slocity.org/parksandrecreation/index.asp | City 2 | 9.348 | French Park | ||
4415 | 4415 | 4414 | {"type": "Polygon", "coordinates": [[[-117.86446, 33.75326], [-117.86421, 33.75286], [-117.86445, 33.75275], [-117.86445, 33.75275], [-117.86446, 33.75326]]]} | Open Access 1 | French Park | 19107 | 1316 | Santa Ana, City of 19 | City 2 | City Agency 2 | http://www.santa-ana.org/parks/ | City 2 | 0.159 | French Park | ||
13680 | 13680 | 13679 | {"type": "Polygon", "coordinates": [[[-118.06802, 33.72364], [-118.06785, 33.7239], [-118.06769, 33.72381], [-118.06745, 33.72369], [-118.06762, 33.72346], [-118.06802, 33.72364]]]} | Open Access 1 | French Park | http://www.huntingtonbeachca.gov/residents/parks_facilities/parks/french-park.cfm | 31168 | 1141 | Huntington Beach, City of 122 | City 2 | City Agency 2 | http://www.surfcity-hb.org/residents/parks_facilities/parks/index.cfm | City 2 | 0.334 | French 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]);