units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
15 rows where ACCESS_TYP = 1, AGNCY_TYP = 2 and MNG_AGENCY = 352
This data as json, copyable, CSV (advanced)
These facets timed out: MNG_AGENCY, MNG_AG_TYP
DES_TP 4
- Local Park 12
- None 1
- None 1
- None 1
ACCESS_TYP 1
- Open Access · 15 ✖
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 | |
3183 | 3183 | 3182 | {"type": "Polygon", "coordinates": [[[-122.0963, 37.97913], [-122.09614, 37.97963], [-122.09566, 37.98021], [-122.09518, 37.98045], [-122.0948, 37.98043], [-122.0946, 37.98108], [-122.0905, 37.98118], [-122.09049, 37.98152], [-122.08816, 37.98141], [-122.08816, 37.98202], [-122.08767, 37.98199], [-122.08731, 37.98187], [-122.08679, 37.98167], [-122.08651, 37.98181], [-122.08673, 37.98211], [-122.0868, 37.98215], [-122.08694, 37.98215], [-122.08737, 37.98228], [-122.0874, 37.98236], [-122.08737, 37.98244], [-122.08732, 37.98247], [-122.08706, 37.98251], [-122.08697, 37.98254], [-122.08695, 37.98257], [-122.08681, 37.98293], [-122.08653, 37.98293], [-122.08653, 37.98259], [-122.08646, 37.98239], [-122.0863, 37.98221], [-122.08604, 37.9821], [-122.08581, 37.98205], [-122.08557, 37.98204], [-122.08534, 37.98204], [-122.08512, 37.98207], [-122.08489, 37.98215], [-122.08467, 37.98225], [-122.08451, 37.98242], [-122.0844, 37.98276], [-122.08432, 37.98275], [-122.08444, 37.98237], [-122.08415, 37.98216], [-122.08376, 37.98213], [-122.08354, 37.98215], [-122.08339, 37.98208], [-122.08319, 37.98203], [-122.083, 37.98201], [-122.08278, 37.98207], [-122.08261, 37.98218], [-122.0824, 37.98214], [-122.08197, 37.98202], [-122.08171, 37.98199], [-122.08124, 37.98197], [-122.08104, 37.98199], [-122.08097, 37.98225], [-122.08066, 37.98217], [-122.08098, 37.98191], [-122.08063, 37.98179], [-122.08074, 37.98174], [-122.08086, 37.98167], [-122.08087, 37.98179], [-122.08128, 37.98173], [-122.08142, 37.98148], [-122.08342, 37.98116], [-122.08382, 37.98037], [-122.0836, 37.97999], [-122.08338, 37.97999], [-122.08331, 37.97983], [-122.08316, 37.97968], [-122.08307, 37.97967], [-122.08296, 37.9795], [-122.08316, 37.97942], [-122.08342, 37.97937], [-122.08343, 37.97968], [-122.08372, 37.97969], [-122.08418, 37.97979], [-122.08429, 37.97952], [-122.08436, 37.97948], [-122.0844, 37.97942], [-122.08452, 37.97942], [-122.08488, 37.97899], [-122.08563, 37.97834], [-122.08609, 37.97818], [-122.08649, 37.9778], [-122.08666, 37.97743], [-122.0864, 37.97649], [-122.08637, 37.97646], [-122.08669, 37.97636], [-122.08731, 37.97632], [-122.08774, 37.97634], [-122.08795, 37.97638], [-122.08835, 37.97651], [-122.08915, 37.97685], [-122.09, 37.97711], [-122.09027, 37.97721], [-122.09052, 37.97737], [-122.09102, 37.97782], [-122.09125, 37.97798], [-122.09151, 37.9781], [-122.09258, 37.9785], [-122.09283, 37.97862], [-122.09304, 37.97879], [-122.09316, 37.97892], [-122.09315, 37.97894], [-122.09361, 37.97951], [-122.0938, 37.97967], [-122.09403, 37.97979], [-122.09416, 37.97984], [-122.09443, 37.9799], [-122.09471, 37.97991], [-122.09485, 37.9799], [-122.09512, 37.97985], [-122.09536, 37.97975], [-122.09558, 37.97961], [-122.09578, 37.97942], [-122.0961, 37.97902], [-122.0963, 37.97913]]]} | Open Access 1 | 22084 | Martinez | 21924 | 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 | 103.419 | Martinez | None 261 | |||
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 | |
9360 | 9360 | 9359 | {"type": "Polygon", "coordinates": [[[-122.1396, 38.02559], [-122.13934, 38.02631], [-122.13935, 38.02633], [-122.13908, 38.02615], [-122.13905, 38.02617], [-122.13895, 38.02599], [-122.13878, 38.0258], [-122.13858, 38.02567], [-122.13852, 38.0256], [-122.1383, 38.02561], [-122.13809, 38.02495], [-122.1378, 38.02421], [-122.13809, 38.02428], [-122.13811, 38.02427], [-122.13789, 38.02383], [-122.13894, 38.02423], [-122.1396, 38.02559]]]} | Open Access 1 | 15636 | Ferry Point | 18888 | 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 | 5.378 | Ferry Point | None 769 | |||
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 | |
10161 | 10161 | 10160 | {"type": "MultiPolygon", "coordinates": [[[[-122.09343, 37.98365], [-122.0921, 37.98368], [-122.09139, 37.98361], [-122.09023, 37.98362], [-122.09022, 37.98333], [-122.09048, 37.98332], [-122.09049, 37.98118], [-122.09313, 37.98112], [-122.09294, 37.98127], [-122.09324, 37.98157], [-122.09322, 37.98165], [-122.09284, 37.98166], [-122.09284, 37.98182], [-122.09331, 37.98251], [-122.09302, 37.98279], [-122.09342, 37.98335], [-122.09343, 37.98365]]], [[[-122.09664, 37.98105], [-122.09646, 37.98134], [-122.09628, 37.98136], [-122.09607, 37.98172], [-122.09607, 37.98173], [-122.09639, 37.98177], [-122.09639, 37.98188], [-122.09558, 37.9819], [-122.09557, 37.98179], [-122.09509, 37.98161], [-122.09504, 37.98167], [-122.09474, 37.98156], [-122.09468, 37.98163], [-122.09466, 37.98108], [-122.09653, 37.98102], [-122.09657, 37.981], [-122.09661, 37.98104], [-122.09664, 37.98105]]]]} | Open Access 1 | 17718 | Martinez | 21924 | 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 | 19.086 | Martinez | None 884 |
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]);