units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
491 rows where MNG_AGENCY = 24 sorted by PARK_URL descending
This data as json, copyable, CSV (advanced)
Suggested facets: UNIT_NAME, SUID_NMA, AGNCY_ID, AGNCY_NAME, AGNCY_LEV, AGNCY_TYP, AGNCY_WEB, LAYER, PARK_URL, ACRES, LABEL_NAME, YR_EST, GAP_STS
DES_TP 35
- Local Park 314
- Local Recreation Area 116
- 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
- None 1
- None 1
- None 1
- None 1
- None 1
ACCESS_TYP 4
- Open Access 432
- No Public Access 36
- Restricted Access 20
- Unknown Access 3
MNG_AG_TYP 1
- City Agency 491
MNG_AGENCY 1
- Los Angeles, City of · 491 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
14702 | 14702 | 14701 | {"type": "Polygon", "coordinates": [[[-118.24012, 33.93118], [-118.24012, 33.93118], [-118.2401, 33.93246], [-118.23934, 33.931], [-118.23943, 33.93111], [-118.23957, 33.93117], [-118.24012, 33.93118]]]} | Open Access 1 | 45057 | Watts Serenity Park | 28919 | 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 | https://www.tpl.org/our-work/parks-for-people/fitness-zones/monitor-avenue-park | Los Angeles 6 | 1.147 | Watts Serenity Park | 0 | Local Park 2 | 4 |
15050 | 15050 | 15049 | {"type": "Polygon", "coordinates": [[[-118.31903, 34.101], [-118.31887, 34.101], [-118.31887, 34.10054], [-118.31903, 34.10054], [-118.31903, 34.101]]]} | Open Access 1 | 45719 | Carlton Way Pocket Park | 28612 | 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 | https://www.tpl.org/our-work/parks-for-people/carlton-way-pocket-park | Los Angeles 6 | 0.191 | Carlton Way PP | 0 | Local Park 2 | 4 |
4131 | 4131 | 4130 | {"type": "Polygon", "coordinates": [[[-118.54299, 34.19064], [-118.54284, 34.19074], [-118.54242, 34.19049], [-118.54196, 34.1903], [-118.54174, 34.19014], [-118.54291, 34.18966], [-118.54291, 34.19054], [-118.54299, 34.19064]]]} | Open Access 1 | 47400 | Los Angeles River and Aliso Creek Confluence Park | 31121 | 1400 | Los Angeles - Department of Water and Power, City of 282 | City 2 | City Agency 2 | http://www.ladwp.com/ | City 2 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | https://www.tpl.org/our-work/los-angeles-river-aliso-creek-confluence-project | Los Angeles 6 | 1.682 | Los Angeles River and Aliso Creek Confluence Park | 2016 | Local Park 2 | 4 |
14749 | 14749 | 14748 | {"type": "Polygon", "coordinates": [[[-118.20749, 34.12111], [-118.2074, 34.12143], [-118.20711, 34.12138], [-118.20707, 34.12135], [-118.20707, 34.12132], [-118.20714, 34.12105], [-118.20749, 34.12111]]]} | Open Access 1 | 45089 | York Boulevard Pocket Park | 32599 | 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 | https://www.laparks.org/park/york-boulevard-park | Los Angeles 6 | 0.293 | York Boulevard PP | 0 | Local Park 2 | 4 |
14704 | 14704 | 14703 | {"type": "Polygon", "coordinates": [[[-118.30056, 34.0395], [-118.30046, 34.0395], [-118.30046, 34.03918], [-118.30049, 34.03915], [-118.30055, 34.03915], [-118.30056, 34.0395]]]} | Open Access 1 | 45059 | West Adams Heights Park | 32572 | 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 | https://www.laparks.org/park/west-adams-heights-park | Los Angeles 6 | 0.088 | West Adams Heights Park | 2014 | Local Park 2 | 4 |
11428 | 11428 | 11427 | {"type": "Polygon", "coordinates": [[[-118.29133, 33.98266], [-118.29128, 33.9827], [-118.2911, 33.9827], [-118.2911, 33.98267], [-118.29108, 33.98267], [-118.29108, 33.98255], [-118.29105, 33.98254], [-118.29105, 33.9822], [-118.2913, 33.98228], [-118.29132, 33.9823], [-118.29133, 33.98266]]]} | Open Access 1 | 48096 | Vermont Gage Park | 32601 | 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 | https://www.laparks.org/park/vermont-and-gage-park | Los Angeles 6 | 0.305 | Vermont Gage Park | 0 | Local Park 2 | 4 |
7464 | 7464 | 7463 | {"type": "Polygon", "coordinates": [[[-118.1847, 34.14373], [-118.1843, 34.1441], [-118.18411, 34.14425], [-118.18398, 34.14441], [-118.18362, 34.14471], [-118.18336, 34.14452], [-118.18363, 34.14438], [-118.18361, 34.14434], [-118.1838, 34.14425], [-118.1839, 34.14415], [-118.18417, 34.14373], [-118.18417, 34.14368], [-118.18413, 34.14353], [-118.18414, 34.14341], [-118.18415, 34.14338], [-118.18422, 34.14338], [-118.18428, 34.14334], [-118.18431, 34.14328], [-118.18429, 34.14323], [-118.18433, 34.14321], [-118.18471, 34.14364], [-118.18472, 34.14368], [-118.1847, 34.14373]]]} | Open Access 1 | 6961 | Richard Alatorre Park | 31684 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | http://www.mrca.ca.gov/ | Special District 4 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | https://www.laparks.org/park/richard-alatorre | Los Angeles 6 | 1.404 | Richard Alatorre Park | 0 | Local Park 2 | 4 |
11341 | 11341 | 11340 | {"type": "Polygon", "coordinates": [[[-118.29214, 33.74614], [-118.29214, 33.74647], [-118.29177, 33.74647], [-118.29177, 33.74612], [-118.29179, 33.74611], [-118.2921, 33.74611], [-118.29214, 33.74614]]]} | Open Access 1 | 48106 | Los Angeles Sister Cities Plaza | 32611 | 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 | https://www.laparks.org/park/los-angeles-sister-cities-plaza | Los Angeles 6 | 0.333 | Los Angeles Sister Cities Plaza | 0 | Local Park 2 | 4 |
11415 | 11415 | 11414 | {"type": "Polygon", "coordinates": [[[-118.44058, 34.20165], [-118.44015, 34.20165], [-118.44015, 34.20137], [-118.44021, 34.20134], [-118.44058, 34.20134], [-118.44058, 34.20165]]]} | Open Access 1 | 48104 | Greenwood Square Park | 32609 | 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 | https://www.laparks.org/park/greenwood-square-park | Los Angeles 6 | 0.331 | Greenwood Square Park | 0 | Local Park 2 | 4 |
14705 | 14705 | 14704 | {"type": "Polygon", "coordinates": [[[-118.34039, 34.03371], [-118.34038, 34.03384], [-118.34032, 34.03407], [-118.34007, 34.03394], [-118.34039, 34.03352], [-118.34039, 34.03371]]]} | Open Access 1 | 45060 | Gladys Jean Wesson Park | 32559 | 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 | https://www.laparks.org/park/gladys-jean-wesson-park-aka-west-boulevard | Los Angeles 6 | 0.209 | Gladys Jean Wesson Park | 2014 | Local Park 2 | 4 |
14718 | 14718 | 14717 | {"type": "Polygon", "coordinates": [[[-118.24192, 34.06099], [-118.24184, 34.06114], [-118.2413, 34.06095], [-118.24161, 34.06034], [-118.24171, 34.06037], [-118.24156, 34.06068], [-118.24155, 34.06086], [-118.24192, 34.06099]]]} | Open Access 1 | 45066 | Ord & Yale Street Park | 28069 | 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 | https://la.curbed.com/2017/9/6/16255916/chinatown-park-yale-ord-alpine-recreation-center | Los Angeles 6 | 0.397 | Ord & Yale Street Park | 0 | Local Park 2 | 4 |
14818 | 14818 | 14817 | {"type": "Polygon", "coordinates": [[[-118.29521, 34.27884], [-118.29519, 34.2801], [-118.29503, 34.28012], [-118.29504, 34.2803], [-118.2952, 34.28031], [-118.29519, 34.28119], [-118.29466, 34.28157], [-118.29422, 34.28183], [-118.29408, 34.28193], [-118.29383, 34.28219], [-118.29376, 34.2823], [-118.29367, 34.28249], [-118.29368, 34.28251], [-118.29404, 34.28224], [-118.29422, 34.28204], [-118.29436, 34.28194], [-118.29469, 34.28176], [-118.29496, 34.28158], [-118.29518, 34.28141], [-118.29514, 34.28609], [-118.29164, 34.28609], [-118.29167, 34.28599], [-118.29165, 34.28597], [-118.29157, 34.28602], [-118.29153, 34.28609], [-118.29132, 34.28609], [-118.2914, 34.28588], [-118.29123, 34.28531], [-118.29102, 34.2843], [-118.29098, 34.28401], [-118.29159, 34.28334], [-118.29146, 34.28272], [-118.29116, 34.28235], [-118.29016, 34.28207], [-118.28993, 34.28138], [-118.28979, 34.28133], [-118.28989, 34.2811], [-118.28996, 34.28047], [-118.29016, 34.28012], [-118.29081, 34.27972], [-118.29084, 34.27882], [-118.29521, 34.27884]]]} | Open Access 1 | 47239 | Tujunga Little League Field | 31254 | 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.tujungalittleleague.com/ | Los Angeles 6 | 79.152 | Tujunga Little League Field | 0 | Local Recreation Area 3 | 4 |
15065 | 15065 | 15064 | {"type": "Polygon", "coordinates": [[[-118.46931, 34.16258], [-118.46866, 34.16231], [-118.46826, 34.16216], [-118.46633, 34.16157], [-118.46632, 34.16106], [-118.46918, 34.16165], [-118.46924, 34.16182], [-118.46929, 34.16204], [-118.46931, 34.16258]]]} | Restricted Access 2 | 45827 | Sherman Oaks Castle Park | 28846 | 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/shermanoaks_castlepk/ | Los Angeles 6 | 4.982 | Sherman Oaks Castle Park | 0 | Local Park 2 | 4 |
14725 | 14725 | 14724 | {"type": "Polygon", "coordinates": [[[-118.27176, 33.98752], [-118.27174, 33.98908], [-118.27171, 33.98911], [-118.27101, 33.98911], [-118.27101, 33.98865], [-118.27061, 33.98865], [-118.27061, 33.98754], [-118.27176, 33.98752]]]} | Open Access 1 | 45077 | Slauson-Wall Park | 28101 | 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/environmental/slauson.htm | Los Angeles 6 | 4.101 | Slauson-Wall Park | 0 | Local Park 2 | 4 |
4223 | 4223 | 4222 | {"type": "Polygon", "coordinates": [[[-118.2713, 33.93401], [-118.2713, 33.93437], [-118.2712, 33.93437], [-118.2712, 33.93401], [-118.2713, 33.93401]]]} | Open Access 1 | 45017 | 111th Place Neighborhood Park | 27920 | 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/environmental/pdf/111thPark.pdf | Los Angeles 6 | 0.09 | 111th Place Neighborhood Park | 0 | Local Park 2 | 4 |
15063 | 15063 | 15062 | {"type": "Polygon", "coordinates": [[[-118.59735, 34.1673], [-118.59689, 34.16721], [-118.59699, 34.16688], [-118.59728, 34.16693], [-118.59732, 34.16696], [-118.59735, 34.1671], [-118.59735, 34.1673]]]} | Open Access 1 | 45820 | Old Fire Station 84 Pocket Park | 28839 | 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/environmental/oldFire.htm | Los Angeles 6 | 0.359 | Old Fire Station 84 PP | 0 | Local Park 2 | 4 |
5715 | 5715 | 5714 | {"type": "Polygon", "coordinates": [[[-118.2636, 33.99857], [-118.26343, 33.99857], [-118.26343, 33.99811], [-118.2636, 33.99811], [-118.2636, 33.99857]]]} | Open Access 1 | 45781 | 49th Street Pocket Park | 28800 | 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/environmental/49thStPark.htm | Los Angeles 6 | 0.189 | 49th Street PP | 0 | Local Park 2 | 4 |
4358 | 4358 | 4357 | {"type": "Polygon", "coordinates": [[[-118.2853, 33.94082], [-118.2853, 33.94114], [-118.28516, 33.94114], [-118.28516, 33.94082], [-118.2853, 33.94082]]]} | Open Access 1 | 45731 | 105th Street Pocket Park | 28734 | 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/environmental/105th.htm | Los Angeles 6 | 0.111 | 105th Street PP | 0 | Local Park 2 | 4 |
16808 | 16808 | 16807 | {"type": "Polygon", "coordinates": [[[-118.61446, 34.17738], [-118.61023, 34.17739], [-118.61032, 34.17679], [-118.61033, 34.17586], [-118.61035, 34.17575], [-118.61046, 34.17557], [-118.61346, 34.17557], [-118.61355, 34.17563], [-118.61364, 34.17565], [-118.61441, 34.17565], [-118.61445, 34.1757], [-118.61446, 34.17738]]]} | Open Access 1 | 15474 | Woodland Hills Recreation Center | 30898 | 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/reccenter/facility/woodlandhillsrc.htm | Los Angeles 6 | 18.776 | Woodland Hills Rec. Ctr. | 0 | Local Recreation Area 3 | 4 |
17060 | 17060 | 17059 | {"type": "Polygon", "coordinates": [[[-118.52603, 34.04074], [-118.52584, 34.04176], [-118.52566, 34.04209], [-118.52555, 34.04307], [-118.52552, 34.04343], [-118.52529, 34.04459], [-118.5251, 34.0447], [-118.52499, 34.04446], [-118.52465, 34.04399], [-118.52427, 34.04367], [-118.52438, 34.04357], [-118.52439, 34.04346], [-118.52438, 34.04335], [-118.52369, 34.04267], [-118.52353, 34.04227], [-118.52351, 34.04195], [-118.52352, 34.04162], [-118.52354, 34.04145], [-118.52382, 34.041], [-118.52333, 34.04086], [-118.52344, 34.04061], [-118.52411, 34.04083], [-118.52413, 34.04044], [-118.52444, 34.04055], [-118.52447, 34.03997], [-118.52501, 34.04047], [-118.52589, 34.04059], [-118.52603, 34.04074]]]} | Open Access 1 | 6339 | Palisades Park & Recreation Center | 28791 | 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/reccenter/facility/palisadesRC.htm | Los Angeles 6 | 17.543 | Palisades Park & Rec. Ctr. | 0 | Local Recreation Area 3 | 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]);