units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
12 rows where ACCESS_TYP = 1, AGNCY_LEV = 2, AGNCY_TYP = 2, DES_TP = 2, MNG_AGENCY = 352 and MNG_AG_TYP = 2
This data as json, copyable, CSV (advanced)
These facets timed out: MNG_AGENCY, DES_TP
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1373 | 1373 | 1372 | {"type": "Polygon", "coordinates": [[[-122.12277, 37.98731], [-122.12226, 37.98757], [-122.12207, 37.98735], [-122.12185, 37.98743], [-122.12071, 37.98629], [-122.12149, 37.98589], [-122.12277, 37.98731]]]} | Open Access 1 | 12112 | Nancy Boyd Park | 22623 | 1198 | Martinez, City of 355 | City 2 | City Agency 2 | http://www.cityofmartinez.org/depts/recreation/parks/default.asp | City 2 | 1198 | Martinez, City of 352 | City 2 | City Agency 2 | Contra Costa 12 | 3.529 | Nancy Boyd Park | 0 | Local Park 2 | 4 | |
1588 | 1588 | 1587 | {"type": "Polygon", "coordinates": [[[-122.13539, 38.01361], [-122.13479, 38.01396], [-122.1344, 38.01352], [-122.13499, 38.01317], [-122.13539, 38.01361]]]} | Open Access 1 | 12148 | Ygnacio Plaza Martinez Park | 27770 | 1198 | Martinez, City of 355 | City 2 | City Agency 2 | http://www.cityofmartinez.org/depts/recreation/parks/default.asp | City 2 | 1198 | Martinez, City of 352 | City 2 | City Agency 2 | Contra Costa 12 | 0.965 | Ygnacio Plaza Martinez Park | 0 | Local Park 2 | 4 | |
2451 | 2451 | 2450 | {"type": "Polygon", "coordinates": [[[-122.14512, 38.01547], [-122.14511, 38.01555], [-122.14506, 38.01563], [-122.14493, 38.01567], [-122.1447, 38.01566], [-122.14462, 38.01569], [-122.14447, 38.01578], [-122.14423, 38.016], [-122.14414, 38.01615], [-122.14397, 38.01638], [-122.14379, 38.01658], [-122.14259, 38.01583], [-122.14436, 38.01553], [-122.14435, 38.01531], [-122.14439, 38.01527], [-122.14494, 38.01527], [-122.14508, 38.01538], [-122.14512, 38.01547]]]} | Open Access 1 | 12183 | Rankin Park | 24186 | 1198 | Martinez, City of 355 | City 2 | City Agency 2 | http://www.cityofmartinez.org/depts/recreation/parks/default.asp | City 2 | 1198 | Martinez, City of 352 | City 2 | City Agency 2 | Contra Costa 12 | 3.017 | Rankin Park | 0 | Local Park 2 | 4 | |
5150 | 5150 | 5149 | {"type": "Polygon", "coordinates": [[[-122.13398, 38.01445], [-122.13343, 38.01479], [-122.13301, 38.01435], [-122.13357, 38.01402], [-122.13398, 38.01445]]]} | Open Access 1 | 12160 | Susana Park | 26080 | 1198 | Martinez, City of 355 | City 2 | City Agency 2 | http://www.cityofmartinez.org/depts/recreation/parks/default.asp | City 2 | 1198 | Martinez, City of 352 | City 2 | City Agency 2 | Contra Costa 12 | 0.914 | Susana Park | 0 | Local Park 2 | 4 | |
7584 | 7584 | 7583 | {"type": "Polygon", "coordinates": [[[-122.09881, 37.96587], [-122.09858, 37.96595], [-122.09694, 37.96348], [-122.09736, 37.96373], [-122.09774, 37.96377], [-122.09788, 37.96445], [-122.09881, 37.96587]]]} | Open Access 1 | 12171 | Foothills Park | 18983 | 1198 | Martinez, City of 355 | City 2 | City Agency 2 | http://www.cityofmartinez.org/depts/recreation/parks/default.asp | City 2 | 1198 | Martinez, City of 352 | City 2 | City Agency 2 | Contra Costa 12 | 1.866 | Foothills Park | 2000 | Local Park 2 | 4 | |
7767 | 7767 | 7766 | {"type": "Polygon", "coordinates": [[[-122.09667, 37.99585], [-122.09615, 37.99596], [-122.09581, 37.99551], [-122.09495, 37.99462], [-122.09564, 37.9944], [-122.09667, 37.99585]]]} | Open Access 1 | 12124 | Holiday Highlands Park | 20030 | 1198 | Martinez, City of 355 | City 2 | City Agency 2 | http://www.cityofmartinez.org/depts/recreation/parks/default.asp | City 2 | 1198 | Martinez, City of 352 | City 2 | City Agency 2 | Contra Costa 12 | 2.388 | Holiday Highlands Park | 0 | Local Park 2 | 4 | |
8081 | 8081 | 8080 | {"type": "Polygon", "coordinates": [[[-122.12208, 37.99953], [-122.12207, 38.00049], [-122.12143, 38.0005], [-122.12061, 37.99958], [-122.12208, 37.99953]]]} | Open Access 1 | 12100 | John Muir Park | 20458 | 1198 | Martinez, City of 355 | City 2 | City Agency 2 | http://www.cityofmartinez.org/depts/recreation/parks/default.asp | City 2 | 1198 | Martinez, City of 352 | City 2 | City Agency 2 | Contra Costa 12 | 2.42 | John Muir Park | 0 | Local Park 2 | 4 | |
8083 | 8083 | 8082 | {"type": "Polygon", "coordinates": [[[-122.11593, 38.00143], [-122.11599, 38.00166], [-122.11582, 38.0035], [-122.11502, 38.00348], [-122.11518, 38.00271], [-122.11518, 38.00234], [-122.11486, 38.00192], [-122.11442, 38.00148], [-122.11593, 38.00143]]]} | Open Access 1 | 12089 | Mountainview Park | 22564 | 1198 | Martinez, City of 355 | City 2 | City Agency 2 | http://www.cityofmartinez.org/depts/recreation/parks/default.asp | City 2 | 1198 | Martinez, City of 352 | City 2 | City Agency 2 | Contra Costa 12 | 4.521 | Mountainview Park | 0 | Local Park 2 | 4 | |
8100 | 8100 | 8099 | {"type": "Polygon", "coordinates": [[[-122.12743, 38.01388], [-122.12684, 38.01421], [-122.12642, 38.01377], [-122.12703, 38.01344], [-122.12743, 38.01388]]]} | Open Access 1 | 12136 | Cappy Ricks Park | 16841 | 1198 | Martinez, City of 355 | City 2 | City Agency 2 | http://www.cityofmartinez.org/depts/recreation/parks/default.asp | City 2 | 1198 | Martinez, City of 352 | City 2 | City Agency 2 | Contra Costa 12 | 0.968 | Cappy Ricks Park | 0 | Local Park 2 | 4 | |
9288 | 9288 | 9287 | {"type": "Polygon", "coordinates": [[[-122.12948, 38.0189], [-122.12919, 38.01904], [-122.12882, 38.01857], [-122.12913, 38.01843], [-122.12948, 38.0189]]]} | Open Access 1 | 15506 | Highland Avenue Park | 19929 | 1198 | Martinez, City of 355 | City 2 | City Agency 2 | http://www.cityofmartinez.org/depts/recreation/parks/default.asp | City 2 | 1198 | Martinez, City of 352 | City 2 | City Agency 2 | Contra Costa 12 | 0.453 | Highland Avenue Park | 0 | Local Park 2 | 4 | |
9304 | 9304 | 9303 | {"type": "Polygon", "coordinates": [[[-122.10163, 38.00127], [-122.10134, 38.00127], [-122.10128, 38.0012], [-122.10118, 38.00117], [-122.10025, 38.00119], [-122.10021, 38.00118], [-122.10015, 38.00111], [-122.10007, 38.00109], [-122.09999, 38.00111], [-122.09994, 38.00116], [-122.09955, 38.00116], [-122.09954, 38.0007], [-122.10162, 38.00068], [-122.10163, 38.00127]]]} | Open Access 1 | 15508 | Morello Park | 22476 | 1198 | Martinez, City of 355 | City 2 | City Agency 2 | http://www.cityofmartinez.org/depts/recreation/parks/default.asp | City 2 | 1198 | Martinez, City of 352 | City 2 | City Agency 2 | Contra Costa 12 | 2.458 | Morello Park | 0 | Local Park 2 | 4 | |
10155 | 10155 | 10154 | {"type": "Polygon", "coordinates": [[[-122.11132, 37.96097], [-122.11095, 37.96139], [-122.11059, 37.96121], [-122.11025, 37.96163], [-122.11003, 37.96435], [-122.10815, 37.96267], [-122.10729, 37.96263], [-122.10597, 37.96145], [-122.10589, 37.96083], [-122.10616, 37.96082], [-122.1081, 37.96183], [-122.1083, 37.96161], [-122.10843, 37.96151], [-122.10862, 37.96129], [-122.10842, 37.96118], [-122.10915, 37.96066], [-122.10919, 37.96072], [-122.10951, 37.96049], [-122.10973, 37.96048], [-122.11008, 37.9602], [-122.11104, 37.96083], [-122.11132, 37.96097]]]} | Open Access 1 | 17697 | Golden Hills Park | 19364 | 1198 | Martinez, City of 355 | City 2 | City Agency 2 | http://www.cityofmartinez.org/depts/recreation/parks/default.asp | City 2 | 1198 | Martinez, City of 352 | City 2 | City Agency 2 | Contra Costa 12 | 20.421 | Golden Hills 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]);