superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where MNG_AGENCY = 465 and PARK_URL = "http://www.sccgov.org/sites/parks/parkfinder/Pages/SunnyvaleBaylands.aspx"
This data as json, copyable, CSV (advanced)
MNG_AG_TYP 1
MNG_AGENCY 1
- Santa Clara County Parks and Recreation Dept., County of · 1 ✖
ACCESS_TYP 1
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
12373 | 12373 | 12372 | {"type": "MultiPolygon", "coordinates": [[[[-122.0043, 37.41496], [-122.00327, 37.41815], [-122.00416, 37.41829], [-122.00315, 37.4183], [-122.00309, 37.41846], [-122.00191, 37.41831], [-121.99998, 37.41833], [-121.99995, 37.41799], [-121.99642, 37.41801], [-121.99575, 37.41831], [-121.99577, 37.41769], [-121.99576, 37.41768], [-121.99536, 37.41778], [-121.99517, 37.41767], [-121.99032, 37.41769], [-121.98676, 37.41766], [-121.98692, 37.41759], [-121.98691, 37.41403], [-121.98707, 37.41402], [-121.98706, 37.4125], [-121.98772, 37.4122], [-121.98844, 37.41193], [-121.9887, 37.41179], [-121.98875, 37.41174], [-121.98893, 37.4117], [-121.98915, 37.41162], [-121.98948, 37.41155], [-121.99016, 37.41135], [-121.99344, 37.41062], [-121.99669, 37.41009], [-121.99687, 37.41008], [-121.99704, 37.41008], [-121.99735, 37.41016], [-121.999, 37.41091], [-121.99914, 37.41099], [-121.99931, 37.41114], [-121.99939, 37.41126], [-121.99944, 37.41139], [-121.99962, 37.41201], [-121.99965, 37.41209], [-121.99971, 37.41215], [-121.99979, 37.41218], [-121.99988, 37.4122], [-121.99997, 37.41219], [-122.00034, 37.41234], [-122.00056, 37.4126], [-122.00124, 37.41367], [-122.0014, 37.41388], [-122.0016, 37.41406], [-122.00193, 37.41431], [-122.00231, 37.4145], [-122.00272, 37.41463], [-122.00345, 37.41479], [-122.00353, 37.41535], [-122.00278, 37.4176], [-122.00256, 37.41775], [-122.00119, 37.41755], [-122.00119, 37.41757], [-122.0024, 37.41797], [-122.00249, 37.41797], [-122.00281, 37.41774], [-122.00271, 37.41806], [-122.00275, 37.41809], [-122.00381, 37.41493], [-122.004, 37.41497], [-122.00403, 37.41491], [-122.0043, 37.41496]]], [[[-122.00375, 37.41492], [-122.00375, 37.41492], [-122.00361, 37.41536], [-122.00353, 37.41481], [-122.0037, 37.41484], [-122.00369, 37.4149], [-122.00375, 37.41492]]]]} | Open Access 1 | Sunnyvale Baylands Park | http://www.sccgov.org/sites/parks/parkfinder/Pages/SunnyvaleBaylands.aspx | 29308 | 326 | Santa Clara County Parks and Recreation Dept., County of 465 | County 3 | County Agency - Parks 7 | http://www.sccgov.org/sites/parks/Pages/Welcome-to-Santa-Clara-County-Parks.aspx | County 3 | 254.244 | Sunnyvale Baylands Park | 1973 |
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]);