superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
3 rows where ACRES = "1.433"
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
365 | 365 | 364 | {"type": "Polygon", "coordinates": [[[-117.82121, 33.6453], [-117.82118, 33.64532], [-117.82079, 33.64543], [-117.8205, 33.64551], [-117.82045, 33.6455], [-117.82042, 33.64546], [-117.82039, 33.64537], [-117.82026, 33.64493], [-117.82024, 33.64481], [-117.82107, 33.64473], [-117.82111, 33.64476], [-117.82122, 33.64527], [-117.82121, 33.6453]]]} | Restricted Access 2 | Grosmont Park | 31978 | 6026 | Turtle Rock Broadmoor Community Association 1009 | Private 7 | Home Owners Association 15 | http://turtlerockhills.com/ | Private 14 | 1.433 | Grosmont Park | ||
2315 | 2315 | 2314 | {"type": "Polygon", "coordinates": [[[-117.23476, 34.05037], [-117.23428, 34.05018], [-117.23354, 34.04986], [-117.23391, 34.04978], [-117.23397, 34.04972], [-117.23398, 34.04965], [-117.23464, 34.04951], [-117.2347, 34.04952], [-117.23474, 34.04955], [-117.23476, 34.04958], [-117.23476, 34.05037]]]} | Open Access 1 | Bryn Mawr Veterans Memorial Park | 16461 | 1181 | Loma Linda, City of 181 | City 2 | City Agency 2 | http://www.lomalinda-ca.gov/ | City 2 | 1.433 | Bryn Mawr Veterans Memorial Park | ||
14234 | 14234 | 14233 | {"type": "Polygon", "coordinates": [[[-122.45841, 37.87645], [-122.45823, 37.87652], [-122.45816, 37.87667], [-122.45809, 37.87672], [-122.4576, 37.87652], [-122.45715, 37.87631], [-122.45674, 37.87606], [-122.45731, 37.87592], [-122.45747, 37.87592], [-122.45757, 37.87595], [-122.45798, 37.87625], [-122.45807, 37.87628], [-122.45822, 37.87628], [-122.45833, 37.87639], [-122.45841, 37.87645]]]} | Open Access 1 | Point Tiburon Tennis Courts | 31725 | 1348 | Tiburon, Town of 477 | City 2 | City Agency 2 | http://www.ci.tiburon.ca.us/ | City 2 | 1.433 | Point Tiburon Tennis Courts |
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]);