units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where DES_TP = 2, LABEL_NAME = "Soledad Natural Park" and MNG_AG_TYP = 2
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
5891 | 5891 | 5890 | {"type": "MultiPolygon", "coordinates": [[[[-117.24909, 32.84273], [-117.24346, 32.84383], [-117.2417, 32.84417], [-117.24168, 32.84419], [-117.24111, 32.84343], [-117.24071, 32.84299], [-117.2403, 32.84261], [-117.23966, 32.84208], [-117.23966, 32.84205], [-117.2381, 32.84079], [-117.23779, 32.84051], [-117.23748, 32.84018], [-117.23822, 32.83971], [-117.23771, 32.83835], [-117.23684, 32.83804], [-117.23621, 32.83754], [-117.23602, 32.83699], [-117.23589, 32.8369], [-117.23543, 32.83671], [-117.23422, 32.83276], [-117.23666, 32.83221], [-117.23876, 32.83921], [-117.24705, 32.83739], [-117.24749, 32.83856], [-117.24759, 32.83872], [-117.24689, 32.839], [-117.24688, 32.83901], [-117.24698, 32.8392], [-117.24735, 32.83907], [-117.24751, 32.83926], [-117.24757, 32.83927], [-117.24758, 32.8393], [-117.24763, 32.83933], [-117.24782, 32.83939], [-117.24909, 32.84273]], [[-117.24459, 32.84008], [-117.24471, 32.84008], [-117.24482, 32.84001], [-117.24487, 32.83993], [-117.24488, 32.83988], [-117.24485, 32.83974], [-117.24475, 32.83967], [-117.24464, 32.83963], [-117.24453, 32.83964], [-117.24441, 32.83969], [-117.24438, 32.83977], [-117.24434, 32.83983], [-117.24435, 32.83991], [-117.24442, 32.84002], [-117.24444, 32.84003], [-117.24448, 32.84006], [-117.24457, 32.84009], [-117.24459, 32.84008]]], [[[-117.24132, 32.84425], [-117.24039, 32.84445], [-117.24057, 32.84506], [-117.24069, 32.8454], [-117.24085, 32.846], [-117.24093, 32.84627], [-117.23846, 32.84683], [-117.23688, 32.84184], [-117.23686, 32.84169], [-117.23655, 32.84073], [-117.23719, 32.84036], [-117.23751, 32.84067], [-117.23791, 32.84102], [-117.24019, 32.8429], [-117.24072, 32.84346], [-117.24132, 32.84425]]]]} | Open Access 1 | 319 | Soledad Natural Park | 30269 | 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 | 200.581 | Soledad Natural Park | 0 | Local Park 2 | 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]);