units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
175 rows where MNG_AGENCY = 16 sorted by SUID_NMA
This data as json, copyable, CSV (advanced)
DES_TP 22
- Local Park 66
- Local Recreation Area 26
- Local Conservation Area 14
- Local Other or Unknown 11
- Local Historic or Cultural Area 1
- National Recreation 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
ACCESS_TYP 4
MNG_AG_TYP 1
- County Agency 135
MNG_AGENCY 1
- Los Angeles, County of · 135 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
11924 | 11924 | 11923 | {"type": "Polygon", "coordinates": [[[-118.50387, 34.02695], [-118.50386, 34.02706], [-118.5038, 34.02717], [-118.50371, 34.02726], [-118.5036, 34.02732], [-118.50347, 34.02736], [-118.50337, 34.02737], [-118.50327, 34.02733], [-118.50321, 34.02727], [-118.50319, 34.02722], [-118.5032, 34.02716], [-118.50325, 34.02704], [-118.50335, 34.02693], [-118.50346, 34.02686], [-118.50361, 34.02682], [-118.50373, 34.02681], [-118.50382, 34.02686], [-118.50387, 34.02695]]]} | Open Access 1 | 24529 | Goose Egg Park | 19406 | 1323 | Santa Monica, City of 184 | City 2 | City Agency 2 | http://santa-monica.org/departments/ccs/content.aspx?id=32599 | City 2 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | Los Angeles 6 | 0.674 | Goose Egg Park | 0 | Local Park 2 | 4 | |
3382 | 3382 | 3381 | {"type": "Polygon", "coordinates": [[[-118.62106, 34.45164], [-118.62107, 34.45184], [-118.62102, 34.45201], [-118.62092, 34.45216], [-118.62076, 34.45229], [-118.62003, 34.45265], [-118.61979, 34.45275], [-118.61957, 34.45281], [-118.61934, 34.45285], [-118.61898, 34.45287], [-118.61899, 34.45259], [-118.61893, 34.45157], [-118.61917, 34.45156], [-118.61924, 34.45151], [-118.61933, 34.45155], [-118.61943, 34.45152], [-118.61948, 34.45157], [-118.62007, 34.45154], [-118.62014, 34.45147], [-118.62025, 34.4515], [-118.62029, 34.45158], [-118.62069, 34.45167], [-118.62071, 34.45165], [-118.62106, 34.45164]]]} | Open Access 1 | 24535 | Hasley Canyon Park | 19731 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | Los Angeles 6 | 5.363 | Hasley Canyon Park | 0 | Local Park 2 | 4 | |
995 | 995 | 994 | {"type": "Polygon", "coordinates": [[[-118.29344, 33.91692], [-118.29343, 33.91878], [-118.29194, 33.91879], [-118.29196, 33.91698], [-118.29227, 33.91697], [-118.29228, 33.91692], [-118.29344, 33.91692]]]} | Open Access 1 | 6205 | Helen Keller Park | 19797 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | Los Angeles 6 | 6.993 | Helen Keller Park | 0 | Local Park 2 | 4 | |
16051 | 16051 | 16050 | {"type": "Polygon", "coordinates": [[[-118.29278, 34.22166], [-118.2774, 34.22176], [-118.27738, 34.21871], [-118.2773, 34.21531], [-118.27834, 34.21531], [-118.27835, 34.21456], [-118.28057, 34.21456], [-118.28668, 34.2146], [-118.29156, 34.2202], [-118.29278, 34.22166]], [[-118.28164, 34.21533], [-118.28164, 34.21532], [-118.28095, 34.21457], [-118.27956, 34.21495], [-118.27872, 34.21549], [-118.27971, 34.21654], [-118.28164, 34.21533]]]} | Open Access 1 | 6829 | Henderson Canyon Open Space | 19812 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | Los Angeles 6 | 214.059 | Henderson Canyon OS | 0 | Local Recreation Area 3 | 4 | |
14245 | 14245 | 14244 | {"type": "Polygon", "coordinates": [[[-118.03024, 34.15973], [-118.02975, 34.15977], [-118.0297, 34.1602], [-118.02916, 34.16008], [-118.02882, 34.16003], [-118.02852, 34.16], [-118.02806, 34.16001], [-118.02952, 34.15919], [-118.03012, 34.15918], [-118.03024, 34.15973]]]} | Restricted Access 2 | 44142 | Highland Oaks Park | 19930 | 2315 | Arcadia Unified School District 762 | Special District 4 | School District 14 | http://site.ausd.net/ | Special District 4 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | Los Angeles 6 | 2.851 | Highland Oaks Park | 0 | Local Park 2 | 4 | |
6502 | 6502 | 6501 | {"type": "Polygon", "coordinates": [[[-117.9227, 34.54259], [-117.92261, 34.54266], [-117.90969, 34.54268], [-117.90967, 34.53918], [-117.92267, 34.53916], [-117.9227, 34.54259]]]} | Open Access 1 | 2385 | Jackrabbit Flats Wildlife Sanctuary | 20317 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | Los Angeles 6 | 114.439 | Jackrabbit Flats Wildlife Sanctuary | 0 | Local Conservation Area 4 | 2 | |
7588 | 7588 | 7587 | {"type": "Polygon", "coordinates": [[[-118.58186, 34.38143], [-118.5814, 34.38179], [-118.58125, 34.38199], [-118.58102, 34.38221], [-118.58064, 34.38249], [-118.58034, 34.38267], [-118.57979, 34.38198], [-118.57962, 34.38135], [-118.57997, 34.38127], [-118.58047, 34.38112], [-118.58096, 34.38092], [-118.58127, 34.38077], [-118.58185, 34.38136], [-118.58186, 34.38143]]]} | Open Access 1 | 7297 | Jake Kuredjian Park | 20337 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | Los Angeles 6 | 5.753 | Jake Kuredjian Park | 0 | Local Park 2 | 4 | |
5277 | 5277 | 5276 | {"type": "Polygon", "coordinates": [[[-117.96221, 34.46435], [-117.95784, 34.46435], [-117.95784, 34.46345], [-117.9622, 34.46345], [-117.96221, 34.46435]]]} | Open Access 1 | 2606 | Juniper Hills Park | 20526 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | Los Angeles 6 | 9.918 | Juniper Hills Park | 0 | Local Park 2 | 4 | |
4973 | 4973 | 4972 | {"type": "Polygon", "coordinates": [[[-118.60043, 34.03928], [-118.59866, 34.03936], [-118.59704, 34.03949], [-118.59696, 34.03894], [-118.59729, 34.03892], [-118.59789, 34.03909], [-118.59841, 34.03915], [-118.59889, 34.03908], [-118.59909, 34.03891], [-118.60041, 34.039], [-118.60043, 34.03928]]]} | Open Access 1 | 3710 | Las Tunas County Beach | 21070 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | Los Angeles 6 | 3.146 | Las Tunas County Beach | 0 | Local Park 2 | 4 | |
2157 | 2157 | 2156 | {"type": "Polygon", "coordinates": [[[-118.35905, 33.9381], [-118.35751, 33.93811], [-118.3575, 33.93775], [-118.35755, 33.93774], [-118.35756, 33.93669], [-118.35858, 33.93669], [-118.3586, 33.93651], [-118.35905, 33.93651], [-118.35905, 33.9381]]]} | Open Access 1 | 6183 | Lennox Park | 21163 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | Los Angeles 6 | 5.629 | Lennox Park | 0 | Local Park 2 | 4 | |
8309 | 8309 | 8308 | {"type": "Polygon", "coordinates": [[[-118.60165, 34.05301], [-118.60165, 34.05347], [-118.60118, 34.05348], [-118.60118, 34.05301], [-118.60165, 34.05301]]]} | No Public Access 3 | 12776 | Los Angeles County Open Space | 21480 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | Los Angeles 6 | 0.548 | Los Angeles County OS | 0 | Local Recreation Area 3 | 4 | |
8322 | 8322 | 8321 | {"type": "Polygon", "coordinates": [[[-118.60332, 34.08036], [-118.60312, 34.08066], [-118.60292, 34.08071], [-118.60319, 34.08034], [-118.60332, 34.08036]]]} | Open Access 1 | 12773 | Los Angeles County Open Space | 21481 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | Los Angeles 6 | 0.131 | Los Angeles County OS | 0 | Local Recreation Area 3 | 4 | |
16105 | 16105 | 16104 | {"type": "MultiPolygon", "coordinates": [[[[-118.58817, 34.10259], [-118.58778, 34.10269], [-118.58765, 34.10265], [-118.58748, 34.1025], [-118.58813, 34.1025], [-118.58817, 34.10259]]], [[[-118.59194, 34.11026], [-118.59184, 34.11026], [-118.59189, 34.11007], [-118.59189, 34.11009], [-118.59194, 34.11026]]], [[[-118.59261, 34.10389], [-118.59255, 34.10406], [-118.59244, 34.10418], [-118.59221, 34.10403], [-118.59261, 34.10381], [-118.59261, 34.10389]]], [[[-118.59325, 34.10862], [-118.59325, 34.10862], [-118.59278, 34.10857], [-118.59282, 34.10848], [-118.59325, 34.10852], [-118.59325, 34.10862]]], [[[-118.5948, 34.10377], [-118.59468, 34.10378], [-118.59439, 34.10389], [-118.59425, 34.10384], [-118.59396, 34.10385], [-118.59371, 34.10394], [-118.59364, 34.10394], [-118.59358, 34.10367], [-118.59325, 34.10342], [-118.59479, 34.10343], [-118.5948, 34.10377]]], [[[-118.5944, 34.10418], [-118.59438, 34.10445], [-118.59427, 34.10438], [-118.59408, 34.10457], [-118.59412, 34.10471], [-118.59421, 34.1048], [-118.5942, 34.10482], [-118.59417, 34.10483], [-118.59392, 34.10454], [-118.59403, 34.10413], [-118.59406, 34.10419], [-118.5944, 34.10418]]], [[[-118.59516, 34.10385], [-118.59512, 34.10419], [-118.59459, 34.10419], [-118.59461, 34.10385], [-118.59469, 34.10383], [-118.59497, 34.1038], [-118.59516, 34.10385]]], [[[-118.59643, 34.10682], [-118.59624, 34.10711], [-118.59621, 34.1071], [-118.59594, 34.10727], [-118.59594, 34.10729], [-118.59577, 34.10729], [-118.59581, 34.10727], [-118.59609, 34.107], [-118.59614, 34.10674], [-118.596, 34.1067], [-118.59526, 34.10636], [-118.59503, 34.10636], [-118.59501, 34.10609], [-118.59528, 34.10609], [-118.59516, 34.10588], [-118.59545, 34.10588], [-118.59567, 34.10601], [-118.59604, 34.10628], [-118.59629, 34.10655], [-118.5962, 34.10666], [-118.59643, 34.10682]]], [[[-118.59552, 34.10731], [-118.59529, 34.10784], [-118.59516, 34.10784], [-118.59512, 34.10781], [-118.59509, 34.10771], [-118.59506, 34.10767], [-118.59531, 34.10723], [-118.59552, 34.10731]]], [[[-118.59592, 34.10562], [-118.59563, 34.10593], [-118.59545, 34.10584], [-118.59512, 34.10582], [-118.59535, 34.10549], [-118.59546, 34.10556], [-118.59568, 34.1056], [-118.59592, 34.10562]]], [[[-118.59609, 34.10677], [-118.59605, 34.10697], [-118.59583, 34.10719], [-118.59529, 34.10697], [-118.59555, 34.10654], [-118.59598, 34.10675], [-118.59609, 34.10677]]], [[[-118.59762, 34.10679], [-118.59762, 34.10734], [-118.59735, 34.10733], [-118.59731, 34.10683], [-118.59762, 34.10679]]]]} | Open Access 1 | 12771 | Los Angeles County Open Space | 21481 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | Los Angeles 6 | 6.522 | Los Angeles County OS | 0 | Local Recreation Area 3 | 4 | |
16106 | 16106 | 16105 | {"type": "Polygon", "coordinates": [[[-118.60065, 34.08186], [-118.60046, 34.08215], [-118.60015, 34.08199], [-118.60027, 34.08183], [-118.60041, 34.08174], [-118.60065, 34.08186]]]} | Open Access 1 | 12772 | Los Angeles County Open Space | 21481 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | Los Angeles 6 | 0.276 | Los Angeles County OS | 0 | Local Recreation Area 3 | 4 | |
13480 | 13480 | 13479 | {"type": "Polygon", "coordinates": [[[-118.61573, 34.06931], [-118.61507, 34.06932], [-118.61506, 34.06843], [-118.61534, 34.06856], [-118.6155, 34.0687], [-118.61554, 34.06878], [-118.61559, 34.06896], [-118.61573, 34.06931]]]} | Open Access 1 | 35764 | Los Angeles holding 10 | 21485 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | Los Angeles 6 | 1.032 | Los Angeles holding 10 | 0 | Local Other or Unknown 14 | 4 | |
13481 | 13481 | 13480 | {"type": "Polygon", "coordinates": [[[-118.16406, 34.20859], [-118.16399, 34.20877], [-118.16379, 34.20908], [-118.16333, 34.20952], [-118.16322, 34.20967], [-118.16298, 34.20963], [-118.16307, 34.20948], [-118.16318, 34.20935], [-118.16368, 34.20899], [-118.16383, 34.20886], [-118.16406, 34.20859]]]} | Open Access 1 | 35765 | Los Angeles holding 11 | 21486 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | Los Angeles 6 | 0.54 | Los Angeles holding 11 | 0 | Local Other or Unknown 14 | 4 | |
13489 | 13489 | 13488 | {"type": "Polygon", "coordinates": [[[-118.64802, 34.12172], [-118.64795, 34.12533], [-118.64416, 34.12532], [-118.64422, 34.1217], [-118.64802, 34.12172]]]} | Open Access 1 | 35774 | Los Angeles holding 3 | 21489 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | Los Angeles 6 | 34.755 | Los Angeles holding 3 | 0 | Local Other or Unknown 14 | 4 | |
13488 | 13488 | 13487 | {"type": "Polygon", "coordinates": [[[-118.65013, 34.12534], [-118.65007, 34.12907], [-118.64741, 34.12906], [-118.64738, 34.12533], [-118.65013, 34.12534]]]} | Open Access 1 | 35773 | Los Angeles holding 4 | 21491 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | Los Angeles 6 | 25.539 | Los Angeles holding 4 | 0 | Local Other or Unknown 14 | 4 | |
3454 | 3454 | 3453 | {"type": "Polygon", "coordinates": [[[-118.63309, 34.12589], [-118.63308, 34.12624], [-118.63243, 34.12624], [-118.63244, 34.12598], [-118.63309, 34.12589]]]} | Open Access 1 | 35562 | Los Angeles holding 5 | 21492 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | Los Angeles 6 | 0.502 | Los Angeles holding 5 | 0 | Local Other or Unknown 14 | 4 | |
13374 | 13374 | 13373 | {"type": "Polygon", "coordinates": [[[-118.16425, 34.20803], [-118.16421, 34.20806], [-118.16415, 34.20814], [-118.16402, 34.20843], [-118.16389, 34.20862], [-118.1638, 34.2087], [-118.16379, 34.20873], [-118.16361, 34.20889], [-118.1632, 34.20918], [-118.16302, 34.20934], [-118.16295, 34.20945], [-118.16292, 34.20946], [-118.16283, 34.20965], [-118.16273, 34.20979], [-118.16243, 34.21008], [-118.16238, 34.21009], [-118.1623, 34.21009], [-118.1622, 34.21004], [-118.16216, 34.20998], [-118.16216, 34.20979], [-118.16218, 34.2096], [-118.16225, 34.20936], [-118.16241, 34.20908], [-118.16248, 34.20891], [-118.16251, 34.20874], [-118.1625, 34.20838], [-118.16293, 34.208], [-118.16425, 34.20803]]]} | Open Access 1 | 35458 | Los Angeles holding 6 | 21493 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | Los Angeles 6 | 5.183 | Los Angeles holding 6 | 0 | Local Other or Unknown 14 | 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]);