units_with_maps

Table actions

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

566 rows where COUNTY = 12

This data as json, copyable, CSV (advanced)

Suggested facets: AGNCY_LEV, 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
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
125 125 124 {"type": "Polygon", "coordinates": [[[-122.16054, 37.91443], [-122.15949, 37.91447], [-122.15824, 37.91493], [-122.15833, 37.91517], [-122.15835, 37.9154], [-122.15843, 37.91558], [-122.15855, 37.91562], [-122.1591, 37.91596], [-122.15923, 37.916], [-122.15932, 37.91606], [-122.15944, 37.9161], [-122.15978, 37.91678], [-122.15987, 37.91706], [-122.15989, 37.91733], [-122.15981, 37.91743], [-122.15968, 37.9175], [-122.15952, 37.91752], [-122.1583, 37.91752], [-122.15781, 37.91755], [-122.15781, 37.9177], [-122.15682, 37.91818], [-122.15556, 37.91921], [-122.15437, 37.92001], [-122.15249, 37.92204], [-122.15111, 37.92218], [-122.14987, 37.92221], [-122.14886, 37.92159], [-122.14828, 37.92145], [-122.14816, 37.92139], [-122.14803, 37.92129], [-122.14763, 37.92077], [-122.14752, 37.92071], [-122.14689, 37.92039], [-122.14573, 37.91988], [-122.14487, 37.91881], [-122.14368, 37.91819], [-122.14285, 37.91769], [-122.14266, 37.9176], [-122.14226, 37.91738], [-122.14209, 37.91701], [-122.14195, 37.91666], [-122.14182, 37.91621], [-122.14211, 37.9161], [-122.14325, 37.91561], [-122.14391, 37.91541], [-122.14487, 37.91524], [-122.14541, 37.91512], [-122.14599, 37.91505], [-122.14652, 37.91488], [-122.14719, 37.91472], [-122.14806, 37.91437], [-122.14828, 37.91418], [-122.14845, 37.91387], [-122.14876, 37.91372], [-122.14919, 37.91365], [-122.14961, 37.91369], [-122.14986, 37.91367], [-122.15009, 37.91362], [-122.15051, 37.91345], [-122.15067, 37.91336], [-122.1508, 37.91331], [-122.15093, 37.9132], [-122.15112, 37.91294], [-122.15129, 37.91276], [-122.15141, 37.91268], [-122.15173, 37.91256], [-122.15298, 37.91254], [-122.15334, 37.91257], [-122.15363, 37.91257], [-122.15418, 37.9127], [-122.15462, 37.91292], [-122.15559, 37.91319], [-122.15586, 37.91333], [-122.15636, 37.91343], [-122.15653, 37.91344], [-122.15685, 37.9134], [-122.15756, 37.9135], [-122.15813, 37.9136], [-122.15841, 37.91372], [-122.15882, 37.91396], [-122.15901, 37.91397], [-122.15914, 37.91394], [-122.1593, 37.91388], [-122.15958, 37.91383], [-122.15976, 37.91392], [-122.1601, 37.91419], [-122.16054, 37.91443]]]} Restricted Access 2 315 Russell Research Station (UC) 24744 217 University of California 53 State 5 State Agency 5 http://nrs.ucop.edu/ Other State 5 217 University of California 51 State 5 State Agency 5   Contra Costa 12 247.32 Russell Research Station (UC)   None 17  
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
565 565 564 {"type": "Polygon", "coordinates": [[[-121.91485, 37.97467], [-121.91485, 37.97489], [-121.91456, 37.9751], [-121.91431, 37.97535], [-121.9141, 37.97553], [-121.91345, 37.97542], [-121.91287, 37.97544], [-121.91255, 37.97534], [-121.91197, 37.97514], [-121.91169, 37.9751], [-121.9116, 37.97515], [-121.91148, 37.97518], [-121.91136, 37.97514], [-121.91103, 37.97515], [-121.9109, 37.97496], [-121.91122, 37.97496], [-121.91189, 37.97489], [-121.91232, 37.9749], [-121.91233, 37.97492], [-121.91345, 37.97494], [-121.91408, 37.97484], [-121.91485, 37.97467]]]} No Public Access 3 47528 Alaimo 31233 379 Contra Costa Department of Conservation and Development, County of 209 County 3 County Agency - Other 9 http://www.cccounty.us/dcd County 3 379 Contra Costa Department of Conservation and Development, County of 205 County 3 County Agency - Other 8   Contra Costa 12 3.763 Alaimo   None 56  
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
672 672 671 {"type": "Polygon", "coordinates": [[[-122.10311, 37.87618], [-122.10304, 37.87629], [-122.10157, 37.87704], [-122.10079, 37.87704], [-122.10071, 37.87693], [-122.10056, 37.87677], [-122.09956, 37.8759], [-122.09896, 37.87548], [-122.09889, 37.87537], [-122.09866, 37.87468], [-122.09864, 37.87453], [-122.10311, 37.87618]]]} Restricted Access 2 5104 711 St. Mary's Road Park 15210 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 11.502 711 St. Mary's Road Park 1983 Local Park 2 4
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

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