superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
3 rows where ACCESS_TYP = 1, MNG_AGENCY = 160 and YR_EST = 2018
This data as json, copyable, CSV (advanced)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1232 | 1232 | 1231 | {"type": "Polygon", "coordinates": [[[-121.85783, 37.71464], [-121.85783, 37.71473], [-121.85752, 37.71497], [-121.85728, 37.71519], [-121.85684, 37.71563], [-121.85657, 37.71602], [-121.85649, 37.71603], [-121.85605, 37.71585], [-121.85602, 37.71588], [-121.85346, 37.71482], [-121.85305, 37.71458], [-121.8528, 37.71439], [-121.85265, 37.71425], [-121.85239, 37.71397], [-121.85226, 37.71378], [-121.85214, 37.71356], [-121.85206, 37.71337], [-121.85199, 37.71316], [-121.85194, 37.71283], [-121.85194, 37.71254], [-121.85207, 37.71144], [-121.85213, 37.71121], [-121.85217, 37.71065], [-121.85226, 37.71058], [-121.8536, 37.71047], [-121.85423, 37.71036], [-121.85473, 37.71025], [-121.85511, 37.71013], [-121.85564, 37.70992], [-121.85597, 37.70976], [-121.85643, 37.7095], [-121.85715, 37.70914], [-121.85726, 37.70917], [-121.85745, 37.70949], [-121.85759, 37.70985], [-121.85766, 37.71022], [-121.85766, 37.71057], [-121.85762, 37.71079], [-121.85756, 37.71101], [-121.85703, 37.71255], [-121.85698, 37.7128], [-121.85697, 37.71317], [-121.85701, 37.71341], [-121.85708, 37.71364], [-121.85725, 37.71398], [-121.85748, 37.71429], [-121.85783, 37.71464]]]} | Open Access 1 | Fallon Sports Park | https://www.dublin.ca.gov/Facilities/Facility/Details/Fallon-Sports-Park-22 | 32911 | 1090 | Dublin, City of 160 | City 2 | City Agency 2 | http://www.ci.dublin.ca.us/index.aspx?nid=1458 | City 2 | 65.297 | Fallon Sports Park | 2018 |
1233 | 1233 | 1232 | {"type": "Polygon", "coordinates": [[[-121.84712, 37.7135], [-121.84714, 37.71357], [-121.8472, 37.71362], [-121.84726, 37.71372], [-121.84732, 37.71388], [-121.84734, 37.71403], [-121.84733, 37.71419], [-121.84728, 37.71435], [-121.8472, 37.71449], [-121.84701, 37.71468], [-121.84686, 37.71478], [-121.84668, 37.71486], [-121.84649, 37.71491], [-121.84569, 37.71507], [-121.84554, 37.71508], [-121.84533, 37.71505], [-121.8452, 37.71499], [-121.84505, 37.71487], [-121.84496, 37.71473], [-121.84487, 37.71469], [-121.84546, 37.71433], [-121.84589, 37.71411], [-121.84639, 37.7139], [-121.8468, 37.71366], [-121.84707, 37.71355], [-121.84712, 37.7135]]]} | Open Access 1 | Jordan Ranch Park | https://ca-dublin2.civicplus.com/Facilities/Facility/Details/Jordan-Ranch-Park-31 | 32912 | 1090 | Dublin, City of 160 | City 2 | City Agency 2 | http://www.ci.dublin.ca.us/index.aspx?nid=1458 | City 2 | 4.982 | Jordan Ranch Park | 2018 |
1244 | 1244 | 1243 | {"type": "Polygon", "coordinates": [[[-121.84613, 37.71921], [-121.8461, 37.71922], [-121.84608, 37.71928], [-121.84603, 37.71931], [-121.84534, 37.71946], [-121.84486, 37.71953], [-121.84439, 37.71957], [-121.84435, 37.71956], [-121.84433, 37.71954], [-121.8443, 37.71954], [-121.84428, 37.71905], [-121.84432, 37.71882], [-121.84438, 37.7186], [-121.84448, 37.71838], [-121.84461, 37.71818], [-121.84485, 37.7179], [-121.84492, 37.71786], [-121.84498, 37.71786], [-121.84503, 37.71789], [-121.84529, 37.7181], [-121.84554, 37.71833], [-121.84584, 37.71871], [-121.84599, 37.71894], [-121.84613, 37.71921]]]} | Open Access 1 | Sean Diamond Park | https://www.dublin.ca.gov/Facilities/Facility/Details/Sean-Diamond-Park-33 | 32917 | 1090 | Dublin, City of 160 | City 2 | City Agency 2 | http://www.ci.dublin.ca.us/index.aspx?nid=1458 | City 2 | 4.986 | Sean Diamond Park | 2018 |
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]);