units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
5 rows where AGNCY_NAME = 426, DES_TP = 2 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1802 | 1802 | 1801 | {"type": "Polygon", "coordinates": [[[-121.82899, 38.46389], [-121.82878, 38.46499], [-121.82747, 38.46487], [-121.82794, 38.46385], [-121.82899, 38.46389]]]} | Open Access 1 | 13636 | Conejo Park | 17585 | 1087 | Dixon, City of 426 | City 2 | City Agency 2 | http://www.ci.dixon.ca.us/ | City 2 | 1087 | Dixon, City of 420 | City 2 | City Agency 2 | Solano 26 | 3.064 | Conejo Park | 0 | Local Park 2 | 4 | |
2281 | 2281 | 2280 | {"type": "Polygon", "coordinates": [[[-121.81928, 38.44185], [-121.81875, 38.44186], [-121.81869, 38.44243], [-121.81846, 38.44344], [-121.81846, 38.44367], [-121.81774, 38.44364], [-121.81717, 38.44368], [-121.8171, 38.44411], [-121.81708, 38.44455], [-121.81691, 38.44502], [-121.81678, 38.44554], [-121.81572, 38.44555], [-121.81568, 38.44522], [-121.81578, 38.44515], [-121.81579, 38.44417], [-121.81588, 38.44341], [-121.81585, 38.44264], [-121.81665, 38.44268], [-121.81666, 38.44266], [-121.81622, 38.44179], [-121.81578, 38.4413], [-121.81515, 38.44042], [-121.81434, 38.43974], [-121.81351, 38.43923], [-121.81323, 38.43917], [-121.813, 38.43896], [-121.81291, 38.43867], [-121.8127, 38.43842], [-121.81442, 38.43841], [-121.81657, 38.43841], [-121.81884, 38.4384], [-121.81889, 38.43881], [-121.81891, 38.43944], [-121.81888, 38.44149], [-121.81907, 38.44168], [-121.81928, 38.44175], [-121.81928, 38.44185]]]} | Open Access 1 | 16852 | Hall Memorial Park | 19605 | 1087 | Dixon, City of 426 | City 2 | City Agency 2 | http://www.ci.dixon.ca.us/ | City 2 | 1087 | Dixon, City of 420 | City 2 | City Agency 2 | Solano 26 | 51.954 | Hall Memorial Park | 0 | Local Park 2 | 4 | |
2795 | 2795 | 2794 | {"type": "Polygon", "coordinates": [[[-121.84621, 38.45144], [-121.84632, 38.45163], [-121.84634, 38.4519], [-121.84631, 38.45227], [-121.84622, 38.45247], [-121.84596, 38.45276], [-121.84502, 38.45261], [-121.84451, 38.45267], [-121.84414, 38.4528], [-121.84395, 38.45265], [-121.84375, 38.45206], [-121.84371, 38.45182], [-121.8439, 38.4516], [-121.84483, 38.45168], [-121.84562, 38.45164], [-121.84621, 38.45144]]]} | Open Access 1 | 18574 | Patwin Park | 23524 | 1087 | Dixon, City of 426 | City 2 | City Agency 2 | http://www.ci.dixon.ca.us/ | City 2 | 1087 | Dixon, City of 420 | City 2 | City Agency 2 | Solano 26 | 6.284 | Patwin Park | 0 | Local Park 2 | 4 | |
10354 | 10354 | 10353 | {"type": "Polygon", "coordinates": [[[-121.83571, 38.45365], [-121.83467, 38.45416], [-121.83391, 38.45483], [-121.83365, 38.45523], [-121.83357, 38.4557], [-121.83358, 38.45651], [-121.83258, 38.45648], [-121.83171, 38.4565], [-121.83162, 38.45575], [-121.83163, 38.45445], [-121.83183, 38.45301], [-121.83226, 38.45301], [-121.83325, 38.45297], [-121.83452, 38.45295], [-121.83566, 38.453], [-121.83575, 38.45339], [-121.83571, 38.45365]]]} | Open Access 1 | 18268 | Northwest Park | 22897 | 1087 | Dixon, City of 426 | City 2 | City Agency 2 | http://www.ci.dixon.ca.us/ | City 2 | 1087 | Dixon, City of 420 | City 2 | City Agency 2 | Solano 26 | 22.755 | Northwest Park | 0 | Local Park 2 | 4 | |
12725 | 12725 | 12724 | {"type": "Polygon", "coordinates": [[[-121.82917, 38.43598], [-121.82882, 38.43588], [-121.8285, 38.43583], [-121.82773, 38.43583], [-121.82742, 38.43587], [-121.82735, 38.43569], [-121.82731, 38.43551], [-121.82741, 38.43518], [-121.8276, 38.4347], [-121.82906, 38.4347], [-121.82932, 38.43533], [-121.82936, 38.43557], [-121.82928, 38.43579], [-121.82917, 38.43598]]]} | Open Access 1 | 29750 | Veterens Park | 27061 | 1087 | Dixon, City of 426 | City 2 | City Agency 2 | http://www.ci.dixon.ca.us/ | City 2 | 1087 | Dixon, City of 420 | City 2 | City Agency 2 | Solano 26 | 5.108 | Veterens 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]);