units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
461 rows where ACCESS_TYP = 1, COUNTY = 17 and DES_TP = 2
This data as json, copyable, CSV (advanced)
These facets timed out: DES_TP
MNG_AGENCY 16
- Oakland, City of 99
- Hayward Area Recreation and Park District 70
- Fremont, City of 44
- Berkeley, City of 43
- Pleasanton, City of 36
- Union City, City of 32
- Alameda, City of 25
- East Bay Regional Park District 23
- Livermore, City of 23
- Dublin, City of 16
- San Leandro, City of 16
- Newark, City of 11
- Livermore Area Recreation and Park District 7
- Emeryville, City of 7
- Albany, City of 5
- Piedmont, City of 4
MNG_AG_TYP 2
- City Agency 361
- Recreation/Parks District 100
ACCESS_TYP 1
- Open Access · 461 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
64 | 64 | 63 | {"type": "Polygon", "coordinates": [[[-121.91483, 37.63509], [-121.91478, 37.64364], [-121.9097, 37.64611], [-121.90561, 37.63248], [-121.90568, 37.63243], [-121.91279, 37.63249], [-121.9128, 37.63255], [-121.91326, 37.63289], [-121.91409, 37.63322], [-121.91427, 37.63348], [-121.91481, 37.63393], [-121.91472, 37.63444], [-121.91458, 37.63451], [-121.91479, 37.63476], [-121.9147, 37.63482], [-121.91478, 37.63509], [-121.91483, 37.63509]]]} | Open Access 1 | 185 | Augustin Bernal Park | 8732 | 1257 | Pleasanton, City of 32 | City 2 | City Agency 2 | http://www.cityofpleasantonca.gov/ | City 2 | 1257 | Pleasanton, City of 31 | City 2 | City Agency 2 | http://www.cityofpleasantonca.gov/services/recreation/rec-augustinpark.html | Alameda 17 | 217.388 | Augustin Bernal Park | 0 | Local Park 2 | 4 |
146 | 146 | 145 | {"type": "Polygon", "coordinates": [[[-122.24241, 37.79003], [-122.24099, 37.79152], [-122.23911, 37.7904], [-122.24053, 37.78891], [-122.24241, 37.79003]]]} | Open Access 1 | 366 | San Antonio Park | 24832 | 1228 | Oakland, City of 58 | City 2 | City Agency 2 | http://www2.oaklandnet.com/Government/o/opr/index.htm | City 2 | 1228 | Oakland, City of 56 | City 2 | City Agency 2 | Alameda 17 | 10.619 | San Antonio Park | 0 | Local Park 2 | 4 | |
394 | 394 | 393 | {"type": "Polygon", "coordinates": [[[-121.90274, 37.6751], [-121.89877, 37.67675], [-121.89728, 37.6759], [-121.89877, 37.67439], [-121.89993, 37.67487], [-121.90048, 37.67498], [-121.90108, 37.67494], [-121.90163, 37.67477], [-121.90224, 37.67434], [-121.90254, 37.67469], [-121.90274, 37.6751]]]} | Open Access 1 | 1438 | Tennis & Community Park | 26243 | 1257 | Pleasanton, City of 32 | City 2 | City Agency 2 | http://www.cityofpleasantonca.gov/ | City 2 | 1257 | Pleasanton, City of 31 | City 2 | City Agency 2 | Alameda 17 | 15.595 | Tennis & Community Park | 0 | Local Park 2 | 4 | |
409 | 409 | 408 | {"type": "Polygon", "coordinates": [[[-121.84613, 37.71921], [-121.8461, 37.71922], [-121.84608, 37.71928], [-121.84603, 37.71931], [-121.84534, 37.71946], [-121.84486, 37.71953], [-121.84439, 37.71957], [-121.84435, 37.71956], [-121.84433, 37.71954], [-121.8443, 37.71954], [-121.84428, 37.71905], [-121.84432, 37.71882], [-121.84438, 37.7186], [-121.84448, 37.71838], [-121.84461, 37.71818], [-121.84485, 37.7179], [-121.84492, 37.71786], [-121.84498, 37.71786], [-121.84503, 37.71789], [-121.84529, 37.7181], [-121.84554, 37.71833], [-121.84584, 37.71871], [-121.84599, 37.71894], [-121.84613, 37.71921]]]} | Open Access 1 | 48353 | Sean Diamond Park | 32917 | 1090 | Dublin, City of 164 | City 2 | City Agency 2 | http://www.ci.dublin.ca.us/index.aspx?nid=1458 | City 2 | 1090 | Dublin, City of 160 | City 2 | City Agency 2 | https://www.dublin.ca.gov/Facilities/Facility/Details/Sean-Diamond-Park-33 | Alameda 17 | 4.986 | Sean Diamond Park | 2018 | Local Park 2 | 4 |
480 | 480 | 479 | {"type": "Polygon", "coordinates": [[[-122.25181, 37.74294], [-122.25094, 37.74333], [-122.2502, 37.74331], [-122.2502, 37.74256], [-122.25026, 37.74211], [-122.25158, 37.74235], [-122.25161, 37.74252], [-122.25168, 37.74271], [-122.25181, 37.74294]]]} | Open Access 1 | 1631 | Tillman Park | 26365 | 1001 | Alameda, City of 180 | City 2 | City Agency 2 | http://alamedaca.gov/recreation | City 2 | 1001 | Alameda, City of 176 | City 2 | City Agency 2 | Alameda 17 | 3.586 | Tillman Park | 0 | Local Park 2 | 4 | |
681 | 681 | 680 | {"type": "Polygon", "coordinates": [[[-122.19178, 37.73593], [-122.19137, 37.73616], [-122.19116, 37.73688], [-122.19077, 37.73841], [-122.18827, 37.73776], [-122.18881, 37.73569], [-122.19025, 37.736], [-122.19031, 37.73606], [-122.19074, 37.7357], [-122.19104, 37.73566], [-122.19126, 37.73533], [-122.19178, 37.73593]]]} | Open Access 1 | 3504 | Ira Jenkins Park | 20226 | 1228 | Oakland, City of 58 | City 2 | City Agency 2 | http://www2.oaklandnet.com/Government/o/opr/index.htm | City 2 | 1228 | Oakland, City of 56 | City 2 | City Agency 2 | Alameda 17 | 15.161 | Ira Jenkins Park | 0 | Local Park 2 | 4 | |
783 | 783 | 782 | {"type": "Polygon", "coordinates": [[[-122.09551, 37.63544], [-122.09549, 37.63615], [-122.0955, 37.63682], [-122.09501, 37.63684], [-122.09505, 37.63746], [-122.09413, 37.63754], [-122.0942, 37.63815], [-122.09387, 37.63819], [-122.09387, 37.63901], [-122.09249, 37.63911], [-122.09222, 37.63912], [-122.0919, 37.63901], [-122.09449, 37.63532], [-122.09496, 37.63539], [-122.09551, 37.63544]]]} | Open Access 1 | 5069 | Southgate Park | 25689 | 2045 | Hayward Area Recreation and Park District 257 | Special District 4 | Recreation/Parks District 4 | http://www.haywardrec.org/ | Special District 4 | 2045 | Hayward Area Recreation and Park District 253 | Special District 4 | Recreation/Parks District 4 | Alameda 17 | 14.46 | Southgate Park | 1965 | Local Park 2 | 4 | |
813 | 813 | 812 | {"type": "Polygon", "coordinates": [[[-121.78193, 37.67297], [-121.78197, 37.67334], [-121.78197, 37.67383], [-121.78189, 37.67423], [-121.78035, 37.67389], [-121.78048, 37.67298], [-121.78193, 37.67297]]]} | Open Access 1 | 5241 | Mocho Park | 22336 | 1178 | Livermore, City of 256 | City 2 | City Agency 2 | http://www.larpd.org/parks/parks.html | City 2 | 1178 | Livermore, City of 252 | City 2 | City Agency 2 | Alameda 17 | 4.098 | Mocho Park | 0 | Local Park 2 | 4 | |
855 | 855 | 854 | {"type": "Polygon", "coordinates": [[[-122.18754, 37.70419], [-122.18658, 37.70459], [-122.18625, 37.70409], [-122.18721, 37.70369], [-122.18754, 37.70419]]]} | Open Access 1 | 24933 | Mulford Park | 22589 | 1306 | San Leandro, City of 183 | City 2 | City Agency 2 | http://www.sanleandro.org/depts/rec/parks/default.asp | City 2 | 1306 | San Leandro, City of 179 | City 2 | City Agency 2 | Alameda 17 | 1.495 | Mulford Park | 0 | Local Park 2 | 4 | |
864 | 864 | 863 | {"type": "Polygon", "coordinates": [[[-122.29161, 37.89499], [-122.29154, 37.89662], [-122.28999, 37.89658], [-122.29007, 37.89494], [-122.29161, 37.89499]]]} | Open Access 1 | 5579 | Albany Memorial Park | 15328 | 1002 | Albany, City of 274 | City 2 | City Agency 2 | http://www.albanyca.org/index.aspx?page=473 | City 2 | 1002 | Albany, City of 269 | City 2 | City Agency 2 | Alameda 17 | 6.13 | Albany Memorial Park | 1920 | Local Park 2 | 4 | |
1101 | 1101 | 1100 | {"type": "Polygon", "coordinates": [[[-122.06832, 37.64878], [-122.0678, 37.64887], [-122.06776, 37.64853], [-122.06779, 37.64844], [-122.06798, 37.64835], [-122.06832, 37.64878]]]} | Open Access 1 | 15630 | Haymont Mini Park | 19758 | 2045 | Hayward Area Recreation and Park District 257 | Special District 4 | Recreation/Parks District 4 | http://www.haywardrec.org/ | Special District 4 | 2045 | Hayward Area Recreation and Park District 253 | Special District 4 | Recreation/Parks District 4 | Alameda 17 | 0.431 | Haymont MP | 0 | Local Park 2 | 4 | |
1218 | 1218 | 1217 | {"type": "MultiPolygon", "coordinates": [[[[-122.1451, 37.64851], [-122.14511, 37.64897], [-122.14509, 37.64903], [-122.14501, 37.64917], [-122.14486, 37.64934], [-122.14456, 37.64957], [-122.14429, 37.64973], [-122.14412, 37.64979], [-122.14409, 37.64745], [-122.14507, 37.64744], [-122.1451, 37.64851]]], [[[-122.14586, 37.6471], [-122.14517, 37.64711], [-122.14517, 37.64682], [-122.14586, 37.64682], [-122.14586, 37.6471]]]]} | Open Access 1 | 8671 | Hayward Shoreline | 19762 | 2032 | East Bay Regional Park District 89 | Special District 4 | Recreation/Parks District 4 | http://www.ebparks.org/ | Special District 4 | 2032 | East Bay Regional Park District 87 | Special District 4 | Recreation/Parks District 4 | Alameda 17 | 5.421 | Hayward Shoreline | 1977 | Local Park 2 | 4 | |
1246 | 1246 | 1245 | {"type": "Polygon", "coordinates": [[[-122.27628, 37.89224], [-122.2759, 37.8923], [-122.27586, 37.89215], [-122.2762, 37.89203], [-122.27628, 37.89224]]]} | Open Access 1 | 44896 | Contra Costa Rock Park | 17607 | 1028 | Berkeley, City of 337 | City 2 | City Agency 2 | http://www.ci.berkeley.ca.us/PRW/ | City 2 | 1028 | Berkeley, City of 334 | City 2 | City Agency 2 | Alameda 17 | 0.169 | Contra Costa Rock Park | 0 | Local Park 2 | 4 | |
1422 | 1422 | 1421 | {"type": "Polygon", "coordinates": [[[-122.0171, 37.59941], [-122.01689, 37.5995], [-122.0168, 37.59947], [-122.01672, 37.59947], [-122.01663, 37.59948], [-122.01658, 37.59951], [-122.01599, 37.59938], [-122.01595, 37.5994], [-122.01563, 37.59933], [-122.01576, 37.59887], [-122.01617, 37.5977], [-122.01742, 37.59798], [-122.01751, 37.59802], [-122.01754, 37.59812], [-122.0171, 37.59941]]]} | Open Access 1 | 12405 | Shorty Garcia Park | 25431 | 1362 | Union City, City of 365 | City 2 | City Agency 2 | http://www.ci.union-city.ca.us/ | City 2 | 1362 | Union City, City of 361 | City 2 | City Agency 2 | Alameda 17 | 5.79 | Shorty Garcia Park | 0 | Local Park 2 | 4 | |
1434 | 1434 | 1433 | {"type": "Polygon", "coordinates": [[[-122.0272, 37.65621], [-122.02609, 37.65763], [-122.02388, 37.65638], [-122.02421, 37.65615], [-122.02448, 37.65581], [-122.02462, 37.65538], [-122.02478, 37.655], [-122.02503, 37.65468], [-122.02527, 37.65453], [-122.0272, 37.65621]]]} | Open Access 1 | 47699 | J.A. Lewis Park | 31435 | 2045 | Hayward Area Recreation and Park District 257 | Special District 4 | Recreation/Parks District 4 | http://www.haywardrec.org/ | Special District 4 | 2045 | Hayward Area Recreation and Park District 253 | Special District 4 | Recreation/Parks District 4 | Alameda 17 | 12.57 | J.A. Lewis Park | 0 | Local Park 2 | 4 | |
1435 | 1435 | 1434 | {"type": "Polygon", "coordinates": [[[-122.13981, 37.67822], [-122.13977, 37.67831], [-122.13782, 37.6791], [-122.13753, 37.67864], [-122.13699, 37.67886], [-122.13613, 37.67751], [-122.13869, 37.67647], [-122.13981, 37.67822]]]} | Open Access 1 | 47700 | Mervin Morris Park | 31436 | 2045 | Hayward Area Recreation and Park District 257 | Special District 4 | Recreation/Parks District 4 | http://www.haywardrec.org/ | Special District 4 | 2045 | Hayward Area Recreation and Park District 253 | Special District 4 | Recreation/Parks District 4 | Alameda 17 | 13.34 | Mervin Morris Park | 0 | Local Park 2 | 4 | |
1441 | 1441 | 1440 | {"type": "Polygon", "coordinates": [[[-122.07092, 37.58343], [-122.07086, 37.58345], [-122.07013, 37.5834], [-122.07006, 37.58342], [-122.07001, 37.58347], [-122.07, 37.5835], [-122.07009, 37.58351], [-122.07001, 37.5836], [-122.07041, 37.58428], [-122.06975, 37.58504], [-122.06972, 37.58506], [-122.06966, 37.58505], [-122.06838, 37.58434], [-122.06877, 37.5839], [-122.06833, 37.58365], [-122.06891, 37.58315], [-122.06911, 37.58292], [-122.06883, 37.58275], [-122.06911, 37.58244], [-122.06919, 37.58244], [-122.07066, 37.58326], [-122.07092, 37.58343]]]} | Open Access 1 | 12481 | Contempo Park | 17606 | 1362 | Union City, City of 365 | City 2 | City Agency 2 | http://www.ci.union-city.ca.us/ | City 2 | 1362 | Union City, City of 361 | City 2 | City Agency 2 | Alameda 17 | 8.19 | Contempo Park | 0 | Local Park 2 | 4 | |
1451 | 1451 | 1450 | {"type": "Polygon", "coordinates": [[[-122.09749, 37.66354], [-122.09714, 37.66357], [-122.09618, 37.66266], [-122.09563, 37.66224], [-122.09518, 37.66185], [-122.0948, 37.66148], [-122.0965, 37.6607], [-122.09689, 37.66105], [-122.0972, 37.66164], [-122.09739, 37.66218], [-122.09747, 37.66261], [-122.09753, 37.66314], [-122.09749, 37.66354]]]} | Open Access 1 | 9747 | Centennial Park | 17031 | 2045 | Hayward Area Recreation and Park District 257 | Special District 4 | Recreation/Parks District 4 | http://www.haywardrec.org/ | Special District 4 | 2045 | Hayward Area Recreation and Park District 253 | Special District 4 | Recreation/Parks District 4 | Alameda 17 | 9.492 | Centennial Park | 0 | Local Park 2 | 4 | |
1501 | 1501 | 1500 | {"type": "Polygon", "coordinates": [[[-122.01802, 37.53174], [-122.0169, 37.53312], [-122.01436, 37.53181], [-122.01549, 37.53039], [-122.01802, 37.53174]]]} | Open Access 1 | 12740 | Birch Grove Park | 16116 | 1221 | Newark, City of 377 | City 2 | City Agency 2 | http://www.ci.newark.ca.us/departments/recreation-and-community-services/parks/ | City 2 | 1221 | Newark, City of 372 | City 2 | City Agency 2 | Alameda 17 | 12.218 | Birch Grove Park | 1973 | Local Park 2 | 4 | |
1511 | 1511 | 1510 | {"type": "Polygon", "coordinates": [[[-122.05125, 37.54145], [-122.05097, 37.54229], [-122.05084, 37.54249], [-122.05067, 37.54266], [-122.04921, 37.54073], [-122.04898, 37.54054], [-122.04953, 37.54009], [-122.04957, 37.54009], [-122.04963, 37.54011], [-122.04965, 37.54009], [-122.05123, 37.5414], [-122.05125, 37.54145]]]} | Open Access 1 | 12752 | Mirabeau Park | 22280 | 1221 | Newark, City of 377 | City 2 | City Agency 2 | http://www.ci.newark.ca.us/departments/recreation-and-community-services/parks/ | City 2 | 1221 | Newark, City of 372 | City 2 | City Agency 2 | Alameda 17 | 6.07 | Mirabeau Park | 1973 | 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]);