units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
18 rows where DES_TP = 2, LABEL_NAME = "Los Angeles City Water Resource Parkland" and MNG_AGENCY = 24
This data as json, copyable, CSV (advanced)
Suggested facets: SUID_NMA
ACCESS_TYP 2
MNG_AG_TYP 1
- City Agency 18
MNG_AGENCY 1
- Los Angeles, City of · 18 ✖
DES_TP 1
- Local Park · 18 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1270 | 1270 | 1269 | {"type": "Polygon", "coordinates": [[[-118.56523, 34.13034], [-118.56473, 34.13106], [-118.56429, 34.13106], [-118.56418, 34.13093], [-118.56397, 34.13076], [-118.56397, 34.13019], [-118.56387, 34.13018], [-118.56387, 34.12948], [-118.5652, 34.12947], [-118.56479, 34.13017], [-118.56523, 34.13034]]]} | No Public Access 3 | 7159 | Los Angeles City Water Resource Parkland | 21477 | 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.129 | Los Angeles City Water Resource Parkland | 0 | Local Park 2 | 4 | |
1271 | 1271 | 1270 | {"type": "Polygon", "coordinates": [[[-118.44484, 34.1151], [-118.44483, 34.11604], [-118.44451, 34.11604], [-118.44418, 34.11581], [-118.44418, 34.11543], [-118.4445, 34.11515], [-118.44451, 34.1151], [-118.44484, 34.1151]]]} | No Public Access 3 | 7160 | Los Angeles City Water Resource Parkland | 21477 | 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.317 | Los Angeles City Water Resource Parkland | 0 | Local Park 2 | 4 | |
1340 | 1340 | 1339 | {"type": "Polygon", "coordinates": [[[-118.38142, 34.10854], [-118.38114, 34.10871], [-118.38103, 34.10855], [-118.38131, 34.10838], [-118.38142, 34.10854]]]} | No Public Access 3 | 12809 | Los Angeles City Water Resource Parkland | 21477 | 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.163 | Los Angeles City Water Resource Parkland | 0 | Local Park 2 | 4 | |
1489 | 1489 | 1488 | {"type": "Polygon", "coordinates": [[[-118.46789, 34.09611], [-118.46633, 34.09612], [-118.46623, 34.09617], [-118.46611, 34.09595], [-118.46593, 34.09571], [-118.46592, 34.09565], [-118.46593, 34.09559], [-118.46595, 34.09555], [-118.46601, 34.09548], [-118.46614, 34.09544], [-118.4678, 34.09543], [-118.46792, 34.09583], [-118.46789, 34.09611]]]} | No Public Access 3 | 12701 | Los Angeles City Water Resource Parkland | 21477 | 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.182 | Los Angeles City Water Resource Parkland | 0 | Local Park 2 | 4 | |
1776 | 1776 | 1775 | {"type": "Polygon", "coordinates": [[[-118.48227, 34.13075], [-118.48207, 34.13116], [-118.48173, 34.13113], [-118.48153, 34.13128], [-118.48151, 34.13133], [-118.48139, 34.13147], [-118.48134, 34.13159], [-118.48124, 34.13158], [-118.48123, 34.13153], [-118.48064, 34.13128], [-118.4807, 34.13117], [-118.4807, 34.13115], [-118.48067, 34.13115], [-118.48067, 34.13113], [-118.48069, 34.13111], [-118.48074, 34.13091], [-118.48073, 34.13058], [-118.4807, 34.13055], [-118.48064, 34.13012], [-118.48073, 34.13007], [-118.4808, 34.13005], [-118.48091, 34.13005], [-118.48099, 34.13007], [-118.48112, 34.13015], [-118.48128, 34.13033], [-118.48142, 34.13043], [-118.48161, 34.13053], [-118.48227, 34.13075]]]} | Open Access 1 | 7163 | Los Angeles City Water Resource Parkland | 21478 | 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.509 | Los Angeles City Water Resource Parkland | 0 | Local Park 2 | 4 | |
2803 | 2803 | 2802 | {"type": "Polygon", "coordinates": [[[-118.37097, 34.13187], [-118.37053, 34.13214], [-118.36993, 34.13183], [-118.37013, 34.13145], [-118.37097, 34.13187]]]} | No Public Access 3 | 12817 | Los Angeles City Water Resource Parkland | 21477 | 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.89 | Los Angeles City Water Resource Parkland | 0 | Local Park 2 | 4 | |
5168 | 5168 | 5167 | {"type": "Polygon", "coordinates": [[[-118.37164, 34.13145], [-118.37153, 34.13213], [-118.37007, 34.13142], [-118.37071, 34.1309], [-118.37084, 34.13153], [-118.37164, 34.13145]]]} | No Public Access 3 | 12818 | Los Angeles City Water Resource Parkland | 21477 | 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.768 | Los Angeles City Water Resource Parkland | 0 | Local Park 2 | 4 | |
5379 | 5379 | 5378 | {"type": "MultiPolygon", "coordinates": [[[[-118.49009, 34.07252], [-118.49006, 34.07266], [-118.48998, 34.07279], [-118.48976, 34.07252], [-118.48972, 34.07104], [-118.48967, 34.0709], [-118.48933, 34.07024], [-118.48922, 34.07], [-118.48958, 34.07056], [-118.48972, 34.0707], [-118.48994, 34.07083], [-118.49006, 34.07107], [-118.49009, 34.07252]]], [[[-118.48922, 34.06999], [-118.48921, 34.06999], [-118.48889, 34.06937], [-118.48868, 34.06909], [-118.48882, 34.06911], [-118.48892, 34.06916], [-118.48903, 34.06928], [-118.48907, 34.06938], [-118.48907, 34.06957], [-118.48909, 34.06971], [-118.48916, 34.0699], [-118.48922, 34.06999]]], [[[-118.48985, 34.07064], [-118.48969, 34.07051], [-118.48929, 34.06987], [-118.48921, 34.06964], [-118.4892, 34.0694], [-118.48921, 34.0694], [-118.48985, 34.07064]]], [[[-118.49104, 34.07372], [-118.4906, 34.07359], [-118.49057, 34.07351], [-118.49005, 34.07288], [-118.49012, 34.07276], [-118.49017, 34.07262], [-118.49018, 34.07255], [-118.49086, 34.07338], [-118.49104, 34.07372]]], [[[-118.49199, 34.07546], [-118.49196, 34.07594], [-118.49177, 34.07593], [-118.49174, 34.07589], [-118.49175, 34.07557], [-118.4917, 34.07537], [-118.49145, 34.07494], [-118.49138, 34.07487], [-118.49127, 34.07482], [-118.49068, 34.07372], [-118.49111, 34.07385], [-118.49199, 34.07546]]], [[[-118.50133, 34.10922], [-118.50107, 34.10941], [-118.49584, 34.1018], [-118.49627, 34.09972], [-118.49607, 34.09983], [-118.4959, 34.09997], [-118.49583, 34.10002], [-118.4957, 34.10007], [-118.49561, 34.10008], [-118.49546, 34.10006], [-118.49532, 34.1], [-118.49522, 34.09991], [-118.49515, 34.09978], [-118.49515, 34.09963], [-118.4952, 34.09951], [-118.49533, 34.0994], [-118.49541, 34.09936], [-118.49554, 34.09933], [-118.49563, 34.09933], [-118.49622, 34.09945], [-118.49635, 34.09938], [-118.49748, 34.09407], [-118.49598, 34.08746], [-118.49578, 34.0865], [-118.49576, 34.0865], [-118.49576, 34.08665], [-118.49443, 34.08665], [-118.49443, 34.08457], [-118.49535, 34.08456], [-118.49528, 34.08426], [-118.49503, 34.0824], [-118.49483, 34.08157], [-118.49496, 34.0815], [-118.49472, 34.08117], [-118.4944, 34.0798], [-118.4916, 34.07645], [-118.49162, 34.07603], [-118.49196, 34.07604], [-118.49193, 34.07638], [-118.49471, 34.07969], [-118.49535, 34.08234], [-118.49561, 34.08421], [-118.49781, 34.09407], [-118.49618, 34.10176], [-118.50133, 34.10922]], [[-118.49547, 34.08519], [-118.49548, 34.08518], [-118.49542, 34.08495], [-118.49534, 34.08509], [-118.49547, 34.08519]], [[-118.49557, 34.08587], [-118.49564, 34.08587], [-118.49559, 34.08567], [-118.49556, 34.0857], [-118.49557, 34.08587]]]]} | Open Access 1 | 7157 | Los Angeles City Water Resource Parkland | 21478 | 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 | 42.397 | Los Angeles City Water Resource Parkland | 0 | Local Park 2 | 4 | |
5411 | 5411 | 5410 | {"type": "Polygon", "coordinates": [[[-118.58708, 34.13904], [-118.58568, 34.13904], [-118.58568, 34.13813], [-118.58707, 34.13866], [-118.58708, 34.13904]]]} | No Public Access 3 | 7166 | Los Angeles City Water Resource Parkland | 21477 | 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.267 | Los Angeles City Water Resource Parkland | 0 | Local Park 2 | 4 | |
5495 | 5495 | 5494 | {"type": "Polygon", "coordinates": [[[-118.38093, 34.1267], [-118.38083, 34.12681], [-118.38083, 34.12701], [-118.38061, 34.12707], [-118.38043, 34.12717], [-118.38031, 34.12721], [-118.3802, 34.12721], [-118.38011, 34.12718], [-118.38003, 34.12714], [-118.37992, 34.12701], [-118.3798, 34.12694], [-118.37975, 34.12694], [-118.37974, 34.12695], [-118.37963, 34.12692], [-118.37943, 34.1269], [-118.37939, 34.12686], [-118.37941, 34.12663], [-118.38093, 34.1267]]]} | No Public Access 3 | 12819 | Los Angeles City Water Resource Parkland | 21477 | 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.441 | Los Angeles City Water Resource Parkland | 0 | Local Park 2 | 4 | |
5496 | 5496 | 5495 | {"type": "Polygon", "coordinates": [[[-118.39301, 34.11863], [-118.39283, 34.11899], [-118.39267, 34.11881], [-118.39276, 34.11874], [-118.39271, 34.11868], [-118.3926, 34.11875], [-118.39249, 34.11863], [-118.39234, 34.11881], [-118.39226, 34.11887], [-118.39219, 34.11889], [-118.39201, 34.11889], [-118.39183, 34.11881], [-118.39175, 34.11874], [-118.39223, 34.11873], [-118.39222, 34.11808], [-118.39228, 34.11821], [-118.39284, 34.11848], [-118.39299, 34.11857], [-118.39297, 34.1186], [-118.39301, 34.11863]]]} | No Public Access 3 | 12820 | Los Angeles City Water Resource Parkland | 21477 | 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.964 | Los Angeles City Water Resource Parkland | 0 | Local Park 2 | 4 | |
5497 | 5497 | 5496 | {"type": "Polygon", "coordinates": [[[-118.39276, 34.11874], [-118.39267, 34.11881], [-118.3926, 34.11875], [-118.39271, 34.11867], [-118.39276, 34.11874]]]} | No Public Access 3 | 12821 | Los Angeles City Water Resource Parkland | 21477 | 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.028 | Los Angeles City Water Resource Parkland | 0 | Local Park 2 | 4 | |
7551 | 7551 | 7550 | {"type": "Polygon", "coordinates": [[[-118.44367, 34.1295], [-118.4417, 34.12943], [-118.4417, 34.12935], [-118.44173, 34.12926], [-118.44203, 34.12886], [-118.44206, 34.12877], [-118.44212, 34.12843], [-118.4427, 34.12846], [-118.44271, 34.12848], [-118.44294, 34.12848], [-118.44294, 34.12861], [-118.4431, 34.12855], [-118.44318, 34.12855], [-118.44328, 34.12859], [-118.44334, 34.12867], [-118.44367, 34.1295]]]} | No Public Access 3 | 7161 | Los Angeles City Water Resource Parkland | 21477 | 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.797 | Los Angeles City Water Resource Parkland | 0 | Local Park 2 | 4 | |
7936 | 7936 | 7935 | {"type": "Polygon", "coordinates": [[[-118.36765, 34.12534], [-118.36714, 34.12607], [-118.36565, 34.126], [-118.3668, 34.12438], [-118.3669, 34.12456], [-118.36735, 34.12491], [-118.36715, 34.12508], [-118.36715, 34.1251], [-118.36765, 34.12534]]]} | No Public Access 3 | 12815 | Los Angeles City Water Resource Parkland | 21477 | 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.385 | Los Angeles City Water Resource Parkland | 0 | Local Park 2 | 4 | |
7948 | 7948 | 7947 | {"type": "Polygon", "coordinates": [[[-118.37369, 34.12306], [-118.3737, 34.12323], [-118.37362, 34.12338], [-118.37328, 34.12338], [-118.37328, 34.12313], [-118.3733, 34.12309], [-118.37349, 34.12293], [-118.37369, 34.12306]]]} | No Public Access 3 | 12814 | Los Angeles City Water Resource Parkland | 21477 | 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.377 | Los Angeles City Water Resource Parkland | 0 | Local Park 2 | 4 | |
8264 | 8264 | 8263 | {"type": "Polygon", "coordinates": [[[-118.38077, 34.1079], [-118.38075, 34.10838], [-118.38056, 34.10851], [-118.3804, 34.10844], [-118.38058, 34.10801], [-118.38077, 34.1079]]]} | No Public Access 3 | 12810 | Los Angeles City Water Resource Parkland | 21477 | 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.337 | Los Angeles City Water Resource Parkland | 0 | Local Park 2 | 4 | |
8326 | 8326 | 8325 | {"type": "Polygon", "coordinates": [[[-118.38131, 34.10838], [-118.38103, 34.10855], [-118.38075, 34.10838], [-118.38077, 34.1079], [-118.38091, 34.10781], [-118.38131, 34.10838]]]} | No Public Access 3 | 12808 | Los Angeles City Water Resource Parkland | 21477 | 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.602 | Los Angeles City Water Resource Parkland | 0 | Local Park 2 | 4 | |
8327 | 8327 | 8326 | {"type": "Polygon", "coordinates": [[[-118.38766, 34.10102], [-118.38766, 34.10162], [-118.38733, 34.10162], [-118.38682, 34.10136], [-118.38679, 34.10134], [-118.3867, 34.10118], [-118.38646, 34.10102], [-118.38651, 34.10098], [-118.38678, 34.10116], [-118.38686, 34.10109], [-118.38711, 34.10102], [-118.38766, 34.10102]]]} | No Public Access 3 | 12811 | Los Angeles City Water Resource Parkland | 21477 | 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.168 | Los Angeles City Water Resource Parkland | 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]);