units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
491 rows where MNG_AGENCY = 24
This data as json, copyable, CSV (advanced)
DES_TP 28
- Local Park 195
- Local Recreation Area 92
- Local Other or Unknown 14
- Local Conservation Area 2
- National Forest 1
- Local Historic or Cultural 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 3
- Open Access 288
- No Public Access 23
- Restricted Access 16
MNG_AG_TYP 1
- City Agency 327
MNG_AGENCY 1
- Los Angeles, City of · 327 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
5211 | 5211 | 5210 | {"type": "Polygon", "coordinates": [[[-118.44242, 33.95212], [-118.44232, 33.9523], [-118.44229, 33.95232], [-118.44224, 33.9523], [-118.44215, 33.95215], [-118.44218, 33.9521], [-118.44246, 33.95198], [-118.44248, 33.95201], [-118.44242, 33.95212]]]} | Open Access 1 | 36584 | Trask Triangle Park | 28698 | 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.143 | Trask Triangle Park | 0 | Local Park 2 | 4 | |
5329 | 5329 | 5328 | {"type": "Polygon", "coordinates": [[[-118.43258, 33.98427], [-118.43233, 33.98437], [-118.43132, 33.98486], [-118.43126, 33.98487], [-118.43123, 33.98486], [-118.4305, 33.9838], [-118.4318, 33.98316], [-118.43258, 33.98427]]]} | Open Access 1 | 6333 | Glen Alla Park | 19313 | 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.828 | Glen Alla Park | 0 | Local Park 2 | 4 | |
5369 | 5369 | 5368 | {"type": "MultiPolygon", "coordinates": [[[[-118.20569, 34.06601], [-118.20568, 34.06602], [-118.20569, 34.06608], [-118.20543, 34.06619], [-118.20541, 34.06622], [-118.20085, 34.06839], [-118.1974, 34.06776], [-118.19816, 34.06492], [-118.20146, 34.06554], [-118.20214, 34.06565], [-118.20266, 34.0657], [-118.20319, 34.06573], [-118.20388, 34.06574], [-118.20455, 34.06571], [-118.20481, 34.06572], [-118.20507, 34.06578], [-118.20547, 34.06592], [-118.20563, 34.06596], [-118.20567, 34.06598], [-118.20569, 34.06601]]], [[[-118.20688, 34.06536], [-118.20606, 34.06589], [-118.20535, 34.06568], [-118.20532, 34.06565], [-118.20535, 34.06562], [-118.20688, 34.06536]]], [[[-118.20759, 34.06586], [-118.20758, 34.06594], [-118.20747, 34.06595], [-118.2066, 34.06596], [-118.20729, 34.06563], [-118.20731, 34.06566], [-118.20752, 34.06579], [-118.20759, 34.06586]]]]} | Open Access 1 | 5692 | Lincoln Park | 21266 | 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 | 43.268 | Lincoln Park | 0 | Local Park 2 | 4 | |
5379 | 5379 | 5378 | {"type": "MultiPolygon", "coordinates": [[[[-118.49009, 34.07252], [-118.49006, 34.07266], [-118.48998, 34.07279], [-118.48976, 34.07252], [-118.48972, 34.07104], [-118.48967, 34.0709], [-118.48933, 34.07024], [-118.48922, 34.07], [-118.48958, 34.07056], [-118.48972, 34.0707], [-118.48994, 34.07083], [-118.49006, 34.07107], [-118.49009, 34.07252]]], [[[-118.48922, 34.06999], [-118.48921, 34.06999], [-118.48889, 34.06937], [-118.48868, 34.06909], [-118.48882, 34.06911], [-118.48892, 34.06916], [-118.48903, 34.06928], [-118.48907, 34.06938], [-118.48907, 34.06957], [-118.48909, 34.06971], [-118.48916, 34.0699], [-118.48922, 34.06999]]], [[[-118.48985, 34.07064], [-118.48969, 34.07051], [-118.48929, 34.06987], [-118.48921, 34.06964], [-118.4892, 34.0694], [-118.48921, 34.0694], [-118.48985, 34.07064]]], [[[-118.49104, 34.07372], [-118.4906, 34.07359], [-118.49057, 34.07351], [-118.49005, 34.07288], [-118.49012, 34.07276], [-118.49017, 34.07262], [-118.49018, 34.07255], [-118.49086, 34.07338], [-118.49104, 34.07372]]], [[[-118.49199, 34.07546], [-118.49196, 34.07594], [-118.49177, 34.07593], [-118.49174, 34.07589], [-118.49175, 34.07557], [-118.4917, 34.07537], [-118.49145, 34.07494], [-118.49138, 34.07487], [-118.49127, 34.07482], [-118.49068, 34.07372], [-118.49111, 34.07385], [-118.49199, 34.07546]]], [[[-118.50133, 34.10922], [-118.50107, 34.10941], [-118.49584, 34.1018], [-118.49627, 34.09972], [-118.49607, 34.09983], [-118.4959, 34.09997], [-118.49583, 34.10002], [-118.4957, 34.10007], [-118.49561, 34.10008], [-118.49546, 34.10006], [-118.49532, 34.1], [-118.49522, 34.09991], [-118.49515, 34.09978], [-118.49515, 34.09963], [-118.4952, 34.09951], [-118.49533, 34.0994], [-118.49541, 34.09936], [-118.49554, 34.09933], [-118.49563, 34.09933], [-118.49622, 34.09945], [-118.49635, 34.09938], [-118.49748, 34.09407], [-118.49598, 34.08746], [-118.49578, 34.0865], [-118.49576, 34.0865], [-118.49576, 34.08665], [-118.49443, 34.08665], [-118.49443, 34.08457], [-118.49535, 34.08456], [-118.49528, 34.08426], [-118.49503, 34.0824], [-118.49483, 34.08157], [-118.49496, 34.0815], [-118.49472, 34.08117], [-118.4944, 34.0798], [-118.4916, 34.07645], [-118.49162, 34.07603], [-118.49196, 34.07604], [-118.49193, 34.07638], [-118.49471, 34.07969], [-118.49535, 34.08234], [-118.49561, 34.08421], [-118.49781, 34.09407], [-118.49618, 34.10176], [-118.50133, 34.10922]], [[-118.49547, 34.08519], [-118.49548, 34.08518], [-118.49542, 34.08495], [-118.49534, 34.08509], [-118.49547, 34.08519]], [[-118.49557, 34.08587], [-118.49564, 34.08587], [-118.49559, 34.08567], [-118.49556, 34.0857], [-118.49557, 34.08587]]]]} | Open Access 1 | 7157 | Los Angeles City Water Resource Parkland | 21478 | 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 | 42.397 | Los Angeles City Water Resource Parkland | 0 | Local Park 2 | 4 | |
5383 | 5383 | 5382 | {"type": "Polygon", "coordinates": [[[-118.46291, 34.27183], [-118.46266, 34.27268], [-118.45861, 34.27261], [-118.45665, 34.27404], [-118.45633, 34.27375], [-118.45635, 34.27372], [-118.45607, 34.27345], [-118.45635, 34.27323], [-118.45487, 34.27183], [-118.45518, 34.27181], [-118.45563, 34.27181], [-118.46131, 34.27203], [-118.46169, 34.27202], [-118.46212, 34.27199], [-118.46254, 34.27192], [-118.46291, 34.27183]]]} | Open Access 1 | 9999 | Brand Park | 16329 | 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 | 18.515 | Brand Park | 0 | Local Park 2 | 4 | |
5390 | 5390 | 5389 | {"type": "Polygon", "coordinates": [[[-118.27253, 33.98433], [-118.27253, 33.98468], [-118.2724, 33.98468], [-118.2724, 33.98433], [-118.27253, 33.98433]]]} | Open Access 1 | 45782 | 61st Street Pocket Park | 28801 | 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.118 | 61st Street PP | 0 | Local Park 2 | 4 | |
5411 | 5411 | 5410 | {"type": "Polygon", "coordinates": [[[-118.58708, 34.13904], [-118.58568, 34.13904], [-118.58568, 34.13813], [-118.58707, 34.13866], [-118.58708, 34.13904]]]} | No Public Access 3 | 7166 | Los Angeles City Water Resource Parkland | 21477 | 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.267 | Los Angeles City Water Resource Parkland | 0 | Local Park 2 | 4 | |
5495 | 5495 | 5494 | {"type": "Polygon", "coordinates": [[[-118.38093, 34.1267], [-118.38083, 34.12681], [-118.38083, 34.12701], [-118.38061, 34.12707], [-118.38043, 34.12717], [-118.38031, 34.12721], [-118.3802, 34.12721], [-118.38011, 34.12718], [-118.38003, 34.12714], [-118.37992, 34.12701], [-118.3798, 34.12694], [-118.37975, 34.12694], [-118.37974, 34.12695], [-118.37963, 34.12692], [-118.37943, 34.1269], [-118.37939, 34.12686], [-118.37941, 34.12663], [-118.38093, 34.1267]]]} | No Public Access 3 | 12819 | Los Angeles City Water Resource Parkland | 21477 | 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.441 | Los Angeles City Water Resource Parkland | 0 | Local Park 2 | 4 | |
5496 | 5496 | 5495 | {"type": "Polygon", "coordinates": [[[-118.39301, 34.11863], [-118.39283, 34.11899], [-118.39267, 34.11881], [-118.39276, 34.11874], [-118.39271, 34.11868], [-118.3926, 34.11875], [-118.39249, 34.11863], [-118.39234, 34.11881], [-118.39226, 34.11887], [-118.39219, 34.11889], [-118.39201, 34.11889], [-118.39183, 34.11881], [-118.39175, 34.11874], [-118.39223, 34.11873], [-118.39222, 34.11808], [-118.39228, 34.11821], [-118.39284, 34.11848], [-118.39299, 34.11857], [-118.39297, 34.1186], [-118.39301, 34.11863]]]} | No Public Access 3 | 12820 | Los Angeles City Water Resource Parkland | 21477 | 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.964 | Los Angeles City Water Resource Parkland | 0 | Local Park 2 | 4 | |
5497 | 5497 | 5496 | {"type": "Polygon", "coordinates": [[[-118.39276, 34.11874], [-118.39267, 34.11881], [-118.3926, 34.11875], [-118.39271, 34.11867], [-118.39276, 34.11874]]]} | No Public Access 3 | 12821 | Los Angeles City Water Resource Parkland | 21477 | 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.028 | Los Angeles City Water Resource Parkland | 0 | Local Park 2 | 4 | |
5681 | 5681 | 5680 | {"type": "Polygon", "coordinates": [[[-118.40207, 34.03879], [-118.40217, 34.03893], [-118.4023, 34.03905], [-118.40231, 34.03908], [-118.40229, 34.03911], [-118.40212, 34.03916], [-118.40197, 34.03924], [-118.40193, 34.03924], [-118.4019, 34.03921], [-118.40189, 34.03908], [-118.40191, 34.03894], [-118.40199, 34.03878], [-118.40203, 34.03877], [-118.40207, 34.03879]]]} | Open Access 1 | 45746 | Club Circle Park | 28750 | 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.3 | Club Circle Park | 0 | Local Park 2 | 4 | |
5688 | 5688 | 5687 | {"type": "MultiPolygon", "coordinates": [[[[-118.35224, 34.21461], [-118.35214, 34.21469], [-118.35207, 34.21469], [-118.35153, 34.21428], [-118.35075, 34.21349], [-118.35224, 34.21461]]], [[[-118.35456, 34.21679], [-118.35366, 34.21607], [-118.35317, 34.21553], [-118.35296, 34.21536], [-118.3523, 34.21486], [-118.35229, 34.21483], [-118.3523, 34.21479], [-118.35238, 34.21472], [-118.35309, 34.21525], [-118.35336, 34.21547], [-118.35368, 34.21578], [-118.35456, 34.21679]]]]} | Open Access 1 | 45747 | De Garmo Park | 28751 | 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.641 | De Garmo Park | 0 | Local Park 2 | 4 | |
5689 | 5689 | 5688 | {"type": "Polygon", "coordinates": [[[-118.28776, 33.98236], [-118.28763, 33.98236], [-118.28762, 33.98231], [-118.28718, 33.98231], [-118.28722, 33.98226], [-118.28776, 33.98208], [-118.28776, 33.98236]]]} | Open Access 1 | 45753 | Hoover-Gage Park | 28757 | 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/hooverGagePk.htm | Los Angeles 6 | 0.206 | Hoover-Gage Park | 0 | Local Park 2 | 4 |
5690 | 5690 | 5689 | {"type": "Polygon", "coordinates": [[[-118.27132, 34.06879], [-118.27084, 34.06957], [-118.27011, 34.06925], [-118.27043, 34.06874], [-118.27067, 34.06885], [-118.27073, 34.06876], [-118.27089, 34.06883], [-118.27101, 34.06865], [-118.27132, 34.06879]]]} | Open Access 1 | 45754 | Lake Street Park | 28758 | 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/lakestComC.htm | Los Angeles 6 | 1.52 | Lake Street Park | 0 | Local Park 2 | 4 |
5695 | 5695 | 5694 | {"type": "Polygon", "coordinates": [[[-118.27159, 33.95943], [-118.27159, 33.95959], [-118.27132, 33.95959], [-118.27132, 33.95944], [-118.27159, 33.95943]]]} | Open Access 1 | 45734 | Wall Street Community Park | 28737 | 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.102 | Wall Street Community Park | 0 | Local Park 2 | 4 | |
5696 | 5696 | 5695 | {"type": "Polygon", "coordinates": [[[-118.29818, 34.06162], [-118.29723, 34.06162], [-118.29617, 34.06163], [-118.29617, 34.06159], [-118.29669, 34.06159], [-118.2967, 34.06149], [-118.29818, 34.06147], [-118.29818, 34.06162]]]} | Restricted Access 2 | 45735 | Robert F Kennedy Inspiration Park | 31643 | 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/commissionerhtm/pdf2010/oct06/10-266.pdf | Los Angeles 6 | 0.574 | Robert F Kennedy Inspiration Park | 0 | Local Park 2 | 4 |
5698 | 5698 | 5697 | {"type": "Polygon", "coordinates": [[[-118.24026, 33.92966], [-118.24026, 33.93026], [-118.24008, 33.93026], [-118.24008, 33.92966], [-118.24026, 33.92966]]]} | Open Access 1 | 45737 | Grigsby Park | 28741 | 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/commissionerhtm/pdf2010/feb17/10-033.pdf | Los Angeles 6 | 0.285 | Grigsby Park | 0 | Local Park 2 | 4 |
5699 | 5699 | 5698 | {"type": "Polygon", "coordinates": [[[-118.1619, 34.0922], [-118.16127, 34.09262], [-118.16102, 34.09237], [-118.16126, 34.0922], [-118.16125, 34.09189], [-118.16146, 34.09185], [-118.16149, 34.09192], [-118.16157, 34.09201], [-118.16171, 34.09211], [-118.1619, 34.0922]]]} | Open Access 1 | 45738 | El Sereno Community Gardens | 28742 | 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.778 | El Sereno Community Gardens | 0 | Local Park 2 | 4 | |
5700 | 5700 | 5699 | {"type": "Polygon", "coordinates": [[[-118.41819, 34.25299], [-118.41809, 34.25306], [-118.41777, 34.25275], [-118.41787, 34.25268], [-118.41819, 34.25299]]]} | Open Access 1 | 45739 | Amistad Park | 28743 | 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.138 | Amistad Park | 0 | Local Park 2 | 4 | |
5702 | 5702 | 5701 | {"type": "Polygon", "coordinates": [[[-118.21106, 34.03932], [-118.21067, 34.03991], [-118.21062, 34.03994], [-118.21057, 34.03993], [-118.20993, 34.03964], [-118.21034, 34.03899], [-118.21106, 34.03932]]]} | Restricted Access 2 | 45762 | Roosevelt High School Pool | 28767 | 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/aquatic/facility/rooseveltPool.htm | Los Angeles 6 | 1.493 | Roosevelt High School Pool | 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]);