units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
2 rows where MNG_AGENCY = 401 and PARK_URL = "http://www.cityofgilroy.org/Facilities/Facility/Details/Dennis-Debell-Uvas-Creek-Preserve-18"
This data as json, copyable, CSV (advanced)
Link | rowid ▼ | id | map | ACCESS_TYP | UNIT_ID | UNIT_NAME | SUID_NMA | AGNCY_ID | AGNCY_NAME | AGNCY_LEV | AGNCY_TYP | AGNCY_WEB | LAYER | MNG_AG_ID | MNG_AGENCY | MNG_AG_LEV | MNG_AG_TYP | PARK_URL | COUNTY | ACRES | LABEL_NAME | YR_EST | DES_TP | GAP_STS |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4109 | 4109 | 4108 | {"type": "Polygon", "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.99048], [-121.56809, 36.99029], [-121.56765, 36.98897], [-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]]]} | Open Access 1 | 47069 | Dennis Debell Uvas Creek Preserve | 18089 | 2143 | Santa Clara Valley Water District 483 | Special District 4 | Water District 13 | http://www.valleywater.org/ | Special District 4 | 1118 | Gilroy, City of 401 | City 2 | City Agency 2 | http://www.cityofgilroy.org/Facilities/Facility/Details/Dennis-Debell-Uvas-Creek-Preserve-18 | Santa Clara 19 | 9.388 | Dennis Debell Uvas Creek Preserve | 0 | Local Conservation Area 4 | 2 |
14859 | 14859 | 14858 | {"type": "Polygon", "coordinates": [[[-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.59757, 37.00529], [-121.59734, 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.59112, 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.00618], [-121.6002, 37.00634]]]} | Open Access 1 | 45369 | Dennis Debell Uvas Creek Preserve | 18089 | 1118 | Gilroy, City of 407 | City 2 | City Agency 2 | http://www.cityofgilroy.org/cityofgilroy/community/parks/default.aspx | City 2 | 1118 | Gilroy, City of 401 | City 2 | City Agency 2 | http://www.cityofgilroy.org/Facilities/Facility/Details/Dennis-Debell-Uvas-Creek-Preserve-18 | Santa Clara 19 | 106.438 | Dennis Debell Uvas Creek Preserve | 0 | Local Conservation Area 4 | 2 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE units_with_maps( id INT, map, ACCESS_TYP INT, UNIT_ID INT, UNIT_NAME TEXT, SUID_NMA INT, AGNCY_ID INT, AGNCY_NAME INT, AGNCY_LEV INT, AGNCY_TYP INT, AGNCY_WEB TEXT, LAYER INT, MNG_AG_ID INT, MNG_AGENCY INT, MNG_AG_LEV INT, MNG_AG_TYP INT, PARK_URL TEXT, COUNTY INT, ACRES REAL, LABEL_NAME TEXT, YR_EST INT, DES_TP INT, GAP_STS TEXT, FOREIGN KEY([ACCESS_TYP]) REFERENCES [ACCESS_TYP]([id]), FOREIGN KEY([AGNCY_NAME]) REFERENCES [AGNCY_NAME]([id]), FOREIGN KEY([AGNCY_LEV]) REFERENCES [AGNCY_LEV]([id]), FOREIGN KEY([AGNCY_TYP]) REFERENCES [AGNCY_TYP]([id]), FOREIGN KEY([LAYER]) REFERENCES [LAYER]([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([COUNTY]) REFERENCES [COUNTY]([id]), FOREIGN KEY([DES_TP]) REFERENCES [DES_TP]([id]) ); CREATE INDEX [idx_units_with_maps_DES_TP] ON [units_with_maps] ([DES_TP]); CREATE INDEX [idx_units_with_maps_COUNTY] ON [units_with_maps] ([COUNTY]); CREATE INDEX [idx_units_with_maps_MNG_AG_TYP] ON [units_with_maps] ([MNG_AG_TYP]); CREATE INDEX [idx_units_with_maps_MNG_AG_LEV] ON [units_with_maps] ([MNG_AG_LEV]); CREATE INDEX [idx_units_with_maps_MNG_AGENCY] ON [units_with_maps] ([MNG_AGENCY]); CREATE INDEX [idx_units_with_maps_LAYER] ON [units_with_maps] ([LAYER]); CREATE INDEX [idx_units_with_maps_AGNCY_TYP] ON [units_with_maps] ([AGNCY_TYP]); CREATE INDEX [idx_units_with_maps_AGNCY_LEV] ON [units_with_maps] ([AGNCY_LEV]); CREATE INDEX [idx_units_with_maps_AGNCY_NAME] ON [units_with_maps] ([AGNCY_NAME]); CREATE INDEX [idx_units_with_maps_ACCESS_TYP] ON [units_with_maps] ([ACCESS_TYP]);