superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where LABEL_NAME = "Scripps Ranch Community Park" 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
12826 | 12826 | 12825 | {"type": "Polygon", "coordinates": [[[-117.08183, 32.92904], [-117.08101, 32.92998], [-117.07835, 32.9286], [-117.07852, 32.92835], [-117.0786, 32.92816], [-117.07865, 32.92791], [-117.07866, 32.92775], [-117.07864, 32.92757], [-117.0786, 32.9274], [-117.07854, 32.92726], [-117.07841, 32.92703], [-117.07822, 32.9268], [-117.07837, 32.92651], [-117.07853, 32.92604], [-117.07856, 32.92561], [-117.07849, 32.92537], [-117.07847, 32.92513], [-117.07901, 32.92516], [-117.07959, 32.92496], [-117.07972, 32.92508], [-117.07953, 32.9257], [-117.0796, 32.92668], [-117.07969, 32.92691], [-117.08006, 32.92685], [-117.08039, 32.92696], [-117.08071, 32.92682], [-117.08105, 32.92697], [-117.08112, 32.9271], [-117.08097, 32.92726], [-117.081, 32.92757], [-117.08095, 32.92792], [-117.08099, 32.92811], [-117.08114, 32.92837], [-117.081, 32.92848], [-117.08143, 32.92883], [-117.08183, 32.92904]]]} | Open Access 1 | Scripps Ranch Community Park | 30042 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 22.273 | Scripps Ranch Community 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]);