superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where ACRES = "354.218" and MNG_AGENCY = 294
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
15047 | 15047 | 15046 | {"type": "MultiPolygon", "coordinates": [[[[-118.09232, 33.82822], [-118.09099, 33.82783], [-118.09091, 33.82687], [-118.09069, 33.82686], [-118.09068, 33.82486], [-118.08925, 33.82485], [-118.08923, 33.8273], [-118.08223, 33.82523], [-118.08214, 33.82485], [-118.0819, 33.82348], [-118.08181, 33.82263], [-118.08176, 33.82191], [-118.08173, 33.8205], [-118.08174, 33.82047], [-118.08175, 33.81779], [-118.08278, 33.81781], [-118.08335, 33.81785], [-118.08389, 33.81793], [-118.08736, 33.81869], [-118.08744, 33.81869], [-118.08787, 33.81882], [-118.08834, 33.81889], [-118.08886, 33.81894], [-118.08923, 33.81896], [-118.09064, 33.81895], [-118.09076, 33.81977], [-118.09109, 33.81978], [-118.09232, 33.82822]]], [[[-118.0908, 33.81768], [-118.09047, 33.8177], [-118.0906, 33.81868], [-118.08945, 33.81869], [-118.0885, 33.81861], [-118.0879, 33.81852], [-118.08434, 33.81774], [-118.08378, 33.81764], [-118.08341, 33.81758], [-118.08286, 33.81753], [-118.08224, 33.81751], [-118.08174, 33.81752], [-118.08176, 33.81394], [-118.08195, 33.81392], [-118.08196, 33.81266], [-118.0827, 33.81114], [-118.0828, 33.811], [-118.08294, 33.81085], [-118.08305, 33.81079], [-118.08332, 33.81069], [-118.08445, 33.81057], [-118.08673, 33.81058], [-118.08732, 33.81055], [-118.09009, 33.81055], [-118.09014, 33.81169], [-118.0905, 33.81171], [-118.09051, 33.81179], [-118.0906, 33.81391], [-118.0908, 33.81768]]]]} | Open Access 1 | El Dorado East Regional Park | http://www.longbeach.gov/park/parks_and_open_spaces/parks/el_dorado_regional_park.asp | 5426 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 354.218 | El Dorado East RP |
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]);