superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where MNG_AG_TYP = 3 and PARK_URL = "http://parks.lacounty.gov/wps/portal/dpr/Parks/Stephen_Sorensen_Park"
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
11630 | 11630 | 11629 | {"type": "Polygon", "coordinates": [[[-117.83849, 34.61111], [-117.83844, 34.61122], [-117.83629, 34.61123], [-117.83631, 34.61635], [-117.8355, 34.61634], [-117.83549, 34.61306], [-117.83548, 34.61288], [-117.83541, 34.61251], [-117.83529, 34.61217], [-117.8348, 34.61124], [-117.8346, 34.61086], [-117.83444, 34.61059], [-117.83432, 34.61046], [-117.83412, 34.61031], [-117.83399, 34.61024], [-117.83364, 34.61011], [-117.83351, 34.61008], [-117.83184, 34.6085], [-117.83127, 34.6083], [-117.82893, 34.60825], [-117.82623, 34.60825], [-117.82514, 34.60681], [-117.82557, 34.60661], [-117.82567, 34.60658], [-117.82682, 34.60652], [-117.82705, 34.60648], [-117.82743, 34.60639], [-117.82795, 34.6062], [-117.82811, 34.60612], [-117.82829, 34.60603], [-117.82856, 34.60584], [-117.82856, 34.60582], [-117.82814, 34.60543], [-117.82814, 34.60539], [-117.8281, 34.60533], [-117.82805, 34.6053], [-117.82799, 34.60529], [-117.82756, 34.60489], [-117.8288, 34.60398], [-117.82949, 34.60318], [-117.8298, 34.60335], [-117.83009, 34.60355], [-117.83037, 34.60377], [-117.83062, 34.604], [-117.8308, 34.60419], [-117.83296, 34.60663], [-117.83319, 34.60687], [-117.83344, 34.60708], [-117.83363, 34.60723], [-117.83392, 34.60744], [-117.83421, 34.60761], [-117.8347, 34.60786], [-117.8352, 34.60806], [-117.83588, 34.60825], [-117.83805, 34.60874], [-117.83794, 34.60908], [-117.83794, 34.61049], [-117.83849, 34.61111]]]} | Open Access 1 | Stephen Sorensen Park | http://parks.lacounty.gov/wps/portal/dpr/Parks/Stephen_Sorensen_Park | 28178 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 108.137 | Stephen Sorensen Park |
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]);