superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where MNG_AGENCY = 4 and PARK_NAME = "Mission Valley Preserve"
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
13005 | 13005 | 13004 | {"type": "MultiPolygon", "coordinates": [[[[-117.20156, 32.76079], [-117.20158, 32.76105], [-117.20156, 32.76126], [-117.20151, 32.76147], [-117.20146, 32.76163], [-117.20139, 32.76181], [-117.20118, 32.76215], [-117.20095, 32.76241], [-117.19915, 32.76255], [-117.19883, 32.76256], [-117.19808, 32.76269], [-117.19801, 32.76268], [-117.19801, 32.76256], [-117.198, 32.76255], [-117.19784, 32.76272], [-117.19713, 32.7628], [-117.19659, 32.76291], [-117.19403, 32.76367], [-117.19312, 32.76072], [-117.19351, 32.7608], [-117.19367, 32.76086], [-117.19407, 32.76095], [-117.19444, 32.76099], [-117.19523, 32.76097], [-117.19584, 32.76085], [-117.19612, 32.76082], [-117.19647, 32.76083], [-117.19687, 32.76077], [-117.19707, 32.76077], [-117.19728, 32.76081], [-117.1974, 32.76086], [-117.19752, 32.76094], [-117.19769, 32.76112], [-117.19773, 32.76123], [-117.19781, 32.76127], [-117.19778, 32.76142], [-117.19781, 32.76228], [-117.19799, 32.76241], [-117.19801, 32.76225], [-117.19787, 32.76214], [-117.19801, 32.76213], [-117.19818, 32.76084], [-117.1983, 32.76068], [-117.19838, 32.76062], [-117.19872, 32.76062], [-117.19877, 32.76065], [-117.2003, 32.76051], [-117.2013, 32.7603], [-117.20149, 32.76021], [-117.20156, 32.76043], [-117.20148, 32.76051], [-117.20151, 32.76062], [-117.20148, 32.76064], [-117.20151, 32.76078], [-117.20156, 32.76079]]], [[[-117.20224, 32.7623], [-117.20197, 32.76234], [-117.20117, 32.7624], [-117.2014, 32.76211], [-117.20148, 32.76198], [-117.20163, 32.76163], [-117.20172, 32.76132], [-117.20174, 32.7609], [-117.20224, 32.7623]]], [[[-117.20319, 32.76218], [-117.20256, 32.76224], [-117.20181, 32.76016], [-117.20242, 32.76013], [-117.20319, 32.76218]]], [[[-117.20417, 32.76202], [-117.20356, 32.76213], [-117.20317, 32.76097], [-117.20328, 32.76093], [-117.20298, 32.7601], [-117.20311, 32.76015], [-117.20336, 32.7603], [-117.20348, 32.7604], [-117.20366, 32.76063], [-117.20387, 32.7611], [-117.20417, 32.76202]]]]} | Open Access 1 | Mission Valley Preserve | 30263 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 49.653 | Mission Valley 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]);