units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
175 rows where MNG_AGENCY = 16 sorted by ACRES
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_ID, AGNCY_NAME, AGNCY_TYP, AGNCY_WEB, LAYER, YR_EST, GAP_STS
DES_TP 25
- Local Park 95
- Local Recreation Area 31
- Local Conservation Area 15
- Local Other or Unknown 11
- National Recreation Area 3
- 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
AGNCY_LEV 7 ✖
- County 155
- City 10
- Federal 3
- Special District 2
- State 2
- Non Profit 2
- Private 1
ACCESS_TYP 4
MNG_AG_TYP 1
- County Agency 175
MNG_AGENCY 1
- Los Angeles, County of · 175 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |
15092 | 15092 | 15091 | {"type": "Polygon", "coordinates": [[[-118.23999, 33.92472], [-118.23998, 33.92479], [-118.23922, 33.9248], [-118.23925, 33.92475], [-118.2393, 33.92473], [-118.23999, 33.92472]]]} | Open Access 1 | 45876 | Martin Luther King Jr. Fitness Garden | 28949 | 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 | http://parks.lacounty.gov/wps/portal/dpr/Parks/Martin_Luther_King_Jr_Fitness_Park | Los Angeles 6 | 0.133 | Martin Luther King Jr. Fitness Garden | 0 | Local Park 2 | 4 |
15085 | 15085 | 15084 | {"type": "MultiPolygon", "coordinates": [[[[-118.15916, 34.01883], [-118.15918, 34.01884], [-118.15919, 34.01886], [-118.15904, 34.01936], [-118.15896, 34.01951], [-118.15899, 34.0193], [-118.15913, 34.01885], [-118.15916, 34.01883]]], [[[-118.15947, 34.01784], [-118.15947, 34.01795], [-118.15928, 34.01858], [-118.15923, 34.0186], [-118.15921, 34.01856], [-118.1594, 34.01795], [-118.15947, 34.01784]]]]} | Open Access 1 | 45867 | Woods Avenue Park | 28914 | 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 | http://parks.lacounty.gov/wps/portal/dpr/Parks/Woods_Avenue_Park | Los Angeles 6 | 0.218 | Woods Avenue Park | 0 | Local Park 2 | 4 |
3899 | 3899 | 3898 | {"type": "Polygon", "coordinates": [[[-117.8205, 34.09105], [-117.82051, 34.09113], [-117.82049, 34.09123], [-117.82036, 34.09135], [-117.82033, 34.09142], [-117.82026, 34.09145], [-117.82024, 34.09087], [-117.82037, 34.09095], [-117.8205, 34.09105]]]} | Open Access 1 | 45847 | San Dimas Staging Area | 28895 | 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 | http://parks.lacounty.gov/wps/portal/dpr/Parks/San_Dimas_Staging_Area | Los Angeles 6 | 0.247 | San Dimas Staging Area | None 334 | ||
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 | |
7178 | 7178 | 7177 | {"type": "Polygon", "coordinates": [[[-118.45957, 33.97626], [-118.45923, 33.97627], [-118.4592, 33.97624], [-118.4591, 33.97585], [-118.45895, 33.97554], [-118.45957, 33.97626]]]} | Open Access 1 | 6321 | Marina del Rey pocket park | 21821 | 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.299 | Marina del Rey pocket park | None 586 | |||
15083 | 15083 | 15082 | {"type": "Polygon", "coordinates": [[[-118.19408, 33.89119], [-118.19324, 33.89119], [-118.19323, 33.89102], [-118.19407, 33.89102], [-118.19408, 33.89119]]]} | Unknown Access 4 | 45865 | Washington Ave Park | 28912 | 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.359 | Washington Ave Park | 0 | Local Park 2 | 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 | |
14937 | 14937 | 14936 | {"type": "Polygon", "coordinates": [[[-118.24398, 33.98243], [-118.24382, 33.9825], [-118.24369, 33.98261], [-118.24358, 33.98273], [-118.24352, 33.98286], [-118.24352, 33.98212], [-118.24397, 33.98212], [-118.24398, 33.98243]]]} | Open Access 1 | 45533 | El Parque Nuestro | 28364 | 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 | http://parks.lacounty.gov/wps/portal/dpr/Parks/El_Parque_Nuestro | Los Angeles 6 | 0.536 | El Parque Nuestro | None 1288 | ||
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 | |
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 | |
7776 | 7776 | 7775 | {"type": "Polygon", "coordinates": [[[-118.60408, 34.12532], [-118.60355, 34.12532], [-118.60343, 34.12511], [-118.60322, 34.12504], [-118.60322, 34.12533], [-118.60305, 34.12533], [-118.60305, 34.12497], [-118.60288, 34.12491], [-118.6019, 34.12492], [-118.6019, 34.12487], [-118.60222, 34.12486], [-118.60221, 34.12436], [-118.60228, 34.12438], [-118.60229, 34.12486], [-118.60291, 34.12486], [-118.60349, 34.12507], [-118.6036, 34.12527], [-118.60408, 34.12526], [-118.60408, 34.12532]]]} | Open Access 1 | 6423 | Canyon Oaks Open Space Access | 16820 | 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.571 | Canyon Oaks OS Access | 0 | Local Recreation Area 3 | 4 | |
6057 | 6057 | 6056 | {"type": "MultiPolygon", "coordinates": [[[[-118.63961, 34.08679], [-118.63961, 34.08715], [-118.63934, 34.08714], [-118.63934, 34.08678], [-118.63961, 34.08679]]], [[[-118.63982, 34.08972], [-118.63981, 34.08989], [-118.63954, 34.08989], [-118.63954, 34.08973], [-118.63982, 34.08972]]], [[[-118.65158, 34.11324], [-118.65137, 34.11354], [-118.65114, 34.11342], [-118.65135, 34.11313], [-118.65158, 34.11324]]]]} | Open Access 1 | 12781 | Santa Monica Mountains National Recreation Area | 6093 | 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 | http://www.nps.gov/samo/index.htm | Los Angeles 6 | 0.591 | Santa Monica Mtns. NRA | 0 | National Recreation Area 54 | 3 |
695 | 695 | 694 | {"type": "Polygon", "coordinates": [[[-118.05463, 33.98259], [-118.05463, 33.98262], [-118.05459, 33.98263], [-118.05399, 33.98263], [-118.0539, 33.9826], [-118.05387, 33.98256], [-118.05386, 33.98251], [-118.05397, 33.98223], [-118.05403, 33.98219], [-118.05411, 33.98218], [-118.05417, 33.9822], [-118.05456, 33.98246], [-118.05462, 33.98252], [-118.05463, 33.98259]]]} | Open Access 1 | 5236 | McNees Park | 22064 | 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.604 | McNees Park | 0 | Local Park 2 | 4 | |
12113 | 12113 | 12112 | {"type": "Polygon", "coordinates": [[[-118.33769, 33.99873], [-118.33749, 33.99926], [-118.33744, 33.99931], [-118.33736, 33.99931], [-118.3369, 33.99912], [-118.33688, 33.99909], [-118.3369, 33.99905], [-118.33762, 33.99869], [-118.33767, 33.99869], [-118.33769, 33.99873]]]} | Open Access 1 | 25041 | Monteith Parkway | 29043 | 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.64 | Monteith Parkway | 0 | Local Recreation Area 3 | 4 | |
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 | |
15074 | 15074 | 15073 | {"type": "Polygon", "coordinates": [[[-118.11482, 34.19575], [-118.11463, 34.19638], [-118.11441, 34.19634], [-118.11429, 34.1954], [-118.11451, 34.19531], [-118.11449, 34.19545], [-118.11455, 34.19559], [-118.11466, 34.19569], [-118.11471, 34.19569], [-118.11482, 34.19575]]]} | No Public Access 3 | 45853 | Casa Del Caballero | 28900 | 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.819 | Casa Del Caballero | None 1306 | |||
7179 | 7179 | 7178 | {"type": "Polygon", "coordinates": [[[-118.45619, 33.96552], [-118.45317, 33.967], [-118.45309, 33.9669], [-118.45614, 33.96543], [-118.45619, 33.96552]]]} | Open Access 1 | 6323 | Aubrey E. Austin Jr. Park and North Jetty | 15682 | 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 | https://beaches.lacounty.gov/?s=Aubrey+E.+Austin+Jr.+Park+and+North+Jetty | Los Angeles 6 | 0.966 | Aubrey E. Austin Jr. Park and North Jetty | None 587 | ||
472 | 472 | 471 | {"type": "Polygon", "coordinates": [[[-118.60788, 34.06942], [-118.60718, 34.06977], [-118.60688, 34.06935], [-118.60758, 34.069], [-118.60788, 34.06942]]]} | Open Access 1 | 35762 | Los Angeles holding 8 | 21495 | 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.024 | Los Angeles holding 8 | 0 | Local Other or Unknown 14 | 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 |
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]);