units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
116 rows where DES_TP = 3 and MNG_AGENCY = 24 sorted by ACRES
This data as json, copyable, CSV (advanced)
ACCESS_TYP 3
MNG_AG_TYP 1
- City Agency 96
MNG_AGENCY 1
- Los Angeles, City of · 96 ✖
DES_TP 1
- Local Recreation Area · 96 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
14964 | 14964 | 14963 | {"type": "Polygon", "coordinates": [[[-118.4065, 34.23117], [-118.4061, 34.23146], [-118.40628, 34.23165], [-118.40483, 34.23133], [-118.40587, 34.23057], [-118.4065, 34.23117]]]} | Open Access 1 | 45577 | Sheldon Skate Park | 32744 | 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.189 | Sheldon Skate Park | 0 | Local Recreation Area 3 | 4 | |
16382 | 16382 | 16381 | {"type": "Polygon", "coordinates": [[[-118.26371, 34.02408], [-118.26326, 34.0248], [-118.26231, 34.02438], [-118.26277, 34.02366], [-118.26371, 34.02408]]]} | Open Access 1 | 14833 | Trinity Recreation Center | 26542 | 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.215 | Trinity Rec. Ctr. | 0 | Local Recreation Area 3 | 4 | |
6674 | 6674 | 6673 | {"type": "Polygon", "coordinates": [[[-118.64797, 34.19522], [-118.64792, 34.19556], [-118.64772, 34.19554], [-118.64752, 34.19555], [-118.64721, 34.19561], [-118.64698, 34.19569], [-118.6464, 34.19595], [-118.64635, 34.19593], [-118.64625, 34.19573], [-118.64624, 34.19563], [-118.64627, 34.19542], [-118.64631, 34.19537], [-118.6464, 34.1953], [-118.64642, 34.19522], [-118.6464, 34.19518], [-118.64636, 34.19513], [-118.64629, 34.19511], [-118.64623, 34.19511], [-118.64624, 34.19507], [-118.64797, 34.19522]]]} | Open Access 1 | 4956 | Mae Boyar Recreation Center | 21665 | 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.247 | Mae Boyar Rec. Ctr. | 0 | Local Recreation Area 3 | 4 | |
16897 | 16897 | 16896 | {"type": "Polygon", "coordinates": [[[-118.19124, 34.08545], [-118.19087, 34.08586], [-118.18962, 34.08586], [-118.19055, 34.08484], [-118.19095, 34.08509], [-118.19086, 34.0852], [-118.19124, 34.08545]]]} | Open Access 1 | 10414 | Rose Hill Recreation Center | 24611 | 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.265 | Rose Hill Rec. Ctr. | 0 | Local Recreation Area 3 | 4 | |
17057 | 17057 | 17056 | {"type": "Polygon", "coordinates": [[[-118.23285, 33.93139], [-118.23204, 33.93139], [-118.23201, 33.93135], [-118.2318, 33.93037], [-118.23285, 33.93037], [-118.23285, 33.93139]]]} | Open Access 1 | 6228 | Imperial Courts Recreation Center | 20179 | 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.43 | Imperial Courts Rec. Ctr. | 0 | Local Recreation Area 3 | 4 | |
16931 | 16931 | 16930 | {"type": "Polygon", "coordinates": [[[-118.21331, 34.05275], [-118.21287, 34.05342], [-118.21238, 34.05314], [-118.21168, 34.05282], [-118.21184, 34.05256], [-118.21177, 34.05252], [-118.21199, 34.05217], [-118.21331, 34.05275]]]} | Open Access 1 | 25050 | State Street Recreation Center | 25812 | 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.623 | State Street Rec. Ctr. | 0 | Local Recreation Area 3 | 4 | |
8333 | 8333 | 8332 | {"type": "Polygon", "coordinates": [[[-118.28001, 34.03946], [-118.27946, 34.0403], [-118.27869, 34.03995], [-118.27897, 34.03953], [-118.27851, 34.03931], [-118.27878, 34.0389], [-118.28001, 34.03946]]]} | Open Access 1 | 14768 | Toberman Playground | 26380 | 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.743 | Toberman Playground | 0 | Local Recreation Area 3 | 4 | |
9990 | 9990 | 9989 | {"type": "Polygon", "coordinates": [[[-118.30462, 34.02364], [-118.30314, 34.02363], [-118.30313, 34.02288], [-118.30462, 34.02289], [-118.30462, 34.02364]]]} | Open Access 1 | 18556 | Denker Recreation Center | 18085 | 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.81 | Denker Rec. Ctr. | 0 | Local Recreation Area 3 | 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 | |
7140 | 7140 | 7139 | {"type": "Polygon", "coordinates": [[[-118.23664, 33.94665], [-118.23491, 33.94665], [-118.2349, 33.94603], [-118.2355, 33.94599], [-118.23625, 33.94585], [-118.23661, 33.94584], [-118.23664, 33.94589], [-118.23664, 33.94665]]]} | Open Access 1 | 6223 | Jordan Downs Recreation Center | 20489 | 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.133 | Jordan Downs Rec. Ctr. | 0 | Local Recreation Area 3 | 4 | |
999 | 999 | 998 | {"type": "Polygon", "coordinates": [[[-118.24932, 33.93589], [-118.24931, 33.93673], [-118.24783, 33.93674], [-118.24784, 33.93589], [-118.24932, 33.93589]]]} | Open Access 1 | 6218 | 109th Street Recreation Center | 15168 | 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.184 | 109th Street Rec. Ctr. | 0 | Local Recreation Area 3 | 4 | |
6937 | 6937 | 6936 | {"type": "Polygon", "coordinates": [[[-118.30014, 34.04536], [-118.29922, 34.04533], [-118.29922, 34.04401], [-118.30011, 34.04389], [-118.30014, 34.04391], [-118.30014, 34.04536]]]} | Open Access 1 | 5833 | Normandie Playground | 22801 | 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.267 | Normandie Playground | 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 |
10381 | 10381 | 10380 | {"type": "Polygon", "coordinates": [[[-118.2263, 34.08911], [-118.22518, 34.08976], [-118.22487, 34.08994], [-118.22508, 34.08832], [-118.22601, 34.0884], [-118.2263, 34.08911]]]} | Open Access 1 | 18332 | Cypress Recreation Center | 28725 | 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/cypressRC.htm | Los Angeles 6 | 3.501 | Cypress Rec. Ctr. | 0 | Local Recreation Area 3 | 4 |
15731 | 15731 | 15730 | {"type": "Polygon", "coordinates": [[[-118.30502, 34.08785], [-118.30481, 34.08785], [-118.30454, 34.08756], [-118.30454, 34.08743], [-118.30421, 34.0871], [-118.30393, 34.08695], [-118.30365, 34.0867], [-118.30352, 34.08657], [-118.30334, 34.08644], [-118.30334, 34.08634], [-118.30501, 34.08633], [-118.30502, 34.08785]]]} | Open Access 1 | 3924 | Lemon Grove Recreation Center | 21152 | 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.523 | Lemon Grove 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 | |
5953 | 5953 | 5952 | {"type": "Polygon", "coordinates": [[[-118.29665, 33.73253], [-118.29665, 33.73325], [-118.29467, 33.73324], [-118.29468, 33.73253], [-118.29665, 33.73253]]]} | Open Access 1 | 5891 | Ralph C. Daniels Field Sports Center | 28619 | 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.587 | Ralph C. Daniels Field Sports Ctr. | 0 | Local Recreation Area 3 | 4 | |
12275 | 12275 | 12274 | {"type": "Polygon", "coordinates": [[[-118.18582, 34.1138], [-118.18566, 34.11396], [-118.18559, 34.11393], [-118.18558, 34.11395], [-118.18563, 34.11399], [-118.18476, 34.11484], [-118.18453, 34.11494], [-118.18429, 34.11501], [-118.18404, 34.11507], [-118.18378, 34.1151], [-118.18338, 34.11496], [-118.18348, 34.11486], [-118.18355, 34.1147], [-118.18392, 34.11442], [-118.18404, 34.11403], [-118.1844, 34.11402], [-118.18582, 34.1138]]]} | Open Access 1 | 46909 | Highland Park Adult Senior Citizen Center | 30450 | 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.717 | Highland Park Adult Senior Citizen Ctr. | 0 | Local Recreation Area 3 | 4 | |
8362 | 8362 | 8361 | {"type": "Polygon", "coordinates": [[[-118.44535, 34.19576], [-118.44445, 34.19576], [-118.44445, 34.19409], [-118.44448, 34.19406], [-118.44451, 34.19405], [-118.44531, 34.19405], [-118.44534, 34.19407], [-118.44535, 34.19576]]]} | Open Access 1 | 14973 | Van Nuys Recreation Area | 26832 | 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.883 | Van Nuys Rec. Area | 0 | Local Recreation Area 3 | 4 | |
8315 | 8315 | 8314 | {"type": "Polygon", "coordinates": [[[-118.24766, 33.99401], [-118.24764, 33.99479], [-118.24576, 33.99477], [-118.24571, 33.99393], [-118.24766, 33.99401]]]} | Open Access 1 | 12785 | Slauson Playground | 25554 | 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.929 | Slauson Playground | 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]);