units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
98 rows where COUNTY = 26, DES_TP = 2 and MNG_AG_TYP = 2
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_ID, YR_EST
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
367 | 367 | 366 | {"type": "Polygon", "coordinates": [[[-121.97916, 38.3386], [-121.97897, 38.3387], [-121.97854, 38.33903], [-121.97832, 38.33915], [-121.9779, 38.33933], [-121.97754, 38.33938], [-121.97698, 38.33931], [-121.97687, 38.33916], [-121.97685, 38.33905], [-121.97684, 38.33888], [-121.97677, 38.33872], [-121.97662, 38.33863], [-121.97638, 38.3386], [-121.97607, 38.33854], [-121.97557, 38.33841], [-121.97526, 38.33838], [-121.97427, 38.33859], [-121.97412, 38.33833], [-121.97479, 38.33815], [-121.97508, 38.3381], [-121.97549, 38.3381], [-121.97579, 38.33815], [-121.9764, 38.33833], [-121.97679, 38.3385], [-121.97683, 38.33855], [-121.97688, 38.33857], [-121.97694, 38.33858], [-121.97702, 38.33855], [-121.97708, 38.33849], [-121.97733, 38.33851], [-121.97744, 38.33855], [-121.97823, 38.33856], [-121.97833, 38.33858], [-121.9785, 38.33859], [-121.9787, 38.33856], [-121.97909, 38.33843], [-121.97916, 38.3386]]]} | Open Access 1 | 1048 | Southwood Park | 25704 | 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 | 5.256 | Southwood Park | 0 | Local Park 2 | 4 | |
400 | 400 | 399 | {"type": "Polygon", "coordinates": [[[-121.93951, 38.36208], [-121.9394, 38.3621], [-121.93921, 38.36218], [-121.93907, 38.36221], [-121.93876, 38.36222], [-121.93861, 38.36224], [-121.93817, 38.36246], [-121.938, 38.36247], [-121.93788, 38.36242], [-121.93768, 38.36205], [-121.93759, 38.36196], [-121.93748, 38.36181], [-121.93743, 38.36171], [-121.93741, 38.36157], [-121.93736, 38.36147], [-121.93732, 38.36111], [-121.93771, 38.36102], [-121.93861, 38.36076], [-121.93867, 38.36075], [-121.93871, 38.36078], [-121.93918, 38.36149], [-121.93951, 38.36208]]]} | Open Access 1 | 1215 | Stonegate Park | 25888 | 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 | 5.702 | Stonegate Park | 0 | Local Park 2 | 4 | |
427 | 427 | 426 | {"type": "Polygon", "coordinates": [[[-121.98272, 38.36571], [-121.98118, 38.36563], [-121.9812, 38.36528], [-121.98124, 38.36513], [-121.98126, 38.36473], [-121.98231, 38.36477], [-121.98241, 38.3648], [-121.98251, 38.36487], [-121.98263, 38.36502], [-121.9827, 38.36517], [-121.98273, 38.36528], [-121.98274, 38.36538], [-121.98272, 38.36571]]]} | Open Access 1 | 1707 | Trower Park | 26551 | 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 | 3.156 | Trower Park | 0 | Local Park 2 | 4 | |
564 | 564 | 563 | {"type": "Polygon", "coordinates": [[[-122.04514, 38.26755], [-122.04396, 38.26758], [-122.04393, 38.26754], [-122.04333, 38.26755], [-122.04331, 38.26645], [-122.04405, 38.26643], [-122.04513, 38.26644], [-122.04514, 38.26755]]]} | Open Access 1 | 1883 | Veteran's Memorial Park | 27011 | 1105 | Fairfield, City of 208 | City 2 | City Agency 2 | http://www.fairfield.ca.gov/gov/depts/pw/parks/default.asp | City 2 | 1105 | Fairfield, City of 204 | City 2 | City Agency 2 | Solano 26 | 4.887 | Veteran's Memorial Park | 0 | Local Park 2 | 4 | |
609 | 609 | 608 | {"type": "Polygon", "coordinates": [[[-121.99599, 38.34541], [-121.996, 38.34585], [-121.99597, 38.34627], [-121.99595, 38.3463], [-121.99545, 38.34591], [-121.99482, 38.34547], [-121.99467, 38.34534], [-121.99471, 38.34529], [-121.99483, 38.34527], [-121.99493, 38.34517], [-121.99495, 38.34513], [-121.99517, 38.345], [-121.99541, 38.34498], [-121.99553, 38.34509], [-121.99599, 38.34541]]]} | Open Access 1 | 2135 | Willows Park | 27595 | 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 | 2.146 | Willows Park | 0 | Local Park 2 | 4 | |
656 | 656 | 655 | {"type": "Polygon", "coordinates": [[[-122.01041, 38.35673], [-122.00892, 38.35725], [-122.00846, 38.35701], [-122.00814, 38.35671], [-122.00769, 38.35685], [-122.0075, 38.35677], [-122.00736, 38.35667], [-122.00728, 38.35618], [-122.00767, 38.35609], [-122.00751, 38.35562], [-122.00947, 38.35527], [-122.01041, 38.35673]]]} | Open Access 1 | 3220 | Alamo Creek Park | 15317 | 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 | 9.429 | Alamo Creek Park | 2000 | Local Park 2 | 4 | |
748 | 748 | 747 | {"type": "Polygon", "coordinates": [[[-122.06423, 38.24698], [-122.06271, 38.24698], [-122.06272, 38.24918], [-122.05835, 38.24917], [-122.0583, 38.24668], [-122.05833, 38.24524], [-122.06423, 38.2453], [-122.06423, 38.24698]]]} | Open Access 1 | 4870 | Alan Witt Park | 15325 | 1105 | Fairfield, City of 208 | City 2 | City Agency 2 | http://www.fairfield.ca.gov/gov/depts/pw/parks/default.asp | City 2 | 1105 | Fairfield, City of 204 | City 2 | City Agency 2 | Solano 26 | 47.468 | Alan Witt Park | 0 | Local Park 2 | 4 | |
1314 | 1314 | 1313 | {"type": "Polygon", "coordinates": [[[-121.95495, 38.3235], [-121.95351, 38.3235], [-121.95349, 38.32364], [-121.9532, 38.32352], [-121.95304, 38.32352], [-121.95289, 38.32347], [-121.95235, 38.32348], [-121.95234, 38.32251], [-121.95241, 38.32246], [-121.95487, 38.32245], [-121.95491, 38.32249], [-121.95492, 38.32321], [-121.95495, 38.3235]]]} | Open Access 1 | 7375 | Cannon Station Park | 16805 | 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 | 6.485 | Cannon Station Park | 0 | Local Park 2 | 4 | |
1328 | 1328 | 1327 | {"type": "Polygon", "coordinates": [[[-122.15732, 38.0806], [-122.1569, 38.08087], [-122.15644, 38.08063], [-122.15466, 38.08044], [-122.15466, 38.08032], [-122.1548, 38.08004], [-122.15494, 38.07957], [-122.15567, 38.07968], [-122.15607, 38.07993], [-122.15624, 38.08012], [-122.15681, 38.08024], [-122.15732, 38.0806]]]} | Open Access 1 | 10834 | Frank Skillman Park | 19054 | 1027 | Benicia, City of 347 | City 2 | City Agency 2 | http://ci.benicia.ca.us/parks | City 2 | 1027 | Benicia, City of 344 | City 2 | City Agency 2 | Solano 26 | 3.944 | Frank Skillman Park | 0 | Local Park 2 | 4 | |
1329 | 1329 | 1328 | {"type": "Polygon", "coordinates": [[[-122.18383, 38.09471], [-122.1838, 38.09489], [-122.18358, 38.09508], [-122.18317, 38.09495], [-122.18237, 38.09491], [-122.18239, 38.09454], [-122.18298, 38.09452], [-122.18335, 38.09437], [-122.18383, 38.09471]]]} | Open Access 1 | 10843 | Channing Circle Park | 17124 | 1027 | Benicia, City of 347 | City 2 | City Agency 2 | http://ci.benicia.ca.us/parks | City 2 | 1027 | Benicia, City of 344 | City 2 | City Agency 2 | Solano 26 | 1.577 | Channing Circle Park | 0 | Local Park 2 | 4 | |
1334 | 1334 | 1333 | {"type": "Polygon", "coordinates": [[[-122.15933, 38.07512], [-122.15933, 38.07532], [-122.15829, 38.07543], [-122.15682, 38.07548], [-122.15563, 38.0758], [-122.15542, 38.07564], [-122.15525, 38.07575], [-122.15507, 38.07565], [-122.15491, 38.07575], [-122.15472, 38.07575], [-122.15485, 38.07472], [-122.15508, 38.07477], [-122.15591, 38.07472], [-122.15688, 38.07449], [-122.15786, 38.07409], [-122.15809, 38.07452], [-122.15852, 38.07478], [-122.15916, 38.07489], [-122.15933, 38.07512]]]} | Open Access 1 | 10860 | Southhampton Park | 25691 | 1027 | Benicia, City of 347 | City 2 | City Agency 2 | http://ci.benicia.ca.us/parks | City 2 | 1027 | Benicia, City of 344 | City 2 | City Agency 2 | Solano 26 | 10.134 | Southhampton Park | 0 | Local Park 2 | 4 | |
1335 | 1335 | 1334 | {"type": "Polygon", "coordinates": [[[-122.16896, 38.0589], [-122.16836, 38.05972], [-122.16685, 38.05884], [-122.16731, 38.05817], [-122.16896, 38.0589]]]} | Open Access 1 | 10872 | Willow Glen Park | 27578 | 1027 | Benicia, City of 347 | City 2 | City Agency 2 | http://ci.benicia.ca.us/parks | City 2 | 1027 | Benicia, City of 344 | City 2 | City Agency 2 | Solano 26 | 3.875 | Willow Glen Park | 0 | Local Park 2 | 4 | |
1445 | 1445 | 1444 | {"type": "MultiPolygon", "coordinates": [[[[-121.96952, 38.368], [-121.96865, 38.36697], [-121.96865, 38.36697], [-121.96936, 38.36672], [-121.96952, 38.36784], [-121.96952, 38.368]]], [[[-121.97601, 38.37279], [-121.97442, 38.37692], [-121.97337, 38.37952], [-121.97228, 38.38237], [-121.97079, 38.38635], [-121.96709, 38.38651], [-121.96528, 38.38665], [-121.96512, 38.38613], [-121.96489, 38.38546], [-121.96482, 38.38545], [-121.96457, 38.38384], [-121.96459, 38.38369], [-121.96442, 38.38233], [-121.96462, 38.38185], [-121.96554, 38.38052], [-121.96572, 38.38021], [-121.96574, 38.38021], [-121.96579, 38.38014], [-121.96578, 38.38012], [-121.96631, 38.3794], [-121.96673, 38.37888], [-121.96773, 38.37756], [-121.96778, 38.37744], [-121.96781, 38.37706], [-121.96776, 38.3766], [-121.96784, 38.37624], [-121.96789, 38.37461], [-121.96788, 38.37444], [-121.9679, 38.37261], [-121.96792, 38.37188], [-121.96794, 38.3716], [-121.9681, 38.36995], [-121.96855, 38.36817], [-121.96846, 38.36803], [-121.96818, 38.36764], [-121.96796, 38.36765], [-121.96759, 38.36733], [-121.96833, 38.36707], [-121.96974, 38.36866], [-121.97015, 38.36908], [-121.9703, 38.36922], [-121.9706, 38.36942], [-121.97061, 38.36955], [-121.97019, 38.36997], [-121.96982, 38.3703], [-121.96968, 38.37047], [-121.96961, 38.37061], [-121.96957, 38.3708], [-121.96956, 38.37095], [-121.96958, 38.37108], [-121.96972, 38.37102], [-121.96974, 38.37084], [-121.9698, 38.37071], [-121.96986, 38.37062], [-121.97002, 38.37046], [-121.97081, 38.36971], [-121.97084, 38.36969], [-121.97098, 38.36968], [-121.97138, 38.36993], [-121.97098, 38.37041], [-121.97098, 38.37043], [-121.97166, 38.37012], [-121.97189, 38.36999], [-121.97317, 38.3709], [-121.976, 38.37276], [-121.97601, 38.37279]]]]} | Open Access 1 | 9627 | Centennial Park | 14382 | 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 | http://www.cityofvacaville.com/index.aspx?page=128 | Solano 26 | 283.173 | Centennial Park | 0 | Local Park 2 | 4 |
1529 | 1529 | 1528 | {"type": "Polygon", "coordinates": [[[-122.14522, 38.04964], [-122.14497, 38.04998], [-122.14428, 38.04965], [-122.14451, 38.04933], [-122.14522, 38.04964]]]} | Open Access 1 | 10896 | Ethelree Saraiva Park | 18733 | 1027 | Benicia, City of 347 | City 2 | City Agency 2 | http://ci.benicia.ca.us/parks | City 2 | 1027 | Benicia, City of 344 | City 2 | City Agency 2 | Solano 26 | 0.741 | Ethelree Saraiva Park | 0 | Local Park 2 | 4 | |
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 | |
1927 | 1927 | 1926 | {"type": "Polygon", "coordinates": [[[-121.70403, 38.16057], [-121.70376, 38.16078], [-121.70282, 38.16005], [-121.70309, 38.15983], [-121.70403, 38.16057]]]} | Open Access 1 | 14902 | Drouin Park | 18275 | 1276 | Rio Vista, City of 327 | City 2 | City Agency 2 | http://riovistacity.com/parks-dept/ | City 2 | 1276 | Rio Vista, City of 324 | City 2 | City Agency 2 | Solano 26 | 0.955 | Drouin Park | 0 | Local Park 2 | 4 | |
1929 | 1929 | 1928 | {"type": "Polygon", "coordinates": [[[-121.69786, 38.16039], [-121.69725, 38.16089], [-121.69655, 38.1603], [-121.69714, 38.15978], [-121.69786, 38.16039]]]} | Open Access 1 | 14908 | Brunavista Park | 16450 | 1276 | Rio Vista, City of 327 | City 2 | City Agency 2 | http://riovistacity.com/parks-dept/ | City 2 | 1276 | Rio Vista, City of 324 | City 2 | City Agency 2 | Solano 26 | 1.736 | Brunavista 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 | |
2289 | 2289 | 2288 | {"type": "MultiPolygon", "coordinates": [[[[-122.00451, 38.37315], [-122.00451, 38.37447], [-122.00217, 38.37446], [-122.00312, 38.3734], [-122.00328, 38.37315], [-122.00451, 38.37315]]], [[[-122.00452, 38.37195], [-122.00451, 38.37304], [-122.0034, 38.37304], [-122.00392, 38.37241], [-122.00432, 38.37195], [-122.00452, 38.37195]]]]} | Open Access 1 | 18241 | North Orchard Park | 22837 | 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 | 7.264 | North Orchard Park | 0 | Local Park 2 | 4 | |
2312 | 2312 | 2311 | {"type": "Polygon", "coordinates": [[[-122.04197, 38.27757], [-122.0416, 38.27758], [-122.04147, 38.27761], [-122.04132, 38.27769], [-122.04097, 38.27776], [-122.04013, 38.27786], [-122.04013, 38.27648], [-122.04191, 38.27649], [-122.04197, 38.27653], [-122.04197, 38.27757]]]} | Open Access 1 | 16959 | Hillview Park | 19993 | 1105 | Fairfield, City of 208 | City 2 | City Agency 2 | http://www.fairfield.ca.gov/gov/depts/pw/parks/default.asp | City 2 | 1105 | Fairfield, City of 204 | City 2 | City Agency 2 | Solano 26 | 5.466 | Hillview 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]);