Data source: data.sfgov.org
This data as json, CSV (advanced)
Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder ▼ | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
15023 | 15023 | 97221 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 1301X Newcomb Ave | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 5 | 15x200 | 6016689.53805 | 2094986.8063299998 | 37.733371301443 | -122.38466554190701 | (37.733371301443, -122.384665541907) | |||
15485 | 15485 | 111661 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1398x Kansas St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 06/25/2015 01:32:00 PM | 3 | 3x3 | 6011721.86925 | 2101900.7924099998 | 37.7520796461774 | -122.402326221379 | (37.7520796461774, -122.402326221379) | ||
17004 | 17004 | 25108 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1400 Dolores St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 30 | 20 | 6005223.671490001 | 2100130.84124 | 37.7468548845426 | -122.424672082757 | (37.7468548845426, -122.424672082757) | |||
17056 | 17056 | 25058 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1000X Dolores St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 90 | 20 | 6005092.48697 | 2102458.1018 | 37.753237594341996 | -122.425291287561 | (37.753237594342, -122.425291287561) | |||
17074 | 17074 | 29980 | DPW Maintained 3 | Cordyline australis :: Dracena Palm 141 | 1622X Guerrero St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/24/2007 12:00:00 AM | 3 | 3x3 | 6005918.535069999 | 2099515.50587 | 37.7452045332674 | -122.422225595834 | (37.7452045332674, -122.422225595834) | ||
17207 | 17207 | 25101 | DPW Maintained 3 | Brahea edulis :: Guadalupe Palm 115 | 1450X Dolores St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 90 | 20 | 6005235.8244 | 2099843.7861200003 | 37.746067383302496 | -122.424609642834 | (37.7460673833025, -122.424609642834) | |||
17299 | 17299 | 8210 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 2189X Funston Ave | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 8X25 | 5992281.31882 | 2100517.50117 | 37.7471771044468 | -122.469453261968 | (37.7471771044468, -122.469453261968) | |||
17311 | 17311 | 25026 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 750X Dolores St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 70 | 20 | 6005011.77925 | 2103932.39938 | 37.7572811108424 | -122.42567531518499 | (37.7572811108424, -122.425675315185) | |||
17315 | 17315 | 25086 | DPW Maintained 3 | Brahea edulis :: Guadalupe Palm 115 | 1250X Dolores St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 30 | 20 | 6005173.10518 | 2101007.42475 | 37.7492589252724 | -122.424909291539 | (37.7492589252724, -122.424909291539) | |||
17339 | 17339 | 25501 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1900X Market St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/01/1993 12:00:00 AM | 36 | 8 | 6005202.0445 | 2108688.1512 | 37.770350024818704 | -122.425355725564 | (37.7703500248187, -122.425355725564) | ||
17411 | 17411 | 25526 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 2300X Market St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/01/1993 12:00:00 AM | 36 | 10 | 6002746.7355 | 2106338.4868 | 37.7637593960329 | -122.43368067367201 | (37.7637593960329, -122.433680673672) | ||
17518 | 17518 | 25033 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 700X Dolores St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 70 | 20 | 6004995.411590001 | 2104224.22732 | 37.7580814768833 | -122.425752691957 | (37.7580814768833, -122.425752691957) | |||
17575 | 17575 | 24996 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 400X Dolores St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 90 | 20 | 6004898.747380001 | 2105973.30508 | 37.7628785677218 | -122.42621152066002 | (37.7628785677218, -122.42621152066) | |||
17620 | 17620 | 25096 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1300X Dolores St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 90 | 20 | 6005188.030230001 | 2100718.94336 | 37.748467664846295 | -122.42483715961001 | (37.7484676648463, -122.42483715961) | |||
17642 | 17642 | 12921 | DPW Maintained 3 | Acacia decurrens :: Acacia: Silver Wattle 181 | 1050 Lawton St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 12 | 5990990.03726 | 2104515.89347 | 37.7580809319146 | -122.474210073944 | (37.7580809319146, -122.474210073944) | |||
17649 | 17649 | 30005 | DPW Maintained 3 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 795X San Jose Ave | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/24/2007 12:00:00 AM | 3 | 3x3 | 6005615.08127 | 2098546.14287 | 37.7425257613504 | -122.423205996259 | (37.7425257613504, -122.423205996259) | ||
17715 | 17715 | 16378 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1000X Moraga St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 18 | 12 | 5991088.16435 | 2103840.65792 | 37.756232597572605 | -122.473821451692 | (37.7562325975726, -122.473821451692) | |||
17932 | 17932 | 24987 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 340X Dolores St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 40 | 20 | 6004879.52665 | 2106321.34538 | 37.7638331171148 | -122.42630277934799 | (37.7638331171148, -122.426302779348) | |||
17974 | 17974 | 15058 | DPW Maintained 3 | Washingtonia filifera :: California Fan Palm 189 | 10X Minerva St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 11 | 5996572.9500165 | 2089038.2134875 | 37.7159048245128 | -122.45378440062001 | (37.7159048245128, -122.45378440062) | |||
18142 | 18142 | 13388 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 218 Marietta Dr | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | 5 | 5997667.5215300005 | 2098758.8322 | 37.7426580336411 | -122.45070150968999 | (37.7426580336411, -122.45070150969) | |||
18236 | 18236 | 25007 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 500X Dolores St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 90 | 20 | 6004931.59557 | 2105384.6255099997 | 37.7612640499245 | -122.426056000898 | (37.7612640499245, -122.426056000898) | |||
18375 | 18375 | 11190 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 140 Idora Ave | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 24 | 8 | 5995683.115039401 | 2099368.7198886 | 37.7442188444672 | -122.457607088025 | (37.7442188444672, -122.457607088025) | |||
18415 | 18415 | 13417 | DPW Maintained 3 | Leptospermum laevigatum :: Australian Tea Tree 38 | 400 Marietta Dr | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 70 | 5 | 5999553.15658 | 2097034.9165400001 | 37.7380323275191 | -122.444057708717 | (37.7380323275191, -122.444057708717) | |||
18432 | 18432 | 25070 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1100X Dolores St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 80 | 20 | 6005125.726319999 | 2101888.99536 | 37.751676838028395 | -122.425135847862 | (37.7516768380284, -122.425135847862) | |||
18484 | 18484 | 12450 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 200X Lake Merced Blvd | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 6 | 5983914.9541303 | 2094860.2401332 | 37.7311567434968 | -122.497965345854 | (37.7311567434968, -122.497965345854) | |||
18527 | 18527 | 25047 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 900X Dolores St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 90 | 20 | 6005062.19129 | 2103039.48532 | 37.754832226347396 | -122.425437427413 | (37.7548322263474, -122.425437427413) | |||
18764 | 18764 | 16103 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 300X Monterey Blvd | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 02/18/2012 12:00:00 AM | 2 | 5 | 6000043.907980001 | 2094672.48858 | 37.7315736376005 | -122.44219140500799 | (37.7315736376005, -122.442191405008) | ||
18783 | 18783 | 29330 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 1370X Portola Dr | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 01/16/2006 12:00:00 AM | 3 | 3X3 | 5993366.67631 | 2097732.50409 | 37.7395928707266 | -122.46549792578699 | (37.7395928707266, -122.465497925787) | ||
18799 | 18799 | 11188 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 100 Idora Ave | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 24 | 8 | 5995291.088769999 | 2099424.10153 | 37.7443483813689 | -122.45896663000299 | (37.7443483813689, -122.458966630003) | |||
18870 | 18870 | 16690 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 950X Noriega St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 11/07/2014 11:22:00 AM | 3 | 8 | 5991053.49575 | 2103158.03284 | 37.7543562808184 | -122.473891546652 | (37.7543562808184, -122.473891546652) | ||
18956 | 18956 | 25081 | DPW Maintained 3 | Phoenix dactylifera :: Date Palm 65 | 1200X Dolores St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 10/03/2012 12:00:00 AM | 20 | 20 | 6005156.57495 | 2101303.54282 | 37.7500710634364 | -122.424987519083 | (37.7500710634364, -122.424987519083) | ||
18988 | 18988 | 16343 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 922X Monterey Blvd | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 01/19/2013 12:00:00 AM | 3 | 5 | 5996035.52811 | 2094660.72414 | 37.7313120760949 | -122.456048222959 | (37.7313120760949, -122.456048222959) | ||
18990 | 18990 | 16587 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 7X Noe St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 3X3 | 6002822.0682 | 2108265.0608599996 | 37.7690535728051 | -122.433557813564 | (37.7690535728051, -122.433557813564) | |||
19000 | 19000 | 30051 | DPW Maintained 3 | Cedrus atlantica :: Atlas Cedar 304 | 700X Junipero Serra Blvd | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 3X3 | 5991309.16462 | 2093067.2657700002 | 37.7266644202262 | -122.472271855075 | (37.7266644202262, -122.472271855075) | |||
19265 | 19265 | 29699 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 1488X Guerrero St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/30/2006 12:00:00 AM | 3 | 6005882.22155 | 2100316.32182 | 37.747401343192 | -122.42240805210399 | (37.747401343192, -122.422408052104) | |||
19284 | 19284 | 25135 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1700X Dolores St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 90 | 20 | 6005318.690690001 | 2098391.09531 | 37.742083304809206 | -122.424219803815 | (37.7420833048092, -122.424219803815) | |||
19342 | 19342 | 26905 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 10 Caine Ave | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 10 | 5997683.40035 | 2089758.8108400002 | 37.7179470200262 | -122.449998089654 | (37.7179470200262, -122.449998089654) | |||
19492 | 19492 | 25148 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 2X Dolores St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 80 | 20 | 6004781.85822 | 2108123.31219 | 37.7687753648286 | -122.426768919571 | (37.7687753648286, -122.426768919571) | |||
19496 | 19496 | 34866 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 579 Miramar Ave | 1 | Median : Cutout 11 | Tree 1 | Private 1 | FUF 1 | 12/29/2015 12:00:00 AM | Permit Number 775311 | 5995338.59696042 | 2093168.95782094 | 37.7271760192259 | -122.458349689476 | (37.7271760192259, -122.458349689476) | ||
19514 | 19514 | 16309 | DPW Maintained 3 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 700X Monterey Blvd | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 02/02/2003 12:00:00 AM | 18 | 5 | 5997384.824659999 | 2094713.0859599998 | 37.7315332040811 | -122.45138725623801 | (37.7315332040811, -122.451387256238) | ||
19536 | 19536 | 29706 | DPW Maintained 3 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 1594X Guerrero St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/30/2006 12:00:00 AM | 3 | 6005915.3087 | 2099718.0441099997 | 37.745760475271204 | -122.422251139273 | (37.7457604752712, -122.422251139273) | |||
19568 | 19568 | 26708 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 88X Noe St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 3 | 6002857.07874 | 2107723.1475299997 | 37.767567597789295 | -122.43339798423 | (37.7675675977893, -122.43339798423) | |||
19570 | 19570 | 29257 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 300X Portola Dr | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 10/14/2005 12:00:00 AM | 3 | 3X3 | 5999277.42958 | 2100279.63386 | 37.7469258104704 | -122.445244250841 | (37.7469258104704, -122.445244250841) | ||
19585 | 19585 | 24338 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 2020X Market St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 05/07/1993 12:00:00 AM | 36 | 8 | 6004443.4589 | 2107950.1478 | 37.76828075872071 | -122.42792707731 | (37.7682807587207, -122.42792707731) | ||
19610 | 19610 | 16184 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 401X Monterey Blvd | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 5 | 5999406.634869999 | 2094682.7033 | 37.7315653449635 | -122.444395308802 | (37.7315653449635, -122.444395308802) | |||
19687 | 19687 | 25091 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1350 Dolores St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 80 | 20 | 6005204.68058 | 2100428.03656 | 37.7476698420965 | -122.42475889070299 | (37.7476698420965, -122.424758890703) | |||
19777 | 19777 | 16245 | DPW Maintained 3 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 601X Monterey Blvd | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 02/02/2003 12:00:00 AM | 12 | 5 | 5997958.54401 | 2094705.63588 | 37.7315455832604 | -122.44940326996401 | (37.7315455832604, -122.449403269964) | ||
19871 | 19871 | 16685 | DPW Maintained 3 | Syagrus romanzoffianum :: Queen Palm 142 | 250X Noe St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 05/25/2010 12:00:00 AM | 3 | 3X3 | 6002901.6582 | 2106832.0518 | 37.7651233950804 | -122.43318011235 | (37.7651233950804, -122.43318011235) | ||
19946 | 19946 | 25514 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 2100X Market St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/01/1993 12:00:00 AM | 36 | 10 | 6004037.0875 | 2107573.3112 | 37.7672230586461 | -122.429305801661 | (37.7672230586461, -122.429305801661) | ||
19957 | 19957 | 13396 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 300 Marietta Dr | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 30 | 5 | 5999058.18381 | 2097687.6567700002 | 37.7397963477092 | -122.44581599931999 | (37.7397963477092, -122.44581599932) | |||
20148 | 20148 | 17245 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 501 Ortega St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | 3 | 5992555.1394 | 2103055.38176 | 37.754161290716205 | -122.468691056856 | (37.7541612907162, -122.468691056856) | |||
20153 | 20153 | 25114 | DPW Maintained 3 | Brahea edulis :: Guadalupe Palm 115 | 1500X Dolores St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 70 | 20 | 6005252.81807 | 2099553.25269 | 37.7452706046555 | -122.424530218307 | (37.7452706046555, -122.424530218307) | |||
20164 | 20164 | 8289 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 50 Garcia Ave | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 8 | 5995199.8326 | 2099398.11528 | 37.7442717834334 | -122.459280291049 | (37.7442717834334, -122.459280291049) | |||
20367 | 20367 | 29572 | DPW Maintained 3 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 400X Junipero Serra Blvd | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/01/2007 12:00:00 AM | 3 | 3X3 | 5991380.33669 | 2094272.13717 | 37.7299768148765 | -122.47211360317 | (37.7299768148765, -122.47211360317) | ||
20534 | 20534 | 16379 | DPW Maintained 3 | Pinus halepensis :: Allepo Pine 164 | 1050 Moraga St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 24 | 12 | 5990995.6052 | 2103835.85647 | 37.7562140526474 | -122.47414119938401 | (37.7562140526474, -122.474141199384) | |||
20554 | 20554 | 24378 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1400 Holloway Ave | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 05/26/1995 12:00:00 AM | 20 | 5x5 | 5990557.6196800005 | 2091079.0001599998 | 37.7211616152093 | -122.474724840503 | (37.7211616152093, -122.474724840503) | ||
20596 | 20596 | 30053 | DPW Maintained 3 | Pittosporum crassifolium :: Karo Tree 108 | 300X Junipero Serra Blvd | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 3X3 | 5991402.003959999 | 2094617.0572900001 | 37.730925132888295 | -122.472063828393 | (37.7309251328883, -122.472063828393) | |||
20630 | 20630 | 24974 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 200 Dolores St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 90 | 20 | 6004833.67989 | 2107139.93189 | 37.7660781684855 | -122.426519640982 | (37.7660781684855, -122.426519640982) | |||
20692 | 20692 | 15069 | DPW Maintained 3 | Melaleuca nesophila :: Pink Melaleuca 93 | 1X Minerva St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 11 | 5995941.11063 | 2089006.6713400001 | 37.715781972331 | -122.455966040227 | (37.715781972331, -122.455966040227) | |||
20732 | 20732 | 29280 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 400X Portola Dr | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 10/14/2005 12:00:00 AM | 3 | 3X3 | 5998304.529680001 | 2100049.9335 | 37.7462395270381 | -122.448591895321 | (37.7462395270381, -122.448591895321) | ||
21040 | 21040 | 16351 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1500X Monterey Blvd | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 4-HOA | 5993490.85605 | 2095190.6948799998 | 37.7326208567505 | -122.464884023402 | (37.7326208567505, -122.464884023402) | |||
21066 | 21066 | 30050 | DPW Maintained 3 | Pinus pinea :: Italian Stone Pine 143 | 900X Junipero Serra Blvd | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 3X3 | 5991182.4145599995 | 2091161.54655 | 37.7214244519661 | -122.472571141372 | (37.7214244519661, -122.472571141372) | |||
21086 | 21086 | 23592 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 200X Vasquez Ave | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | 8 | 5994656.2966599995 | 2099224.9929400003 | 37.7437651683354 | -122.461147162215 | (37.7437651683354, -122.461147162215) | |||
21445 | 21445 | 25496 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1745X Market St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/01/1993 12:00:00 AM | 24 | 20 | 6005866.13841 | 2109325.7941099997 | 37.772138336447 | -122.42310395199499 | (37.772138336447, -122.423103951995) | ||
21462 | 21462 | 25153 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 50X Dolores St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 90 | 20 | 6004788.48534 | 2107965.7019599997 | 37.768342979778204 | -122.426734771418 | (37.7683429797782, -122.426734771418) | |||
21480 | 21480 | 24990 | DPW Maintained 3 | Brahea edulis :: Guadalupe Palm 115 | 300 Dolores St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 90 | 20 | 6004865.2254 | 2106541.92962 | 37.7644379804469 | -122.426367949619 | (37.7644379804469, -122.426367949619) | |||
21512 | 21512 | 25120 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1550 Dolores St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 90 | 20 | 6005269.99247 | 2099258.02767 | 37.744460954018 | -122.424449836913 | (37.744460954018, -122.424449836913) | |||
21531 | 21531 | 29579 | DPW Maintained 3 | Syzygium paniculatum :: Brush Cherry 198 | 500X Junipero Serra Blvd | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/01/2007 12:00:00 AM | 3 | 3X3 | 5991348.44459 | 2093803.51532 | 37.7286882509598 | -122.472189710993 | (37.7286882509598, -122.472189710993) | ||
21785 | 21785 | 25131 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 1600X Dolores St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 90 | 20 | 6005285.7039 | 2098966.45887 | 37.74366125975121 | -122.42437477586901 | (37.7436612597512, -122.424374775869) | |||
21853 | 21853 | 25535 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 2200X Market St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/01/1993 12:00:00 AM | 36 | 20 | 6003362.1302 | 2106920.4307 | 37.765392172561796 | -122.431593762963 | (37.7653921725618, -122.431593762963) | ||
21891 | 21891 | 25037 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 800X Dolores St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 90 | 20 | 6005031.31461 | 2103614.04185 | 37.7564080795924 | -122.425585096976 | (37.7564080795924, -122.425585096976) | |||
22009 | 22009 | 24961 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 100 Dolores St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/21/2005 12:00:00 AM | 90 | 20 | 6004800.95891 | 2107734.51921 | 37.76770891277079 | -122.42667516163999 | (37.7677089127708, -122.42667516164) | ||
22014 | 22014 | 16697 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 900 Noriega St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 36 | 8 | 5991184.711180001 | 2103161.77097 | 37.754374144067505 | -122.473438047351 | (37.7543741440675, -122.473438047351) | |||
22125 | 22125 | 16043 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 200X Monterey Blvd | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | 5 | 6000692.70251 | 2094661.9023 | 37.731581524671995 | -122.43994764238701 | (37.731581524672, -122.439947642387) | |||
22161 | 22161 | 18116 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 1250X Portola Dr | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 24 | 10 | 5994256.15058 | 2097914.09085 | 37.740142723404105 | -122.46243569826001 | (37.7401427234041, -122.46243569826) | |||
22191 | 22191 | 29356 | DPW Maintained 3 | Arbutus unedo :: Strawberry Tree 61 | 1600X Portola Dr | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 01/16/2006 12:00:00 AM | 3 | 3X3 | 5991811.277419999 | 2096273.10994 | 37.7354959129041 | -122.47076949802201 | (37.7354959129041, -122.470769498022) | ||
22281 | 22281 | 29985 | DPW Maintained 3 | Cordyline australis :: Dracena Palm 141 | 688X San Jose Ave | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/24/2007 12:00:00 AM | 3 | 3x3 | 6005799.980169999 | 2099121.4011 | 37.744115723156796 | -122.422607538818 | (37.7441157231568, -122.422607538818) | ||
22425 | 22425 | 9012 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 5317 Geary Blvd | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 8M | 5990521.6823 | 2112683.6213 | 37.7804801526055 | -122.476426471359 | (37.7804801526055, -122.476426471359) | |||
22541 | 22541 | 9137 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 5900 Geary Blvd | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 8M | 5988584.9325 | 2112610.849 | 37.7801678269123 | -122.48312118538799 | (37.7801678269123, -122.483121185388) | |||
22564 | 22564 | 9174 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 6100 Geary Blvd | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 8M | 5988054.2055 | 2112594.5834 | 37.7800922677689 | -122.484955995928 | (37.7800922677689, -122.484955995928) | |||
22589 | 22589 | 9159 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 6000 Geary Blvd | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 18 | 3x3 | 5988363.5866 | 2112600.7878 | 37.7801273186276 | -122.48388617463999 | (37.7801273186276, -122.48388617464) | |||
22625 | 22625 | 9089 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 5700 Geary Blvd | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | 8M | 5989272.6654 | 2112633.6176 | 37.7802703397174 | -122.480743697915 | (37.7802703397174, -122.480743697915) | |||
22919 | 22919 | 251161 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 528 Noriega St | 1 | Median : Cutout 11 | Tree 1 | Private 1 | 3x3 | 5992330.0 | 2103518.0 | 37.7554185113149 | -122.46950331083401 | (37.7554185113149, -122.469503310834) | ||||
22922 | 22922 | 251160 | DPW Maintained 3 | Pinus pinea :: Italian Stone Pine 143 | 1126x Portola Dr | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | Private 3 | 3x3 | 5994964.0 | 2098019.0 | 37.7404715144277 | -122.459995857341 | (37.7404715144277, -122.459995857341) | |||
22999 | 22999 | 16007 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 100X Monterey Blvd | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 16 | 8 | 6001364.53052 | 2094649.25854 | 37.7315850293086 | -122.43762410089799 | (37.7315850293086, -122.437624100898) | |||
23079 | 23079 | 8464 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 1900 Geary Blvd | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 17 | 8 | 6002427.515 | 2113723.6274 | 37.784019039174794 | -122.435313053048 | (37.7840190391748, -122.435313053048) | |||
23159 | 23159 | 16339 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 890X Monterey Blvd | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/22/2008 12:00:00 AM | 2 | 5 | 5996276.20802 | 2094704.1816900002 | 37.7314452117282 | -122.45521929265 | (37.7314452117282, -122.45521929265) | ||
23198 | 23198 | 16002 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 1X Monterey Blvd | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 17 | 3 | 6001503.91519 | 2094647.64932 | 37.7315885348642 | -122.43714210651699 | (37.7315885348642, -122.437142106517) | |||
23246 | 23246 | 8613 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 2660 Geary Blvd | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 17 | 20 | 5998899.2985 | 2113220.7326 | 37.7824372241255 | -122.447483138223 | (37.7824372241255, -122.447483138223) | |||
24090 | 24090 | 238060 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2x Montezuma St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 3ft | 6007260.48935 | 2099759.47356 | 37.7459500163869 | -122.417602623671 | (37.7459500163869, -122.417602623671) | |||
24137 | 24137 | 231180 | DPW Maintained 3 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 2800x Bryant St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 2 | Width 5ft | 6009829.19056 | 2100977.4251599996 | 37.7494384497445 | -122.408806277407 | (37.7494384497445, -122.408806277407) | |||
24559 | 24559 | 246349 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 2190x Market St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 31 | Width 0ft | 6003723.2107 | 2107266.4094 | 37.766362606026796 | -122.430369556243 | (37.7663626060268, -122.430369556243) | |||
26254 | 26254 | 116994 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 600M Divisadero St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 6001630.0135 | 2110553.7073 | 37.775269918649705 | -122.43784499428999 | (37.7752699186497, -122.43784499429) | ||||
26885 | 26885 | 249467 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 1000x Van Ness Ave | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 8 | Width 3ft | 6006503.72956 | 2113992.67034 | 37.7849884074321 | -122.421229920427 | (37.7849884074321, -122.421229920427) | |||
26941 | 26941 | 233639 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 738x San Jose Ave | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 4 | Width 3ft | 6005705.797780001 | 2098817.87018 | 37.743276982150604 | -122.42291163287099 | (37.7432769821506, -122.422911632871) | |||
28092 | 28092 | 246547 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 20x Octavia St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 4ft | 6005744.74711 | 2109415.26549 | 37.772377152311705 | -122.42353021715599 | (37.7723771523117, -122.423530217156) | |||
29392 | 29392 | 244311 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 301x Octavia St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | Width 0ft | 6005501.4183 | 2110598.8748 | 37.7756133196055 | -122.424456119453 | (37.7756133196055, -122.424456119453) | |||
29751 | 29751 | 219429 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 900x Kirkham St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 1 | Width 4ft | 5992085.46562 | 2105232.9931400004 | 37.7601132972171 | -122.47047387378099 | (37.7601132972171, -122.470473873781) | |||
30280 | 30280 | 217724 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 150x Lincoln Way | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 8 | Width 5ft | 5995249.55673 | 2107377.5130000003 | 37.7661840384824 | -122.45968619826701 | (37.7661840384824, -122.459686198267) | |||
30755 | 30755 | 208080 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 1000x Junipero Serra Blvd | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 4 | Width 0ft | 5991162.63824 | 2089810.37082 | 37.7177133113937 | -122.472541042839 | (37.7177133113937, -122.472541042839) |
JSON shape: default, array, newline-delimited
CREATE TABLE "Street_Tree_List" ( "TreeID" INTEGER, "qLegalStatus" INTEGER, "qSpecies" INTEGER, "qAddress" TEXT, "SiteOrder" INTEGER, "qSiteInfo" INTEGER, "PlantType" INTEGER, "qCaretaker" INTEGER, "qCareAssistant" INTEGER, "PlantDate" TEXT, "DBH" INTEGER, "PlotSize" TEXT, "PermitNotes" TEXT, "XCoord" REAL, "YCoord" REAL, "Latitude" REAL, "Longitude" REAL, "Location" TEXT , FOREIGN KEY ("PlantType") REFERENCES [PlantType](id), FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id), FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id), FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id), FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id), FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id)); CREATE INDEX ["Street_Tree_List_PlantType"] ON [Street_Tree_List]("PlantType"); CREATE INDEX ["Street_Tree_List_qCaretaker"] ON [Street_Tree_List]("qCaretaker"); CREATE INDEX ["Street_Tree_List_qSpecies"] ON [Street_Tree_List]("qSpecies"); CREATE INDEX ["Street_Tree_List_qSiteInfo"] ON [Street_Tree_List]("qSiteInfo"); CREATE INDEX ["Street_Tree_List_qCareAssistant"] ON [Street_Tree_List]("qCareAssistant"); CREATE INDEX ["Street_Tree_List_qLegalStatus"] ON [Street_Tree_List]("qLegalStatus");