units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
27 rows where MNG_AGENCY = 421 sorted by ACRES
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_ID, AGNCY_NAME, AGNCY_LEV, AGNCY_TYP, AGNCY_WEB, LAYER, ACRES, YR_EST
DES_TP 6
- Local Park 17
- Local Recreation Area 6
- None 1
- None 1
- None 1
- None 1
MNG_AG_TYP 1
- City Agency 27
MNG_AGENCY 1
- Daly City, City of · 27 ✖
ACCESS_TYP 1
- Open Access 27
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 | |
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 | |
8785 | 8785 | 8784 | {"type": "Polygon", "coordinates": [[[-122.43747, 37.7074], [-122.43724, 37.70761], [-122.43697, 37.70744], [-122.43721, 37.70722], [-122.43747, 37.7074]]]} | Open Access 1 | 14288 | Polaris Park | 23870 | 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.234 | Polaris Park | 1969 | Local Park 2 | 4 | |
2044 | 2044 | 2043 | {"type": "Polygon", "coordinates": [[[-122.42983, 37.70536], [-122.42971, 37.70543], [-122.42944, 37.70564], [-122.42915, 37.70553], [-122.42926, 37.70533], [-122.42983, 37.70536]]]} | Open Access 1 | 15588 | Arden Court | 15576 | 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.282 | Arden Court | 1963 | Local Park 2 | 4 | |
5148 | 5148 | 5147 | {"type": "Polygon", "coordinates": [[[-122.47214, 37.65904], [-122.47192, 37.65919], [-122.47189, 37.65924], [-122.47161, 37.65914], [-122.47162, 37.65906], [-122.47158, 37.65901], [-122.47176, 37.65883], [-122.47214, 37.65904]]]} | Open Access 1 | 15599 | Cameo Tot Lot | 28794 | 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.303 | Cameo Tot Lot | 1972 | Local Recreation Area 3 | 4 | |
5256 | 5256 | 5255 | {"type": "Polygon", "coordinates": [[[-122.45944, 37.65127], [-122.45942, 37.65138], [-122.45937, 37.65145], [-122.45928, 37.65151], [-122.45917, 37.65153], [-122.45905, 37.65152], [-122.45887, 37.65145], [-122.4588, 37.65138], [-122.45877, 37.65129], [-122.45877, 37.65123], [-122.45944, 37.65127]]]} | Open Access 1 | 15597 | Camelot Tot Lot | 28793 | 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.361 | Camelot Tot Lot | 1972 | Local Recreation Area 3 | 4 | |
5149 | 5149 | 5148 | {"type": "Polygon", "coordinates": [[[-122.47106, 37.65288], [-122.47049, 37.65305], [-122.47037, 37.65276], [-122.47096, 37.65265], [-122.47106, 37.65288]]]} | Open Access 1 | 15601 | Canterbury Tot Lot | 28796 | 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 | Canterbury Tot Lot | 1969 | Local Recreation Area 3 | 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 | |
8780 | 8780 | 8779 | {"type": "Polygon", "coordinates": [[[-122.45024, 37.70477], [-122.44957, 37.70499], [-122.4494, 37.70475], [-122.45005, 37.70451], [-122.45024, 37.70477]]]} | Open Access 1 | 14283 | Dan Gilbrech Park | 17906 | 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.502 | Dan Gilbrech 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 | |||
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 | |
8784 | 8784 | 8783 | {"type": "Polygon", "coordinates": [[[-122.49422, 37.67986], [-122.49409, 37.68022], [-122.49374, 37.68015], [-122.49378, 37.68003], [-122.49381, 37.67984], [-122.49369, 37.67956], [-122.49403, 37.67946], [-122.49422, 37.67986]]]} | Open Access 1 | 14287 | Northridge Park | 28792 | 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.642 | Northridge Park | 1975 | Local Park 2 | 4 | |
1809 | 1809 | 1808 | {"type": "Polygon", "coordinates": [[[-122.46028, 37.70064], [-122.46009, 37.70065], [-122.45961, 37.70111], [-122.45957, 37.70032], [-122.46026, 37.70029], [-122.46028, 37.70064]]]} | Open Access 1 | 15603 | Edgewood Park | 18440 | 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.854 | Edgewood Park | 0 | Local Park 2 | 4 | |
8781 | 8781 | 8780 | {"type": "Polygon", "coordinates": [[[-122.44177, 37.70781], [-122.4411, 37.70804], [-122.44089, 37.70804], [-122.44093, 37.7078], [-122.44118, 37.70732], [-122.44153, 37.70735], [-122.44161, 37.70745], [-122.44172, 37.70765], [-122.44177, 37.70781]]]} | Open Access 1 | 14284 | Mission Hills Park | 22299 | 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 | 1.012 | Mission Hills Park | 1989 | Local Park 2 | 4 | |
8783 | 8783 | 8782 | {"type": "Polygon", "coordinates": [[[-122.49561, 37.68954], [-122.49554, 37.68957], [-122.4952, 37.68961], [-122.49487, 37.68846], [-122.49527, 37.68839], [-122.49561, 37.68954]]]} | Open Access 1 | 14286 | Palisades Park | 23329 | 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 | 1.21 | Palisades Park | 0 | Local Park 2 | 4 | |
8779 | 8779 | 8778 | {"type": "Polygon", "coordinates": [[[-122.45367, 37.70696], [-122.45263, 37.70735], [-122.4524, 37.70684], [-122.45315, 37.70655], [-122.45367, 37.70696]]]} | Open Access 1 | 14281 | Lincoln Park | 21263 | 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 | 1.286 | Lincoln Park | 1980 | Local Park 2 | 4 | |
2045 | 2045 | 2044 | {"type": "Polygon", "coordinates": [[[-122.48424, 37.70817], [-122.48238, 37.70817], [-122.48202, 37.70806], [-122.48203, 37.70759], [-122.48237, 37.7076], [-122.48347, 37.70733], [-122.48364, 37.70723], [-122.48377, 37.70732], [-122.48385, 37.70744], [-122.48389, 37.70757], [-122.48389, 37.70776], [-122.48395, 37.7079], [-122.48403, 37.708], [-122.48424, 37.70817]]]} | Open Access 1 | 15592 | Broderick-Terry Dueling Place | 16414 | 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.321 | Broderick-Terry Dueling Place | None 161 | |||
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 | |
8782 | 8782 | 8781 | {"type": "Polygon", "coordinates": [[[-122.42028, 37.7016], [-122.41998, 37.70231], [-122.41862, 37.70194], [-122.41903, 37.70091], [-122.42007, 37.70115], [-122.42028, 37.7016]]]} | Open Access 1 | 14285 | Bayshore Heights | 15892 | 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.701 | Bayshore Heights | 1985 | None 741 | ||
5937 | 5937 | 5936 | {"type": "Polygon", "coordinates": [[[-122.48453, 37.70411], [-122.48339, 37.70417], [-122.48337, 37.70264], [-122.48434, 37.70264], [-122.48453, 37.70411]]]} | Open Access 1 | 14273 | Westlake Park | 27402 | 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.837 | Westlake Park | 0 | 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]);