units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
491 rows where MNG_AGENCY = 24 sorted by ACCESS_TYP
This data as json, copyable, CSV (advanced)
DES_TP >30
- Local Park 295
- Local Recreation Area 115
- Local Other or Unknown 26
- Local Conservation Area 4
- National Forest 1
- Local Historic or Cultural Area 1
- None 1
- Local Resource Management Area 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- …
ACCESS_TYP 4
- Open Access 412
- No Public Access 36
- Restricted Access 20
- Unknown Access 3
MNG_AG_TYP 1
- City Agency 471
MNG_AGENCY 1
- Los Angeles, City of · 471 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
730 | 730 | 729 | {"type": "Polygon", "coordinates": [[[-118.33247, 34.0566], [-118.33202, 34.05756], [-118.33104, 34.05732], [-118.33138, 34.05632], [-118.33247, 34.0566]]]} | Open Access 1 | 4724 | Los Angeles High Memorial Park | 21483 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | Los Angeles 6 | 2.835 | Los Angeles High Memorial Park | 0 | Local Park 2 | 4 | |
737 | 737 | 736 | {"type": "Polygon", "coordinates": [[[-118.50977, 34.20099], [-118.50767, 34.20099], [-118.50767, 34.19973], [-118.50918, 34.19972], [-118.5092, 34.19979], [-118.50938, 34.19979], [-118.50938, 34.19974], [-118.50977, 34.19974], [-118.50977, 34.20099]]]} | Open Access 1 | 4829 | Louise Park | 21550 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | Los Angeles 6 | 6.663 | Louise Park | 0 | Local Park 2 | 4 | |
752 | 752 | 751 | {"type": "Polygon", "coordinates": [[[-118.28031, 34.05822], [-118.27848, 34.06102], [-118.27504, 34.05949], [-118.27684, 34.05666], [-118.28031, 34.05822]]]} | Open Access 1 | 4928 | MacArthur Park | 21623 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | Los Angeles 6 | 31.717 | MacArthur Park | 0 | Local Park 2 | 4 | |
791 | 791 | 790 | {"type": "Polygon", "coordinates": [[[-118.30835, 34.01371], [-118.30834, 34.014], [-118.30815, 34.014], [-118.30813, 34.0142], [-118.30731, 34.0142], [-118.30731, 34.01294], [-118.30773, 34.01293], [-118.30779, 34.01291], [-118.30789, 34.01283], [-118.3079, 34.01358], [-118.30812, 34.01359], [-118.30813, 34.01373], [-118.30835, 34.01371]]]} | Open Access 1 | 5154 | Martin Luther King Jr Park | 21907 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | Los Angeles 6 | 2.407 | Martin Luther King Jr Park | 0 | Local Park 2 | 4 | |
792 | 792 | 791 | {"type": "Polygon", "coordinates": [[[-118.57969, 34.26206], [-118.57967, 34.2621], [-118.57963, 34.26211], [-118.57724, 34.26212], [-118.57721, 34.2621], [-118.5772, 34.26208], [-118.5772, 34.25943], [-118.57721, 34.25941], [-118.57725, 34.25939], [-118.57962, 34.25939], [-118.57967, 34.25942], [-118.57969, 34.26206]]]} | Open Access 1 | 5161 | Mason Park | 21943 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | Los Angeles 6 | 17.038 | Mason Park | 0 | Local Park 2 | 4 | |
827 | 827 | 826 | {"type": "Polygon", "coordinates": [[[-118.29052, 33.70593], [-118.29052, 33.70629], [-118.2901, 33.70629], [-118.28968, 33.70635], [-118.28937, 33.70643], [-118.28917, 33.70649], [-118.28883, 33.70664], [-118.28863, 33.70632], [-118.28909, 33.70613], [-118.28954, 33.70601], [-118.29003, 33.70594], [-118.29052, 33.70593]]]} | Open Access 1 | 5952 | Wilder's Addition (Point Fermin Park) | 27505 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | Los Angeles 6 | 1.693 | Wilder's Addition (Point Fermin Park) | None 76 | |||
856 | 856 | 855 | {"type": "Polygon", "coordinates": [[[-118.28914, 33.97559], [-118.28914, 33.97628], [-118.2872, 33.97629], [-118.2872, 33.9756], [-118.28914, 33.97559]]]} | Open Access 1 | 5525 | Mount Carmel Park | 22522 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | Los Angeles 6 | 3.405 | Mount Carmel Park | 0 | Local Park 2 | 4 | |
888 | 888 | 887 | {"type": "MultiPolygon", "coordinates": [[[[-118.44145, 33.9444], [-118.44145, 33.94447], [-118.44138, 33.94465], [-118.44136, 33.94467], [-118.4413, 33.94467], [-118.44127, 33.94464], [-118.4412, 33.94453], [-118.44114, 33.94437], [-118.44113, 33.94429], [-118.44116, 33.94426], [-118.44122, 33.94426], [-118.44141, 33.94434], [-118.44145, 33.9444]]], [[[-118.44163, 33.94405], [-118.44154, 33.94426], [-118.4415, 33.94429], [-118.44146, 33.9443], [-118.44122, 33.9442], [-118.4412, 33.94418], [-118.4412, 33.94415], [-118.44122, 33.94412], [-118.44155, 33.94399], [-118.4416, 33.944], [-118.44163, 33.94405]]], [[[-118.4419, 33.94457], [-118.44153, 33.94471], [-118.44148, 33.94472], [-118.44145, 33.94469], [-118.44145, 33.94465], [-118.44152, 33.94446], [-118.44156, 33.94443], [-118.44163, 33.94443], [-118.44188, 33.9445], [-118.4419, 33.94452], [-118.4419, 33.94457]]], [[[-118.44196, 33.94442], [-118.44193, 33.94445], [-118.44189, 33.94445], [-118.44166, 33.94438], [-118.44161, 33.94434], [-118.4416, 33.94425], [-118.44168, 33.94407], [-118.44171, 33.94405], [-118.44174, 33.94405], [-118.44178, 33.94406], [-118.44196, 33.94438], [-118.44196, 33.94442]]]]} | Open Access 1 | 6312 | Vista Del Mar Park | 27170 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | Los Angeles 6 | 0.852 | Vista Del Mar Park | 0 | Local Park 2 | 4 | |
890 | 890 | 889 | {"type": "Polygon", "coordinates": [[[-118.44628, 33.96116], [-118.44598, 33.9614], [-118.44575, 33.9612], [-118.44605, 33.96097], [-118.44628, 33.96116]]]} | Open Access 1 | 6317 | Titmouse Park | 26375 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | Los Angeles 6 | 0.286 | Titmouse Park | 0 | Local Park 2 | 4 | |
900 | 900 | 899 | {"type": "Polygon", "coordinates": [[[-118.5393, 34.04023], [-118.5392, 34.04026], [-118.53912, 34.04018], [-118.53906, 34.04014], [-118.53896, 34.04012], [-118.53789, 34.04018], [-118.53702, 34.04019], [-118.53585, 34.04014], [-118.53571, 34.04012], [-118.53547, 34.04004], [-118.53525, 34.03993], [-118.53514, 34.03985], [-118.53513, 34.03978], [-118.53515, 34.03976], [-118.53508, 34.03965], [-118.53502, 34.0396], [-118.53492, 34.03957], [-118.53483, 34.0396], [-118.53481, 34.03959], [-118.53495, 34.03938], [-118.53524, 34.0395], [-118.53576, 34.03995], [-118.53608, 34.03994], [-118.53637, 34.04007], [-118.53655, 34.04011], [-118.53679, 34.04004], [-118.53703, 34.04009], [-118.53712, 34.04016], [-118.53771, 34.04016], [-118.53778, 34.04008], [-118.53788, 34.04008], [-118.53794, 34.04014], [-118.53893, 34.04004], [-118.53911, 34.04009], [-118.5393, 34.04023]]]} | Open Access 1 | 6342 | Palisades-Asilomar Park | 28614 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | Los Angeles 6 | 1.433 | Palisades-Asilomar Park | 0 | Local Park 2 | 4 | |
917 | 917 | 916 | {"type": "Polygon", "coordinates": [[[-118.446, 34.13918], [-118.44599, 34.13919], [-118.44597, 34.13919], [-118.44542, 34.13894], [-118.44542, 34.13891], [-118.446, 34.13918]]]} | Open Access 1 | 6396 | Oak Forest West Access | 22965 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | Los Angeles 6 | 0.044 | Oak Forest West Access | 0 | Local Recreation Area 3 | 4 | |
920 | 920 | 919 | {"type": "MultiPolygon", "coordinates": [[[[-118.2933, 33.74611], [-118.2933, 33.74675], [-118.29307, 33.74676], [-118.29293, 33.74681], [-118.2928, 33.7468], [-118.29271, 33.74686], [-118.2927, 33.74694], [-118.29256, 33.74666], [-118.29279, 33.74665], [-118.2928, 33.74611], [-118.2933, 33.74611]]], [[[-118.29437, 33.7462], [-118.29434, 33.74633], [-118.29429, 33.74644], [-118.29347, 33.74646], [-118.29348, 33.74611], [-118.29437, 33.74611], [-118.29437, 33.7462]]], [[[-118.29658, 33.74641], [-118.295, 33.7464], [-118.29449, 33.7464], [-118.29457, 33.7462], [-118.29459, 33.74618], [-118.29598, 33.74618], [-118.29656, 33.74619], [-118.29658, 33.7462], [-118.29658, 33.74641]]], [[[-118.29717, 33.74641], [-118.29681, 33.74641], [-118.29682, 33.7462], [-118.29717, 33.74619], [-118.29717, 33.74641]]], [[[-118.29879, 33.74622], [-118.29878, 33.74641], [-118.29722, 33.74641], [-118.29723, 33.74619], [-118.29878, 33.7462], [-118.29879, 33.74622]]]]} | Open Access 1 | 5882 | Bandini Canyon Park | 15794 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | Los Angeles 6 | 3.959 | Bandini Canyon Park | 0 | Local Park 2 | 4 | |
924 | 924 | 923 | {"type": "MultiPolygon", "coordinates": [[[[-118.29797, 33.72561], [-118.29725, 33.72561], [-118.29724, 33.72563], [-118.29692, 33.72564], [-118.29692, 33.72527], [-118.29797, 33.72527], [-118.29797, 33.72561]]], [[[-118.29824, 33.7247], [-118.29784, 33.7247], [-118.29784, 33.7251], [-118.29692, 33.7251], [-118.29692, 33.72485], [-118.29731, 33.72485], [-118.29731, 33.72476], [-118.29758, 33.72475], [-118.29758, 33.72436], [-118.29823, 33.72436], [-118.29824, 33.7247]]]]} | Open Access 1 | 5892 | Alma Park | 15387 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | Los Angeles 6 | 2.257 | Alma Park | 0 | Local Park 2 | 4 | |
925 | 925 | 924 | {"type": "Polygon", "coordinates": [[[-118.31177, 33.73167], [-118.31176, 33.73332], [-118.31098, 33.73332], [-118.31072, 33.73336], [-118.31042, 33.73346], [-118.30969, 33.73379], [-118.30966, 33.73379], [-118.3096, 33.73376], [-118.30925, 33.7332], [-118.30917, 33.7331], [-118.30891, 33.73287], [-118.30979, 33.73216], [-118.3098, 33.73166], [-118.31177, 33.73167]]]} | Open Access 1 | 5893 | Averill Park | 15727 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | Los Angeles 6 | 10.743 | Averill Park | 0 | Local Park 2 | 4 | |
926 | 926 | 925 | {"type": "Polygon", "coordinates": [[[-118.38249, 34.16339], [-118.38231, 34.1629], [-118.38103, 34.1601], [-118.38166, 34.16015], [-118.38179, 34.1602], [-118.38199, 34.16041], [-118.38213, 34.16054], [-118.38249, 34.16077], [-118.38256, 34.16084], [-118.38263, 34.16094], [-118.38279, 34.16126], [-118.38279, 34.16205], [-118.38278, 34.1622], [-118.38249, 34.16339]]]} | Open Access 1 | 5896 | Valley Village Park | 28628 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://www.laparks.org/dos/parks/facility/valleyVillagePk.htm | Los Angeles 6 | 6.493 | Valley Village Park | 0 | Local Park 2 | 4 |
999 | 999 | 998 | {"type": "Polygon", "coordinates": [[[-118.24932, 33.93589], [-118.24931, 33.93673], [-118.24783, 33.93674], [-118.24784, 33.93589], [-118.24932, 33.93589]]]} | Open Access 1 | 6218 | 109th Street Recreation Center | 15168 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | Los Angeles 6 | 3.184 | 109th Street Rec. Ctr. | 0 | Local Recreation Area 3 | 4 | |
1000 | 1000 | 999 | {"type": "Polygon", "coordinates": [[[-118.24176, 33.93869], [-118.24175, 33.93903], [-118.24158, 33.93902], [-118.24126, 33.93886], [-118.24127, 33.93867], [-118.24176, 33.93869]]]} | Open Access 1 | 6220 | Watts Towers Art Center | 27314 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | Los Angeles 6 | 0.366 | Watts Towers Art Ctr. | 0 | Local Recreation Area 3 | 4 | |
1025 | 1025 | 1024 | {"type": "Polygon", "coordinates": [[[-118.51578, 34.0842], [-118.51146, 34.08421], [-118.51147, 34.09085], [-118.50449, 34.09085], [-118.50453, 34.09008], [-118.50471, 34.08963], [-118.50405, 34.08964], [-118.50409, 34.08955], [-118.50412, 34.08939], [-118.50407, 34.08868], [-118.50472, 34.08863], [-118.50465, 34.08784], [-118.50547, 34.08805], [-118.50717, 34.08751], [-118.50657, 34.08622], [-118.50536, 34.08626], [-118.50463, 34.08654], [-118.50437, 34.0852], [-118.5038, 34.08523], [-118.50381, 34.08485], [-118.50392, 34.08441], [-118.50394, 34.08426], [-118.50393, 34.08408], [-118.5039, 34.08389], [-118.50385, 34.08375], [-118.50376, 34.08357], [-118.50357, 34.08329], [-118.50339, 34.08277], [-118.50376, 34.08268], [-118.50477, 34.08284], [-118.50554, 34.08262], [-118.50551, 34.08319], [-118.50592, 34.0834], [-118.50612, 34.08372], [-118.50557, 34.08415], [-118.50566, 34.08513], [-118.50677, 34.08538], [-118.50793, 34.08535], [-118.50818, 34.08553], [-118.50951, 34.08542], [-118.50992, 34.08369], [-118.5094, 34.08289], [-118.51053, 34.08238], [-118.51101, 34.08205], [-118.51101, 34.08203], [-118.51067, 34.08178], [-118.51099, 34.08132], [-118.51205, 34.08078], [-118.51257, 34.08155], [-118.5157, 34.08409], [-118.51578, 34.0842]]]} | Open Access 1 | 6376 | Mandeville Open Space | 21742 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | Los Angeles 6 | 134.869 | Mandeville OS | 0 | Local Recreation Area 3 | 4 | |
1027 | 1027 | 1026 | {"type": "Polygon", "coordinates": [[[-118.46676, 33.98488], [-118.4666, 33.98497], [-118.46642, 33.98477], [-118.46658, 33.98467], [-118.46676, 33.98488]]]} | Open Access 1 | 6327 | Canal Park | 16796 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | Los Angeles 6 | 0.131 | Canal Park | 0 | Local Park 2 | 4 | |
1035 | 1035 | 1034 | {"type": "Polygon", "coordinates": [[[-118.33822, 34.21675], [-118.3366, 34.21733], [-118.33701, 34.21615], [-118.33703, 34.21547], [-118.33731, 34.21544], [-118.33759, 34.21539], [-118.33784, 34.21529], [-118.33822, 34.21675]]]} | Open Access 1 | 6843 | Villa Cabrini Park | 27098 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | Los Angeles 6 | 4.683 | Villa Cabrini 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]);