superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
33 rows where MNG_AGENCY = 242 sorted by map
This data as json, copyable, CSV (advanced)
Suggested facets: ACRES
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
7308 | 7308 | 7307 | {"type": "MultiPolygon", "coordinates": [[[[-118.37492, 33.81806], [-118.37492, 33.81912], [-118.37442, 33.81908], [-118.37443, 33.81802], [-118.37492, 33.81806]]], [[[-118.37894, 33.85955], [-118.37878, 33.85955], [-118.37878, 33.85916], [-118.37876, 33.85914], [-118.37876, 33.85884], [-118.37894, 33.85875], [-118.37894, 33.85955]]], [[[-118.38545, 33.86935], [-118.38521, 33.86935], [-118.38521, 33.86898], [-118.38541, 33.86928], [-118.38545, 33.86935]]], [[[-118.38767, 33.87273], [-118.3875, 33.87272], [-118.38747, 33.8727], [-118.38746, 33.87241], [-118.38767, 33.87273]]], [[[-118.38942, 33.87265], [-118.3894, 33.87269], [-118.38871, 33.87271], [-118.3884, 33.87224], [-118.38898, 33.87199], [-118.38942, 33.87265]]]]} | Open Access 1 | Redondo Beach Open Space | 24239 | 1270 | Redondo Beach, City of 242 | City 2 | City Agency 2 | http://www.redondo.org | City 2 | 2.971 | Redondo Beach OS | ||
10902 | 10902 | 10901 | {"type": "MultiPolygon", "coordinates": [[[[-118.38413, 33.84424], [-118.3838, 33.84437], [-118.38362, 33.84405], [-118.3836, 33.84397], [-118.38363, 33.8439], [-118.38368, 33.84385], [-118.38376, 33.84383], [-118.38386, 33.84383], [-118.38392, 33.84387], [-118.38397, 33.84393], [-118.38413, 33.84424]]], [[[-118.38438, 33.84494], [-118.38429, 33.84499], [-118.3841, 33.84497], [-118.38404, 33.8449], [-118.38388, 33.84456], [-118.38423, 33.84445], [-118.38441, 33.84478], [-118.38441, 33.84486], [-118.38438, 33.84494]]]]} | Open Access 1 | Vincent Park | 27128 | 1270 | Redondo Beach, City of 242 | City 2 | City Agency 2 | http://www.redondo.org | City 2 | 0.924 | Vincent Park | ||
4314 | 4314 | 4313 | {"type": "Polygon", "coordinates": [[[-118.3602, 33.86163], [-118.35988, 33.86164], [-118.35987, 33.86189], [-118.359, 33.86189], [-118.359, 33.8606], [-118.3602, 33.8606], [-118.3602, 33.86163]]]} | Open Access 1 | Franklin Park | 19065 | 1270 | Redondo Beach, City of 242 | City 2 | City Agency 2 | http://www.redondo.org | City 2 | 3.736 | Franklin Park | ||
6169 | 6169 | 6168 | {"type": "Polygon", "coordinates": [[[-118.36568, 33.86009], [-118.36552, 33.86011], [-118.36552, 33.86188], [-118.36536, 33.86188], [-118.36536, 33.85842], [-118.36568, 33.85842], [-118.36568, 33.86009]]]} | Open Access 1 | Lilienthal Park | 21234 | 1270 | Redondo Beach, City of 242 | City 2 | City Agency 2 | http://www.redondo.org | City 2 | 2.131 | Lilienthal Park | ||
3406 | 3406 | 3405 | {"type": "Polygon", "coordinates": [[[-118.36599, 33.88112], [-118.3656, 33.8815], [-118.3656, 33.88015], [-118.36599, 33.88015], [-118.36599, 33.88112]]]} | Open Access 1 | Dale Page Park | 17894 | 1270 | Redondo Beach, City of 242 | City 2 | City Agency 2 | http://www.redondo.org | City 2 | 1.163 | Dale Page Park | ||
10431 | 10431 | 10430 | {"type": "Polygon", "coordinates": [[[-118.3671, 33.86571], [-118.3671, 33.86611], [-118.36694, 33.86612], [-118.36694, 33.8657], [-118.3671, 33.86571]]]} | Open Access 1 | Townsend Parkette | 26498 | 1270 | Redondo Beach, City of 242 | City 2 | City Agency 2 | http://www.redondo.org | City 2 | 0.168 | Townsend Parkette | ||
8098 | 8098 | 8097 | {"type": "Polygon", "coordinates": [[[-118.37053, 33.86995], [-118.36856, 33.86996], [-118.36856, 33.86914], [-118.37053, 33.86913], [-118.37053, 33.86995]]]} | Open Access 1 | Perry Park | 23614 | 1270 | Redondo Beach, City of 242 | City 2 | City Agency 2 | http://www.redondo.org | City 2 | 4.106 | Perry Park | ||
1177 | 1177 | 1176 | {"type": "Polygon", "coordinates": [[[-118.37269, 33.88366], [-118.37002, 33.88368], [-118.37002, 33.88279], [-118.37268, 33.88279], [-118.37268, 33.88285], [-118.37269, 33.88366]]]} | Open Access 1 | Anderson Park | 15477 | 1270 | Redondo Beach, City of 242 | City 2 | City Agency 2 | http://www.redondo.org | City 2 | 5.938 | Anderson Park | ||
4451 | 4451 | 4450 | {"type": "Polygon", "coordinates": [[[-118.3727, 33.86126], [-118.37269, 33.86142], [-118.37262, 33.86173], [-118.3726, 33.86177], [-118.37254, 33.86182], [-118.37209, 33.86205], [-118.37203, 33.86204], [-118.37195, 33.8619], [-118.37193, 33.86179], [-118.37193, 33.86126], [-118.3727, 33.86126]]]} | Open Access 1 | Fulton Playfield | 19148 | 1270 | Redondo Beach, City of 242 | City 2 | City Agency 2 | http://www.redondo.org | City 2 | 1.216 | Fulton Playfield | ||
14257 | 14257 | 14256 | {"type": "Polygon", "coordinates": [[[-118.37521, 33.81927], [-118.37481, 33.81924], [-118.37482, 33.81911], [-118.37521, 33.81914], [-118.37521, 33.81927]]]} | Open Access 1 | Massena Parkette | 21945 | 1270 | Redondo Beach, City of 242 | City 2 | City Agency 2 | http://www.redondo.org | City 2 | 0.136 | Massena Parkette | ||
5252 | 5252 | 5251 | {"type": "Polygon", "coordinates": [[[-118.37563, 33.82957], [-118.3743, 33.83077], [-118.37429, 33.8313], [-118.37368, 33.83139], [-118.37311, 33.82856], [-118.37351, 33.82804], [-118.37387, 33.82825], [-118.37422, 33.82848], [-118.37563, 33.82957]]]} | Open Access 1 | Hopkins Wilderness Park | 20088 | 1270 | Redondo Beach, City of 242 | City 2 | City Agency 2 | http://www.redondo.org | City 2 | 10.985 | Hopkins Wilderness Park | ||
8096 | 8096 | 8095 | {"type": "Polygon", "coordinates": [[[-118.37572, 33.8587], [-118.37493, 33.8587], [-118.37492, 33.85844], [-118.37497, 33.85841], [-118.37568, 33.85841], [-118.37571, 33.85844], [-118.37572, 33.8587]]]} | Open Access 1 | Perry Allison Playfield | 23612 | 1270 | Redondo Beach, City of 242 | City 2 | City Agency 2 | http://www.redondo.org | City 2 | 0.582 | Perry Allison Playfield | ||
6758 | 6758 | 6757 | {"type": "Polygon", "coordinates": [[[-118.3775, 33.87385], [-118.3775, 33.87426], [-118.37734, 33.87426], [-118.37733, 33.87385], [-118.3775, 33.87385]]]} | Open Access 1 | Mathews Parkette | 21952 | 1270 | Redondo Beach, City of 242 | City 2 | City Agency 2 | http://www.redondo.org | City 2 | 0.177 | Mathews Parkette | ||
4726 | 4726 | 4725 | {"type": "Polygon", "coordinates": [[[-118.37763, 33.86101], [-118.37763, 33.86143], [-118.37747, 33.86143], [-118.37746, 33.86101], [-118.37763, 33.86101]]]} | Open Access 1 | La Paz Parkette | 20785 | 1270 | Redondo Beach, City of 242 | City 2 | City Agency 2 | http://www.redondo.org | City 2 | 0.176 | La Paz Parkette | ||
4710 | 4710 | 4709 | {"type": "Polygon", "coordinates": [[[-118.37797, 33.86434], [-118.37796, 33.86475], [-118.37764, 33.86475], [-118.37763, 33.86434], [-118.37797, 33.86434]]]} | Open Access 1 | Gregg Parkette | 19500 | 1270 | Redondo Beach, City of 242 | City 2 | City Agency 2 | http://www.redondo.org | City 2 | 0.343 | Gregg Parkette | ||
1696 | 1696 | 1695 | {"type": "Polygon", "coordinates": [[[-118.3785, 33.89082], [-118.3774, 33.89083], [-118.3774, 33.89044], [-118.37725, 33.89043], [-118.37724, 33.88957], [-118.37638, 33.89028], [-118.37594, 33.88991], [-118.3769, 33.88911], [-118.3769, 33.88752], [-118.37843, 33.88752], [-118.37849, 33.88757], [-118.3785, 33.89082]]]} | Open Access 1 | Aviation Park | 15730 | 1270 | Redondo Beach, City of 242 | City 2 | City Agency 2 | http://www.redondo.org | City 2 | 13.62 | Aviation Park | ||
3647 | 3647 | 3646 | {"type": "Polygon", "coordinates": [[[-118.37876, 33.85826], [-118.37549, 33.85827], [-118.37531, 33.85739], [-118.37483, 33.85727], [-118.37483, 33.85698], [-118.3749, 33.85669], [-118.37504, 33.8564], [-118.37523, 33.85615], [-118.37538, 33.85602], [-118.37564, 33.85587], [-118.37587, 33.85577], [-118.37813, 33.85513], [-118.37876, 33.85826]]]} | Open Access 1 | Dominguez Park | 18197 | 1270 | Redondo Beach, City of 242 | City 2 | City Agency 2 | http://www.redondo.org | City 2 | 22.865 | Dominguez Park | ||
5307 | 5307 | 5306 | {"type": "Polygon", "coordinates": [[[-118.37992, 33.86807], [-118.37992, 33.86849], [-118.37975, 33.86849], [-118.37976, 33.86808], [-118.37992, 33.86807]]]} | Open Access 1 | Huntington Parkette | 20158 | 1270 | Redondo Beach, City of 242 | City 2 | City Agency 2 | http://www.redondo.org | City 2 | 0.17 | Huntington Parkette | ||
1154 | 1154 | 1153 | {"type": "Polygon", "coordinates": [[[-118.38008, 33.86755], [-118.37992, 33.86755], [-118.37992, 33.86714], [-118.38008, 33.86714], [-118.38008, 33.86755]]]} | Open Access 1 | Beverly Parkette | 16058 | 1270 | Redondo Beach, City of 242 | City 2 | City Agency 2 | http://www.redondo.org | City 2 | 0.168 | Beverly Parkette | ||
14145 | 14145 | 14144 | {"type": "Polygon", "coordinates": [[[-118.38032, 33.83008], [-118.38014, 33.83049], [-118.38004, 33.83074], [-118.37953, 33.83259], [-118.37946, 33.83264], [-118.37939, 33.83263], [-118.37864, 33.83203], [-118.3785, 33.83189], [-118.37858, 33.83155], [-118.37918, 33.82935], [-118.3792, 33.82933], [-118.37923, 33.82933], [-118.37961, 33.82944], [-118.37995, 33.82962], [-118.38006, 33.8297], [-118.37989, 33.82988], [-118.37984, 33.82998], [-118.38032, 33.83008]]]} | Restricted Access 2 | Alta Vista Park | http://www.redondo.org/depts/public_works/parks/altavista.asp | 31602 | 1270 | Redondo Beach, City of 242 | City 2 | City Agency 2 | http://www.redondo.org | City 2 | 8.548 | Alta Vista Park |
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]);