superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where LABEL_NAME = "Ballona Lagoon Marine Preserve" and 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1286 | 1286 | 1285 | {"type": "Polygon", "coordinates": [[[-118.46153, 33.97503], [-118.46151, 33.97515], [-118.46145, 33.97532], [-118.4613, 33.97553], [-118.46123, 33.97559], [-118.46107, 33.97571], [-118.46039, 33.97608], [-118.45986, 33.97557], [-118.46056, 33.97514], [-118.46066, 33.97505], [-118.46076, 33.9749], [-118.4608, 33.97475], [-118.46078, 33.97459], [-118.46074, 33.97448], [-118.45889, 33.97201], [-118.45771, 33.97025], [-118.45652, 33.969], [-118.45648, 33.969], [-118.45458, 33.96645], [-118.45481, 33.96634], [-118.45481, 33.96632], [-118.45505, 33.9662], [-118.45681, 33.96885], [-118.45712, 33.96873], [-118.45717, 33.96881], [-118.45703, 33.96889], [-118.45708, 33.96897], [-118.45727, 33.96889], [-118.45758, 33.96936], [-118.45745, 33.96943], [-118.4575, 33.96951], [-118.45759, 33.96948], [-118.45794, 33.96993], [-118.45787, 33.96997], [-118.45787, 33.96999], [-118.45794, 33.97006], [-118.45801, 33.97002], [-118.45837, 33.97047], [-118.45829, 33.97051], [-118.45829, 33.97053], [-118.45836, 33.9706], [-118.45843, 33.97057], [-118.45879, 33.97101], [-118.45871, 33.97106], [-118.45871, 33.97107], [-118.45878, 33.97114], [-118.45885, 33.97111], [-118.45921, 33.97156], [-118.45913, 33.97159], [-118.45913, 33.97161], [-118.4592, 33.97169], [-118.45928, 33.97165], [-118.45963, 33.9721], [-118.45955, 33.97214], [-118.45955, 33.97216], [-118.45962, 33.97223], [-118.4597, 33.9722], [-118.46005, 33.97264], [-118.45997, 33.97268], [-118.45997, 33.9727], [-118.46004, 33.97277], [-118.46013, 33.97273], [-118.46047, 33.97319], [-118.4604, 33.97323], [-118.46045, 33.97331], [-118.46055, 33.97328], [-118.46093, 33.97378], [-118.46086, 33.97382], [-118.46086, 33.97384], [-118.46092, 33.97391], [-118.461, 33.97387], [-118.46135, 33.97431], [-118.46129, 33.97438], [-118.4614, 33.97453], [-118.46148, 33.97468], [-118.46153, 33.97487], [-118.46153, 33.97503]]]} | Open Access 1 | Ballona Lagoon Marine Preserve | http://lacity.org/ | 15788 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 16.02 | Ballona Lagoon Marine Preserve |
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]);