units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where MNG_AG_TYP = 2 and SUID_NMA = 31366
This data as json, copyable, CSV (advanced)
Link | rowid ▼ | id | map | ACCESS_TYP | UNIT_ID | UNIT_NAME | SUID_NMA | AGNCY_ID | AGNCY_NAME | AGNCY_LEV | AGNCY_TYP | AGNCY_WEB | LAYER | MNG_AG_ID | MNG_AGENCY | MNG_AG_LEV | MNG_AG_TYP | PARK_URL | COUNTY | ACRES | LABEL_NAME | YR_EST | DES_TP | GAP_STS |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
16084 | 16084 | 16083 | {"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.13376, 32.78926], [-117.13343, 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.79787], [-117.13324, 32.79787], [-117.13357, 32.79917], [-117.13336, 32.79962], [-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.13146, 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.79817], [-117.1312, 32.79793], [-117.13132, 32.79741], [-117.13133, 32.79725], [-117.13129, 32.79658], [-117.1313, 32.79644], [-117.13128, 32.79601], [-117.13129, 32.79597], [-117.13127, 32.79592], [-117.1313, 32.79556], [-117.13068, 32.79351], [-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.13007, 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.13126, 32.78833], [-117.13052, 32.78854], [-117.1282, 32.78854], [-117.12707, 32.78856], [-117.12421, 32.78853], [-117.12417, 32.78854], [-117.12391, 32.78853], [-117.12188, 32.78854], [-117.1228, 32.79114], [-117.12206, 32.7913], [-117.12114, 32.78995], [-117.12111, 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.79786], [-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.79483], [-117.13647, 32.79494], [-117.13653, 32.7952], [-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 | 47627 | 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 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | San Diego 4 | 138.995 | Ruffin Canyon & Sandrock Canyon OS | 0 | Local Recreation Area 3 | 4 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE units_with_maps( id INT, map, ACCESS_TYP INT, UNIT_ID INT, UNIT_NAME TEXT, SUID_NMA INT, AGNCY_ID INT, AGNCY_NAME INT, AGNCY_LEV INT, AGNCY_TYP INT, AGNCY_WEB TEXT, LAYER INT, MNG_AG_ID INT, MNG_AGENCY INT, MNG_AG_LEV INT, MNG_AG_TYP INT, PARK_URL TEXT, COUNTY INT, ACRES REAL, LABEL_NAME TEXT, YR_EST INT, DES_TP INT, GAP_STS TEXT, FOREIGN KEY([ACCESS_TYP]) REFERENCES [ACCESS_TYP]([id]), FOREIGN KEY([AGNCY_NAME]) REFERENCES [AGNCY_NAME]([id]), FOREIGN KEY([AGNCY_LEV]) REFERENCES [AGNCY_LEV]([id]), FOREIGN KEY([AGNCY_TYP]) REFERENCES [AGNCY_TYP]([id]), FOREIGN KEY([LAYER]) REFERENCES [LAYER]([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([COUNTY]) REFERENCES [COUNTY]([id]), FOREIGN KEY([DES_TP]) REFERENCES [DES_TP]([id]) ); CREATE INDEX [idx_units_with_maps_DES_TP] ON [units_with_maps] ([DES_TP]); CREATE INDEX [idx_units_with_maps_COUNTY] ON [units_with_maps] ([COUNTY]); CREATE INDEX [idx_units_with_maps_MNG_AG_TYP] ON [units_with_maps] ([MNG_AG_TYP]); CREATE INDEX [idx_units_with_maps_MNG_AG_LEV] ON [units_with_maps] ([MNG_AG_LEV]); CREATE INDEX [idx_units_with_maps_MNG_AGENCY] ON [units_with_maps] ([MNG_AGENCY]); CREATE INDEX [idx_units_with_maps_LAYER] ON [units_with_maps] ([LAYER]); CREATE INDEX [idx_units_with_maps_AGNCY_TYP] ON [units_with_maps] ([AGNCY_TYP]); CREATE INDEX [idx_units_with_maps_AGNCY_LEV] ON [units_with_maps] ([AGNCY_LEV]); CREATE INDEX [idx_units_with_maps_AGNCY_NAME] ON [units_with_maps] ([AGNCY_NAME]); CREATE INDEX [idx_units_with_maps_ACCESS_TYP] ON [units_with_maps] ([ACCESS_TYP]);