units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
27 rows where MNG_AGENCY = 421
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
8841 | 8841 | 8840 | {"type": "Polygon", "coordinates": [[[-122.46503, 37.70656], [-122.46473, 37.70672], [-122.46448, 37.70646], [-122.46452, 37.70643], [-122.46498, 37.7065], [-122.46503, 37.70656]]]} | Open Access 1 | 46693 | John Daly Tot Lot | 30038 | 1078 | Daly City, City of 427 | City 2 | City Agency 2 | http://www.dalycity.org/ | City 2 | 1078 | Daly City, City of 421 | City 2 | City Agency 2 | San Mateo 15 | 0.189 | John Daly Tot Lot | 0 | Local Recreation Area 3 | 4 | |
9336 | 9336 | 9335 | {"type": "Polygon", "coordinates": [[[-122.41374, 37.70263], [-122.41365, 37.70283], [-122.41296, 37.70283], [-122.413, 37.70307], [-122.41298, 37.70324], [-122.41292, 37.70342], [-122.41281, 37.70358], [-122.41189, 37.70309], [-122.41234, 37.70208], [-122.41268, 37.70218], [-122.41267, 37.70221], [-122.41281, 37.70225], [-122.41309, 37.70201], [-122.41335, 37.70208], [-122.41318, 37.70247], [-122.41374, 37.70263]]]} | Open Access 1 | 15602 | David Rowe Park | 17944 | 1078 | Daly City, City of 427 | City 2 | City Agency 2 | http://www.dalycity.org/ | City 2 | 1078 | Daly City, City of 421 | City 2 | City Agency 2 | San Mateo 15 | 3.507 | David Rowe Park | 1977 | Local Park 2 | 4 | |
9337 | 9337 | 9336 | {"type": "Polygon", "coordinates": [[[-122.46174, 37.65483], [-122.46141, 37.65508], [-122.46109, 37.65483], [-122.4614, 37.65458], [-122.46174, 37.65483]]]} | Open Access 1 | 15604 | Hampshire Tot Lot | 28797 | 1078 | Daly City, City of 427 | City 2 | City Agency 2 | http://www.dalycity.org/ | City 2 | 1078 | Daly City, City of 421 | City 2 | City Agency 2 | San Mateo 15 | 0.402 | Hampshire Tot Lot | 1972 | Local Recreation Area 3 | 4 | |
9339 | 9339 | 9338 | {"type": "Polygon", "coordinates": [[[-122.46717, 37.65442], [-122.46684, 37.65445], [-122.46683, 37.65457], [-122.46653, 37.65456], [-122.46654, 37.65449], [-122.46649, 37.65441], [-122.46641, 37.65438], [-122.46632, 37.65439], [-122.46624, 37.65412], [-122.46683, 37.65403], [-122.46688, 37.65431], [-122.46681, 37.65432], [-122.46683, 37.65441], [-122.46717, 37.65438], [-122.46717, 37.65442]]]} | Open Access 1 | 15606 | Lycett Tot Lot | 28798 | 1078 | Daly City, City of 427 | City 2 | City Agency 2 | http://www.dalycity.org/ | City 2 | 1078 | Daly City, City of 421 | City 2 | City Agency 2 | San Mateo 15 | 0.601 | Lycett Tot Lot | 1980 | Local Recreation Area 3 | 4 | |
9340 | 9340 | 9339 | {"type": "Polygon", "coordinates": [[[-122.46686, 37.66099], [-122.4665, 37.66111], [-122.46638, 37.66086], [-122.46652, 37.66082], [-122.4667, 37.66082], [-122.46677, 37.66079], [-122.46686, 37.66099]]]} | Open Access 1 | 15607 | Norwood Park | 22907 | 1078 | Daly City, City of 427 | City 2 | City Agency 2 | http://www.dalycity.org/ | City 2 | 1078 | Daly City, City of 421 | City 2 | City Agency 2 | San Mateo 15 | 0.228 | Norwood Park | 1972 | Local Park 2 | 4 | |
10303 | 10303 | 10302 | {"type": "MultiPolygon", "coordinates": [[[[-122.49447, 37.67424], [-122.49335, 37.67528], [-122.49337, 37.67793], [-122.49327, 37.67796], [-122.49306, 37.67756], [-122.49295, 37.67745], [-122.49281, 37.67737], [-122.49289, 37.67725], [-122.49268, 37.67517], [-122.49244, 37.67515], [-122.49243, 37.675], [-122.49235, 37.67486], [-122.49223, 37.67474], [-122.49207, 37.67465], [-122.49191, 37.67461], [-122.49175, 37.6746], [-122.49162, 37.67462], [-122.49141, 37.67467], [-122.49011, 37.67164], [-122.49003, 37.67155], [-122.48993, 37.67147], [-122.4898, 37.67141], [-122.48964, 37.67137], [-122.48945, 37.67093], [-122.48898, 37.67105], [-122.48889, 37.67088], [-122.48878, 37.67072], [-122.48825, 37.67013], [-122.48811, 37.66994], [-122.48803, 37.66976], [-122.48748, 37.66794], [-122.48734, 37.66768], [-122.48713, 37.66741], [-122.48919, 37.66744], [-122.48938, 37.66741], [-122.48956, 37.66732], [-122.48958, 37.66726], [-122.48951, 37.66716], [-122.48986, 37.66709], [-122.49046, 37.66708], [-122.49161, 37.66709], [-122.49163, 37.66643], [-122.49237, 37.66648], [-122.49397, 37.66684], [-122.49283, 37.66901], [-122.49275, 37.6692], [-122.49269, 37.66947], [-122.49267, 37.66971], [-122.49267, 37.66991], [-122.49273, 37.67025], [-122.49287, 37.6706], [-122.49365, 37.67184], [-122.49355, 37.67244], [-122.49404, 37.67318], [-122.49414, 37.67351], [-122.49447, 37.67424]]], [[[-122.49506, 37.6795], [-122.49514, 37.68191], [-122.4949, 37.68332], [-122.49457, 37.68502], [-122.49345, 37.68365], [-122.49344, 37.68358], [-122.49181, 37.68336], [-122.49175, 37.68282], [-122.49188, 37.68254], [-122.49162, 37.68208], [-122.49166, 37.68188], [-122.4915, 37.68186], [-122.49136, 37.6816], [-122.49152, 37.68076], [-122.49185, 37.6808], [-122.49187, 37.68076], [-122.49272, 37.68075], [-122.49337, 37.68091], [-122.49337, 37.68117], [-122.4944, 37.68118], [-122.49443, 37.6795], [-122.49506, 37.6795]]], [[[-122.49618, 37.66608], [-122.4961, 37.66614], [-122.49611, 37.66629], [-122.4962, 37.66647], [-122.49632, 37.66646], [-122.49634, 37.66648], [-122.49634, 37.66661], [-122.49631, 37.66691], [-122.49635, 37.66701], [-122.49638, 37.66726], [-122.49637, 37.66733], [-122.4963, 37.66745], [-122.49623, 37.66767], [-122.49623, 37.66788], [-122.49604, 37.66856], [-122.49595, 37.66881], [-122.49585, 37.67022], [-122.49585, 37.67035], [-122.49591, 37.67051], [-122.49592, 37.67085], [-122.49596, 37.67124], [-122.49597, 37.672], [-122.49591, 37.67252], [-122.49581, 37.67291], [-122.49569, 37.67356], [-122.49557, 37.67409], [-122.49557, 37.67415], [-122.49562, 37.67424], [-122.49564, 37.67454], [-122.49572, 37.67484], [-122.49572, 37.67491], [-122.49566, 37.675], [-122.49565, 37.67508], [-122.4957, 37.67534], [-122.49568, 37.67561], [-122.49571, 37.67582], [-122.49507, 37.67582], [-122.49518, 37.67515], [-122.49519, 37.67491], [-122.49518, 37.67471], [-122.49513, 37.6745], [-122.49507, 37.67431], [-122.49472, 37.67354], [-122.4952, 37.67339], [-122.49507, 37.67289], [-122.49455, 37.67283], [-122.49445, 37.67236], [-122.49431, 37.67201], [-122.49341, 37.67058], [-122.49334, 37.66903], [-122.49426, 37.6673], [-122.49464, 37.66728], [-122.49486, 37.66685], [-122.49458, 37.66662], [-122.49466, 37.6663], [-122.49468, 37.66593], [-122.49465, 37.66561], [-122.49456, 37.66529], [-122.49446, 37.66505], [-122.49433, 37.66481], [-122.49417, 37.66459], [-122.49399, 37.66438], [-122.49495, 37.6644], [-122.49499, 37.66448], [-122.49503, 37.66499], [-122.49508, 37.66509], [-122.49517, 37.66518], [-122.49524, 37.66524], [-122.49532, 37.66525], [-122.49543, 37.66524], [-122.49549, 37.66526], [-122.4955, 37.66529], [-122.49548, 37.66553], [-122.49575, 37.66576], [-122.4959, 37.6657], [-122.49595, 37.66571], [-122.49595, 37.66574], [-122.4959, 37.66589], [-122.49606, 37.66594], [-122.49618, 37.66608]]]]} | Open Access 1 | 18134 | Mussel Rock Park | 2960 | 1078 | Daly City, City of 427 | City 2 | City Agency 2 | http://www.dalycity.org/ | City 2 | 1078 | Daly City, City of 421 | City 2 | City Agency 2 | San Mateo 15 | 152.371 | Mussel Rock Park | 0 | Local Park 2 | 4 | |
15428 | 15428 | 15427 | {"type": "Polygon", "coordinates": [[[-122.49663, 37.69768], [-122.49659, 37.69771], [-122.4965, 37.69774], [-122.49643, 37.69775], [-122.49637, 37.69777], [-122.4963, 37.69797], [-122.49625, 37.69802], [-122.49611, 37.6981], [-122.49612, 37.69816], [-122.49609, 37.69823], [-122.49605, 37.69828], [-122.49599, 37.69832], [-122.49546, 37.69842], [-122.49538, 37.69822], [-122.49551, 37.6982], [-122.49565, 37.69816], [-122.49571, 37.698], [-122.49576, 37.69796], [-122.49589, 37.69795], [-122.49619, 37.69801], [-122.49627, 37.69798], [-122.49633, 37.6978], [-122.49637, 37.69775], [-122.49647, 37.69771], [-122.49653, 37.69765], [-122.49658, 37.69763], [-122.49662, 37.69764], [-122.49663, 37.69768]]]} | Open Access 1 | 46692 | Thornton Beach Vista | 30037 | 205 | California Department of Transportation 283 | State 5 | State Agency 5 | http://www.dot.ca.gov/ | Other State 5 | 1078 | Daly City, City of 421 | City 2 | City Agency 2 | San Mateo 15 | 0.584 | Thornton Beach Vista | None 1364 |
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]);