units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
491 rows where MNG_AGENCY = 24 sorted by UNIT_ID
This data as json, copyable, CSV (advanced)
DES_TP >30
- Local Park 300
- Local Recreation Area 110
- 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
- …
ACCESS_TYP 4
- Open Access 412
- No Public Access 36
- Restricted Access 20
- Unknown Access 3
MNG_AG_TYP 1
- City Agency 471
MNG_AGENCY 1
- Los Angeles, City of · 471 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
6272 | 6272 | 6271 | {"type": "Polygon", "coordinates": [[[-118.35915, 34.06474], [-118.35911, 34.06476], [-118.35475, 34.06477], [-118.35472, 34.06473], [-118.35471, 34.06324], [-118.35472, 34.06319], [-118.35498, 34.0626], [-118.35501, 34.06258], [-118.35708, 34.06262], [-118.35742, 34.06266], [-118.35751, 34.06275], [-118.35863, 34.06287], [-118.35874, 34.06281], [-118.35915, 34.06285], [-118.35915, 34.06474]]]} | Open Access 1 | 1365 | Hancock Park | 19635 | 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 | 23.098 | Hancock Park | 0 | Local Park 2 | 4 | |
16795 | 16795 | 16794 | {"type": "MultiPolygon", "coordinates": [[[[-118.35638, 34.26783], [-118.35593, 34.26829], [-118.35584, 34.26829], [-118.35537, 34.2677], [-118.35638, 34.26783]]], [[[-118.40076, 34.26685], [-118.3982, 34.26992], [-118.39688, 34.27114], [-118.39396, 34.27326], [-118.39345, 34.27322], [-118.39305, 34.27306], [-118.39242, 34.27288], [-118.39167, 34.27275], [-118.39148, 34.27273], [-118.3913, 34.27261], [-118.39115, 34.27271], [-118.39048, 34.27273], [-118.3895, 34.27285], [-118.38271, 34.27375], [-118.38204, 34.27395], [-118.38165, 34.27413], [-118.38166, 34.27415], [-118.38199, 34.27411], [-118.38149, 34.27448], [-118.37505, 34.27381], [-118.37326, 34.27372], [-118.3728, 34.27074], [-118.37311, 34.26911], [-118.37307, 34.26894], [-118.37297, 34.26886], [-118.3728, 34.26881], [-118.3725, 34.26887], [-118.36836, 34.26898], [-118.36556, 34.26923], [-118.36779, 34.27246], [-118.3682, 34.27267], [-118.3682, 34.27331], [-118.36827, 34.27335], [-118.36339, 34.27298], [-118.36215, 34.27292], [-118.36205, 34.27265], [-118.36168, 34.27244], [-118.36149, 34.27222], [-118.36028, 34.27139], [-118.35844, 34.27155], [-118.35617, 34.26871], [-118.35695, 34.26791], [-118.35827, 34.26807], [-118.35863, 34.26622], [-118.36449, 34.26628], [-118.36534, 34.26618], [-118.36553, 34.26608], [-118.36603, 34.26587], [-118.36643, 34.26563], [-118.36663, 34.26571], [-118.36732, 34.26584], [-118.36782, 34.26584], [-118.36997, 34.26526], [-118.36978, 34.2624], [-118.37166, 34.25994], [-118.37265, 34.25872], [-118.37328, 34.25818], [-118.3738, 34.25783], [-118.37343, 34.25859], [-118.37343, 34.25862], [-118.37506, 34.25861], [-118.37614, 34.2584], [-118.37725, 34.25823], [-118.37816, 34.25822], [-118.37936, 34.25812], [-118.38042, 34.25817], [-118.38262, 34.25846], [-118.38325, 34.25843], [-118.38394, 34.2583], [-118.38448, 34.25843], [-118.38587, 34.25895], [-118.3865, 34.2579], [-118.38713, 34.25817], [-118.38665, 34.259], [-118.3866, 34.26034], [-118.38666, 34.26042], [-118.38925, 34.26121], [-118.3894, 34.26086], [-118.39031, 34.26113], [-118.39073, 34.26043], [-118.39103, 34.26066], [-118.39148, 34.26078], [-118.39335, 34.2618], [-118.39344, 34.2618], [-118.3935, 34.26157], [-118.3954, 34.26242], [-118.39631, 34.26249], [-118.39746, 34.26329], [-118.39782, 34.26398], [-118.39843, 34.26433], [-118.39897, 34.26483], [-118.39946, 34.26558], [-118.39988, 34.26605], [-118.40076, 34.26685]]], [[[-118.39867, 34.27251], [-118.39763, 34.27327], [-118.39688, 34.27256], [-118.3959, 34.27251], [-118.39568, 34.27231], [-118.39725, 34.27116], [-118.39867, 34.27251]]], [[[-118.40091, 34.26912], [-118.40073, 34.26966], [-118.40042, 34.27118], [-118.40039, 34.27126], [-118.39882, 34.2724], [-118.39739, 34.27105], [-118.3978, 34.2707], [-118.39826, 34.27023], [-118.39995, 34.26822], [-118.40091, 34.26912]]], [[[-118.4014, 34.26764], [-118.40094, 34.26903], [-118.40001, 34.26815], [-118.40119, 34.26673], [-118.4014, 34.26764]]]]} | Open Access 1 | 1374 | Hansen Dam Recreation Area | 30957 | 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/hansendamRC.htm | Los Angeles 6 | 1140.78 | Hansen Dam Rec. Area | 0 | Local Recreation Area 3 | 4 |
5008 | 5008 | 5007 | {"type": "Polygon", "coordinates": [[[-118.32627, 34.05769], [-118.32605, 34.05799], [-118.32596, 34.05801], [-118.32412, 34.05794], [-118.32448, 34.05734], [-118.32526, 34.05759], [-118.32627, 34.05769]]]} | Open Access 1 | 1424 | Harold A. Henry Park | 19684 | 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.08 | Harold A. Henry Park | 0 | Local Park 2 | 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 |
6207 | 6207 | 6206 | {"type": "MultiPolygon", "coordinates": [[[[-118.20447, 34.05944], [-118.20433, 34.05965], [-118.20331, 34.05921], [-118.20265, 34.06024], [-118.20279, 34.06042], [-118.20363, 34.06072], [-118.20347, 34.06095], [-118.2034, 34.06118], [-118.20138, 34.06118], [-118.19973, 34.05985], [-118.20096, 34.05789], [-118.20447, 34.05944]]], [[[-118.203, 34.05761], [-118.20234, 34.05831], [-118.20105, 34.05774], [-118.20154, 34.05696], [-118.203, 34.05761]]]]} | Open Access 1 | 1580 | Hazard Park | 19763 | 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 | 24.188 | Hazard Park | 0 | Local Park 2 | 4 | |
511 | 511 | 510 | {"type": "Polygon", "coordinates": [[[-118.19601, 34.05796], [-118.19489, 34.05976], [-118.19436, 34.05954], [-118.19513, 34.0583], [-118.1952, 34.05834], [-118.19523, 34.05833], [-118.19532, 34.05836], [-118.19542, 34.05832], [-118.19563, 34.05796], [-118.19573, 34.058], [-118.19601, 34.05796]]]} | Open Access 1 | 1704 | Henry Alvarez Memorial Park | 19822 | 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.566 | Henry Alvarez Memorial Park | 0 | Local Park 2 | 4 | |
514 | 514 | 513 | {"type": "Polygon", "coordinates": [[[-118.29549, 34.09994], [-118.29552, 34.10008], [-118.29552, 34.10036], [-118.2955, 34.10049], [-118.29546, 34.10058], [-118.29538, 34.10069], [-118.29515, 34.10094], [-118.29543, 34.10117], [-118.29519, 34.10127], [-118.2953, 34.10134], [-118.2953, 34.10166], [-118.29326, 34.10167], [-118.29326, 34.10131], [-118.29305, 34.10119], [-118.29296, 34.10103], [-118.29294, 34.10094], [-118.29294, 34.10085], [-118.29299, 34.10075], [-118.29298, 34.09918], [-118.29357, 34.0992], [-118.29358, 34.09919], [-118.29391, 34.09915], [-118.29454, 34.09916], [-118.29462, 34.0992], [-118.29469, 34.09919], [-118.29473, 34.09923], [-118.29489, 34.09928], [-118.29489, 34.09935], [-118.29492, 34.09941], [-118.29518, 34.0996], [-118.29539, 34.09978], [-118.29549, 34.09994]]]} | Open Access 1 | 1713 | Barnsdall Park | 15825 | 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 | 14.293 | Barnsdall Park | 0 | Local Park 2 | 4 | |
449 | 449 | 448 | {"type": "Polygon", "coordinates": [[[-118.18446, 34.11514], [-118.1843, 34.11529], [-118.18412, 34.11522], [-118.1843, 34.11518], [-118.18446, 34.11514]]]} | Open Access 1 | 1807 | Highland Park | 19932 | 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.045 | Highland Park | 0 | Local Park 2 | 4 | |
6394 | 6394 | 6393 | {"type": "Polygon", "coordinates": [[[-118.18925, 34.11305], [-118.18679, 34.11383], [-118.18662, 34.11346], [-118.18815, 34.11212], [-118.18864, 34.1122], [-118.18925, 34.11305]]]} | Open Access 1 | 1811 | Highland Park Recreation Center | 19937 | 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 | 5.416 | Highland Park Rec. Ctr. | 0 | Local Recreation Area 3 | 4 | |
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 | |
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 | |
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 | |
6453 | 6453 | 6452 | {"type": "Polygon", "coordinates": [[[-118.301, 34.25802], [-118.301, 34.25871], [-118.30032, 34.2587], [-118.3003, 34.25803], [-118.301, 34.25802]]]} | Open Access 1 | 1983 | Howard Finn Park | 20116 | 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.195 | Howard Finn Park | 0 | Local Park 2 | 4 | |
493 | 493 | 492 | {"type": "Polygon", "coordinates": [[[-118.40813, 34.28144], [-118.40657, 34.28258], [-118.40505, 34.28116], [-118.40662, 34.28002], [-118.40813, 34.28144]]]} | Open Access 1 | 1998 | Hubert H. Humphrey Memorial Park | 20130 | 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.987 | Hubert H. Humphrey Memorial Park | 0 | Local Park 2 | 4 | |
6486 | 6486 | 6485 | {"type": "Polygon", "coordinates": [[[-118.3997, 34.03994], [-118.39971, 34.03999], [-118.39966, 34.04019], [-118.39957, 34.04036], [-118.39942, 34.04074], [-118.39859, 34.04048], [-118.39877, 34.04004], [-118.39885, 34.03982], [-118.39923, 34.0398], [-118.3997, 34.03994]]]} | Open Access 1 | 2316 | Irving Schachter Park | 20272 | 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.797 | Irving Schachter Park | 0 | Local Park 2 | 4 | |
6508 | 6508 | 6507 | {"type": "Polygon", "coordinates": [[[-118.5185, 34.20003], [-118.51792, 34.20003], [-118.51758, 34.20022], [-118.51758, 34.19931], [-118.5185, 34.19931], [-118.5185, 34.20003]]]} | Open Access 1 | 2428 | Jesse Owens Mini Park | 29042 | 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.745 | Jesse Owens MP | 0 | Local Park 2 | 4 | |
6513 | 6513 | 6512 | {"type": "Polygon", "coordinates": [[[-118.58829, 34.19929], [-118.58736, 34.19929], [-118.58736, 34.1976], [-118.58748, 34.19747], [-118.58822, 34.19746], [-118.58828, 34.1975], [-118.58829, 34.19929]]]} | Open Access 1 | 2529 | John Quimby Park | 20463 | 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.246 | John Quimby Park | 0 | Local Park 2 | 4 | |
640 | 640 | 639 | {"type": "Polygon", "coordinates": [[[-118.38183, 34.28065], [-118.38163, 34.2808], [-118.38181, 34.28097], [-118.38084, 34.28168], [-118.38011, 34.28099], [-118.38128, 34.28013], [-118.38183, 34.28065]]]} | Open Access 1 | 2675 | Kagel Canyon Park | 20542 | 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.465 | Kagel Canyon Park | 0 | Local Park 2 | 4 | |
6532 | 6532 | 6531 | {"type": "Polygon", "coordinates": [[[-118.42634, 34.19022], [-118.42593, 34.19022], [-118.4259, 34.19019], [-118.42589, 34.19014], [-118.42634, 34.19014], [-118.42634, 34.19022]]]} | Open Access 1 | 2916 | Kittridge Mini Park | 20680 | 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.091 | Kittridge MP | 0 | 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]);