superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where LABEL_NAME = "Tijuana River Valley RP" and MNG_AGENCY = 4
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
822 | 822 | 821 | {"type": "MultiPolygon", "coordinates": [[[[-117.07543, 32.54723], [-117.07334, 32.54725], [-117.07265, 32.54719], [-117.07205, 32.54707], [-117.07148, 32.54689], [-117.0711, 32.54673], [-117.07109, 32.54619], [-117.0715, 32.54637], [-117.07191, 32.54654], [-117.07243, 32.54667], [-117.07273, 32.54672], [-117.07335, 32.54678], [-117.07543, 32.54677], [-117.07543, 32.54723]]], [[[-117.07531, 32.56113], [-117.07484, 32.56105], [-117.07453, 32.56098], [-117.07423, 32.56089], [-117.07377, 32.56072], [-117.07348, 32.56061], [-117.0732, 32.56047], [-117.07246, 32.56004], [-117.07531, 32.56004], [-117.07531, 32.56113]]], [[[-117.08397, 32.55455], [-117.08325, 32.55455], [-117.08325, 32.55408], [-117.08397, 32.55408], [-117.08398, 32.55438], [-117.08397, 32.55455]]], [[[-117.08438, 32.55435], [-117.08437, 32.55447], [-117.08419, 32.55448], [-117.08419, 32.55436], [-117.08438, 32.55435]]], [[[-117.08848, 32.54379], [-117.08838, 32.54365], [-117.08828, 32.54358], [-117.08847, 32.54358], [-117.08848, 32.54379]]]]} | Open Access 1 | Tijuana River Valley Regional Park | http://www.sdparks.org/content/sdparks/en/park-pages/TJRVRP.html | 26363 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 11.184 | Tijuana River Valley 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]);