units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
9 rows where COUNTY = 15 and YR_EST = 1962
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_ID, AGNCY_NAME, AGNCY_LEV, AGNCY_TYP, AGNCY_WEB, LAYER, MNG_AG_ID, MNG_AG_LEV, GAP_STS
MNG_AGENCY 6
DES_TP 6
MNG_AG_TYP 2
ACCESS_TYP 1
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1834 | 1834 | 1833 | {"type": "Polygon", "coordinates": [[[-122.29139, 37.56829], [-122.29135, 37.56831], [-122.2913, 37.56829], [-122.29123, 37.56825], [-122.29109, 37.56813], [-122.29095, 37.56795], [-122.29089, 37.56778], [-122.29092, 37.56774], [-122.29111, 37.5678], [-122.29127, 37.56788], [-122.2914, 37.568], [-122.29143, 37.56813], [-122.29141, 37.56827], [-122.29139, 37.56829]]]} | Open Access 1 | 14019 | Marina Lagoon Wildlife Island | 21829 | 1310 | San Mateo, City of 98 | City 2 | City Agency 2 | http://www.cityofsanmateo.org/index.aspx?nid=324 | City 2 | 1310 | San Mateo, City of 96 | City 2 | City Agency 2 | San Mateo 15 | 0.388 | Marina Lagoon Wildlife Island | 1962 | Local Conservation Area 4 | 2 | |
1841 | 1841 | 1840 | {"type": "Polygon", "coordinates": [[[-122.29381, 37.54598], [-122.29325, 37.54661], [-122.29319, 37.54657], [-122.29232, 37.54575], [-122.29336, 37.54507], [-122.2935, 37.54518], [-122.29315, 37.5456], [-122.29381, 37.54598]]]} | Open Access 1 | 14077 | Bay Meadows West | 15876 | 1310 | San Mateo, City of 98 | City 2 | City Agency 2 | http://www.cityofsanmateo.org/index.aspx?nid=324 | City 2 | 1310 | San Mateo, City of 96 | City 2 | City Agency 2 | San Mateo 15 | 2.436 | Bay Meadows West | 1962 | None 146 | ||
1842 | 1842 | 1841 | {"type": "Polygon", "coordinates": [[[-122.29185, 37.54671], [-122.29236, 37.54722], [-122.29185, 37.54752], [-122.29115, 37.5467], [-122.29145, 37.5465], [-122.2914, 37.54642], [-122.29154, 37.54633], [-122.29159, 37.54639], [-122.29155, 37.54645], [-122.29153, 37.54651], [-122.29155, 37.54658], [-122.29158, 37.54664], [-122.29164, 37.54668], [-122.29171, 37.54671], [-122.29185, 37.54671]]]} | Open Access 1 | 14079 | Bay Meadows East | 15873 | 1310 | San Mateo, City of 98 | City 2 | City Agency 2 | http://www.cityofsanmateo.org/index.aspx?nid=324 | City 2 | 1310 | San Mateo, City of 96 | City 2 | City Agency 2 | San Mateo 15 | 1.371 | Bay Meadows East | 1962 | None 147 | ||
5104 | 5104 | 5103 | {"type": "Polygon", "coordinates": [[[-122.22471, 37.47312], [-122.2232, 37.47432], [-122.22235, 37.475], [-122.22294, 37.47252], [-122.22471, 37.47312]]]} | Open Access 1 | 13961 | Union Cemetery | 26655 | 1271 | Redwood City, City of 397 | City 2 | City Agency 2 | http://www.redwoodcity.org/parks/ | City 2 | 1271 | Redwood City, City of 391 | City 2 | City Agency 2 | San Mateo 15 | 5.763 | Union Cemetery | 1962 | Local Historic or Cultural Area 19 | 4 | |
6152 | 6152 | 6151 | {"type": "Polygon", "coordinates": [[[-122.26027, 37.50956], [-122.25945, 37.51013], [-122.25916, 37.51001], [-122.25916, 37.50997], [-122.25875, 37.50957], [-122.25955, 37.50895], [-122.26027, 37.50956]]]} | Open Access 1 | 14351 | Laureola Park | 21109 | 1295 | San Carlos, City of 438 | City 2 | City Agency 2 | http://www.cityofsancarlos.org/depts/pr/default.asp | City 2 | 1295 | San Carlos, City of 432 | City 2 | City Agency 2 | San Mateo 15 | 2.247 | Laureola Park | 1962 | Local Park 2 | 4 | |
8796 | 8796 | 8795 | {"type": "Polygon", "coordinates": [[[-122.3781, 37.60526], [-122.37758, 37.60546], [-122.37701, 37.60546], [-122.37638, 37.60529], [-122.3761, 37.60514], [-122.37588, 37.60499], [-122.37578, 37.60487], [-122.37554, 37.60465], [-122.37534, 37.60452], [-122.37481, 37.60411], [-122.37457, 37.60399], [-122.37435, 37.60378], [-122.37438, 37.6037], [-122.37667, 37.60469], [-122.37747, 37.60502], [-122.37771, 37.60507], [-122.3781, 37.60526]]]} | Open Access 1 | 14308 | Bay Front Park | 15872 | 1205 | Millbrae, City of 404 | City 2 | City Agency 2 | http://www.ci.millbrae.ca.us/ | City 2 | 1205 | Millbrae, City of 398 | City 2 | City Agency 2 | San Mateo 15 | 4.105 | Bay Front Park | 1962 | Local Park 2 | 4 | |
8824 | 8824 | 8823 | {"type": "Polygon", "coordinates": [[[-122.41852, 37.63269], [-122.4172, 37.63337], [-122.4159, 37.63383], [-122.41435, 37.63404], [-122.41411, 37.63403], [-122.41415, 37.63398], [-122.41494, 37.63392], [-122.41593, 37.63353], [-122.41759, 37.63292], [-122.4185, 37.6325], [-122.41852, 37.63269]]]} | Open Access 1 | 14381 | Forest Lane Park | 18996 | 1294 | San Bruno, City of 440 | City 2 | City Agency 2 | http://www.sanbruno.ca.gov/parks_main.html | City 2 | 1294 | San Bruno, City of 434 | City 2 | City Agency 2 | San Mateo 15 | 2.178 | Forest Lane Park | 1962 | Local Park 2 | 4 | |
9317 | 9317 | 9316 | {"type": "Polygon", "coordinates": [[[-122.44233, 37.6272], [-122.4423, 37.62756], [-122.44226, 37.62762], [-122.4421, 37.62755], [-122.44212, 37.62752], [-122.44216, 37.62718], [-122.44233, 37.6272]]]} | Open Access 1 | 15533 | Catalpa Tot Lot | 16969 | 1294 | San Bruno, City of 440 | City 2 | City Agency 2 | http://www.sanbruno.ca.gov/parks_main.html | City 2 | 1294 | San Bruno, City of 434 | City 2 | City Agency 2 | San Mateo 15 | 0.174 | Catalpa Tot Lot | 1962 | Local Recreation Area 3 | 4 | |
9345 | 9345 | 9344 | {"type": "Polygon", "coordinates": [[[-122.29842, 37.5564], [-122.2981, 37.55659], [-122.29806, 37.55653], [-122.29799, 37.55649], [-122.29791, 37.55648], [-122.29782, 37.55651], [-122.29745, 37.55611], [-122.2975, 37.55607], [-122.29753, 37.556], [-122.29751, 37.55594], [-122.29746, 37.55589], [-122.29777, 37.55571], [-122.29842, 37.5564]]]} | Open Access 1 | 15612 | Washington Playground | 27284 | 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 | San Mateo 15 | 1.049 | Washington Playground | 1962 | Local Recreation Area 3 | 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]);