superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
3 rows where ACRES = "9.084"
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2812 | 2812 | 2811 | {"type": "MultiPolygon", "coordinates": [[[[-118.20289, 33.77061], [-118.2028, 33.77063], [-118.2028, 33.77101], [-118.20239, 33.771], [-118.20239, 33.77061], [-118.20257, 33.7706], [-118.20258, 33.77058], [-118.20251, 33.77054], [-118.20225, 33.7705], [-118.20193, 33.7705], [-118.20193, 33.77027], [-118.2019, 33.77026], [-118.20191, 33.77014], [-118.20189, 33.7701], [-118.20183, 33.77008], [-118.20183, 33.76935], [-118.20193, 33.76935], [-118.20195, 33.7694], [-118.20233, 33.7694], [-118.20235, 33.76937], [-118.20278, 33.76942], [-118.20289, 33.77061]], [[-118.20226, 33.76983], [-118.20226, 33.76981], [-118.20194, 33.7698], [-118.20193, 33.76981], [-118.20226, 33.76983]]], [[[-118.20234, 33.77103], [-118.20234, 33.77152], [-118.20192, 33.77152], [-118.20193, 33.77103], [-118.20234, 33.77103]]], [[[-118.2028, 33.7728], [-118.20193, 33.77281], [-118.20192, 33.77254], [-118.20213, 33.77253], [-118.20246, 33.77258], [-118.20265, 33.77258], [-118.20279, 33.77256], [-118.2028, 33.7728]]], [[[-118.20234, 33.771], [-118.20193, 33.77101], [-118.20193, 33.7706], [-118.20226, 33.7706], [-118.20234, 33.77061], [-118.20234, 33.771]]], [[[-118.20234, 33.77347], [-118.20234, 33.77401], [-118.20193, 33.77402], [-118.20193, 33.77303], [-118.20234, 33.77303], [-118.20234, 33.77347]]], [[[-118.20306, 33.77226], [-118.20298, 33.77231], [-118.20278, 33.77239], [-118.20264, 33.77241], [-118.20245, 33.77241], [-118.2021, 33.77236], [-118.20193, 33.77238], [-118.20193, 33.77181], [-118.20222, 33.77181], [-118.20249, 33.77186], [-118.20259, 33.77186], [-118.20279, 33.7718], [-118.20305, 33.77165], [-118.20306, 33.77226]]], [[[-118.20234, 33.77166], [-118.20202, 33.77164], [-118.20196, 33.77163], [-118.20193, 33.77159], [-118.20234, 33.77159], [-118.20234, 33.77166]]], [[[-118.20281, 33.77399], [-118.20277, 33.77402], [-118.20239, 33.77401], [-118.20239, 33.7739], [-118.20238, 33.77303], [-118.20279, 33.77303], [-118.20281, 33.77399]]], [[[-118.2028, 33.77103], [-118.20278, 33.77158], [-118.20256, 33.77168], [-118.20239, 33.77167], [-118.20239, 33.77103], [-118.2028, 33.77103]]]]} | Open Access 1 | Cesar E. Chavez Park | 17104 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 9.084 | Cesar E. Chavez Park | ||
5920 | 5920 | 5919 | {"type": "Polygon", "coordinates": [[[-122.88631, 39.13873], [-122.88627, 39.14019], [-122.88546, 39.14008], [-122.88385, 39.14009], [-122.88351, 39.13976], [-122.8834, 39.13871], [-122.88631, 39.13873]]]} | Open Access 1 | Lake holding 14 | 20900 | 345 | Lake, County of 275 | County 3 | County Agency 3 | http://parks.lakecountyca.gov/ | County 3 | 9.084 | Lake holding 14 | ||
14349 | 14349 | 14348 | {"type": "Polygon", "coordinates": [[[-119.7721, 36.81927], [-119.7721, 36.82034], [-119.77065, 36.82075], [-119.76932, 36.82178], [-119.76873, 36.82129], [-119.76874, 36.82111], [-119.76941, 36.82058], [-119.76952, 36.82038], [-119.76935, 36.82024], [-119.76862, 36.8208], [-119.76973, 36.81993], [-119.7721, 36.81927]]]} | No Public Access 3 | Unnamed site - Fresno Metropolitan Flood Control District | 30753 | 2036 | Fresno Metropolitan Flood Control District 729 | Special District 4 | Flood District 9 | http://www.fresnofloodcontrol.org/ | Special District 4 | 9.084 |
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]);