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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 684 | 684 | 24323 | Permitted Site 1 | Eucalyptus globulus :: Blue Gum 103 | 600X Golden Gate Ave | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6006332.380890001 | 2112512.31586 | 37.7809140549901 | -122.42171754994101 | (37.7809140549901, -122.421717549941) | |||
| 6891 | 6891 | 7808 | Permitted Site 1 | Eucalyptus globulus :: Blue Gum 103 | 700X Franklin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 4X4 | 6006239.03041 | 2112534.82936 | 37.7809706070447 | -122.422042095466 | (37.7809706070447, -122.422042095466) | |||
| 9488 | 9488 | 17957 | Permitted Site 1 | Eucalyptus globulus :: Blue Gum 103 | 2500 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | 3x3 | 6001928.8852 | 2115030.4127 | 37.7875788082428 | -122.437131721785 | (37.7875788082428, -122.437131721785) | |||
| 18477 | 18477 | 4843 | Permitted Site 1 | Eucalyptus globulus :: Blue Gum 103 | 146 Cortland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 70 | 3X3 | 6006528.82493 | 2097534.91084 | 37.739800668952604 | -122.419974789699 | (37.7398006689526, -122.419974789699) | |||
| 20364 | 20364 | 4837 | Permitted Site 1 | Eucalyptus globulus :: Blue Gum 103 | 127 Cortland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3X3 | 6006404.24922 | 2097646.68025 | 37.7401005434118 | -122.420413452032 | (37.7401005434118, -122.420413452032) | |||
| 42995 | 42995 | 52091 | Permitted Site 1 | Eucalyptus globulus :: Blue Gum 103 | 300 Dorantes Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/24/2005 12:00:00 AM | Permit Number 48287 | 5993176.51233561 | 2099718.04340733 | 37.745033690620396 | -122.46629968747601 | (37.7450336906204, -122.466299687476) | |||
| 48059 | 48059 | 43994 | Permitted Site 1 | Eucalyptus globulus :: Blue Gum 103 | 141 Hampshire St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/08/2000 12:00:00 AM | 18 | Permit Number 43551 | 6010001.85414 | 2107517.13485 | 37.7674046909874 | -122.408670488759 | (37.7674046909874, -122.408670488759) | ||
| 48548 | 48548 | 65198 | Permitted Site 1 | Eucalyptus globulus :: Blue Gum 103 | 371 Madrid St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/29/1989 12:00:00 AM | 34 | Permit Number 27183 | 6003158.74485 | 2091706.4873099998 | 37.7236066919673 | -122.431211180179 | (37.7236066919673, -122.431211180179) | |
| 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) | |||
| 108603 | 108603 | 114396 | Permitted Site 1 | Eucalyptus globulus :: Blue Gum 103 | 35 HIGUERA AVE | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5987903.0 | 2090420.0 | 37.7191979850677 | -122.483852684784 | (37.7191979850677, -122.483852684784) | |||||
| 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) | |||
| 122260 | 122260 | 66251 | Permitted Site 1 | Eucalyptus globulus :: Blue Gum 103 | 35 HIGUERA AVE | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/24/1990 12:00:00 AM | Permit Number 29352 | 5987903.0 | 2090420.0 | 37.7191979850677 | -122.483852684784 | (37.7191979850677, -122.483852684784) | |||
| 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) | |||
| 692 | 692 | 176334 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 287 Hester Ave | 7 | Side Yard : Yard 17 | Tree 1 | Private 1 | 34 | 6012223.87562 | 2087782.5469900002 | 37.713341893097 | -122.399599040764 | (37.713341893097, -122.399599040764) | ||||
| 701 | 701 | 176335 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 287 Hester Ave | 5 | Side Yard : Yard 17 | Tree 1 | Private 1 | 17 | 6012233.93602 | 2087774.2056900002 | 37.7133195503322 | -122.399563683027 | (37.7133195503322, -122.399563683027) | ||||
| 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) | ||||
| 2603 | 2603 | 253136 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 3059 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4x5 | 5999298.0 | 2114593.0 | 37.786227889505604 | -122.446202552789 | (37.7862278895056, -122.446202552789) | ||||
| 3693 | 3693 | 252877 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 1400 Baker St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3x3 | 6000422.0 | 2113928.0 | 37.7844660975886 | -122.442266061376 | (37.7844660975886, -122.442266061376) | ||||
| 3850 | 3850 | 207785 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 290 Santa Clara Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 09/28/2017 12:00:00 AM | 3 | Width 10ft | 5993081.87997 | 2096205.8056700001 | 37.7353845093885 | -122.46637169180299 | (37.7353845093885, -122.466371691803) | ||
| 5068 | 5068 | 253206 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 2253 09th Ave | 3 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | 5993186.0 | 2100608.0 | 37.7474778324271 | -122.466331547971 | (37.7474778324271, -122.466331547971) | ||||
| 23367 | 23367 | 208982 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 320 Santa Clara Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 45 | Width 3ft | 5993096.565780001 | 2095876.3159599998 | 37.7344806601409 | -122.46629697974501 | (37.7344806601409, -122.466296979745) | |||
| 23922 | 23922 | 208951 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 440 Saint Francis Blvd | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 40 | Width 10ft | 5993021.57409 | 2096009.5815299999 | 37.734842246953896 | -122.46656593187099 | (37.7348422469539, -122.466565931871) | |||
| 24218 | 24218 | 208954 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 600 Saint Francis Blvd | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 30 | Width 8ft | 5993495.97502 | 2095994.9515900002 | 37.7348294415148 | -122.464924714122 | (37.7348294415148, -122.464924714122) | |||
| 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) | ||||
| 24602 | 24602 | 208981 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 310 Santa Clara Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 43 | Width 3ft | 5993092.40274 | 2095921.0497 | 37.7346032476459 | -122.466314622626 | (37.7346032476459, -122.466314622626) | |||
| 25657 | 25657 | 208945 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 234 Saint Francis Blvd | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 40 | Width 10ft | 5992554.30272 | 2095990.82137 | 37.73476376044329 | -122.46818007286001 | (37.7347637604433, -122.46818007286) | |||
| 25962 | 25962 | 209036 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 427 Baden St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 41 | 6000750.14831 | 2095370.65935 | 37.7335308771479 | -122.439799837889 | (37.7335308771479, -122.439799837889) | ||||
| 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) | ||||
| 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) | |||
| 26913 | 26913 | 224258 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 355 Buena Vista Ave East | 14 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 21 | Width 3ft | 6001075.26018 | 2107893.8305599997 | 37.7679350014146 | -122.439573286101 | (37.7679350014146, -122.439573286101) | |||
| 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) | ||||
| 26956 | 26956 | 208920 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 135 Saint Francis Blvd | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 10ft | 5992288.77396 | 2096040.55395 | 37.734884974665 | -122.46910170710301 | (37.734884974665, -122.469101707103) | |||
| 27200 | 27200 | 209021 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 34 Martha Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 25 | 6000790.06178 | 2095561.6998400001 | 37.7340577017886 | -122.43967553722 | (37.7340577017886, -122.43967553722) | ||||
| 28258 | 28258 | 208938 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 66 Saint Francis Blvd | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 28 | Width 10ft | 5991979.81471 | 2095977.19537 | 37.7346931510662 | -122.470165265142 | (37.7346931510662, -122.470165265142) | |||
| 28820 | 28820 | 209004 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 156 Kensington Way | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 13 | Width 3ft | 5994803.6888 | 2098556.09355 | 37.7419370183784 | -122.460589057359 | (37.7419370183784, -122.460589057359) | |||
| 28853 | 28853 | 209017 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 33 Martha Ave | 1 | : Yard 23 | Tree 1 | Private 1 | 25 | 6000774.79116 | 2095519.5815700002 | 37.7339411856303 | -122.43972531378401 | (37.7339411856303, -122.439725313784) | ||||
| 29038 | 29038 | 208963 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 90 Yerba Buena Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 30 | Width 6ft | 5993939.166669999 | 2096822.57013 | 37.7371274206966 | -122.463452499655 | (37.7371274206966, -122.463452499655) | |||
| 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) | |||
| 29388 | 29388 | 207794 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 213 Santa Clara Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 19 | Width 10ft | 5993149.25155 | 2096563.99491 | 37.736371894833 | -122.46616478658999 | (37.736371894833, -122.46616478659) | |||
| 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) | ||||
| 30144 | 30144 | 209022 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 34 Martha Ave | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 33 | 6000785.93499 | 2095562.5681900003 | 37.7340598511869 | -122.43968986701401 | (37.7340598511869, -122.439689867014) | ||||
| 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) | |||
| 30943 | 30943 | 208922 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 201 Saint Francis Blvd | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 25 | Width 10ft | 5992403.02946 | 2096048.0013299999 | 37.7349120244605 | -122.46870723116899 | (37.7349120244605, -122.468707231169) | |||
| 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) | ||||
| 32381 | 32381 | 207778 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 124 Santa Clara Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 17 | Width 10ft | 5993200.08857 | 2096786.31561 | 37.7369852648432 | -122.46600517310699 | (37.7369852648432, -122.466005173107) | |||
| 32543 | 32543 | 176345 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 450 Raymond Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 34 | 6008420.88631 | 2088405.51015 | 37.7148397004654 | -122.412787554496 | (37.7148397004654, -122.412787554496) | ||||
| 32753 | 32753 | 224251 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 177 Powhattan Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 21 | Width 3ft | 6008204.54136 | 2098121.72815 | 37.741506207147005 | -122.414222358085 | (37.741506207147, -122.414222358085) | |||
| 33426 | 33426 | 224248 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 512 Clipper St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 27 | Width 5ft | 6001839.26935 | 2100907.02963 | 37.7487943903519 | -122.43643055213998 | (37.7487943903519, -122.43643055214) | |||
| 33664 | 33664 | 207789 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 275 Santa Clara Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 16 | Width 10ft | 5993131.90761 | 2096210.54353 | 37.735400404893 | -122.46619907325199 | (37.735400404893, -122.466199073252) | |||
| 33873 | 33873 | 208955 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 630 Saint Francis Blvd | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 35 | Width 8ft | 5993530.979180001 | 2095998.56422 | 37.7348413791301 | -122.464803955838 | (37.7348413791301, -122.464803955838) | |||
| 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) | |||
| 34595 | 34595 | 209040 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 419 Baden St | 5 | Front Yard : Yard 7 | Tree 1 | Private 1 | 1 | 6000753.71672 | 2095344.13435 | 37.7334582487793 | -122.43978559983 | (37.7334582487793, -122.43978559983) | ||||
| 35228 | 35228 | 209038 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 419 Baden St | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6 | 6000746.779019999 | 2095349.3205099998 | 37.7334720938659 | -122.439809957065 | (37.7334720938659, -122.439809957065) | ||||
| 35692 | 35692 | 209045 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 300 Melrose Ave | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 88 | 5998032.3562900005 | 2095523.6559099997 | 37.733795893852296 | -122.44920699922599 | (37.7337958938523, -122.449206999226) | ||||
| 35751 | 35751 | 224259 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 355 Buena Vista Ave East | 15 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 19 | Width 3ft | 6001093.91519 | 2107903.0746400002 | 37.767961445086605 | -122.43950942341999 | (37.7679614450866, -122.43950942342) | |||
| 36584 | 36584 | 208984 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 354 Santa Clara Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 38 | Width 3ft | 5993109.71634 | 2095669.50335 | 37.7339135629453 | -122.466236489538 | (37.7339135629453, -122.466236489538) | |||
| 36668 | 36668 | 209041 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 419 Baden St | 6 | Front Yard : Yard 7 | Tree 1 | Private 1 | 1 | 6000751.4342 | 2095340.2355900002 | 37.7334474137664 | -122.43979321169901 | (37.7334474137664, -122.439793211699) | ||||
| 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) | |||
| 36877 | 36877 | 138087 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 1611 Octavia St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 30 | Width 0ft | 6004894.5944 | 2114873.9606 | 37.7873173623789 | -122.426859803648 | (37.7873173623789, -122.426859803648) | |||
| 36905 | 36905 | 224255 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 388 Corbett Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 5999122.55283 | 2104753.1321799997 | 37.7592000986313 | -122.446101520571 | (37.7592000986313, -122.446101520571) | |||
| 36907 | 36907 | 208993 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 31 Yerba Buena Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 28 | Width 4ft | 5993535.26127 | 2097150.77507 | 37.7380053101076 | -122.46487280074899 | (37.7380053101076, -122.464872800749) | |||
| 37470 | 37470 | 176346 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 40 Teddy Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 18 | 6011228.44814 | 2087808.7969 | 37.7133584325151 | -122.40304144861 | (37.7133584325151, -122.40304144861) | ||||
| 39683 | 39683 | 191728 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 1790 23rd St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 21 | 6013472.8835 | 2102915.30193 | 37.754962860065 | -122.39634201017999 | (37.754962860065, -122.39634201018) | ||||
| 40168 | 40168 | 208995 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 21 Yerba Buena Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 35 | Width 4ft | 5993486.0432 | 2097190.73028 | 37.7381121792369 | -122.465045871672 | (37.7381121792369, -122.465045871672) | |||
| 40215 | 40215 | 207788 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 285 Santa Clara Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 19 | Width 10ft | 5993135.10109 | 2096167.2284099997 | 37.7352816566244 | -122.46618488553001 | (37.7352816566244, -122.46618488553) | |||
| 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) | |||
| 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) | ||||
| 41245 | 41245 | 138027 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 1631 Octavia St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 39 | Width 0ft | 6004885.3328 | 2114935.3188 | 37.7874853129815 | -122.426896218405 | (37.7874853129815, -122.426896218405) | |||
| 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) | ||||
| 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) | |||
| 41832 | 41832 | 208941 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 130 Saint Francis Blvd | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 30 | Width 10ft | 5992287.573419999 | 2095984.60456 | 37.734731282309106 | -122.469101787134 | (37.7347312823091, -122.469101787134) | |||
| 42046 | 42046 | 209030 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 36 Martha Ave | 7 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5 | 6000755.13076 | 2095576.9220900002 | 37.7340975102859 | -122.439797395328 | (37.7340975102859, -122.439797395328) | ||||
| 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) | ||||
| 43267 | 43267 | 121204 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 44 MacOndray Ln | 1 | Unaccepted Street : Cutout 20 | Tree 1 | Private 1 | 52 | 6008473.20212 | 2119153.5676 | 37.799269800719294 | -122.41478152415002 | (37.7992698007193, -122.41478152415) | ||||
| 43564 | 43564 | 207757 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 95 Kirkham St | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 24 | 5994806.26925 | 2105291.62903 | 37.760431240817795 | -122.46106822873399 | (37.7604312408178, -122.461068228734) | ||||
| 43824 | 43824 | 207767 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 20 Santa Clara Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 26 | Width 10ft | 5993205.662140001 | 2097402.75145 | 37.7386781648646 | -122.466030683288 | (37.7386781648646, -122.466030683288) | |||
| 44163 | 44163 | 224253 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 755 Sanchez St | 6 | Front Yard : Yard 7 | Tree 1 | Private 1 | 28 | Width 3ft | 6003620.8208099995 | 2103873.1752 | 37.757039798462294 | -122.430481566473 | (37.7570397984623, -122.430481566473) | |||
| 44792 | 44792 | 208974 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 130 Yerba Buena Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 25 | Width 6ft | 5994229.97779 | 2096604.2011400003 | 37.7365445844613 | -122.462431207033 | (37.7365445844613, -122.462431207033) | |||
| 45082 | 45082 | 209042 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 419 Baden St | 7 | Front Yard : Yard 7 | Tree 1 | Private 1 | 7 | 6000746.1619 | 2095340.78312 | 37.7334486170489 | -122.439811478728 | (37.7334486170489, -122.439811478728) | ||||
| 45967 | 45967 | 209014 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 412 Baden St | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 7 | 6000787.79858 | 2095464.06576 | 37.733789492485 | -122.43967636459601 | (37.733789492485, -122.439676364596) | ||||
| 46031 | 46031 | 207784 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 270 Santa Clara Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 24 | Width 10ft | 5993081.2153199995 | 2096255.53806 | 37.735521023771604 | -122.466377603044 | (37.7355210237716, -122.466377603044) | |||
| 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) | ||||
| 46778 | 46778 | 209043 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 690 Mangels Ave | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 54 | Width 10ft | 5996832.93686 | 2095303.5906200001 | 37.7331229707542 | -122.453337845278 | (37.7331229707542, -122.453337845278) | |||
| 47668 | 47668 | 208973 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 136 Yerba Buena Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 17 | Width 6ft | 5994259.725980001 | 2096572.0955299998 | 37.7364581434207 | -122.46232602774799 | (37.7364581434207, -122.462326027748) | |||
| 47715 | 47715 | 207770 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 40 Santa Clara Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 35 | Width 10ft | 5993240.61068 | 2097284.1687 | 37.738354582507895 | -122.465901234858 | (37.7383545825079, -122.465901234858) | |||
| 48153 | 48153 | 209013 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 412 Baden St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 20 | 6000780.48794 | 2095392.50815 | 37.7335925958074 | -122.439696511209 | (37.7335925958074, -122.439696511209) | ||||
| 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) | ||||
| 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) | |||
| 50349 | 50349 | 208932 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 435 Saint Francis Blvd | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 47 | Width 10ft | 5992980.53983 | 2096066.6285400002 | 37.734996515770604 | -122.4667119458 | (37.7349965157706, -122.4667119458) | |||
| 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) | ||||
| 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) | ||||
| 51062 | 51062 | 224245 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 160 Coso Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 32 | 6007485.6356 | 2099587.10163 | 37.7454893881214 | -122.41681188667201 | (37.7454893881214, -122.416811886672) | ||||
| 51100 | 51100 | 209006 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 172 Kensington Way | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 21 | Width 3ft | 5994773.63128 | 2098602.47798 | 37.7420626491773 | -122.46069634646099 | (37.7420626491773, -122.460696346461) | |||
| 51382 | 51382 | 207780 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 250 Santa Clara Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 20 | Width 10ft | 5993075.61435 | 2096444.65306 | 37.7360399631594 | -122.46641070800501 | (37.7360399631594, -122.466410708005) |
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");