units_with_maps

Table actions

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

468 rows where ACCESS_TYP = 1 and COUNTY = 12

This data as json, copyable, CSV (advanced)

These facets timed out: MNG_AG_TYP

ACCESS_TYP 1

  • Open Access · 468 ✖
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
37 37 36 {"type": "Polygon", "coordinates": [[[-122.32795, 37.91786], [-122.32631, 37.91992], [-122.32264, 37.91975], [-122.32261, 37.91967], [-122.32261, 37.91841], [-122.32258, 37.9183], [-122.32754, 37.91757], [-122.32795, 37.91786]]]} Open Access 1 119 Booker T. Anderson Jr. Park 16269 1274 Richmond, City of 20 City 2 City Agency 2 http://www.ci.richmond.ca.us/index.aspx?NID=2075 City 2 1274 Richmond, City of 20 City 2 City Agency 2   Contra Costa 12 21.023 Booker T. Anderson Jr. Park 0 Local Park 2 4
45 45 44 {"type": "Polygon", "coordinates": [[[-121.58017, 38.00647], [-121.57962, 38.00489], [-121.5792, 38.00424], [-121.57866, 38.00373], [-121.578, 38.00325], [-121.5773, 38.00297], [-121.5765, 38.00275], [-121.57532, 38.00267], [-121.57437, 38.00274], [-121.57366, 38.00284], [-121.57299, 38.00288], [-121.57271, 38.00292], [-121.57084, 38.00265], [-121.56985, 38.00228], [-121.56934, 38.002], [-121.56923, 38.00168], [-121.56976, 38.00083], [-121.57043, 38.0001], [-121.57105, 37.99959], [-121.57179, 37.99931], [-121.57271, 37.99929], [-121.57361, 37.99936], [-121.57459, 37.99948], [-121.57536, 37.99977], [-121.57739, 37.99957], [-121.57899, 37.99906], [-121.57922, 37.99895], [-121.57943, 37.99902], [-121.57968, 38.00053], [-121.57966, 38.0016], [-121.57979, 38.0027], [-121.5798, 38.00342], [-121.57997, 38.00413], [-121.58015, 38.00529], [-121.58017, 38.00647]]]} Open Access 1 104 Rhode Island Wildlife Area 30492 201 California Department of Fish and Wildlife 25 State 5 State Agency 5 https://www.wildlife.ca.gov/ California Department of Fish and Wildlife 6 201 California Department of Fish and Wildlife 25 State 5 State Agency 5 https://www.wildlife.ca.gov/Lands/Places-to-Visit/Rhode-Island-WA Contra Costa 12 85.271 Rhode Island Wildlife Area 2002 State Conservation Area 8 2
183 183 182 {"type": "Polygon", "coordinates": [[[-121.9589, 37.75072], [-121.95656, 37.75167], [-121.95627, 37.75123], [-121.95597, 37.75097], [-121.95558, 37.75036], [-121.95489, 37.74989], [-121.95534, 37.74942], [-121.95561, 37.74904], [-121.95572, 37.74886], [-121.9561, 37.74807], [-121.95647, 37.74778], [-121.95661, 37.7477], [-121.95692, 37.74756], [-121.95773, 37.74884], [-121.9589, 37.75072]]]} Open Access 1 506 Athan Downs Park 31278 1313 San Ramon, City of 70 City 2 City Agency 2 http://www.ci.san-ramon.ca.us/Parks/default.htm City 2 1313 San Ramon, City of 68 City 2 City Agency 2   Contra Costa 12 20.518 Athan Downs Park 0 Local Park 2 4
261 261 260 {"type": "Polygon", "coordinates": [[[-122.16261, 37.9746], [-122.1626, 37.9801], [-122.16254, 37.98012], [-122.16252, 37.98011], [-122.16149, 37.98051], [-122.16049, 37.98141], [-122.1587, 37.98292], [-122.15833, 37.98316], [-122.15779, 37.98345], [-122.15791, 37.98902], [-122.15339, 37.98907], [-122.15338, 37.98794], [-122.15359, 37.97455], [-122.16261, 37.9746]]]} Open Access 1 884 Sky Ranch 7292 3045 John Muir Land Trust 108 Non Profit 6 Non Profit - Land Trust 10 http://www.jmlt.org/ Non Governmental Organization 10 3045 John Muir Land Trust 105 Non Profit 6 Non Profit - Land Trust 10 http://www.muirheritagelandtrust.org/sky_ranch.html Contra Costa 12 233.641 Sky Ranch 1998 Private Conservation 16 2
476 476 475 {"type": "Polygon", "coordinates": [[[-122.06976, 37.87928], [-122.06833, 37.8812], [-122.06772, 37.88097], [-122.06649, 37.88015], [-122.06665, 37.87674], [-122.06746, 37.87673], [-122.06699, 37.87773], [-122.06732, 37.87877], [-122.06801, 37.879], [-122.06955, 37.87914], [-122.06976, 37.87928]]]} Open Access 1 1591 Old Oak Park 23095 1371 Walnut Creek, City of 178 City 2 City Agency 2 http://www.ci.walnut-creek.ca.us/citygov/depts/ps/openspace/default.asp City 2 1371 Walnut Creek, City of 174 City 2 City Agency 2   Contra Costa 12 15.049 Old Oak Park 0 Local Park 2 4
507 507 506 {"type": "Polygon", "coordinates": [[[-122.3113, 37.95195], [-122.31115, 37.95198], [-122.31097, 37.9517], [-122.31046, 37.95149], [-122.31045, 37.95104], [-122.30995, 37.95105], [-122.30989, 37.95092], [-122.30964, 37.95091], [-122.30966, 37.95076], [-122.30979, 37.95074], [-122.31036, 37.95059], [-122.31015, 37.9501], [-122.30955, 37.94944], [-122.30954, 37.94962], [-122.30842, 37.94838], [-122.30754, 37.94769], [-122.30759, 37.94744], [-122.30788, 37.94711], [-122.30746, 37.94655], [-122.30701, 37.94631], [-122.30627, 37.94612], [-122.30617, 37.9458], [-122.3065, 37.94519], [-122.30634, 37.94491], [-122.30587, 37.94479], [-122.3057, 37.94457], [-122.30726, 37.94498], [-122.30729, 37.94514], [-122.30789, 37.94641], [-122.30825, 37.94651], [-122.30849, 37.94698], [-122.30882, 37.94708], [-122.30887, 37.94742], [-122.309, 37.94761], [-122.30975, 37.94822], [-122.30975, 37.94857], [-122.31016, 37.9492], [-122.31052, 37.94925], [-122.31084, 37.94972], [-122.31069, 37.94998], [-122.31109, 37.95054], [-122.31128, 37.95049], [-122.31126, 37.95075], [-122.3113, 37.95195]]]} Open Access 1 2075 Wildcat Canyon Regional Park 27502 1311 San Pablo, City of 192 City 2 City Agency 2 http://www.ci.san-pablo.ca.us/ City 2 1311 San Pablo, City of 188 City 2 City Agency 2 http://www.ebparks.org/parks/wildcat Contra Costa 12 18.143 Wildcat Canyon RP 1936 Local Park 2 4
592 592 591 {"type": "Polygon", "coordinates": [[[-121.94024, 38.01658], [-121.93978, 38.01658], [-121.93977, 38.01672], [-121.93947, 38.01673], [-121.9395, 38.01832], [-121.93948, 38.01832], [-121.93914, 38.01842], [-121.93876, 38.01847], [-121.93842, 38.01836], [-121.93821, 38.01832], [-121.93821, 38.01825], [-121.93793, 38.01815], [-121.9373, 38.01768], [-121.93773, 38.01605], [-121.94023, 38.01603], [-121.94024, 38.01658]]]} Open Access 1 2015 Ambrose Park 15445 2001 Ambrose Recreation and Park District 217 Special District 4 Recreation/Parks District 4 http://www.ambroserec.org/ Special District 4 2001 Ambrose Recreation and Park District 213 Special District 4 Recreation/Parks District 4   Contra Costa 12 11.746 Ambrose Park 0 Local Park 2 4
658 658 657 {"type": "Polygon", "coordinates": [[[-122.1718, 37.99251], [-122.16269, 37.99253], [-122.16267, 37.98898], [-122.16654, 37.98899], [-122.16655, 37.98895], [-122.17178, 37.98893], [-122.1718, 37.99251]]]} Open Access 1 3251 Gustin 19572 3045 John Muir Land Trust 108 Non Profit 6 Non Profit - Land Trust 10 http://www.jmlt.org/ Non Governmental Organization 10 3045 John Muir Land Trust 105 Non Profit 6 Non Profit - Land Trust 10   Contra Costa 12 78.179 Gustin 2000 Private Conservation 16 2
780 780 779 {"type": "Polygon", "coordinates": [[[-121.73394, 37.98555], [-121.73394, 37.98694], [-121.73255, 37.98694], [-121.73255, 37.98555], [-121.73394, 37.98555]]]} Open Access 1 5063 Crockett Park 17829 1229 Oakley, City of 255 City 2 City Agency 2 http://www.ci.oakley.ca.us/subpage.cfm?id=441408 City 2 1229 Oakley, City of 251 City 2 City Agency 2   Contra Costa 12 4.667 Crockett Park 0 Local Park 2 4
786 786 785 {"type": "Polygon", "coordinates": [[[-122.10174, 37.85993], [-122.10174, 37.86191], [-122.10034, 37.86391], [-122.09999, 37.86392], [-122.09965, 37.86438], [-122.09912, 37.86403], [-122.09873, 37.86468], [-122.09828, 37.8651], [-122.09781, 37.86516], [-122.09794, 37.8657], [-122.09807, 37.86602], [-122.0979, 37.86635], [-122.09797, 37.86662], [-122.09815, 37.8669], [-122.09776, 37.86746], [-122.09806, 37.86777], [-122.09807, 37.86819], [-122.09803, 37.86883], [-122.09759, 37.86962], [-122.09705, 37.86926], [-122.09627, 37.8684], [-122.0955, 37.86773], [-122.09513, 37.86732], [-122.09484, 37.86714], [-122.09459, 37.86673], [-122.0961, 37.86643], [-122.09667, 37.86596], [-122.09734, 37.86507], [-122.09768, 37.86456], [-122.09766, 37.86387], [-122.09799, 37.86358], [-122.09332, 37.86072], [-122.09488, 37.86046], [-122.09586, 37.86008], [-122.09628, 37.86048], [-122.09757, 37.86078], [-122.09879, 37.86062], [-122.10029, 37.86018], [-122.10174, 37.85993]]]} Open Access 1 5101 Lafayette Community Park 20830 1163 Lafayette, City of 236 City 2 City Agency 2 http://www.ci.lafayette.ca.us/index.aspx?page=87 City 2 1163 Lafayette, City of 232 City 2 City Agency 2   Contra Costa 12 70.977 Lafayette Community Park 1973 Local Park 2 4
1095 1095 1094 {"type": "Polygon", "coordinates": [[[-121.61579, 37.90931], [-121.61435, 37.90927], [-121.61438, 37.90837], [-121.61578, 37.90838], [-121.61579, 37.90931]]]} Open Access 1 48931 Ravenswood Park 33651 2439 Discovery Bay Community Service District 314 Special District 4 Community Services District 19 https://www.todb.ca.gov/district-services Special District 4 2439 Discovery Bay Community Service District 311 Special District 4 Community Services District 17   Contra Costa 12 3.141 Ravenswood Park 0 Local Park 2 4
1344 1344 1343 {"type": "Polygon", "coordinates": [[[-121.80306, 37.96023], [-121.80282, 37.96064], [-121.80082, 37.96089], [-121.80065, 37.96007], [-121.80169, 37.95988], [-121.80252, 37.95958], [-121.8027, 37.95983], [-121.80296, 37.95969], [-121.80306, 37.96023]]]} Open Access 1 11320 Dallas Ranch Park 17898 1007 Antioch, City of 350 City 2 City Agency 2 http://www.ci.antioch.ca.us/Recreation/parks.asp City 2 1007 Antioch, City of 347 City 2 City Agency 2   Contra Costa 12 5.028 Dallas Ranch Park 0 Local Park 2 4
1345 1345 1344 {"type": "Polygon", "coordinates": [[[-121.78833, 37.96151], [-121.78833, 37.96151], [-121.7875, 37.9627], [-121.78747, 37.96115], [-121.78782, 37.96133], [-121.78833, 37.96151]]]} Open Access 1 11331 Diablo West Park 18137 1007 Antioch, City of 350 City 2 City Agency 2 http://www.ci.antioch.ca.us/Recreation/parks.asp City 2 1007 Antioch, City of 347 City 2 City Agency 2   Contra Costa 12 1.559 Diablo West Park 0 Local Park 2 4
1346 1346 1345 {"type": "Polygon", "coordinates": [[[-121.72032, 37.95387], [-121.72018, 37.95386], [-121.71935, 37.95216], [-121.71878, 37.95215], [-121.71868, 37.95125], [-121.71883, 37.9506], [-121.7191, 37.95044], [-121.71918, 37.95013], [-121.71908, 37.94982], [-121.71878, 37.94918], [-121.71903, 37.9487], [-121.71921, 37.9488], [-121.71925, 37.94937], [-121.71934, 37.94948], [-121.7194, 37.94965], [-121.7196, 37.94968], [-121.71959, 37.94986], [-121.71979, 37.94989], [-121.71995, 37.95087], [-121.71995, 37.95309], [-121.72015, 37.95329], [-121.72032, 37.95387]]]} Open Access 1 11368 Miwok Park and Trail 22332 1034 Brentwood, City of 351 City 2 City Agency 2 http://www.brentwoodca.gov/gov/parks/default.asp City 2 1034 Brentwood, City of 348 City 2 City Agency 2   Contra Costa 12 8.092 Miwok Park and Trail 0 Local Recreation Area 3 4
1351 1351 1350 {"type": "Polygon", "coordinates": [[[-121.69897, 37.92733], [-121.69896, 37.92916], [-121.69801, 37.92915], [-121.69802, 37.92899], [-121.69829, 37.92877], [-121.69827, 37.92732], [-121.69897, 37.92733]]]} Open Access 1 11414 McClarren Park 21997 1034 Brentwood, City of 351 City 2 City Agency 2 http://www.brentwoodca.gov/gov/parks/default.asp City 2 1034 Brentwood, City of 348 City 2 City Agency 2   Contra Costa 12 3.186 McClarren Park 0 Local Park 2 4
1352 1352 1351 {"type": "Polygon", "coordinates": [[[-121.69054, 37.92014], [-121.6899, 37.92051], [-121.68948, 37.92005], [-121.69016, 37.91969], [-121.69054, 37.92014]]]} Open Access 1 11501 Glory Park 19349 1034 Brentwood, City of 351 City 2 City Agency 2 http://www.brentwoodca.gov/gov/parks/default.asp City 2 1034 Brentwood, City of 348 City 2 City Agency 2   Contra Costa 12 1.072 Glory Park 0 Local Park 2 4
1370 1370 1369 {"type": "Polygon", "coordinates": [[[-122.2916, 38.01582], [-122.29115, 38.01599], [-122.29085, 38.01572], [-122.2913, 38.01544], [-122.2916, 38.01582]]]} Open Access 1 12052 Waterfront Park 27303 1133 Hercules, City of 354 City 2 City Agency 2 http://www.ci.hercules.ca.us/index.aspx?page=166 City 2 1133 Hercules, City of 351 City 2 City Agency 2   Contra Costa 12 0.507 Waterfront Park 0 Local Park 2 4
1371 1371 1370 {"type": "Polygon", "coordinates": [[[-122.12055, 37.88858], [-122.12052, 37.88861], [-122.12045, 37.8887], [-122.1203, 37.88872], [-122.12016, 37.88824], [-122.12045, 37.88819], [-122.12055, 37.88858]]]} Open Access 1 12062 Brook Street Park 30315 1163 Lafayette, City of 236 City 2 City Agency 2 http://www.ci.lafayette.ca.us/index.aspx?page=87 City 2 1163 Lafayette, City of 232 City 2 City Agency 2   Contra Costa 12 0.324 Brook Street Park 0 Local Park 2 4
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
1398 1398 1397 {"type": "Polygon", "coordinates": [[[-122.27441, 37.98392], [-122.27416, 37.98446], [-122.27372, 37.98438], [-122.27337, 37.98424], [-122.27285, 37.98397], [-122.27253, 37.98359], [-122.27304, 37.98321], [-122.27328, 37.98347], [-122.27387, 37.98379], [-122.27441, 37.98392]]]} Open Access 1 12285 Amber Swartz Park 15442 1252 Pinole, City of 357 City 2 City Agency 2 http://www.ci.pinole.ca.us/recreation/parks.html City 2 1252 Pinole, City of 354 City 2 City Agency 2   Contra Costa 12 2.612 Amber Swartz Park 0 Local Park 2 4

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