superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
465 rows where MNG_AGENCY = 24
This data as json, copyable, CSV (advanced)
Link | rowid ▼ | id | map | ACCESS_TYP | PARK_NAME | PARK_URL | SUID_NMA | MNG_AG_ID | MNG_AGENCY | MNG_AG_LEV | MNG_AG_TYP | AGNCY_WEB | LAYER | ACRES | LABEL_NAME | YR_EST |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4697 | 4697 | 4696 | {"type": "Polygon", "coordinates": [[[-118.34172, 34.25537], [-118.34043, 34.2563], [-118.34044, 34.25641], [-118.34035, 34.25674], [-118.34035, 34.25683], [-118.34042, 34.25704], [-118.34042, 34.25714], [-118.34039, 34.2572], [-118.34031, 34.25726], [-118.34008, 34.25733], [-118.34002, 34.25738], [-118.3399, 34.25768], [-118.33994, 34.25797], [-118.33988, 34.25807], [-118.33974, 34.25819], [-118.3397, 34.25824], [-118.33977, 34.25865], [-118.33975, 34.25872], [-118.33969, 34.2588], [-118.33959, 34.25885], [-118.33944, 34.25885], [-118.33898, 34.2586], [-118.3389, 34.25857], [-118.33883, 34.25857], [-118.3382, 34.2587], [-118.3377, 34.25897], [-118.3376, 34.25898], [-118.33701, 34.2589], [-118.3369, 34.25893], [-118.3367, 34.25901], [-118.33652, 34.25903], [-118.33522, 34.25891], [-118.33481, 34.25879], [-118.3345, 34.25867], [-118.33443, 34.25863], [-118.33438, 34.25854], [-118.33438, 34.25848], [-118.33441, 34.25841], [-118.33441, 34.25829], [-118.33439, 34.25817], [-118.33437, 34.25814], [-118.3343, 34.2581], [-118.33423, 34.25811], [-118.33402, 34.25796], [-118.33282, 34.25776], [-118.33176, 34.25745], [-118.33175, 34.25642], [-118.33162, 34.25606], [-118.33187, 34.2553], [-118.33131, 34.25461], [-118.33174, 34.2526], [-118.33464, 34.25337], [-118.34172, 34.25537]]]} | No Public Access 3 | Green Verdugo Reservoir | 19469 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 105.013 | Green Verdugo Reservoir | ||
4707 | 4707 | 4706 | {"type": "Polygon", "coordinates": [[[-118.23684, 33.93818], [-118.23642, 33.93819], [-118.23642, 33.93808], [-118.23684, 33.93808], [-118.23684, 33.93818]]]} | Open Access 1 | Grape Street Pocket Park | 19447 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 0.115 | Grape Street PP | ||
4834 | 4834 | 4833 | {"type": "Polygon", "coordinates": [[[-118.2855, 34.24184], [-118.28517, 34.2414], [-118.2847, 34.24093], [-118.28432, 34.24104], [-118.28413, 34.24085], [-118.28392, 34.24094], [-118.2845, 34.24068], [-118.28446, 34.2406], [-118.28439, 34.24059], [-118.28436, 34.24057], [-118.28386, 34.23976], [-118.28428, 34.23944], [-118.28411, 34.23914], [-118.2845, 34.23881], [-118.28455, 34.23842], [-118.28416, 34.23811], [-118.284, 34.23777], [-118.28387, 34.23728], [-118.28281, 34.23712], [-118.28277, 34.23776], [-118.28275, 34.23781], [-118.28223, 34.23804], [-118.28166, 34.23806], [-118.28167, 34.23791], [-118.28102, 34.23759], [-118.2805, 34.23788], [-118.28028, 34.23827], [-118.28003, 34.23828], [-118.27879, 34.23815], [-118.27817, 34.23802], [-118.27864, 34.23641], [-118.27984, 34.23639], [-118.27982, 34.23485], [-118.2797, 34.23477], [-118.28048, 34.2349], [-118.28118, 34.23496], [-118.28419, 34.23495], [-118.28421, 34.23637], [-118.28544, 34.23636], [-118.2855, 34.24184]]]} | Open Access 1 | Haines Canyon Park | 19597 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 52.575 | Haines Canyon Park | ||
4867 | 4867 | 4866 | {"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.35502, 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 | Hancock Park | 19635 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 23.098 | Hancock Park | ||
4868 | 4868 | 4867 | {"type": "Polygon", "coordinates": [[[-118.29098, 33.72201], [-118.2901, 33.72224], [-118.29009, 33.72236], [-118.28969, 33.72235], [-118.28969, 33.72234], [-118.28924, 33.72132], [-118.29019, 33.72107], [-118.29057, 33.7219], [-118.29092, 33.72182], [-118.29098, 33.72201]]]} | Open Access 1 | Harbor View Memorial Park | 19666 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 3.036 | Harbor View Memorial Park | ||
4892 | 4892 | 4891 | {"type": "Polygon", "coordinates": [[[-118.29681, 33.75776], [-118.29638, 33.75796], [-118.29566, 33.75841], [-118.29538, 33.75856], [-118.29502, 33.75869], [-118.29462, 33.75877], [-118.29445, 33.75781], [-118.29583, 33.75782], [-118.296, 33.7578], [-118.29613, 33.75776], [-118.29681, 33.75776]]]} | Open Access 1 | Harbor Highlands Park | 19663 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 3.181 | Harbor Highlands Park | ||
4901 | 4901 | 4900 | {"type": "Polygon", "coordinates": [[[-118.18789, 34.13489], [-118.18738, 34.13556], [-118.18733, 34.13557], [-118.18727, 34.13555], [-118.18726, 34.13551], [-118.18778, 34.13483], [-118.18789, 34.13489]]]} | Open Access 1 | Lanark/Shelby Park | 20998 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 0.273 | Lanark/Shelby Park | ||
4911 | 4911 | 4910 | {"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 | Harold A. Henry Park | 19684 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 2.08 | Harold A. Henry Park | ||
4940 | 4940 | 4939 | {"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 | Hartland Mini Park | 19710 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 0.065 | Hartland MP | ||
4989 | 4989 | 4988 | {"type": "MultiPolygon", "coordinates": [[[[-118.20447, 34.05944], [-118.20433, 34.05965], [-118.20331, 34.05922], [-118.20266, 34.06023], [-118.2028, 34.06042], [-118.20363, 34.06072], [-118.20347, 34.06095], [-118.20339, 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 | Hazard Park | 19763 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 24.196 | Hazard Park | ||
5032 | 5032 | 5031 | {"type": "Polygon", "coordinates": [[[-118.19601, 34.05796], [-118.19489, 34.05976], [-118.19436, 34.05954], [-118.19513, 34.0583], [-118.19519, 34.05833], [-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 | Henry Alvarez Memorial Park | 19822 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 2.567 | Henry Alvarez Memorial Park | ||
5072 | 5072 | 5071 | {"type": "Polygon", "coordinates": [[[-118.21282, 34.08604], [-118.21279, 34.0861], [-118.21277, 34.0861], [-118.21265, 34.08637], [-118.21229, 34.0864], [-118.21188, 34.08647], [-118.21132, 34.08662], [-118.21073, 34.08685], [-118.21027, 34.08709], [-118.20971, 34.08746], [-118.20817, 34.08873], [-118.20788, 34.08904], [-118.20765, 34.08934], [-118.20734, 34.08932], [-118.20749, 34.0892], [-118.20785, 34.08875], [-118.20774, 34.08869], [-118.20778, 34.0886], [-118.20747, 34.08846], [-118.20787, 34.08805], [-118.20821, 34.08774], [-118.20832, 34.08767], [-118.20877, 34.08744], [-118.20891, 34.0874], [-118.20975, 34.08693], [-118.2099, 34.08687], [-118.21071, 34.08645], [-118.21071, 34.08643], [-118.21055, 34.0864], [-118.21158, 34.08576], [-118.21178, 34.08581], [-118.2118, 34.08576], [-118.21282, 34.08604]]]} | Open Access 1 | Heritage Square | 19865 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 8.473 | Heritage Square | ||
5128 | 5128 | 5127 | {"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 | Highland Park | 19932 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 0.045 | Highland Park | ||
5208 | 5208 | 5207 | {"type": "Polygon", "coordinates": [[[-118.57291, 34.29201], [-118.57256, 34.29204], [-118.57271, 34.29241], [-118.5727, 34.29245], [-118.57268, 34.29247], [-118.57212, 34.29268], [-118.57066, 34.29334], [-118.57034, 34.29285], [-118.57021, 34.29259], [-118.57011, 34.29225], [-118.57008, 34.29191], [-118.57009, 34.29164], [-118.57016, 34.29134], [-118.57045, 34.29067], [-118.57044, 34.29065], [-118.57028, 34.29066], [-118.57043, 34.29029], [-118.57052, 34.28994], [-118.57056, 34.28958], [-118.57055, 34.28916], [-118.57062, 34.28954], [-118.57073, 34.28986], [-118.57089, 34.29016], [-118.57111, 34.29046], [-118.57137, 34.29075], [-118.57218, 34.29148], [-118.57236, 34.29169], [-118.57251, 34.29196], [-118.57288, 34.29194], [-118.57291, 34.29201]]]} | Open Access 1 | Holleigh Bernson Memorial Park | 20034 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 13.04 | Holleigh Bernson Memorial Park | ||
5210 | 5210 | 5209 | {"type": "Polygon", "coordinates": [[[-118.21967, 34.04001], [-118.21899, 34.03972], [-118.21821, 34.04086], [-118.21807, 34.04097], [-118.21772, 34.04113], [-118.21758, 34.04124], [-118.21666, 34.04267], [-118.21561, 34.0422], [-118.2175, 34.03904], [-118.21835, 34.03771], [-118.21919, 34.03781], [-118.21944, 34.03841], [-118.21965, 34.03868], [-118.21971, 34.03904], [-118.21973, 34.03937], [-118.21972, 34.03969], [-118.21967, 34.04001]]]} | Open Access 1 | Hollenbeck Park | 20037 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 20.477 | Hollenbeck Park | ||
5249 | 5249 | 5248 | {"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 | Hope and Peace Park | 20084 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 0.567 | Hope and Peace Park | ||
5258 | 5258 | 5257 | {"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 | Hoover Recreation Center | 20083 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 2.987 | Hoover Rec. Ctr. | ||
5270 | 5270 | 5269 | {"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 | Howard Finn Park | 20116 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 1.194 | Howard Finn Park | ||
5282 | 5282 | 5281 | {"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 | Hubert H. Humphrey Memorial Park | 20130 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 9.986 | Hubert H. Humphrey Memorial Park | ||
5320 | 5320 | 5319 | {"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 | Imperial Courts Recreation Center | 20179 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 2.429 | Imperial Courts Rec. Ctr. |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE superunits_with_maps( id INT, map, ACCESS_TYP INT, PARK_NAME TEXT, PARK_URL TEXT, SUID_NMA INT, MNG_AG_ID INT, MNG_AGENCY INT, MNG_AG_LEV INT, MNG_AG_TYP INT, AGNCY_WEB TEXT, LAYER INT, ACRES REAL, LABEL_NAME TEXT, YR_EST INT, FOREIGN KEY([ACCESS_TYP]) REFERENCES [ACCESS_TYP]([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([LAYER]) REFERENCES [LAYER]([id]) ); CREATE INDEX [idx_superunits_with_maps_LAYER] ON [superunits_with_maps] ([LAYER]); CREATE INDEX [idx_superunits_with_maps_MNG_AG_TYP] ON [superunits_with_maps] ([MNG_AG_TYP]); CREATE INDEX [idx_superunits_with_maps_MNG_AG_LEV] ON [superunits_with_maps] ([MNG_AG_LEV]); CREATE INDEX [idx_superunits_with_maps_MNG_AGENCY] ON [superunits_with_maps] ([MNG_AGENCY]); CREATE INDEX [idx_superunits_with_maps_ACCESS_TYP] ON [superunits_with_maps] ([ACCESS_TYP]);