units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where COUNTY = 26 and UNIT_NAME = "Three Oaks Park"
This data as json, copyable, CSV (advanced)
MNG_AG_TYP 1
MNG_AGENCY 1
DES_TP 1
ACCESS_TYP 1
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
11338 | 11338 | 11337 | {"type": "Polygon", "coordinates": [[[-121.99693, 38.3399], [-121.99577, 38.34086], [-121.99406, 38.34217], [-121.99346, 38.34176], [-121.99261, 38.34113], [-121.99289, 38.34091], [-121.9936, 38.3404], [-121.99383, 38.34032], [-121.99401, 38.34023], [-121.99425, 38.34004], [-121.99457, 38.33986], [-121.99499, 38.33954], [-121.99492, 38.33946], [-121.99477, 38.33904], [-121.99459, 38.33877], [-121.9945, 38.33855], [-121.99436, 38.33852], [-121.99429, 38.33846], [-121.99407, 38.33836], [-121.99396, 38.33824], [-121.99389, 38.33811], [-121.99381, 38.33811], [-121.99363, 38.3383], [-121.99361, 38.33829], [-121.99375, 38.33808], [-121.99376, 38.33797], [-121.99371, 38.33792], [-121.99365, 38.3379], [-121.99355, 38.33789], [-121.99342, 38.33792], [-121.99329, 38.338], [-121.99322, 38.33809], [-121.99288, 38.33819], [-121.99283, 38.33818], [-121.99272, 38.33815], [-121.99281, 38.33792], [-121.99275, 38.33787], [-121.99273, 38.33779], [-121.99252, 38.3377], [-121.99249, 38.33765], [-121.99242, 38.33765], [-121.99233, 38.33762], [-121.9921, 38.33758], [-121.99175, 38.33757], [-121.99145, 38.33732], [-121.99115, 38.33701], [-121.99102, 38.33696], [-121.99087, 38.33699], [-121.99045, 38.33689], [-121.99029, 38.33667], [-121.99014, 38.33642], [-121.98992, 38.33612], [-121.98972, 38.33599], [-121.98959, 38.33599], [-121.98952, 38.33606], [-121.98949, 38.33606], [-121.98944, 38.33611], [-121.98929, 38.33619], [-121.98913, 38.33634], [-121.98898, 38.33642], [-121.98865, 38.33666], [-121.98856, 38.33665], [-121.98848, 38.33669], [-121.98835, 38.33666], [-121.98821, 38.3366], [-121.98803, 38.33659], [-121.98791, 38.33656], [-121.9876, 38.33663], [-121.98727, 38.33662], [-121.98696, 38.33652], [-121.98662, 38.33648], [-121.98631, 38.33624], [-121.98634, 38.33622], [-121.98666, 38.33619], [-121.98688, 38.33625], [-121.98709, 38.33627], [-121.98734, 38.33627], [-121.98749, 38.3363], [-121.98765, 38.33625], [-121.98788, 38.33623], [-121.98806, 38.33626], [-121.98832, 38.33627], [-121.98852, 38.33631], [-121.98854, 38.3363], [-121.98866, 38.33628], [-121.98885, 38.33615], [-121.98898, 38.33602], [-121.98898, 38.3359], [-121.9891, 38.33585], [-121.98922, 38.33573], [-121.9893, 38.33566], [-121.98937, 38.33552], [-121.98963, 38.33556], [-121.9898, 38.33561], [-121.98998, 38.33581], [-121.99017, 38.33599], [-121.99055, 38.3364], [-121.99083, 38.33656], [-121.99099, 38.33658], [-121.99116, 38.33642], [-121.99122, 38.33646], [-121.99129, 38.33654], [-121.99152, 38.33687], [-121.99164, 38.337], [-121.99179, 38.33708], [-121.99207, 38.33717], [-121.99253, 38.33722], [-121.99297, 38.33733], [-121.99303, 38.33736], [-121.99304, 38.3375], [-121.99311, 38.33754], [-121.99322, 38.33755], [-121.9933, 38.33754], [-121.99337, 38.33745], [-121.99396, 38.33745], [-121.99402, 38.33744], [-121.99425, 38.33761], [-121.99458, 38.33796], [-121.99484, 38.33826], [-121.99491, 38.33827], [-121.99505, 38.33845], [-121.99558, 38.33901], [-121.99585, 38.33923], [-121.9961, 38.33939], [-121.9967, 38.33973], [-121.99693, 38.3399]]]} | Open Access 1 | 22104 | Three Oaks Park | 26333 | 1364 | Vacaville, City of 151 | City 2 | City Agency 2 | http://www.cityofvacaville.com/index.aspx?page=374 | City 2 | 1364 | Vacaville, City of 147 | City 2 | City Agency 2 | Solano 26 | 25.071 | Three Oaks 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]);