units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where LABEL_NAME = "Porter Ranch Park" and MNG_AGENCY = 24
This data as json, copyable, CSV (advanced)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
7791 | 7791 | 7790 | {"type": "MultiPolygon", "coordinates": [[[[-118.5578, 34.25878], [-118.5578, 34.25878], [-118.55772, 34.25882], [-118.55779, 34.25871], [-118.5578, 34.25878]]], [[[-118.55939, 34.26301], [-118.55914, 34.2636], [-118.55914, 34.26449], [-118.55869, 34.26449], [-118.55761, 34.265], [-118.55739, 34.26524], [-118.55734, 34.26531], [-118.55698, 34.26561], [-118.5567, 34.2658], [-118.55672, 34.26564], [-118.5568, 34.26545], [-118.5573, 34.26477], [-118.5574, 34.26466], [-118.55759, 34.26449], [-118.55822, 34.26409], [-118.55843, 34.26391], [-118.55856, 34.26377], [-118.55869, 34.26357], [-118.55878, 34.26337], [-118.55882, 34.26324], [-118.55885, 34.26298], [-118.55883, 34.26269], [-118.55878, 34.26251], [-118.55856, 34.26183], [-118.55852, 34.26163], [-118.55851, 34.26149], [-118.55862, 34.26057], [-118.5588, 34.26058], [-118.55879, 34.26028], [-118.55875, 34.26009], [-118.55867, 34.2599], [-118.55826, 34.25925], [-118.55887, 34.25926], [-118.55888, 34.26199], [-118.55939, 34.26301]]], [[[-118.55782, 34.25913], [-118.55777, 34.25935], [-118.55772, 34.25999], [-118.55765, 34.26], [-118.55764, 34.2601], [-118.55713, 34.26025], [-118.55703, 34.26043], [-118.55703, 34.26071], [-118.55711, 34.26084], [-118.55711, 34.26222], [-118.55727, 34.26284], [-118.55727, 34.26359], [-118.55671, 34.26447], [-118.55605, 34.26492], [-118.55605, 34.26605], [-118.5557, 34.26611], [-118.55542, 34.26613], [-118.55538, 34.26608], [-118.5554, 34.26578], [-118.55545, 34.26551], [-118.55554, 34.26525], [-118.55571, 34.26492], [-118.55649, 34.26374], [-118.55662, 34.26351], [-118.55671, 34.26332], [-118.5568, 34.26308], [-118.55686, 34.26288], [-118.5569, 34.26263], [-118.55692, 34.26232], [-118.5569, 34.26202], [-118.55683, 34.26167], [-118.55674, 34.26142], [-118.55661, 34.26114], [-118.55647, 34.26091], [-118.55627, 34.26065], [-118.55601, 34.26037], [-118.556, 34.26033], [-118.55723, 34.25938], [-118.55749, 34.25912], [-118.55771, 34.25884], [-118.55766, 34.25898], [-118.55782, 34.25913]]], [[[-118.56197, 34.27203], [-118.56197, 34.27218], [-118.56166, 34.27227], [-118.56155, 34.27228], [-118.56143, 34.27225], [-118.5604, 34.27183], [-118.5601, 34.27177], [-118.55894, 34.27181], [-118.55868, 34.27188], [-118.55847, 34.27198], [-118.55826, 34.27195], [-118.55818, 34.272], [-118.55711, 34.27186], [-118.5571, 34.27183], [-118.55673, 34.27193], [-118.55664, 34.27173], [-118.55636, 34.27175], [-118.55625, 34.27173], [-118.55622, 34.27167], [-118.55651, 34.27156], [-118.55651, 34.27155], [-118.55621, 34.27099], [-118.55582, 34.27084], [-118.5557, 34.27088], [-118.55553, 34.27044], [-118.55543, 34.27004], [-118.55541, 34.26983], [-118.55539, 34.2695], [-118.55538, 34.26643], [-118.55539, 34.26641], [-118.55543, 34.26638], [-118.55573, 34.26636], [-118.55605, 34.26631], [-118.55605, 34.2666], [-118.55632, 34.26728], [-118.55671, 34.2673], [-118.55674, 34.26674], [-118.55671, 34.26607], [-118.55695, 34.26594], [-118.55717, 34.2658], [-118.55717, 34.26628], [-118.55719, 34.26688], [-118.55726, 34.26744], [-118.55744, 34.26792], [-118.55747, 34.26858], [-118.55709, 34.26898], [-118.55701, 34.26913], [-118.55722, 34.26959], [-118.55725, 34.26971], [-118.55728, 34.2701], [-118.55722, 34.2703], [-118.55706, 34.27052], [-118.55708, 34.27063], [-118.55738, 34.27092], [-118.55742, 34.27104], [-118.55745, 34.27132], [-118.55767, 34.27166], [-118.55775, 34.27188], [-118.55826, 34.27195], [-118.55855, 34.27178], [-118.55886, 34.27169], [-118.55905, 34.27166], [-118.56001, 34.27163], [-118.56024, 34.27165], [-118.56047, 34.27171], [-118.56152, 34.27214], [-118.56163, 34.27213], [-118.56197, 34.27203]]], [[[-118.57493, 34.27239], [-118.57491, 34.27259], [-118.5739, 34.27235], [-118.57387, 34.27232], [-118.573, 34.27211], [-118.57249, 34.27262], [-118.57234, 34.27272], [-118.57221, 34.27277], [-118.57211, 34.27278], [-118.57152, 34.27279], [-118.57141, 34.27276], [-118.57132, 34.27269], [-118.57114, 34.27241], [-118.57092, 34.2722], [-118.57078, 34.27212], [-118.5705, 34.27203], [-118.5704, 34.27197], [-118.57013, 34.27165], [-118.57004, 34.27171], [-118.56994, 34.27163], [-118.56984, 34.27158], [-118.5696, 34.27154], [-118.56944, 34.27155], [-118.56931, 34.27158], [-118.56836, 34.272], [-118.5682, 34.27203], [-118.5679, 34.27204], [-118.56694, 34.27181], [-118.56693, 34.27177], [-118.56599, 34.27156], [-118.56558, 34.27151], [-118.56351, 34.27136], [-118.56334, 34.27139], [-118.56318, 34.27146], [-118.56251, 34.27201], [-118.56238, 34.27208], [-118.56226, 34.27212], [-118.56225, 34.27195], [-118.56238, 34.27188], [-118.56307, 34.27133], [-118.56327, 34.27123], [-118.56347, 34.27119], [-118.56364, 34.27119], [-118.56587, 34.27137], [-118.56635, 34.27146], [-118.56796, 34.27185], [-118.5681, 34.27187], [-118.56824, 34.27186], [-118.56836, 34.27182], [-118.56927, 34.27142], [-118.56946, 34.27137], [-118.56961, 34.27136], [-118.56981, 34.27139], [-118.56999, 34.27146], [-118.57308, 34.272], [-118.57324, 34.272], [-118.57493, 34.27239]], [[-118.57244, 34.27257], [-118.57292, 34.27207], [-118.57021, 34.27161], [-118.57042, 34.27188], [-118.57049, 34.27194], [-118.57056, 34.27198], [-118.57085, 34.27208], [-118.57101, 34.27218], [-118.57122, 34.27238], [-118.57137, 34.27264], [-118.57146, 34.2727], [-118.57156, 34.27273], [-118.57215, 34.27271], [-118.5723, 34.27266], [-118.57244, 34.27257]]]]} | Open Access 1 | 8785 | Porter Ranch Park | 23900 | 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 | 48.309 | Porter Ranch Park | 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]);