units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
37 rows where MNG_AGENCY = 242 sorted by LABEL_NAME descending
This data as json, copyable, CSV (advanced)
Suggested facets: UNIT_NAME, SUID_NMA, ACRES, LABEL_NAME, YR_EST, GAP_STS
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
7063 | 7063 | 7062 | {"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 | 6061 | Vincent Park | 27128 | 1270 | Redondo Beach, City of 246 | City 2 | City Agency 2 | http://www.redondo.org | City 2 | 1270 | Redondo Beach, City of 242 | City 2 | City Agency 2 | Los Angeles 6 | 0.925 | Vincent Park | 0 | Local Park 2 | 4 | |
7060 | 7060 | 7059 | {"type": "Polygon", "coordinates": [[[-118.39016, 33.83762], [-118.3901, 33.83809], [-118.39011, 33.83828], [-118.38943, 33.8384], [-118.38927, 33.83835], [-118.38905, 33.83822], [-118.38874, 33.8381], [-118.38848, 33.83805], [-118.38825, 33.83803], [-118.3882, 33.83799], [-118.3882, 33.83797], [-118.38822, 33.83796], [-118.38818, 33.83755], [-118.38853, 33.83753], [-118.38853, 33.83748], [-118.38861, 33.83736], [-118.38858, 33.83687], [-118.38873, 33.83674], [-118.38844, 33.83659], [-118.38857, 33.83643], [-118.38878, 33.83623], [-118.38948, 33.83623], [-118.38949, 33.83646], [-118.38952, 33.83644], [-118.38956, 33.83627], [-118.38974, 33.83628], [-118.38984, 33.83639], [-118.38996, 33.83657], [-118.39003, 33.83675], [-118.39016, 33.83762]], [[-118.3886, 33.8377], [-118.38858, 33.83767], [-118.3883, 33.83774], [-118.38837, 33.8379], [-118.38843, 33.83798], [-118.38868, 33.83786], [-118.3886, 33.8377]]]} | Open Access 1 | 6058 | Veterans Park | 27048 | 1270 | Redondo Beach, City of 246 | City 2 | City Agency 2 | http://www.redondo.org | City 2 | 1270 | Redondo Beach, City of 242 | City 2 | City Agency 2 | Los Angeles 6 | 7.833 | Veterans Park | 0 | Local Park 2 | 4 | |
1973 | 1973 | 1972 | {"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 | 6077 | Townsend Parkette | 26498 | 1270 | Redondo Beach, City of 246 | City 2 | City Agency 2 | http://www.redondo.org | City 2 | 1270 | Redondo Beach, City of 242 | City 2 | City Agency 2 | Los Angeles 6 | 0.169 | Townsend Parkette | 0 | Local Park 2 | 4 | |
1995 | 1995 | 1994 | {"type": "Polygon", "coordinates": [[[-118.38198, 33.8634], [-118.38162, 33.86356], [-118.38151, 33.8634], [-118.38168, 33.8634], [-118.38198, 33.8634]]]} | Open Access 1 | 6084 | Sneary Parkette | 25580 | 1270 | Redondo Beach, City of 246 | City 2 | City Agency 2 | http://www.redondo.org | City 2 | 1270 | Redondo Beach, City of 242 | City 2 | City Agency 2 | Los Angeles 6 | 0.098 | Sneary Parkette | 0 | Local Park 2 | 4 | |
724 | 724 | 723 | {"type": "Polygon", "coordinates": [[[-118.39535, 33.84489], [-118.3944, 33.84514], [-118.39429, 33.8451], [-118.3941, 33.84517], [-118.39403, 33.84513], [-118.39382, 33.84468], [-118.39327, 33.84426], [-118.39374, 33.84384], [-118.39428, 33.84415], [-118.39471, 33.84423], [-118.39513, 33.84427], [-118.39535, 33.84489]]]} | Open Access 1 | 5468 | Seaside Lagoon Park | 32657 | 1270 | Redondo Beach, City of 246 | City 2 | City Agency 2 | http://www.redondo.org | City 2 | 1270 | Redondo Beach, City of 242 | City 2 | City Agency 2 | Los Angeles 6 | 3.802 | Seaside Lagoon Park | 0 | Local Park 2 | 4 | |
7061 | 7061 | 7060 | {"type": "Polygon", "coordinates": [[[-118.39283, 33.83951], [-118.39263, 33.84033], [-118.39231, 33.84086], [-118.39197, 33.84097], [-118.39202, 33.84107], [-118.39202, 33.84109], [-118.3922, 33.84141], [-118.39168, 33.84149], [-118.39159, 33.84168], [-118.39154, 33.84186], [-118.39152, 33.84203], [-118.39172, 33.84269], [-118.39164, 33.84273], [-118.39135, 33.84219], [-118.39128, 33.8422], [-118.39113, 33.84191], [-118.39097, 33.84196], [-118.39083, 33.84171], [-118.39099, 33.84163], [-118.39087, 33.84142], [-118.39082, 33.84143], [-118.39056, 33.84096], [-118.39024, 33.84107], [-118.38999, 33.84059], [-118.39021, 33.8405], [-118.38984, 33.83979], [-118.38981, 33.83979], [-118.38965, 33.8395], [-118.38964, 33.83947], [-118.38978, 33.83944], [-118.38979, 33.83943], [-118.3895, 33.83887], [-118.3897, 33.839], [-118.38981, 33.83904], [-118.38987, 33.83908], [-118.39001, 33.83909], [-118.39011, 33.83936], [-118.39056, 33.83926], [-118.39045, 33.83892], [-118.39121, 33.83873], [-118.39117, 33.83862], [-118.39155, 33.83854], [-118.39172, 33.83877], [-118.39239, 33.83861], [-118.39268, 33.83944], [-118.39283, 33.83951]]]} | Open Access 1 | 6059 | Redondo Beach Pier | 24241 | 1270 | Redondo Beach, City of 246 | City 2 | City Agency 2 | http://www.redondo.org | City 2 | 1270 | Redondo Beach, City of 242 | City 2 | City Agency 2 | Los Angeles 6 | 17.467 | Redondo Beach Pier | 0 | None 577 | ||
1996 | 1996 | 1995 | {"type": "MultiPolygon", "coordinates": [[[[-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 | 6067 | Redondo Beach Open Space | 24239 | 1270 | Redondo Beach, City of 246 | City 2 | City Agency 2 | http://www.redondo.org | City 2 | 1270 | Redondo Beach, City of 242 | City 2 | City Agency 2 | Los Angeles 6 | 1.196 | Redondo Beach OS | 0 | Local Recreation Area 3 | 4 | |
6868 | 6868 | 6867 | {"type": "Polygon", "coordinates": [[[-118.38545, 33.86935], [-118.38521, 33.86935], [-118.38521, 33.86898], [-118.38541, 33.86928], [-118.38545, 33.86935]]]} | Open Access 1 | 6091 | Redondo Beach Open Space | 24239 | 1270 | Redondo Beach, City of 246 | City 2 | City Agency 2 | http://www.redondo.org | City 2 | 1270 | Redondo Beach, City of 242 | City 2 | City Agency 2 | Los Angeles 6 | 0.118 | Redondo Beach OS | 0 | Local Recreation Area 3 | 4 | |
7879 | 7879 | 7878 | {"type": "Polygon", "coordinates": [[[-118.37492, 33.81806], [-118.37492, 33.81912], [-118.37442, 33.81908], [-118.37443, 33.81802], [-118.37492, 33.81806]]]} | Open Access 1 | 12578 | Redondo Beach Open Space | 24239 | 1270 | Redondo Beach, City of 246 | City 2 | City Agency 2 | http://www.redondo.org | City 2 | 1270 | Redondo Beach, City of 242 | City 2 | City Agency 2 | Los Angeles 6 | 1.333 | Redondo Beach OS | 0 | Local Recreation Area 3 | 4 | |
15862 | 15862 | 15861 | {"type": "Polygon", "coordinates": [[[-118.37894, 33.85955], [-118.37878, 33.85955], [-118.37878, 33.85915], [-118.37876, 33.85914], [-118.37876, 33.85884], [-118.37894, 33.85875], [-118.37894, 33.85955]]]} | Open Access 1 | 6071 | Redondo Beach Open Space | 24239 | 1270 | Redondo Beach, City of 246 | City 2 | City Agency 2 | http://www.redondo.org | City 2 | 1270 | Redondo Beach, City of 242 | City 2 | City Agency 2 | Los Angeles 6 | 0.325 | Redondo Beach OS | 0 | Local Recreation Area 3 | 4 | |
1974 | 1974 | 1973 | {"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 | 6078 | Perry Park | 23614 | 1270 | Redondo Beach, City of 246 | City 2 | City Agency 2 | http://www.redondo.org | City 2 | 1270 | Redondo Beach, City of 242 | City 2 | City Agency 2 | Los Angeles 6 | 4.107 | Perry Park | 0 | Local Park 2 | 4 | |
1975 | 1975 | 1974 | {"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 | 6079 | Perry Allison Playfield | 23612 | 1270 | Redondo Beach, City of 246 | City 2 | City Agency 2 | http://www.redondo.org | City 2 | 1270 | Redondo Beach, City of 242 | City 2 | City Agency 2 | Los Angeles 6 | 0.583 | Perry Allison Playfield | 0 | Local Recreation Area 3 | 4 | |
975 | 975 | 974 | {"type": "Polygon", "coordinates": [[[-118.39965, 33.84813], [-118.39896, 33.84828], [-118.39862, 33.84723], [-118.39869, 33.84718], [-118.39878, 33.84709], [-118.39886, 33.84712], [-118.39892, 33.84715], [-118.39965, 33.84813]]]} | Open Access 1 | 6095 | Moonstone Park | 22456 | 1270 | Redondo Beach, City of 246 | City 2 | City Agency 2 | http://www.redondo.org | City 2 | 1270 | Redondo Beach, City of 242 | City 2 | City Agency 2 | Los Angeles 6 | 1.461 | Moonstone Park | 0 | Local Park 2 | 4 | |
1977 | 1977 | 1976 | {"type": "Polygon", "coordinates": [[[-118.3842, 33.86131], [-118.38404, 33.86131], [-118.38403, 33.86103], [-118.38419, 33.86103], [-118.3842, 33.86131]]]} | Open Access 1 | 6080 | McNeill Parkette | 22065 | 1270 | Redondo Beach, City of 246 | City 2 | City Agency 2 | http://www.redondo.org | City 2 | 1270 | Redondo Beach, City of 242 | City 2 | City Agency 2 | Los Angeles 6 | 0.115 | McNeill Parkette | 0 | Local Park 2 | 4 | |
1987 | 1987 | 1986 | {"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 | 6082 | Mathews Parkette | 21952 | 1270 | Redondo Beach, City of 246 | City 2 | City Agency 2 | http://www.redondo.org | City 2 | 1270 | Redondo Beach, City of 242 | City 2 | City Agency 2 | Los Angeles 6 | 0.177 | Mathews Parkette | 0 | Local Park 2 | 4 | |
6303 | 6303 | 6302 | {"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 | 5993 | Massena Parkette | 21945 | 1270 | Redondo Beach, City of 246 | City 2 | City Agency 2 | http://www.redondo.org | City 2 | 1270 | Redondo Beach, City of 242 | City 2 | City Agency 2 | Los Angeles 6 | 0.136 | Massena Parkette | 0 | Local Park 2 | 4 | |
979 | 979 | 978 | {"type": "Polygon", "coordinates": [[[-118.36568, 33.86009], [-118.36552, 33.8601], [-118.36552, 33.86188], [-118.36536, 33.86188], [-118.36536, 33.85842], [-118.36568, 33.85842], [-118.36568, 33.86009]]]} | Open Access 1 | 6075 | Lilienthal Park | 21234 | 1270 | Redondo Beach, City of 246 | City 2 | City Agency 2 | http://www.redondo.org | City 2 | 1270 | Redondo Beach, City of 242 | City 2 | City Agency 2 | Los Angeles 6 | 2.13 | Lilienthal Park | 0 | Local Park 2 | 4 | |
1971 | 1971 | 1970 | {"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 | 6072 | La Paz Parkette | 20785 | 1270 | Redondo Beach, City of 246 | City 2 | City Agency 2 | http://www.redondo.org | City 2 | 1270 | Redondo Beach, City of 242 | City 2 | City Agency 2 | Los Angeles 6 | 0.176 | La Paz Parkette | 0 | Local Park 2 | 4 | |
1988 | 1988 | 1987 | {"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 | 6083 | Huntington Parkette | 20158 | 1270 | Redondo Beach, City of 246 | City 2 | City Agency 2 | http://www.redondo.org | City 2 | 1270 | Redondo Beach, City of 242 | City 2 | City Agency 2 | Los Angeles 6 | 0.17 | Huntington Parkette | 0 | Local Park 2 | 4 | |
964 | 964 | 963 | {"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.37421, 33.82848], [-118.37563, 33.82957]]]} | Open Access 1 | 6056 | Hopkins Wilderness Park | 20088 | 1270 | Redondo Beach, City of 246 | City 2 | City Agency 2 | http://www.redondo.org | City 2 | 1270 | Redondo Beach, City of 242 | City 2 | City Agency 2 | Los Angeles 6 | 10.984 | Hopkins Wilderness Park | 0 | Local Conservation Area 4 | 2 |
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]);