Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, qCareAssistant, PlantDate, PlotSize, PermitNotes
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress ▼ | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 54108 | 54108 | 176348 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 0 Fuente Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 26 | 5989603.79735 | 2090546.09261 | 37.7196430676648 | -122.47798295295799 | (37.7196430676648, -122.477982952958) | ||||
| 887 | 887 | 251303 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 1 Cashmere St | 2 | Back Yard : Yard 13 | Tree 1 | Health Dept 8 | 3x3 | 6017463.0 | 2095772.0 | 37.7355700327415 | -122.382046041696 | (37.7355700327415, -122.382046041696) | ||||
| 896 | 896 | 251302 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 1 Cashmere St | 1 | Back Yard : Yard 13 | Tree 1 | Health Dept 8 | 3x3 | 6017463.0 | 2095772.0 | 37.7355700327415 | -122.382046041696 | (37.7355700327415, -122.382046041696) | ||||
| 19068 | 19068 | 26911 | DPW Maintained 3 | Eucalyptus globulus :: Blue Gum 103 | 10 Caine Ave | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 18 | 10 | 5997609.86555 | 2089654.4499099997 | 37.7176562610968 | -122.450244747607 | (37.7176562610968, -122.450244747607) | |||
| 78601 | 78601 | 92035 | Permitted Site 1 | Eucalyptus globulus :: Blue Gum 103 | 10 Elk St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 52176 | 5999970.9 | 2097826.1 | 37.7402285519688 | -122.44267015975201 | (37.7402285519688, -122.442670159752) | |||
| 89710 | 89710 | 92040 | Permitted Site 1 | Eucalyptus globulus :: Blue Gum 103 | 10 Elk St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 52176 | 5999970.9 | 2097826.1 | 37.7402285519688 | -122.44267015975201 | (37.7402285519688, -122.442670159752) | |||
| 95756 | 95756 | 92036 | Permitted Site 1 | Eucalyptus globulus :: Blue Gum 103 | 10 Elk St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 52176 | 5999970.9 | 2097826.1 | 37.7402285519688 | -122.44267015975201 | (37.7402285519688, -122.442670159752) | |||
| 97794 | 97794 | 92038 | Permitted Site 1 | Eucalyptus globulus :: Blue Gum 103 | 10 Elk St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 52176 | 5999970.9 | 2097826.1 | 37.7402285519688 | -122.44267015975201 | (37.7402285519688, -122.442670159752) | |||
| 115215 | 115215 | 92034 | Permitted Site 1 | Eucalyptus globulus :: Blue Gum 103 | 10 Elk St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 52176 | 5999970.9 | 2097826.1 | 37.7402285519688 | -122.44267015975201 | (37.7402285519688, -122.442670159752) | |||
| 116196 | 116196 | 92033 | Permitted Site 1 | Eucalyptus globulus :: Blue Gum 103 | 10 Elk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 52176 | 5999970.9 | 2097826.1 | 37.7402285519688 | -122.44267015975201 | (37.7402285519688, -122.442670159752) | |||
| 121824 | 121824 | 92039 | Permitted Site 1 | Eucalyptus globulus :: Blue Gum 103 | 10 Elk St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 52176 | 5999970.9 | 2097826.1 | 37.7402285519688 | -122.44267015975201 | (37.7402285519688, -122.442670159752) | |||
| 128237 | 128237 | 92037 | Permitted Site 1 | Eucalyptus globulus :: Blue Gum 103 | 10 Elk St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 52176 | 5999970.9 | 2097826.1 | 37.7402285519688 | -122.44267015975201 | (37.7402285519688, -122.442670159752) | |||
| 52160 | 52160 | 208998 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 10 Yerba Buena Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 33 | Width 4ft | 5993381.76992 | 2097221.25805 | 37.7381899876824 | -122.465408610532 | (37.7381899876824, -122.465408610532) | |||
| 75055 | 75055 | 208997 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 10 Yerba Buena Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 31 | Width 4ft | 5993343.646380001 | 2097250.7379 | 37.738268733207605 | -122.465542562746 | (37.7382687332076, -122.465542562746) | |||
| 77037 | 77037 | 208999 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 10 Yerba Buena Ave | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 33 | Width 4ft | 5993404.322790001 | 2097201.32336 | 37.7381365526709 | -122.465329186907 | (37.7381365526709, -122.465329186907) | |||
| 50757 | 50757 | 191735 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 100 Hampshire St | 8 | Front Yard : Yard 7 | Tree 1 | Private 1 | 27 | 6010009.096969999 | 2107534.42743 | 37.7674525780981 | -122.408646656734 | (37.7674525780981, -122.408646656734) | ||||
| 70209 | 70209 | 191734 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 100 Hampshire St | 7 | Front Yard : Yard 7 | Tree 1 | Private 1 | 22 | 6009976.801940001 | 2107534.39117 | 37.767450669731105 | -122.40875835881201 | (37.7674506697311, -122.408758358812) | ||||
| 134906 | 134906 | 191730 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 100 Hampshire St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 24 | 6009966.3806300005 | 2107638.17528 | 37.767735053365705 | -122.40880172773399 | (37.7677350533657, -122.408801727734) | ||||
| 158665 | 158665 | 191729 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 100 Hampshire St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 24 | 6009963.10998 | 2107668.13664 | 37.7678171371844 | -122.408815154618 | (37.7678171371844, -122.408815154618) | ||||
| 159705 | 159705 | 191732 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 100 Hampshire St | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | 18 | 6009982.19315 | 2107558.06249 | 37.7675159677065 | -122.408741381426 | (37.7675159677065, -122.408741381426) | ||||
| 164405 | 164405 | 191733 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 100 Hampshire St | 5 | Front Yard : Yard 7 | Tree 1 | Private 1 | 25 | 6009990.5053900005 | 2107548.56259 | 37.7674903487254 | -122.408711960091 | (37.7674903487254, -122.408711960091) | ||||
| 185592 | 185592 | 191731 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 100 Hampshire St | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 24 | 6009975.967759999 | 2107617.96239 | 37.76768009039721 | -122.408767140702 | (37.7676800903972, -122.408767140702) | ||||
| 1070 | 1070 | 19942 | DPW Maintained 3 | Eucalyptus globulus :: Blue Gum 103 | 100 STAIRWAY38 | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 10ST | ||||||||
| 7805 | 7805 | 19939 | DPW Maintained 3 | Eucalyptus globulus :: Blue Gum 103 | 100 STAIRWAY38 | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 10ST | ||||||||
| 8002 | 8002 | 19938 | DPW Maintained 3 | Eucalyptus globulus :: Blue Gum 103 | 100 STAIRWAY38 | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 10ST | ||||||||
| 14348 | 14348 | 19941 | DPW Maintained 3 | Eucalyptus globulus :: Blue Gum 103 | 100 STAIRWAY38 | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 10ST | ||||||||
| 14547 | 14547 | 19940 | DPW Maintained 3 | Eucalyptus globulus :: Blue Gum 103 | 100 STAIRWAY38 | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 10ST | ||||||||
| 6027 | 6027 | 20016 | DPW Maintained 3 | Eucalyptus globulus :: Blue Gum 103 | 100 STAIRWAY48 | 0 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 10ST | ||||||||
| 8496 | 8496 | 20017 | DPW Maintained 3 | Eucalyptus globulus :: Blue Gum 103 | 100 STAIRWAY48 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 10ST | ||||||||
| 26365 | 26365 | 208940 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 100 Saint Francis Blvd | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 37 | Width 10ft | 5992201.32921 | 2095978.5342700002 | 37.7347096311457 | -122.469399518468 | (37.7347096311457, -122.469399518468) | |||
| 185411 | 185411 | 208939 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 100 Saint Francis Blvd | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 33 | Width 10ft | 5992155.70572 | 2095974.23732 | 37.7346951961161 | -122.469556940308 | (37.7346951961161, -122.469556940308) | |||
| 36761 | 36761 | 208976 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 100 Yerba Buena Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 24 | Width 6ft | 5994151.01662 | 2096664.6627200001 | 37.7367060496466 | -122.462708592139 | (37.7367060496466, -122.462708592139) | |||
| 160755 | 160755 | 208975 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 100 Yerba Buena Ave | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 31 | Width 6ft | 5994177.11325 | 2096643.32557 | 37.7366489660835 | -122.462616818123 | (37.7366489660835, -122.462616818123) | |||
| 177154 | 177154 | 224221 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 1000 San Jose Ave | 63 | Front Yard : Yard 7 | Tree 1 | Private 1 | 15 | 6005093.2410699995 | 2097044.1609999998 | 37.7383721957242 | -122.424903531393 | (37.7383721957242, -122.424903531393) | ||||
| 154149 | 154149 | 201514 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 1001 Innes Ave | 12 | Front Yard : Yard 7 | Tree 1 | Private 1 | 75 | 6018663.55815 | 2094844.4948099998 | 37.733089515074795 | -122.377830854436 | (37.7330895150748, -122.377830854436) | ||||
| 172222 | 172222 | 201510 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 1001 Innes Ave | 8 | Front Yard : Yard 7 | Tree 1 | Private 1 | 38 | 6018594.17439 | 2094891.11142 | 37.73321369166371 | -122.378073969944 | (37.7332136916637, -122.378073969944) | ||||
| 28512 | 28512 | 176338 | DPW Maintained 3 | Eucalyptus globulus :: Blue Gum 103 | 100x Mansell St | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 5 | Width 0ft | 6011479.2515 | 2090641.1055 | 37.721149380822 | -122.402373605767 | (37.721149380822, -122.402373605767) | |||
| 38393 | 38393 | 176339 | DPW Maintained 3 | Eucalyptus globulus :: Blue Gum 103 | 100x Mansell St | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 26 | Width 0ft | 6011461.59774 | 2090655.36204 | 37.7211875408569 | -122.402435631998 | (37.7211875408569, -122.402435631998) | |||
| 47690 | 47690 | 176337 | DPW Maintained 3 | Eucalyptus globulus :: Blue Gum 103 | 100x Mansell St | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 59 | Width 0ft | 6011478.9031 | 2090656.6645400003 | 37.72119208331829 | -122.40237590353901 | (37.7211920833183, -122.402375903539) | |||
| 171841 | 171841 | 176342 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 101 Mansell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 3ft | 6011455.5144 | 2090588.63485 | 37.721003982019504 | -122.40245197087799 | (37.7210039820195, -122.402451970878) | |||
| 49984 | 49984 | 208918 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 101 Saint Francis Blvd | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 35 | Width 10ft | 5992207.01448 | 2096041.6179 | 37.7348831715052 | -122.46938445304899 | (37.7348831715052, -122.469384453049) | |||
| 74311 | 74311 | 208919 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 101 Saint Francis Blvd | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 38 | Width 10ft | 5992247.91507 | 2096042.0705099998 | 37.734886777797996 | -122.469243079632 | (37.734886777798, -122.469243079632) | |||
| 137770 | 137770 | 208917 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 101 Saint Francis Blvd | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 41 | Width 10ft | 5992152.90186 | 2096040.12972 | 37.734875958047496 | -122.46957142927499 | (37.7348759580475, -122.469571429275) | |||
| 34400 | 34400 | 207800 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 101 Santa Clara Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 42 | Width 10ft | 5993292.571380001 | 2096874.95335 | 37.737233976861205 | -122.465691859205 | (37.7372339768612, -122.465691859205) | |||
| 40777 | 40777 | 207799 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 101 Santa Clara Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 30 | Width 10ft | 5993278.012180001 | 2096833.03373 | 37.7371180362587 | -122.465739151856 | (37.7371180362587, -122.465739151856) | |||
| 165361 | 165361 | 207798 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 101 Santa Clara Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 41 | Width 10ft | 5993265.61107 | 2096796.17632 | 37.7370161196856 | -122.465779350629 | (37.7370161196856, -122.465779350629) | |||
| 3884 | 3884 | 20320 | DPW Maintained 3 | Eucalyptus globulus :: Blue Gum 103 | 101X Sunset Blvd | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 42 | 60 | ||||||||
| 6772 | 6772 | 20314 | DPW Maintained 3 | Eucalyptus globulus :: Blue Gum 103 | 101X Sunset Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 42 | 60 | ||||||||
| 12003 | 12003 | 20316 | DPW Maintained 3 | Eucalyptus globulus :: Blue Gum 103 | 101X Sunset Blvd | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 42 | 60 | ||||||||
| 16276 | 16276 | 20315 | DPW Maintained 3 | Eucalyptus globulus :: Blue Gum 103 | 101X Sunset Blvd | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 42 | 60 | ||||||||
| 17047 | 17047 | 20318 | DPW Maintained 3 | Eucalyptus globulus :: Blue Gum 103 | 101X Sunset Blvd | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 36 | 60 | ||||||||
| 17109 | 17109 | 20319 | DPW Maintained 3 | Eucalyptus globulus :: Blue Gum 103 | 101X Sunset Blvd | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 36 | 60 | ||||||||
| 183364 | 183364 | 247818 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 1058 Jarboe Ave | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 46 | 6009634.533480001 | 2096844.3676599998 | 37.738079072495395 | -122.409187798594 | (37.7380790724954, -122.409187798594) | ||||
| 25982 | 25982 | 247919 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 1098 Esmeralda Ave | 4 | Side Yard : Yard 17 | Tree 1 | Private 1 | 22 | 6010242.48982 | 2098715.3752200003 | 37.743250496220895 | -122.40721763491001 | (37.7432504962209, -122.40721763491) | ||||
| 30032 | 30032 | 247924 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 1098 Esmeralda Ave | 9 | Side Yard : Yard 17 | Tree 1 | Private 1 | 23 | 6010297.695230001 | 2098727.78354 | 37.7432876562154 | -122.40702762254499 | (37.7432876562154, -122.407027622545) | ||||
| 46194 | 46194 | 247925 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 1098 Esmeralda Ave | 10 | Side Yard : Yard 17 | Tree 1 | Private 1 | 25 | 6010304.27631 | 2098731.76841 | 37.743298966077795 | -122.407005147582 | (37.7432989660778, -122.407005147582) | ||||
| 59867 | 59867 | 247926 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 1098 Esmeralda Ave | 11 | Side Yard : Yard 17 | Tree 1 | Private 1 | 27 | 6010312.05046 | 2098736.31721 | 37.743311891127604 | -122.406978587005 | (37.7433118911276, -122.406978587005) | ||||
| 62115 | 62115 | 247923 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 1098 Esmeralda Ave | 8 | Side Yard : Yard 17 | Tree 1 | Private 1 | 17 | 6010288.87158 | 2098729.72842 | 37.7432925026595 | -122.40705826963699 | (37.7432925026595, -122.407058269637) | ||||
| 70884 | 70884 | 247927 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 1098 Esmeralda Ave | 12 | Side Yard : Yard 17 | Tree 1 | Private 1 | 34 | 6010318.55961 | 2098736.7728 | 37.7433135063186 | -122.40695611204501 | (37.7433135063186, -122.406956112045) | ||||
| 147007 | 147007 | 247922 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 1098 Esmeralda Ave | 7 | Side Yard : Yard 17 | Tree 1 | Private 1 | 24 | 6010270.948580001 | 2098720.09099 | 37.7432650373678 | -122.40711956383001 | (37.7432650373678, -122.40711956383) | ||||
| 150294 | 150294 | 247917 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 1098 Esmeralda Ave | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 32 | 6010231.88216 | 2098716.76824 | 37.7432537274832 | -122.407254411775 | (37.7432537274832, -122.407254411775) | ||||
| 169544 | 169544 | 247921 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 1098 Esmeralda Ave | 6 | Side Yard : Yard 17 | Tree 1 | Private 1 | 38 | 6010260.8237 | 2098716.17835 | 37.7432537274883 | -122.407154297447 | (37.7432537274883, -122.407154297447) | ||||
| 24579 | 24579 | 247929 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 1099 Esmeralda Ave | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 37 | 6010384.7561099995 | 2098766.60945 | 37.743399135274295 | -122.40672932282301 | (37.7433991352743, -122.406729322823) | ||||
| 31541 | 31541 | 247930 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 1099 Esmeralda Ave | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 18 | 6010384.98383 | 2098777.78466 | 37.7434298327179 | -122.406729322818 | (37.7434298327179, -122.406729322818) | ||||
| 74012 | 74012 | 247935 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 1099 Esmeralda Ave | 8 | Side Yard : Yard 17 | Tree 1 | Private 1 | 31 | 6010295.56922 | 2098768.42696 | 37.743399135252204 | -122.407037837932 | (37.7433991352522, -122.407037837932) | ||||
| 166763 | 166763 | 247928 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 1099 Esmeralda Ave | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 22 | 6010393.74755 | 2098772.89885 | 37.7434169076795 | -122.406698675702 | (37.7434169076795, -122.406698675702) | ||||
| 181095 | 181095 | 247932 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 1099 Esmeralda Ave | 5 | Side Yard : Yard 17 | Tree 1 | Private 1 | 11 | 6010369.906140001 | 2098762.7933799997 | 37.743387826290395 | -122.406780401602 | (37.7433878262904, -122.406780401602) | ||||
| 69421 | 69421 | 224263 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 11 Germania St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6004229.44428 | 2108900.2308400003 | 37.770877346636205 | -122.42873507047399 | (37.7708773466362, -122.428735070474) | |||
| 186323 | 186323 | 224264 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 11 Germania St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6004254.57068 | 2108904.38845 | 37.770890184456796 | -122.42864845406 | (37.7708901844568, -122.42864845406) | |||
| 73251 | 73251 | 208996 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 11 Yerba Buena Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 29 | Width 4ft | 5993421.96829 | 2097241.5815 | 37.7382481090644 | -122.465271101502 | (37.7382481090644, -122.465271101502) | |||
| 30634 | 30634 | 207776 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 110 Santa Clara Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 17 | Width 10ft | 5993235.98614 | 2096867.2882599998 | 37.7372096663776 | -122.46588694193001 | (37.7372096663776, -122.46588694193) | |||
| 41418 | 41418 | 207775 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 110 Santa Clara Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 27 | Width 10ft | 5993244.34274 | 2096906.29835 | 37.737317260394 | -122.465860883191 | (37.737317260394, -122.465860883191) | |||
| 43077 | 43077 | 191722 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 1100 25th St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 18 | 6014479.640380001 | 2101959.5389 | 37.752394509601494 | -122.392793471535 | (37.7523945096015, -122.392793471535) | ||||
| 26944 | 26944 | 224225 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 1100 San Jose Ave | 15 | Front Yard : Yard 7 | Tree 1 | Private 1 | 32 | 6004862.254919999 | 2096710.90423 | 37.737444098063 | -122.42567845649201 | (37.737444098063, -122.425678456492) | ||||
| 41213 | 41213 | 224227 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 1100 San Jose Ave | 17 | Front Yard : Yard 7 | Tree 1 | Private 1 | 12 | 6004843.36157 | 2096707.31423 | 37.7374331731056 | -122.425743524245 | (37.7374331731056, -122.425743524245) | ||||
| 41325 | 41325 | 224244 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 1100 San Jose Ave | 38 | Front Yard : Yard 7 | Tree 1 | Private 1 | 23 | 6004777.47133 | 2096641.4622900002 | 37.73724863492671 | -122.425966651467 | (37.7372486349267, -122.425966651467) | ||||
| 48572 | 48572 | 224238 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 1100 San Jose Ave | 30 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6 | 6004809.6017 | 2096680.0059200001 | 37.737356282853 | -122.425858304718 | (37.737356282853, -122.425858304718) | ||||
| 50832 | 50832 | 224239 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 1100 San Jose Ave | 36 | Front Yard : Yard 7 | Tree 1 | Private 1 | 37 | 6004801.05123 | 2096666.83115 | 37.7373196246961 | -122.425886930149 | (37.7373196246961, -122.425886930149) | ||||
| 61204 | 61204 | 224222 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 1100 San Jose Ave | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 14 | 6004869.898159999 | 2096730.73115 | 37.7374989702074 | -122.42565344095199 | (37.7374989702074, -122.425653440952) | ||||
| 61471 | 61471 | 224223 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 1100 San Jose Ave | 13 | Front Yard : Yard 7 | Tree 1 | Private 1 | 21 | 6004855.412690001 | 2096718.43509 | 37.7374643894683 | -122.425702649156 | (37.7374643894683, -122.425702649156) | ||||
| 61748 | 61748 | 224243 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 1100 San Jose Ave | 39 | Front Yard : Yard 7 | Tree 1 | Private 1 | 20 | 6004771.77471 | 2096643.7523700001 | 37.737254601020005 | -122.425986510284 | (37.73725460102, -122.425986510284) | ||||
| 63465 | 63465 | 224224 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 1100 San Jose Ave | 14 | Front Yard : Yard 7 | Tree 1 | Private 1 | 18 | 6004854.036780001 | 2096713.3958700001 | 37.737450475157296 | -122.42570704776199 | (37.7374504751573, -122.425707047762) | ||||
| 63720 | 63720 | 224229 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 1100 San Jose Ave | 19 | Front Yard : Yard 7 | Tree 1 | Private 1 | 14 | 6004833.29966 | 2096702.67223 | 37.7374198586269 | -122.425777982686 | (37.7374198586269, -122.425777982686) | ||||
| 63892 | 63892 | 224237 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 1100 San Jose Ave | 29 | Front Yard : Yard 7 | Tree 1 | Private 1 | 19 | 6004814.56562 | 2096681.78705 | 37.7373614539559 | -122.425841268876 | (37.7373614539559, -122.425841268876) | ||||
| 68974 | 68974 | 224228 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 1100 San Jose Ave | 18 | Front Yard : Yard 7 | Tree 1 | Private 1 | 15 | 6004840.27089 | 2096702.3446900002 | 37.7374193532181 | -122.425753856564 | (37.7374193532181, -122.425753856564) | ||||
| 124116 | 124116 | 224234 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 1100 San Jose Ave | 24 | Front Yard : Yard 7 | Tree 1 | Private 1 | 13 | 6004836.880530001 | 2096694.1378 | 37.7373966273622 | -122.425764994654 | (37.7373966273622, -122.425764994654) | ||||
| 133399 | 133399 | 224230 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 1100 San Jose Ave | 20 | Front Yard : Yard 7 | Tree 1 | Private 1 | 9 | 6004850.154069999 | 2096702.7007099998 | 37.7374208892559 | -122.425719711103 | (37.7374208892559, -122.425719711103) | ||||
| 135102 | 135102 | 224232 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 1100 San Jose Ave | 22 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6 | 6004847.66693 | 2096700.7431599998 | 37.7374153737207 | -122.425728171024 | (37.7374153737207, -122.425728171024) | ||||
| 135905 | 135905 | 224240 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 1100 San Jose Ave | 42 | Front Yard : Yard 7 | Tree 1 | Private 1 | 36 | 6004759.95311 | 2096625.2597 | 37.7372031562031 | -122.426026066958 | (37.7372031562031, -122.426026066958) | ||||
| 136867 | 136867 | 224241 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 1100 San Jose Ave | 41 | Front Yard : Yard 7 | Tree 1 | Private 1 | 15 | 6004764.42793 | 2096634.9587599998 | 37.7372300405369 | -122.42601128568998 | (37.7372300405369, -122.42601128569) | ||||
| 155920 | 155920 | 224236 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 1100 San Jose Ave | 26 | Front Yard : Yard 7 | Tree 1 | Private 1 | 25 | 6004818.97924 | 2096691.85028 | 37.737389334736 | -122.425826725021 | (37.737389334736, -122.425826725021) | ||||
| 162554 | 162554 | 224231 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 1100 San Jose Ave | 21 | Front Yard : Yard 7 | Tree 1 | Private 1 | 23 | 6004851.9976 | 2096696.37519 | 37.7374036249796 | -122.42571288706301 | (37.7374036249796, -122.425712887063) | ||||
| 178073 | 178073 | 224242 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 1100 San Jose Ave | 40 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5 | 6004773.2240699995 | 2096631.25513 | 37.7372203683314 | -122.425980609816 | (37.7372203683314, -122.425980609816) | ||||
| 179858 | 179858 | 224235 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 1100 San Jose Ave | 25 | Front Yard : Yard 7 | Tree 1 | Private 1 | 17 | 6004831.6413199995 | 2096688.95275 | 37.7373820943173 | -122.425782740103 | (37.7373820943173, -122.425782740103) | ||||
| 181562 | 181562 | 224233 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 1100 San Jose Ave | 23 | Front Yard : Yard 7 | Tree 1 | Private 1 | 22 | 6004845.23458 | 2096693.0180000002 | 37.737394024725205 | -122.42573603111 | (37.7373940247252, -122.42573603111) | ||||
| 181724 | 181724 | 224226 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 1100 San Jose Ave | 16 | Front Yard : Yard 7 | Tree 1 | Private 1 | 13 | 6004846.937969999 | 2096712.6297900002 | 37.7374479705325 | -122.42573153718 | (37.7374479705325, -122.42573153718) | ||||
| 56692 | 56692 | 247937 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 1149 Esmeralda Ave | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 24 | 6010236.06133 | 2098747.86868 | 37.7433393564296 | -122.40724215312599 | (37.7433393564296, -122.407242153126) | ||||
| 29186 | 29186 | 209002 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 115 Yerba Buena Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 36 | Width 4ft | 5994119.61861 | 2096725.9639 | 37.736872559114104 | -122.462821593742 | (37.7368725591141, -122.462821593742) | |||
| 173688 | 173688 | 191721 | DPW Maintained 3 | Eucalyptus globulus :: Blue Gum 103 | 1150x Tennessee St | 7 | Median : Yard 3 | Tree 1 | DPW 2 | 50 | 6015559.12531 | 2103608.85918 | 37.75698309171089 | -122.389175557402 | (37.7569830917109, -122.389175557402) | ||||
| 10119 | 10119 | 173856 | DPW Maintained 3 | Eucalyptus globulus :: Blue Gum 103 | 118 Saint Mary's Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | DPW 2 | Width 3ft | 6003956.18287 | 2095944.61673 | 37.735288805319904 | -122.42875656067 | (37.7352888053199, -122.42875656067) |
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");