units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where DES_TP = 2 and PARK_URL = "https://parks.smcgov.org/san-pedro-valley-park"
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
181 | 181 | 180 | {"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.57847], [-122.48102, 37.5785], [-122.481, 37.57846], [-122.48036, 37.57855], [-122.47994, 37.57956], [-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.47647, 37.58023], [-122.47644, 37.58014], [-122.47473, 37.57919], [-122.4744, 37.57919], [-122.47403, 37.57936], [-122.47405, 37.57941], [-122.47384, 37.5795], [-122.47392, 37.57924], [-122.47382, 37.57911], [-122.47377, 37.5791], [-122.47281, 37.57956], [-122.47288, 37.57996], [-122.47348, 37.58032], [-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.47447, 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.46834, 37.56631], [-122.46827, 37.56264], [-122.48708, 37.56253], [-122.48732, 37.5697], [-122.49305, 37.56961]], [[-122.46846, 37.57002], [-122.47795, 37.56987], [-122.47791, 37.5662], [-122.46835, 37.56631], [-122.46846, 37.57002]]]} | Open Access 1 | 499 | 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 | 324 | San Mateo County Parks and Recreation Dept., County of 28 | County 3 | County Agency - Parks 7 | https://parks.smcgov.org/san-pedro-valley-park | San Mateo 15 | 1051.78 | San Pedro Valley Park | 2000 | Local Park 2 | 4 |
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]);