units_with_maps

Table actions

Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette

647 rows where COUNTY = 17

This data as json, copyable, CSV (advanced)

Suggested facets: AGNCY_TYP, LAYER, MNG_AG_LEV, GAP_STS

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
218 218 217 {"type": "MultiPolygon", "coordinates": [[[[-122.00283, 37.56787], [-122.00528, 37.56886], [-122.00536, 37.56876], [-122.00637, 37.56915], [-122.00646, 37.56905], [-122.00694, 37.56924], [-122.00841, 37.57037], [-122.00605, 37.57247], [-122.00581, 37.57272], [-122.00563, 37.57245], [-122.00561, 37.57245], [-122.00486, 37.57485], [-122.00167, 37.57418], [-122.00088, 37.57663], [-122.00033, 37.5765], [-121.99656, 37.57363], [-121.99685, 37.57277], [-121.99721, 37.57285], [-121.99723, 37.57284], [-121.99743, 37.56696], [-121.99852, 37.56669], [-121.99871, 37.5667], [-121.9987, 37.56677], [-121.99916, 37.56686], [-121.99961, 37.56698], [-122.00112, 37.56756], [-122.0012, 37.56746], [-122.00224, 37.56786], [-122.00235, 37.56771], [-122.00283, 37.56787]]], [[[-122.00227, 37.57706], [-122.00224, 37.57716], [-122.00227, 37.57718], [-122.00203, 37.57784], [-122.0005, 37.57666], [-122.00227, 37.57706]]], [[[-122.01347, 37.57268], [-122.01183, 37.57446], [-122.01014, 37.57619], [-122.00994, 37.57635], [-122.00973, 37.57651], [-122.00895, 37.57696], [-122.00821, 37.57742], [-122.00796, 37.57759], [-122.0077, 37.57782], [-122.00748, 37.57808], [-122.0073, 37.57835], [-122.00718, 37.57862], [-122.00706, 37.5786], [-122.00686, 37.57917], [-122.00811, 37.57947], [-122.00818, 37.57956], [-122.00772, 37.58092], [-122.00605, 37.58056], [-122.00568, 37.58164], [-122.00418, 37.58051], [-122.00216, 37.57896], [-122.00209, 37.57889], [-122.00203, 37.5788], [-122.00198, 37.57866], [-122.002, 37.57851], [-122.00244, 37.57734], [-122.00248, 37.57728], [-122.00258, 37.57724], [-122.003, 37.57733], [-122.00424, 37.57807], [-122.00588, 37.57674], [-122.00592, 37.57631], [-122.01114, 37.57138], [-122.01347, 37.57268]]]]} Open Access 1 586 Quarry Lakes Regional Recreation Area 30594 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 254.616 Quarry Lakes Reg. Rec. Area 2001 Local Recreation Area 3 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
490 490 489 {"type": "Polygon", "coordinates": [[[-122.14785, 37.69505], [-122.1456, 37.69512], [-122.14527, 37.69542], [-122.14472, 37.69503], [-122.1447, 37.69334], [-122.14783, 37.69326], [-122.14785, 37.69505]]]} Open Access 1 1962 Washington Manor 27270 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 13.829 Washington Manor   None 51  
576 576 575 {"type": "Polygon", "coordinates": [[[-122.14526, 37.74311], [-122.14524, 37.74315], [-122.14492, 37.74341], [-122.14434, 37.74398], [-122.14423, 37.74406], [-122.1437, 37.7433], [-122.14342, 37.74306], [-122.14482, 37.7425], [-122.14526, 37.74311]]]} Open Access 1 3448 Poaks Headquarters 23819 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 3.419 Poaks Headquarters   None 57  
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
781 781 780 {"type": "Polygon", "coordinates": [[[-121.83892, 37.69284], [-121.83892, 37.69497], [-121.83838, 37.69541], [-121.83777, 37.69567], [-121.83724, 37.69614], [-121.83653, 37.69638], [-121.83615, 37.6966], [-121.8359, 37.6971], [-121.83545, 37.69735], [-121.83435, 37.69759], [-121.83308, 37.69793], [-121.83316, 37.69844], [-121.83289, 37.69879], [-121.83205, 37.69921], [-121.83202, 37.6983], [-121.82998, 37.69835], [-121.82998, 37.70055], [-121.82094, 37.70062], [-121.81888, 37.69912], [-121.81883, 37.69713], [-121.82405, 37.69676], [-121.8243, 37.69635], [-121.82403, 37.6952], [-121.82983, 37.6953], [-121.83021, 37.69279], [-121.83892, 37.69284]]]} Restricted Access 2 5062 Las Positas Golf Course 33002 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 216.12 Las Positas GC 0 Local Recreation Area 3 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
816 816 815 {"type": "Polygon", "coordinates": [[[-121.80478, 37.67824], [-121.80306, 37.67892], [-121.80129, 37.67953], [-121.80062, 37.67969], [-121.79957, 37.67975], [-121.79748, 37.67946], [-121.79627, 37.67965], [-121.7953, 37.67994], [-121.79396, 37.67982], [-121.79254, 37.67974], [-121.7915, 37.67976], [-121.79158, 37.67946], [-121.79158, 37.67939], [-121.79205, 37.6795], [-121.79326, 37.67955], [-121.79464, 37.67963], [-121.79547, 37.6796], [-121.79602, 37.67934], [-121.7967, 37.67905], [-121.79774, 37.6791], [-121.79887, 37.67934], [-121.79991, 37.67942], [-121.80079, 37.67936], [-121.80188, 37.67901], [-121.80281, 37.67855], [-121.80429, 37.6779], [-121.80478, 37.67824]]]} Open Access 1 5263 Arroyo Mocho 15613 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 10.963 Arroyo Mocho   None 75  
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
1226 1226 1225 {"type": "Polygon", "coordinates": [[[-122.2621, 37.81037], [-122.26187, 37.81046], [-122.26141, 37.8104], [-122.26121, 37.81003], [-122.26124, 37.80951], [-122.26139, 37.80882], [-122.26145, 37.80722], [-122.26125, 37.80701], [-122.26115, 37.80678], [-122.26059, 37.80677], [-122.26018, 37.80656], [-122.26, 37.80604], [-122.25945, 37.80556], [-122.25897, 37.80479], [-122.25862, 37.80467], [-122.25787, 37.80485], [-122.2566, 37.80538], [-122.25631, 37.8057], [-122.25625, 37.80655], [-122.25573, 37.80703], [-122.25541, 37.80719], [-122.25475, 37.80716], [-122.254, 37.80703], [-122.25305, 37.80712], [-122.25224, 37.80751], [-122.25146, 37.8081], [-122.25109, 37.80815], [-122.24995, 37.80847], [-122.24972, 37.80838], [-122.24972, 37.80785], [-122.24999, 37.80721], [-122.2503, 37.80668], [-122.25074, 37.80566], [-122.2511, 37.80499], [-122.25117, 37.80494], [-122.2534, 37.80418], [-122.25372, 37.80369], [-122.2539, 37.80321], [-122.25472, 37.80211], [-122.25473, 37.80206], [-122.25483, 37.80191], [-122.25473, 37.80158], [-122.25473, 37.80085], [-122.25507, 37.80057], [-122.25551, 37.80043], [-122.25654, 37.80053], [-122.25712, 37.80039], [-122.25836, 37.79968], [-122.25882, 37.7992], [-122.25917, 37.79895], [-122.26125, 37.79996], [-122.26139, 37.80021], [-122.26151, 37.80087], [-122.2613, 37.80222], [-122.26104, 37.80261], [-122.26049, 37.80382], [-122.26049, 37.80451], [-122.26147, 37.80527], [-122.26245, 37.80641], [-122.2628, 37.80726], [-122.2628, 37.80815], [-122.2626, 37.8087], [-122.26228, 37.81014], [-122.2621, 37.81037]]]} Open Access 1 8847 Lake Merritt 20953 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 141.432 Lake Merritt 1957 None 107  
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
1390 1390 1389 {"type": "Polygon", "coordinates": [[[-121.79075, 37.65873], [-121.78962, 37.65876], [-121.78926, 37.6589], [-121.78862, 37.65791], [-121.79066, 37.65786], [-121.79072, 37.65809], [-121.79075, 37.65873]]]} Open Access 1 12195 Jack Williams 20314 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 3.928 Jack Williams   None 118  

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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]);