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 >30
- Local Park 229
- Local Recreation Area 104
- Local Other or Unknown 21
- Local Conservation 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
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- …
ACCESS_TYP 4
- Open Access 339
- No Public Access 25
- Restricted Access 18
- Unknown Access 3
MNG_AG_TYP 1
- City Agency 385
MNG_AGENCY 1
- Los Angeles, City of · 385 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2878 | 2878 | 2877 | {"type": "Polygon", "coordinates": [[[-118.31233, 34.03401], [-118.31231, 34.03394], [-118.31235, 34.03388], [-118.31242, 34.03384], [-118.31252, 34.03386], [-118.31252, 34.03389], [-118.31239, 34.03402], [-118.31236, 34.03402], [-118.31233, 34.03401]]]} | Open Access 1 | 18875 | Gramercy Park | 29322 | 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.056 | Gramercy Park | 0 | Local Park 2 | 4 | |
2907 | 2907 | 2906 | {"type": "Polygon", "coordinates": [[[-118.2343, 34.11538], [-118.23311, 34.11682], [-118.23255, 34.1176], [-118.23164, 34.11715], [-118.23068, 34.11666], [-118.2302, 34.11658], [-118.23129, 34.11609], [-118.2325, 34.11535], [-118.23326, 34.1146], [-118.23381, 34.11501], [-118.23351, 34.11525], [-118.23351, 34.11526], [-118.23352, 34.11527], [-118.23383, 34.11503], [-118.2343, 34.11538]]]} | Open Access 1 | 1011 | Glassell Park and Recreation Center | 19309 | 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/glassellParkRC.htm | Los Angeles 6 | 12.663 | Glassell Park and Rec. Ctr. | 0 | Local Recreation Area 3 | 4 |
2946 | 2946 | 2945 | {"type": "Polygon", "coordinates": [[[-118.43139, 34.07349], [-118.43133, 34.0739], [-118.43131, 34.07413], [-118.43128, 34.07416], [-118.43123, 34.07417], [-118.4312, 34.07415], [-118.43081, 34.0738], [-118.4306, 34.07366], [-118.4303, 34.07352], [-118.42983, 34.0734], [-118.42965, 34.0733], [-118.4295, 34.07319], [-118.42916, 34.07276], [-118.42892, 34.07255], [-118.42767, 34.07171], [-118.42764, 34.07166], [-118.42764, 34.0716], [-118.4278, 34.0712], [-118.42784, 34.07119], [-118.42921, 34.07171], [-118.42952, 34.07187], [-118.42979, 34.07208], [-118.43009, 34.07242], [-118.43027, 34.0726], [-118.43138, 34.07347], [-118.43139, 34.07349]]]} | Restricted Access 2 | 1906 | Holmby Park | 32999 | 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 | 8.535 | Holmby Park | 0 | Local Park 2 | 4 | |
3058 | 3058 | 3057 | {"type": "Polygon", "coordinates": [[[-118.34268, 34.26987], [-118.34212, 34.26999], [-118.34206, 34.26981], [-118.34091, 34.26925], [-118.33938, 34.26836], [-118.33771, 34.26708], [-118.33809, 34.26706], [-118.33825, 34.26717], [-118.33934, 34.26732], [-118.33933, 34.26743], [-118.34229, 34.26782], [-118.34195, 34.26956], [-118.34268, 34.26987]]]} | Open Access 1 | 12696 | Tujunga Ponds Wildlife Sanctuary | 26562 | 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 | 12.885 | Tujunga Ponds Wildlife Sanctuary | 0 | Local Conservation Area 4 | 2 | |
3181 | 3181 | 3180 | {"type": "Polygon", "coordinates": [[[-118.32975, 34.09132], [-118.32975, 34.09151], [-118.32899, 34.09152], [-118.32899, 34.09084], [-118.32975, 34.09084], [-118.32975, 34.09132]]]} | Open Access 1 | 1902 | Hollywood Recreation Center | 20054 | 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.295 | Hollywood Rec. Ctr. | 0 | Local Recreation Area 3 | 4 | |
3305 | 3305 | 3304 | {"type": "Polygon", "coordinates": [[[-118.31904, 34.27061], [-118.31739, 34.27184], [-118.31705, 34.27189], [-118.31679, 34.27195], [-118.31654, 34.27201], [-118.31592, 34.27222], [-118.31585, 34.2722], [-118.31584, 34.27218], [-118.31584, 34.27186], [-118.3158, 34.27185], [-118.31581, 34.2706], [-118.31904, 34.27061]]]} | Open Access 1 | 29608 | Oro Vista Park | 23209 | 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 | 8.225 | Oro Vista Park | 0 | Local Park 2 | 4 | |
3495 | 3495 | 3494 | {"type": "Polygon", "coordinates": [[[-118.27701, 34.05269], [-118.27675, 34.05309], [-118.27632, 34.05289], [-118.27658, 34.0525], [-118.27701, 34.05269]]]} | Open Access 1 | 25933 | Hope and Peace Park | 20084 | 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.567 | Hope and Peace Park | 0 | Local Park 2 | 4 | |
3496 | 3496 | 3495 | {"type": "Polygon", "coordinates": [[[-118.31416, 34.09327], [-118.31383, 34.09327], [-118.31383, 34.09286], [-118.31416, 34.09286], [-118.31416, 34.09327]]]} | Open Access 1 | 25934 | Seily Rodriguez Park | 25288 | 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.344 | Seily Rodriguez Park | 0 | Local Park 2 | 4 | |
3572 | 3572 | 3571 | {"type": "Polygon", "coordinates": [[[-118.4037, 34.2292], [-118.40363, 34.22925], [-118.40364, 34.22929], [-118.40362, 34.22931], [-118.40221, 34.23034], [-118.40077, 34.22897], [-118.40228, 34.22787], [-118.4037, 34.2292]]]} | Open Access 1 | 519 | Fernangeles Recreation Center | 18880 | 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 | 9.262 | Fernangeles Rec. Ctr. | 0 | Local Recreation Area 3 | 4 | |
3865 | 3865 | 3864 | {"type": "Polygon", "coordinates": [[[-118.21168, 34.02172], [-118.21009, 34.02095], [-118.21048, 34.02035], [-118.21052, 34.02033], [-118.21056, 34.02033], [-118.21206, 34.02102], [-118.21206, 34.02108], [-118.21168, 34.02172]]]} | Open Access 1 | 45552 | Lou Costello Recreation Center | 28382 | 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/louCostelloRC.htm | Los Angeles 6 | 3.426 | Lou Costello Rec. Ctr. | 0 | Local Recreation Area 3 | 4 |
3875 | 3875 | 3874 | {"type": "Polygon", "coordinates": [[[-118.28833, 33.97082], [-118.28833, 33.9712], [-118.2882, 33.9712], [-118.2882, 33.97082], [-118.28833, 33.97082]]]} | Open Access 1 | 45783 | 76th Street Pocket Park | 28802 | 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.lanlt.org/parks-and-gardens.php#76th | Los Angeles 6 | 0.128 | 76th Street PP | 0 | Local Park 2 | 4 |
3895 | 3895 | 3894 | {"type": "Polygon", "coordinates": [[[-118.24917, 34.0477], [-118.24861, 34.0483], [-118.24819, 34.04803], [-118.2485, 34.04771], [-118.2487, 34.04784], [-118.24876, 34.04778], [-118.24871, 34.04774], [-118.24886, 34.04759], [-118.24891, 34.04762], [-118.24896, 34.04756], [-118.24917, 34.0477]]]} | Open Access 1 | 45828 | Spring Street Park | 28847 | 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.813 | Spring Street Park | 0 | Local Park 2 | 4 | |
3896 | 3896 | 3895 | {"type": "Polygon", "coordinates": [[[-118.57142, 34.12782], [-118.57142, 34.12931], [-118.56528, 34.12931], [-118.5662, 34.12783], [-118.57142, 34.12782]]]} | Unknown Access 4 | 45829 | Steers Property | 28848 | 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 | 21.351 | Steers Property | 0 | Local Other or Unknown 14 | 4 | |
3897 | 3897 | 3896 | {"type": "MultiPolygon", "coordinates": [[[[-118.46929, 34.16474], [-118.46895, 34.16474], [-118.46804, 34.16377], [-118.46928, 34.16377], [-118.46929, 34.16474]]], [[[-118.46929, 34.16495], [-118.46923, 34.16585], [-118.46917, 34.16617], [-118.46905, 34.16659], [-118.46874, 34.16659], [-118.46875, 34.16496], [-118.46929, 34.16495]]]]} | Open Access 1 | 45830 | Teichman Family Magnolia Park | 28849 | 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.852 | Teichman Family Magnolia Park | 0 | Local Park 2 | 4 | |
3902 | 3902 | 3901 | {"type": "MultiPolygon", "coordinates": [[[[-118.28275, 34.03276], [-118.28253, 34.0331], [-118.28239, 34.03304], [-118.28261, 34.03269], [-118.28275, 34.03276]]], [[[-118.28381, 34.033], [-118.28378, 34.03302], [-118.2827, 34.03255], [-118.28329, 34.0316], [-118.28337, 34.03159], [-118.28376, 34.03176], [-118.2838, 34.03182], [-118.28381, 34.033]]], [[[-118.2838, 34.03365], [-118.28341, 34.03348], [-118.28363, 34.03314], [-118.28377, 34.0332], [-118.2838, 34.03324], [-118.2838, 34.03365]]]]} | Open Access 1 | 1924 | Hoover Recreation Center | 20083 | 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.988 | Hoover Rec. Ctr. | 0 | Local Recreation Area 3 | 4 | |
3966 | 3966 | 3965 | {"type": "Polygon", "coordinates": [[[-118.46539, 33.99607], [-118.46473, 33.99643], [-118.46421, 33.99576], [-118.46399, 33.99551], [-118.46423, 33.99539], [-118.46427, 33.9954], [-118.4644, 33.99553], [-118.46442, 33.99553], [-118.46442, 33.99551], [-118.46429, 33.99538], [-118.46428, 33.99531], [-118.46421, 33.99531], [-118.46418, 33.99533], [-118.4642, 33.99537], [-118.46398, 33.99548], [-118.46333, 33.99472], [-118.46333, 33.99468], [-118.4636, 33.99429], [-118.46539, 33.99607]]]} | Open Access 1 | 6332 | Oakwood Recreation Center | 23039 | 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.555 | Oakwood Rec. Ctr. | 0 | Local Recreation Area 3 | 4 | |
4018 | 4018 | 4017 | {"type": "Polygon", "coordinates": [[[-118.43109, 34.19476], [-118.43107, 34.19479], [-118.43103, 34.19481], [-118.4306, 34.19481], [-118.4306, 34.19476], [-118.43109, 34.19476]]]} | Open Access 1 | 1478 | Hartland Mini Park | 19710 | 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.065 | Hartland MP | 0 | Local Park 2 | 4 | |
4082 | 4082 | 4081 | {"type": "Polygon", "coordinates": [[[-118.30667, 33.98334], [-118.30667, 33.98455], [-118.30249, 33.98455], [-118.30251, 33.98333], [-118.30667, 33.98334]]]} | Open Access 1 | 1485 | Jackie Tatum/Harvard Recreation Center | 28621 | 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/jackieTatumRC.htm | Los Angeles 6 | 12.849 | Jackie Tatum/Harvard Rec. Ctr. | 0 | Local Recreation Area 3 | 4 |
4092 | 4092 | 4091 | {"type": "Polygon", "coordinates": [[[-118.518, 34.05167], [-118.51753, 34.05174], [-118.51751, 34.0517], [-118.51798, 34.05163], [-118.518, 34.05167]]]} | No Public Access 3 | 47493 | Chautauqua Blvd Access to Will Rogers State Historic Preserve | 31212 | 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.053 | Chautauqua Blvd Access to Will Rogers SHPr | None 355 | |||
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 |
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]);