superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
3 rows where ACRES = "1.138"
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
884 | 884 | 883 | {"type": "Polygon", "coordinates": [[[-119.54752, 36.70767], [-119.54749, 36.70896], [-119.54749, 36.70896], [-119.54747, 36.70878], [-119.54743, 36.70866], [-119.54738, 36.70854], [-119.54729, 36.70842], [-119.54713, 36.70825], [-119.54676, 36.70799], [-119.54658, 36.70779], [-119.54752, 36.70767]]]} | Open Access 1 | Sanger Skate Park | https://www.ci.sanger.ca.us/Facilities/Facility/Details/Sanger-Skate-Park-11 | 32756 | 1315 | Sanger, City of 227 | City 2 | City Agency 2 | http://www.ci.sanger.ca.us/parks-rec.asp | City 2 | 1.138 | Sanger Skate Park | |
9874 | 9874 | 9873 | {"type": "Polygon", "coordinates": [[[-121.08267, 38.93257], [-121.08255, 38.93257], [-121.08236, 38.93233], [-121.08197, 38.93233], [-121.08209, 38.93168], [-121.08212, 38.93165], [-121.08218, 38.93163], [-121.08245, 38.93166], [-121.08266, 38.93166], [-121.08267, 38.93257]]]} | Open Access 1 | Springs Meadow Park | 25749 | 314 | Placer, County of 206 | County 3 | County Agency 3 | http://www.placer.ca.gov/departments/facility/parks | County 3 | 1.138 | Springs Meadow Park | ||
12969 | 12969 | 12968 | {"type": "Polygon", "coordinates": [[[-117.07527, 32.92376], [-117.07526, 32.92394], [-117.07429, 32.92395], [-117.07417, 32.92371], [-117.0741, 32.9236], [-117.0741, 32.92355], [-117.07412, 32.92351], [-117.07416, 32.92348], [-117.07426, 32.92345], [-117.07449, 32.9235], [-117.07481, 32.92352], [-117.07505, 32.92359], [-117.07523, 32.92368], [-117.07527, 32.92376]]]} | Open Access 1 | Cypress Valley Mini-Park | 30205 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 1.138 | Cypress Valley Mini-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]);