superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where MNG_AG_LEV = 3 and PARK_URL = "https://parks.smcgov.org/san-pedro-valley-park" sorted by map
This data as json, copyable, CSV (advanced)
MNG_AG_TYP 1
MNG_AGENCY 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
782 | 782 | 781 | {"type": "Polygon", "coordinates": [[[-122.49305, 37.56961], [-122.48546, 37.57318], [-122.48238, 37.57518], [-122.48238, 37.5752], [-122.48578, 37.57789], [-122.48314, 37.5798], [-122.48265, 37.57957], [-122.48195, 37.57839], [-122.4812, 37.5785], [-122.48118, 37.57848], [-122.48102, 37.5785], [-122.481, 37.57846], [-122.48037, 37.57855], [-122.47994, 37.57955], [-122.48006, 37.57981], [-122.47919, 37.57994], [-122.4786, 37.58015], [-122.47767, 37.58015], [-122.47712, 37.58], [-122.47679, 37.58021], [-122.47668, 37.58021], [-122.47658, 37.58026], [-122.47604, 37.58089], [-122.47595, 37.58083], [-122.47646, 37.58023], [-122.47644, 37.58014], [-122.47473, 37.57919], [-122.4744, 37.57919], [-122.47404, 37.57936], [-122.47405, 37.57941], [-122.47384, 37.5795], [-122.47392, 37.57924], [-122.47382, 37.57911], [-122.47377, 37.5791], [-122.47282, 37.57956], [-122.47288, 37.57996], [-122.47348, 37.58031], [-122.47376, 37.58001], [-122.47416, 37.58031], [-122.4742, 37.58053], [-122.47443, 37.58065], [-122.47458, 37.58085], [-122.47517, 37.58105], [-122.47552, 37.58131], [-122.47551, 37.5815], [-122.47513, 37.58196], [-122.47446, 37.58158], [-122.47446, 37.58155], [-122.47273, 37.58059], [-122.47231, 37.58024], [-122.46848, 37.58207], [-122.46308, 37.5846], [-122.46295, 37.58445], [-122.46286, 37.58449], [-122.45977, 37.58449], [-122.45942, 37.56638], [-122.46833, 37.5663], [-122.46827, 37.56264], [-122.48708, 37.56253], [-122.48732, 37.5697], [-122.49305, 37.56961]], [[-122.46846, 37.57001], [-122.47795, 37.56987], [-122.47791, 37.5662], [-122.46836, 37.56631], [-122.46846, 37.57001]]]} | Open Access 1 | San Pedro Valley Park | https://parks.smcgov.org/san-pedro-valley-park | 11490 | 324 | San Mateo County Parks and Recreation Dept., County of 28 | County 3 | County Agency - Parks 7 | http://www.co.sanmateo.ca.us/portal/site/parks/ | County 3 | 1052.147 | San Pedro Valley Park | 2000 |
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]);