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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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. | ||
5411 | 5411 | 5410 | {"type": "Polygon", "coordinates": [[[-118.3997, 34.03994], [-118.39971, 34.04], [-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 | Irving Schachter Park | 20272 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 1.797 | Irving Schachter Park | ||
5576 | 5576 | 5575 | {"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 | John Quimby Park | 20463 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 4.245 | John Quimby Park | ||
5579 | 5579 | 5578 | {"type": "MultiPolygon", "coordinates": [[[[-118.27948, 33.7416], [-118.27944, 33.74156], [-118.27932, 33.74155], [-118.2792, 33.74148], [-118.2792, 33.74068], [-118.27946, 33.74068], [-118.27948, 33.7407], [-118.27948, 33.7416]]], [[[-118.27967, 33.7389], [-118.27968, 33.73933], [-118.27965, 33.73979], [-118.27953, 33.74038], [-118.27951, 33.7404], [-118.27948, 33.7404], [-118.27945, 33.74011], [-118.27942, 33.73886], [-118.27963, 33.73887], [-118.27967, 33.7389]]], [[[-118.28034, 33.73864], [-118.28006, 33.73865], [-118.28, 33.7386], [-118.28001, 33.73837], [-118.28033, 33.73837], [-118.28034, 33.73864]]]]} | Open Access 1 | John S. Gibson Jr. Park | 20466 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 1.602 | John S. Gibson Jr. Park | ||
5585 | 5585 | 5584 | {"type": "Polygon", "coordinates": [[[-118.33115, 34.15496], [-118.33062, 34.15513], [-118.32876, 34.15396], [-118.32928, 34.15378], [-118.33115, 34.15496]]]} | Open Access 1 | Johnny Carson Park | 20473 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 2.408 | Johnny Carson Park | ||
5609 | 5609 | 5608 | {"type": "Polygon", "coordinates": [[[-118.24672, 34.11889], [-118.24632, 34.1192], [-118.24592, 34.1188], [-118.24579, 34.11887], [-118.24539, 34.11847], [-118.24593, 34.1181], [-118.24672, 34.11889]]]} | Open Access 1 | Juntos Park | 20534 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 1.64 | Juntos Park | ||
5613 | 5613 | 5612 | {"type": "Polygon", "coordinates": [[[-118.23664, 33.94589], [-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]]]} | Open Access 1 | Jordan Downs Recreation Center | 20489 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 3.132 | Jordan Downs Rec. Ctr. | ||
5646 | 5646 | 5645 | {"type": "Polygon", "coordinates": [[[-118.38183, 34.28065], [-118.38164, 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 | Kagel Canyon Park | 20542 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 3.467 | Kagel Canyon Park | ||
5761 | 5761 | 5760 | {"type": "Polygon", "coordinates": [[[-118.66738, 34.18769], [-118.66733, 34.19134], [-118.66148, 34.18951], [-118.6613, 34.18942], [-118.66109, 34.18936], [-118.65975, 34.1892], [-118.65953, 34.18919], [-118.65927, 34.1892], [-118.65868, 34.18927], [-118.65841, 34.18933], [-118.65818, 34.18941], [-118.65747, 34.18971], [-118.65772, 34.18768], [-118.66363, 34.18769], [-118.66365, 34.18691], [-118.66382, 34.1869], [-118.66509, 34.18549], [-118.66548, 34.18553], [-118.6657, 34.1858], [-118.66637, 34.18602], [-118.66659, 34.18616], [-118.66669, 34.18768], [-118.66738, 34.18769]]]} | Open Access 1 | Knapp Ranch Park | 20692 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 69.296 | Knapp Ranch Park | ||
5868 | 5868 | 5867 | {"type": "MultiPolygon", "coordinates": [[[[-118.28551, 34.06276], [-118.28488, 34.06277], [-118.28427, 34.06357], [-118.28256, 34.0628], [-118.28336, 34.06157], [-118.28425, 34.06197], [-118.2855, 34.06197], [-118.28551, 34.06276]]], [[[-118.28408, 34.06152], [-118.28355, 34.06128], [-118.28407, 34.06049], [-118.28407, 34.06049], [-118.28408, 34.06152]]]]} | Open Access 1 | Lafayette Park | 20832 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 9.082 | Lafayette Park | ||
5970 | 5970 | 5969 | {"type": "Polygon", "coordinates": [[[-118.3716, 34.27463], [-118.37157, 34.27826], [-118.371, 34.27826], [-118.371, 34.27744], [-118.37049, 34.27743], [-118.3705, 34.27575], [-118.37032, 34.27573], [-118.37031, 34.27523], [-118.37007, 34.27517], [-118.37007, 34.27462], [-118.3716, 34.27463]]]} | Open Access 1 | Lakeview Terrace Recreation Center | 20985 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 9.833 | Lakeview Terrace Rec. Ctr. | ||
5977 | 5977 | 5976 | {"type": "Polygon", "coordinates": [[[-118.41363, 33.95967], [-118.40927, 33.95968], [-118.40927, 33.95722], [-118.40942, 33.95725], [-118.40951, 33.95722], [-118.40956, 33.95713], [-118.40956, 33.95708], [-118.40953, 33.95704], [-118.40948, 33.957], [-118.40942, 33.95699], [-118.40928, 33.95702], [-118.4057, 33.95703], [-118.40454, 33.95711], [-118.4045, 33.95706], [-118.4045, 33.95483], [-118.40456, 33.95479], [-118.41077, 33.95416], [-118.41233, 33.95399], [-118.41264, 33.95412], [-118.41314, 33.95437], [-118.41362, 33.95468], [-118.41363, 33.95967]]]} | Restricted Access 2 | Westchester Golf Course | http://lacity.org/ | 33047 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 90.2 | Westchester GC |
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]);