Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, qCareAssistant
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo ▲ | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 55679 | 55679 | 200228 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1079 Ingerson Ave | 2 | unknown : Yard 19 | Tree 1 | Private 1 | 7 | Width 0ft | 6013685.1573 | 2090181.4131 | 37.7200100518893 | -122.394716195485 | (37.7200100518893, -122.394716195485) | |||
| 182621 | 182621 | 200227 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1079 Ingerson Ave | 1 | unknown : Yard 19 | Tree 1 | Private 1 | 11 | Width 0ft | 6013668.3894 | 2090192.8153 | 37.7200404277679 | -122.39477495490499 | (37.7200404277679, -122.394774954905) | |||
| 183984 | 183984 | 200230 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1079 Ingerson Ave | 4 | unknown : Yard 19 | Tree 1 | Private 1 | 9 | Width 0ft | 6013720.7054 | 2090151.9015 | 37.7199309952824 | -122.394591251483 | (37.7199309952824, -122.394591251483) | |||
| 28127 | 28127 | 191847 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 2101 Newcomb Ave | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 23 | Width 10ft | 6012411.60288 | 2097770.43241 | 37.7407770404189 | -122.39965102878901 | (37.7407770404189, -122.399651028789) | |||
| 43726 | 43726 | 247881 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 387 Mayflower St | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 15 | 6009928.32781 | 2098399.30466 | 37.742365048010896 | -122.4082816417 | (37.7423650480109, -122.4082816417) | ||||
| 54010 | 54010 | 247872 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 388 Mayflower St | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 23 | 6009895.64631 | 2098398.03188 | 37.7423597231243 | -122.408394555183 | (37.7423597231243, -122.408394555183) | ||||
| 136621 | 136621 | 249776 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 102 Pfeiffer St | 7 | Side Yard : Yard 17 | Tree 1 | Private 1 | 25 | Width 0ft | 6010370.54568 | 2121149.36884 | 37.804856202214204 | -122.408356876268 | (37.8048562022142, -122.408356876268) | |||
| 169612 | 169612 | 247876 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 388 Mayflower St | 5 | Side Yard : Yard 17 | Tree 1 | Private 1 | 22 | 6009908.43883 | 2098395.0561 | 37.742352268652 | -122.40835011248001 | (37.742352268652, -122.40835011248) | ||||
| 172369 | 172369 | 191849 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1998 Revere Ave | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 18 | 6013048.000580001 | 2095925.65097 | 37.735747110629 | -122.397321254093 | (37.735747110629, -122.397321254093) | ||||
| 669 | 669 | 251343 | Property Tree 7 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 934 Brannan St | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 3x3 | 6010724.0 | 2108745.0 | 37.7708165471861 | -122.40625919407302 | (37.7708165471861, -122.406259194073) | ||||
| 27119 | 27119 | 209185 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 140 Kensington Way | 5 | Back Yard : Yard 13 | Tree 1 | Private 1 | 7 | Width 3ft | 5994853.690119999 | 2098493.2474700003 | 37.741767335194105 | -122.460411617495 | (37.7417673351941, -122.460411617495) | |||
| 48070 | 48070 | 209184 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 140 Kensington Way | 4 | Back Yard : Yard 13 | Tree 1 | Private 1 | 16 | Width 3ft | 5994856.4919300005 | 2098484.57238 | 37.7417436767315 | -122.460401301401 | (37.7417436767315, -122.460401301401) | |||
| 48281 | 48281 | 209182 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 140 Kensington Way | 2 | Back Yard : Yard 13 | Tree 1 | Private 1 | 17 | Width 3ft | 5994867.86795 | 2098472.15279 | 37.7417102300345 | -122.46036106750799 | (37.7417102300345, -122.460361067508) | |||
| 60639 | 60639 | 191813 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 300 Vermont St | 6 | Back Yard : Yard 13 | Tree 1 | Private 1 | 25 | 6011137.70759 | 2106686.95849 | 37.7651887659782 | -122.40468325722901 | (37.7651887659782, -122.404683257229) | ||||
| 63607 | 63607 | 191841 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1501 Davidson Ave | 9 | Back Yard : Yard 13 | Tree 1 | Private 1 | 23 | 6015067.74656 | 2099262.4877299997 | 37.7450216201491 | -122.39057124226801 | (37.7450216201491, -122.390571242268) | ||||
| 71300 | 71300 | 191840 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1501 Davidson Ave | 8 | Back Yard : Yard 13 | Tree 1 | Private 1 | 16 | 6015034.2062 | 2099284.7294900003 | 37.7450808306162 | -122.39068877377701 | (37.7450808306162, -122.390688773777) | ||||
| 73581 | 73581 | 191844 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1501 Davidson Ave | 14 | Back Yard : Yard 13 | Tree 1 | Private 1 | 27 | 6015247.82087 | 2099125.91751 | 37.7446566150196 | -122.38993903417 | (37.7446566150196, -122.38993903417) | ||||
| 73889 | 73889 | 191811 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 300 Vermont St | 3 | Back Yard : Yard 13 | Tree 1 | Private 1 | 24 | 6011131.47947 | 2106831.70462 | 37.76558585803421 | -122.40471498982299 | (37.7655858580342, -122.404714989823) | ||||
| 172795 | 172795 | 191843 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1501 Davidson Ave | 11 | Back Yard : Yard 13 | Tree 1 | Private 1 | 20 | 6015141.47385 | 2099207.7707599998 | 37.7448754686187 | -122.390312482158 | (37.7448754686187, -122.390312482158) | ||||
| 172941 | 172941 | 191812 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 300 Vermont St | 5 | Back Yard : Yard 13 | Tree 1 | Private 1 | 23 | 6011136.684719999 | 2106709.3643099996 | 37.765250230128004 | -122.404688372578 | (37.765250230128, -122.404688372578) | ||||
| 174819 | 174819 | 209181 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 140 Kensington Way | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 15 | Width 3ft | 5994876.85162 | 2098459.48593 | 37.7416759667651 | -122.46032908762699 | (37.7416759667651, -122.460329087627) | |||
| 177691 | 177691 | 209186 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 140 Kensington Way | 6 | Back Yard : Yard 13 | Tree 1 | Private 1 | 12 | Width 3ft | 5994849.5459 | 2098494.81966 | 37.741771413634794 | -122.46042606063 | (37.7417714136348, -122.46042606063) | |||
| 177754 | 177754 | 209147 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 75 Ralston St | 3 | Back Yard : Yard 13 | Tree 1 | Private 1 | 16 | 5992171.618 | 2088327.33496 | 37.7136996047335 | -122.46894561897 | (37.7136996047335, -122.46894561897) | ||||
| 180957 | 180957 | 191842 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1501 Davidson Ave | 10 | Back Yard : Yard 13 | Tree 1 | Private 1 | 15 | 6015112.514169999 | 2099226.0983 | 37.744924185813396 | -122.390413900506 | (37.7449241858134, -122.390413900506) | ||||
| 182862 | 182862 | 209187 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 156 Kensington Way | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 9 | Width 3ft | 5994832.7400400005 | 2098518.64338 | 37.7418358608449 | -122.460485895213 | (37.7418358608449, -122.460485895213) | |||
| 182994 | 182994 | 191809 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 300 Vermont St | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 19 | 6011127.66334 | 2106895.1514 | 37.76575985524929 | -122.404732656101 | (37.7657598552493, -122.404732656101) | ||||
| 183262 | 183262 | 191810 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 300 Vermont St | 2 | Back Yard : Yard 13 | Tree 1 | Private 1 | 18 | 6011130.07486 | 2106859.15267 | 37.7656611456652 | -122.40472178059099 | (37.7656611456652, -122.404721780591) | ||||
| 189024 | 189024 | 209189 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 156 Kensington Way | 3 | Back Yard : Yard 13 | Tree 1 | Private 1 | 9 | Width 3ft | 5994812.38667 | 2098544.02713 | 37.7419043873887 | -122.460558108972 | (37.7419043873887, -122.460558108972) | |||
| 5380 | 5380 | 23543 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 2800X Van Ness Ave | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 35 | 9 | 6005659.04127 | 2120027.6333 | 37.8015112413055 | -122.424581715282 | (37.8015112413055, -122.424581715282) | |||
| 6534 | 6534 | 23551 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 2900X Van Ness Ave | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 30 | 6005612.78895 | 2120375.11437 | 37.802462723129395 | -122.424766503478 | (37.8024627231294, -122.424766503478) | ||||
| 7152 | 7152 | 29781 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 2000X Van Ness Ave | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/12/2006 12:00:00 AM | 3 | 6006021.95745 | 2117391.75426 | 37.7942942736085 | -122.42313839334601 | (37.7942942736085, -122.423138393346) | |||
| 8259 | 8259 | 23442 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 2100X Van Ness Ave | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 24 | 9 | 6005990.50725 | 2117651.28863 | 37.795005114851 | -122.42326567258301 | (37.795005114851, -122.423265672583) | |||
| 10299 | 10299 | 1295 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 4000X Alemany Blvd | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 25 | 10 | 5991914.74417 | 2087134.82891 | 37.710410426081 | -122.46974669545901 | (37.710410426081, -122.469746695459) | |||
| 10727 | 10727 | 1298 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 4000X Alemany Blvd | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 25 | 10 | 5991889.9079 | 2087118.85792 | 37.7103651380077 | -122.46983137204599 | (37.7103651380077, -122.469831372046) | |||
| 10785 | 10785 | 1296 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 4000X Alemany Blvd | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 35 | 10 | 5991907.39965 | 2087130.17274 | 37.710397216839496 | -122.46977174067499 | (37.7103972168395, -122.469771740675) | |||
| 10821 | 10821 | 1299 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 4000X Alemany Blvd | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 40 | 10 | 5991881.88808 | 2087114.90346 | 37.7103538164401 | -122.46985880224301 | (37.7103538164401, -122.469858802243) | |||
| 11437 | 11437 | 1297 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 4000X Alemany Blvd | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 25 | 10 | 5991899.37983 | 2087126.21827 | 37.7103858952584 | -122.46979917089199 | (37.7103858952584, -122.469799170892) | |||
| 17146 | 17146 | 2013 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 500X Bosworth St | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 10 | 6002577.1884699995 | 2095292.92439 | 37.7334212632741 | -122.433477690263 | (37.7334212632741, -122.433477690263) | |||
| 17205 | 17205 | 26909 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 10 Caine Ave | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 18 | 10 | 5997629.54091 | 2089680.9775599998 | 37.71773022584279 | -122.45017865014299 | (37.7177302258428, -122.450178650143) | |||
| 17236 | 17236 | 19195 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 150 Sanchez St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 24 | 3X3 | 6003512.4095 | 2107418.3103 | 37.76676774608121 | -122.431109521045 | (37.7667677460812, -122.431109521045) | |||
| 17237 | 17237 | 26912 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 10 Caine Ave | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 50 | 10 | 5997598.31865 | 2089637.50605 | 37.7176090763688 | -122.450283439137 | (37.7176090763688, -122.450283439137) | |||
| 19083 | 19083 | 26913 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 10 Caine Ave | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 24 | 10 | 5997584.35365 | 2089616.43233 | 37.717550413599795 | -122.45033019131 | (37.7175504135998, -122.45033019131) | |||
| 19195 | 19195 | 26910 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 10 Caine Ave | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 10 | 5997620.43146 | 2089669.0920400003 | 37.7176970696553 | -122.45020928103399 | (37.7176970696553, -122.450209281034) | |||
| 19231 | 19231 | 2011 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 500X Bosworth St | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 10 | 6002543.1242 | 2095301.43659 | 37.7334427031002 | -122.433596068029 | (37.7334427031002, -122.433596068029) | |||
| 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) | |||
| 19416 | 19416 | 2014 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 500X Bosworth St | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 18 | 10 | 6002609.44021 | 2095285.23051 | 37.733401967419205 | -122.43336563743799 | (37.7334019674192, -122.433365637438) | |||
| 19538 | 19538 | 16588 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 88X Noe St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | 3X3 | 6002852.6033 | 2107735.26664 | 37.7676006199961 | -122.43341433031401 | (37.7676006199961, -122.433414330314) | |||
| 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) | |||
| 19977 | 19977 | 29369 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 500X Bosworth St | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 07/06/2005 12:00:00 AM | 3 | 3X3 | 6002638.340030001 | 2095276.9082799999 | 37.733380755998894 | -122.43326512830099 | (37.7333807559989, -122.433265128301) | ||
| 20093 | 20093 | 2015 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 500X Bosworth St | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 10 | 6002627.0989 | 2095279.66022 | 37.733387674484604 | -122.433304188563 | (37.7333876744846, -122.433304188563) | |||
| 20603 | 20603 | 26906 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 10 Caine Ave | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 24 | 10 | 5997668.873459999 | 2089736.17467 | 37.717884035095295 | -122.450046671911 | (37.7178840350953, -122.450046671911) | |||
| 21305 | 21305 | 26908 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 10 Caine Ave | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 18 | 10 | 5997639.65043 | 2089696.09364 | 37.7177723096208 | -122.45014479517 | (37.7177723096208, -122.45014479517) | |||
| 21568 | 21568 | 2012 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 500X Bosworth St | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 18 | 10 | 6002566.51434 | 2095294.967 | 37.7334262662011 | -122.43351473961599 | (37.7334262662011, -122.433514739616) | |||
| 21645 | 21645 | 26907 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 10 Caine Ave | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 18 | 10 | 5997653.71656 | 2089718.57825 | 37.717834852078205 | -122.45009779478701 | (37.7178348520782, -122.450097794787) | |||
| 21793 | 21793 | 29370 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 500X Bosworth St | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 07/06/2005 12:00:00 AM | 3 | 3X3 | 6002650.152480001 | 2095274.05972 | 37.733373604614 | -122.433224085933 | (37.733373604614, -122.433224085933) | ||
| 22854 | 22854 | 176359 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 350x Winding Way | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 19 | Width 0ft | 6001093.21408 | 2086592.19305 | 37.7094467152559 | -122.437985185864 | (37.7094467152559, -122.437985185864) | |||
| 67936 | 67936 | 209179 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 255x San Marcos Ave | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 14 | Width 5ft | 5993078.87861 | 2100249.74193 | 37.7464879656554 | -122.46667592616998 | (37.7464879656554, -122.46667592617) | |||
| 76168 | 76168 | 2148 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1100X Bosworth St | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 6 | 6001043.628513 | 2095761.867481 | 37.734621744877295 | -122.438813219285 | (37.7346217448773, -122.438813219285) | |||
| 77440 | 77440 | 23201 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 538X Van Ness Ave | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 30 | 9 | 6006777.891315901 | 2112378.9819314997 | 37.7805730648795 | -122.420166841786 | (37.7805730648795, -122.420166841786) | |||
| 82031 | 82031 | 23557 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 2900X Van Ness Ave | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 28 | 9x200 | 6005648.5023441 | 2120304.1415398 | 37.8022698669467 | -122.42463786565399 | (37.8022698669467, -122.424637865654) | |||
| 88140 | 88140 | 2149 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1100X Bosworth St | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 24 | 6 | 6001043.628513 | 2095761.867481 | 37.734621744877295 | -122.438813219285 | (37.7346217448773, -122.438813219285) | |||
| 91725 | 91725 | 2147 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1100X Bosworth St | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 18 | 6 | 6001043.628513 | 2095761.867481 | 37.734621744877295 | -122.438813219285 | (37.7346217448773, -122.438813219285) | |||
| 97478 | 97478 | 2145 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1100X Bosworth St | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | 6 | 6001043.628513 | 2095761.867481 | 37.734621744877295 | -122.438813219285 | (37.7346217448773, -122.438813219285) | |||
| 102311 | 102311 | 23415 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1800X VAN NESS AVE | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 30 | 9 | 6006192.0 | 2116736.0 | 37.7925033310543 | -122.422503407712 | (37.7925033310543, -122.422503407712) | |||
| 112688 | 112688 | 2150 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1100X Bosworth St | 11 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/12/2006 12:00:00 AM | 24 | 6 | 6001043.628513 | 2095761.867481 | 37.734621744877295 | -122.438813219285 | (37.7346217448773, -122.438813219285) | ||
| 116746 | 116746 | 2143 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1100X Bosworth St | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 18 | 6 | 6001043.628513 | 2095761.867481 | 37.734621744877295 | -122.438813219285 | (37.7346217448773, -122.438813219285) | |||
| 121107 | 121107 | 2142 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1100X Bosworth St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 18 | 4 | 6001043.628513 | 2095761.867481 | 37.734621744877295 | -122.438813219285 | (37.7346217448773, -122.438813219285) | |||
| 124289 | 124289 | 2008 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 500X Bosworth St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 18 | 12x100 | 6002728.1222807 | 2095276.2570246002 | 37.733384060718 | -122.432954679755 | (37.733384060718, -122.432954679755) | |||
| 128637 | 128637 | 2140 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1100X Bosworth St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 18 | 4 | 6001043.628513 | 2095761.867481 | 37.734621744877295 | -122.438813219285 | (37.7346217448773, -122.438813219285) | |||
| 144777 | 144777 | 24280 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 300X Winding Way | 18 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 8 | 6001646.2933309 | 2086550.8578367 | 37.7093646550959 | -122.436070699117 | (37.7093646550959, -122.436070699117) | |||
| 146698 | 146698 | 223933 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 500x 27th St | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 14 | Width 4ft | 6002792.14111 | 2100065.62398 | 37.7465381864861 | -122.43307541991999 | (37.7465381864861, -122.43307541992) | |||
| 179926 | 179926 | 176358 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 300x Mansell St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 24 | Width 0ft | 6010959.21222 | 2090503.85024 | 37.720743461908995 | -122.40416158569599 | (37.720743461909, -122.404161585696) | |||
| 132830 | 132830 | 223930 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 400 Clipper St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 18 | Width 4ft | 6002523.62609 | 2100944.1238700002 | 37.748935105485295 | -122.434066703011 | (37.7489351054853, -122.434066703011) | |||
| 340 | 340 | 191854 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 573 10th St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | DPW 2 | 24 | Width 6ft | tree is in ROW therefore DPW maintained | 6009977.72395 | 2108375.30106 | 37.7697596664942 | -122.408814503513 | (37.7697596664942, -122.408814503513) | ||
| 389 | 389 | 191855 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 573 10th St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | DPW 2 | 49 | Width 6ft | Cal Trans adjacent; 10 ft ROW | 6009921.77605 | 2108434.69103 | 37.7699196037317 | -122.409012217656 | (37.7699196037317, -122.409012217656) | ||
| 4764 | 4764 | 253679 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 94 Teresita Blvd | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4x8 | 5997405.0 | 2099153.0 | 37.7437252916895 | -122.45163765514201 | (37.7437252916895, -122.451637655142) | ||||
| 25083 | 25083 | 250988 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 401 45th Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | 5981857.67732 | 2112961.27677 | 37.780736228431394 | -122.50641942431999 | (37.7807362284314, -122.50641942432) | ||||
| 25469 | 25469 | 224313 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1300 San Jose Ave | 43 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 23 | 6003370.69781 | 2095579.24653 | 37.734252427487895 | -122.43075473197099 | (37.7342524274879, -122.430754731971) | ||||
| 29272 | 29272 | 206257 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 470 Joost Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | 5998979.032869999 | 2094999.63504 | 37.7324111582444 | -122.44589639242099 | (37.7324111582444, -122.445896392421) | ||||
| 34621 | 34621 | 142349 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 101 Jean Way | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Width 0ft | 5998390.8197 | 2112613.6039 | 37.780741136182996 | -122.44919849112499 | (37.780741136183, -122.449198491125) | |||
| 34820 | 34820 | 185062 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 57 Crestlake Dr | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 34 | Width 0ft | 5988606.9554 | 2096240.5545 | 37.735220697007 | -122.48184553440599 | (37.735220697007, -122.481845534406) | |||
| 34903 | 34903 | 209050 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1957 11th Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 8ft | 5992832.0563900005 | 2102279.47717 | 37.752046850582104 | -122.46767699299299 | (37.7520468505821, -122.467676992993) | |||
| 38245 | 38245 | 206256 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 52 Burnside Ave | 9 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 14 | 6001149.03132 | 2095735.7759900002 | 37.7345560997669 | -122.438446938292 | (37.7345560997669, -122.438446938292) | ||||
| 40028 | 40028 | 223932 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 540 28th St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 10ft | 6002411.2824 | 2099479.33596 | 37.74490676593071 | -122.434350476903 | (37.7449067659307, -122.434350476903) | |||
| 43280 | 43280 | 202107 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1833 Egbert Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 23 | Width 5ft | 6011947.78492 | 2092850.2983099998 | 37.727241516067 | -122.40090914794399 | (37.727241516067, -122.400909147944) | |||
| 45093 | 45093 | 176361 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 33 Burr Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 15 | Width 3ft | 6007913.680380001 | 2086634.77605 | 37.70994915030529 | -122.414415456032 | (37.7099491503053, -122.414415456032) | |||
| 49532 | 49532 | 191815 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1101 18th St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 34 | Width 4ft | 6014219.19015 | 2105700.54735 | 37.762652041984296 | -122.39395601257 | (37.7626520419843, -122.39395601257) | |||
| 51031 | 51031 | 206258 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 470 Joost Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | 5998976.70694 | 2094998.91633 | 37.732409052024295 | -122.44590438200198 | (37.7324090520243, -122.445904382002) | ||||
| 51663 | 51663 | 224312 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1300 San Jose Ave | 42 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 14 | 6003373.67876 | 2095579.3072 | 37.7342527629625 | -122.43074443020599 | (37.7342527629625, -122.430744430206) | ||||
| 53137 | 53137 | 191990 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1000 Oakdale Ave | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 22 | 6018074.25782 | 2093264.02641 | 37.7287173674097 | -122.379758475681 | (37.7287173674097, -122.379758475681) | ||||
| 56135 | 56135 | 250989 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 401 45th Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | 5981864.98937 | 2112954.2603599997 | 37.7807173939441 | -122.506393608376 | (37.7807173939441, -122.506393608376) | ||||
| 60751 | 60751 | 209139 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 201 Judson Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 15 | Width 10ft | 5998643.81867 | 2093469.90945 | 37.72819174514839 | -122.44694526181001 | (37.7281917451484, -122.44694526181) | |||
| 62844 | 62844 | 191852 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 130 Vermont St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 22 | Width 8ft | 6011081.7581400005 | 2107773.41593 | 37.768168804485605 | -122.404953275984 | (37.7681688044856, -122.404953275984) | |||
| 62987 | 62987 | 209141 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 112 Marston Ave | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 16 | 5998693.6705599995 | 2093224.71233 | 37.7275213392184 | -122.446755287223 | (37.7275213392184, -122.446755287223) | ||||
| 68442 | 68442 | 126585 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 2626 Baker St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 6ft | 5999659.00092 | 2117875.6856 | 37.7952618910822 | -122.445189684462 | (37.7952618910822, -122.445189684462) | |||
| 68826 | 68826 | 209140 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 112 Marston Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 16 | 5998703.32943 | 2093223.9709599998 | 37.727519855354096 | -122.446721843256 | (37.7275198553541, -122.446721843256) | ||||
| 69503 | 69503 | 224311 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1300 San Jose Ave | 41 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 16 | 6003371.63665 | 2095581.9974099998 | 37.7342600339703 | -122.430751682345 | (37.7342600339703, -122.430751682345) | ||||
| 69709 | 69709 | 202108 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1833 Egbert Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 17 | Width 5ft | 6011952.33399 | 2092848.9632599999 | 37.7272381040432 | -122.400893327983 | (37.7272381040432, -122.400893327983) | |||
| 70601 | 70601 | 209051 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1957 11th Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 8ft | 5992829.67425 | 2102278.35273 | 37.7520436256167 | -122.46768514894501 | (37.7520436256167, -122.467685148945) | |||
| 72113 | 72113 | 142421 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 10 MAYFAIR DR | 36 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 0ft | 5997633.2625 | 2114522.3029 | 37.78593856211079 | -122.451956978624 | (37.7859385621108, -122.451956978624) |
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");