superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where MNG_AG_LEV = 3 and PARK_URL = "http://santaanarivertrail.org/home.html" sorted by map
This data as json, copyable, CSV (advanced)
MNG_AG_TYP 1
MNG_AGENCY 1
ACCESS_TYP 1
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
823 | 823 | 822 | {"type": "Polygon", "coordinates": [[[-117.43583, 33.96849], [-117.43536, 33.96974], [-117.43501, 33.97033], [-117.43446, 33.97086], [-117.43442, 33.97085], [-117.43427, 33.971], [-117.43171, 33.97096], [-117.43118, 33.97227], [-117.433, 33.97287], [-117.43293, 33.9733], [-117.43265, 33.97349], [-117.43197, 33.97466], [-117.43188, 33.97477], [-117.43138, 33.97492], [-117.43111, 33.97531], [-117.43102, 33.97528], [-117.43086, 33.97546], [-117.4307, 33.9756], [-117.43, 33.97602], [-117.4298, 33.9762], [-117.42956, 33.97649], [-117.42946, 33.97658], [-117.42929, 33.97668], [-117.42923, 33.97697], [-117.429, 33.97716], [-117.42792, 33.97905], [-117.42513, 33.97828], [-117.42577, 33.97715], [-117.42648, 33.97737], [-117.42771, 33.97462], [-117.42799, 33.97381], [-117.42718, 33.97361], [-117.42691, 33.97415], [-117.42673, 33.97411], [-117.42663, 33.97435], [-117.42677, 33.97442], [-117.42548, 33.97708], [-117.42489, 33.97821], [-117.42302, 33.97769], [-117.42279, 33.9779], [-117.4225, 33.9787], [-117.4225, 33.97903], [-117.4218, 33.98023], [-117.42087, 33.97983], [-117.4201, 33.97938], [-117.41876, 33.97847], [-117.42046, 33.97761], [-117.42057, 33.97678], [-117.41981, 33.97625], [-117.41726, 33.97756], [-117.41297, 33.97467], [-117.41574, 33.97359], [-117.41586, 33.97327], [-117.41563, 33.97311], [-117.41662, 33.96931], [-117.41524, 33.96978], [-117.41515, 33.97005], [-117.41285, 33.97113], [-117.41121, 33.96974], [-117.41245, 33.96917], [-117.41288, 33.96841], [-117.41392, 33.96765], [-117.41477, 33.96672], [-117.41487, 33.96652], [-117.4155, 33.96578], [-117.41588, 33.96605], [-117.41621, 33.96583], [-117.41621, 33.96581], [-117.4157, 33.96541], [-117.41653, 33.96498], [-117.41659, 33.96504], [-117.41774, 33.96484], [-117.42157, 33.96549], [-117.42287, 33.96409], [-117.42349, 33.96386], [-117.42531, 33.96378], [-117.42585, 33.96357], [-117.42679, 33.96353], [-117.42722, 33.96266], [-117.42797, 33.9627], [-117.42798, 33.96274], [-117.42896, 33.96279], [-117.43583, 33.96849]]]} | Open Access 1 | Martha McLean Anza Narrows Park | http://santaanarivertrail.org/home.html | 9503 | 315 | Riverside, County of 165 | County 3 | County Agency 3 | http://www.rivcoparks.org/ | County 3 | 615.589 | Martha McLean Anza Narrows 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]);