superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where ACCESS_TYP = 1 and ACRES = "32.888"
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
14918 | 14918 | 14917 | {"type": "MultiPolygon", "coordinates": [[[[-117.05024, 32.6962], [-117.04979, 32.69679], [-117.04629, 32.69776], [-117.04593, 32.69748], [-117.04452, 32.69764], [-117.04427, 32.69769], [-117.04312, 32.69819], [-117.04232, 32.69844], [-117.04218, 32.69857], [-117.04153, 32.69885], [-117.04148, 32.69881], [-117.04142, 32.69878], [-117.04132, 32.69877], [-117.04119, 32.6988], [-117.04073, 32.69884], [-117.04065, 32.6983], [-117.04033, 32.69832], [-117.03994, 32.69836], [-117.03974, 32.69847], [-117.03959, 32.6986], [-117.03943, 32.69862], [-117.03925, 32.69859], [-117.03908, 32.69862], [-117.03856, 32.69891], [-117.0383, 32.69911], [-117.03807, 32.69933], [-117.03794, 32.69942], [-117.0378, 32.69948], [-117.03763, 32.69952], [-117.03722, 32.69952], [-117.03713, 32.69972], [-117.03701, 32.69971], [-117.03686, 32.69966], [-117.03652, 32.69979], [-117.03644, 32.69973], [-117.03623, 32.69973], [-117.03555, 32.69999], [-117.0352, 32.69927], [-117.03647, 32.69886], [-117.03704, 32.69855], [-117.0379, 32.69841], [-117.03891, 32.6977], [-117.03925, 32.69783], [-117.03946, 32.69784], [-117.03963, 32.69771], [-117.03975, 32.69765], [-117.04108, 32.69747], [-117.04152, 32.6976], [-117.04162, 32.69777], [-117.04177, 32.69783], [-117.04205, 32.69788], [-117.04229, 32.69788], [-117.04252, 32.69774], [-117.04331, 32.69752], [-117.04368, 32.69728], [-117.044, 32.69722], [-117.04494, 32.69701], [-117.04517, 32.69708], [-117.04556, 32.69704], [-117.04638, 32.69691], [-117.04659, 32.69652], [-117.0474, 32.69629], [-117.04804, 32.6965], [-117.04852, 32.69637], [-117.04858, 32.69604], [-117.04907, 32.6959], [-117.0492, 32.69621], [-117.04966, 32.6961], [-117.04977, 32.69577], [-117.04999, 32.696], [-117.05024, 32.6962]]], [[[-117.0369, 32.69752], [-117.0368, 32.6977], [-117.03668, 32.69801], [-117.03636, 32.69777], [-117.03643, 32.69762], [-117.0364, 32.69745], [-117.03659, 32.69739], [-117.03636, 32.69677], [-117.03685, 32.69699], [-117.03673, 32.69709], [-117.03675, 32.69728], [-117.03686, 32.69749], [-117.0369, 32.69752]]]]} | Open Access 1 | Paradise Canyon Park and Open Space | 23400 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 32.888 | Paradise Canyon Park and OS |
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]);