superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where ACCESS_TYP = 1, LABEL_NAME = "Dennis Debell Uvas Creek Preserve" and MNG_AG_TYP = 2
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3563 | 3563 | 3562 | {"type": "MultiPolygon", "coordinates": [[[[-121.57219, 36.99174], [-121.57176, 36.99186], [-121.57125, 36.99193], [-121.57084, 36.99194], [-121.57024, 36.99192], [-121.56989, 36.99187], [-121.56959, 36.99181], [-121.5693, 36.99164], [-121.56899, 36.99143], [-121.5687, 36.99119], [-121.5685, 36.99099], [-121.56833, 36.99076], [-121.56817, 36.99047], [-121.56809, 36.99029], [-121.56765, 36.98898], [-121.56746, 36.98889], [-121.56736, 36.98862], [-121.56745, 36.98845], [-121.56739, 36.98809], [-121.56752, 36.98805], [-121.56823, 36.98827], [-121.56811, 36.98841], [-121.56887, 36.9906], [-121.57019, 36.99142], [-121.57166, 36.99134], [-121.57219, 36.99174]]], [[[-121.6002, 37.00634], [-121.60006, 37.00745], [-121.59916, 37.0074], [-121.59923, 37.00672], [-121.59923, 37.00658], [-121.59917, 37.00637], [-121.59909, 37.00625], [-121.599, 37.00613], [-121.59884, 37.00601], [-121.59777, 37.00539], [-121.59756, 37.00529], [-121.59735, 37.00521], [-121.59635, 37.00497], [-121.59598, 37.00485], [-121.59554, 37.00465], [-121.59479, 37.0042], [-121.59454, 37.00409], [-121.5943, 37.00401], [-121.59402, 37.00395], [-121.5937, 37.00392], [-121.59238, 37.00395], [-121.59209, 37.00393], [-121.59187, 37.00389], [-121.59128, 37.00375], [-121.5909, 37.00361], [-121.59062, 37.00345], [-121.59038, 37.00325], [-121.59026, 37.00312], [-121.58912, 37.00165], [-121.58877, 37.00134], [-121.58828, 37.00097], [-121.58793, 37.00077], [-121.58472, 36.99939], [-121.58513, 36.99877], [-121.58569, 36.99801], [-121.5869, 36.99662], [-121.58813, 36.99743], [-121.5892, 36.99769], [-121.58952, 36.99791], [-121.59015, 36.99815], [-121.59035, 36.99814], [-121.59069, 36.9981], [-121.59072, 36.9982], [-121.5908, 36.99821], [-121.59086, 36.99826], [-121.59106, 36.9987], [-121.59111, 36.99894], [-121.59108, 36.99929], [-121.5911, 36.99948], [-121.59119, 36.9997], [-121.59127, 36.9998], [-121.59137, 36.99991], [-121.5916, 37.00006], [-121.59206, 37.00022], [-121.59232, 37.00037], [-121.59366, 37.00156], [-121.59449, 37.00203], [-121.59639, 37.00287], [-121.5987, 37.00403], [-121.5999, 37.00488], [-121.59977, 37.00617], [-121.6002, 37.00634]]]]} | Open Access 1 | Dennis Debell Uvas Creek Preserve | http://www.cityofgilroy.org/Facilities/Facility/Details/Dennis-Debell-Uvas-Creek-Preserve-18 | 18089 | 1118 | Gilroy, City of 401 | City 2 | City Agency 2 | http://www.cityofgilroy.org/cityofgilroy/community/parks/default.aspx | City 2 | 115.84 | Dennis Debell Uvas Creek Preserve |
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]);