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 = "Ruffin Canyon & Sandrock Canyon Open Space"
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
15010 | 15010 | 15009 | {"type": "MultiPolygon", "coordinates": [[[[-117.12172, 32.79137], [-117.12078, 32.79161], [-117.11958, 32.78813], [-117.11772, 32.78812], [-117.11773, 32.78729], [-117.11839, 32.78733], [-117.11896, 32.78716], [-117.11922, 32.78718], [-117.11962, 32.78714], [-117.11964, 32.78719], [-117.11985, 32.78717], [-117.11999, 32.78718], [-117.12012, 32.78727], [-117.12015, 32.78732], [-117.12031, 32.78812], [-117.1204, 32.7886], [-117.12042, 32.7889], [-117.12046, 32.78914], [-117.12064, 32.78967], [-117.12085, 32.79008], [-117.12172, 32.79137]]], [[[-117.13537, 32.78805], [-117.13534, 32.78922], [-117.13405, 32.78921], [-117.13377, 32.78926], [-117.13344, 32.78971], [-117.1337, 32.79015], [-117.13347, 32.79179], [-117.13345, 32.79195], [-117.13284, 32.79209], [-117.13263, 32.79229], [-117.13252, 32.79254], [-117.13241, 32.79331], [-117.13276, 32.79548], [-117.13284, 32.79786], [-117.13324, 32.79787], [-117.13357, 32.79917], [-117.13336, 32.79963], [-117.13355, 32.79999], [-117.13396, 32.80102], [-117.13392, 32.80168], [-117.13389, 32.80186], [-117.13387, 32.80235], [-117.13294, 32.80231], [-117.13291, 32.80078], [-117.13145, 32.79942], [-117.13084, 32.79941], [-117.12927, 32.80136], [-117.12906, 32.80135], [-117.12874, 32.80115], [-117.13111, 32.7982], [-117.13117, 32.79816], [-117.1312, 32.79793], [-117.13132, 32.79741], [-117.13133, 32.79725], [-117.13129, 32.79658], [-117.1313, 32.79644], [-117.13128, 32.79602], [-117.13129, 32.79597], [-117.13127, 32.79592], [-117.1313, 32.79556], [-117.13068, 32.79352], [-117.12632, 32.79444], [-117.12619, 32.79394], [-117.12665, 32.79383], [-117.12658, 32.79356], [-117.12966, 32.79286], [-117.13004, 32.79275], [-117.13022, 32.79272], [-117.13098, 32.79254], [-117.13067, 32.7916], [-117.13008, 32.79132], [-117.12862, 32.79166], [-117.12835, 32.79143], [-117.12977, 32.79012], [-117.13026, 32.79012], [-117.13028, 32.7907], [-117.13126, 32.7907], [-117.13127, 32.79005], [-117.13125, 32.78833], [-117.13052, 32.78854], [-117.1282, 32.78854], [-117.12707, 32.78856], [-117.12422, 32.78853], [-117.12417, 32.78854], [-117.12391, 32.78853], [-117.12189, 32.78854], [-117.1228, 32.79114], [-117.12206, 32.7913], [-117.12114, 32.78995], [-117.1211, 32.78986], [-117.12101, 32.78972], [-117.12096, 32.7896], [-117.12087, 32.78937], [-117.1208, 32.7891], [-117.12074, 32.78879], [-117.12073, 32.78858], [-117.12064, 32.78811], [-117.12502, 32.78806], [-117.13029, 32.78807], [-117.13537, 32.78805]]], [[[-117.13396, 32.80261], [-117.13392, 32.80324], [-117.13295, 32.80265], [-117.13295, 32.80255], [-117.13396, 32.80261]]], [[[-117.1376, 32.79888], [-117.13732, 32.79913], [-117.13719, 32.79922], [-117.13702, 32.79787], [-117.13673, 32.79786], [-117.13671, 32.79773], [-117.13668, 32.79767], [-117.13658, 32.79726], [-117.13645, 32.79695], [-117.13622, 32.7965], [-117.13621, 32.79642], [-117.13564, 32.79518], [-117.13549, 32.79472], [-117.13536, 32.79406], [-117.13535, 32.79368], [-117.13663, 32.79365], [-117.13646, 32.79444], [-117.13642, 32.79471], [-117.13646, 32.79482], [-117.13647, 32.79494], [-117.13653, 32.79519], [-117.13737, 32.79518], [-117.13739, 32.7962], [-117.13737, 32.79637], [-117.1374, 32.79707], [-117.13739, 32.79786], [-117.13743, 32.79793], [-117.13747, 32.79812], [-117.13761, 32.79842], [-117.1376, 32.79888]]]]} | Open Access 1 | Ruffin Canyon & Sandrock Canyon Open Space | 31366 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 139.146 | Ruffin Canyon & Sandrock Canyon 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]);