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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 52437 | 52437 | 232289 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 0 San Jose Av Off Ramp | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | 16 | Width 9ft | 6002953.30911 | 2095259.2744599998 | 37.7333502006365 | -122.43217493415301 | (37.7333502006365, -122.432174934153) | |||
| 36763 | 36763 | 194034 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1 24th St | 18 | : Yard 23 | Tree 1 | Private 1 | 25 | 6017329.2954 | 2102592.85695 | 37.754291333594395 | -122.382982871671 | (37.7542913335944, -122.382982871671) | ||||
| 162377 | 162377 | 194033 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1 24th St | 9 | : Yard 23 | Tree 1 | Private 1 | 18 | 6017162.02159 | 2102667.2446 | 37.7544863425722 | -122.383566530788 | (37.7544863425722, -122.383566530788) | ||||
| 158947 | 158947 | 194032 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1 25th St | 9 | : Yard 23 | Tree 1 | Private 1 | 4 | 6015018.29801 | 2102168.6663599997 | 37.7529986327902 | -122.39094530450599 | (37.7529986327902, -122.390945304506) | ||||
| 32406 | 32406 | 194091 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1 Apparel Way | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 18 | 6011263.07589 | 2097812.25269 | 37.7408277801759 | -122.403625166174 | (37.7408277801759, -122.403625166174) | ||||
| 49273 | 49273 | 194089 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1 Apparel Way | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | 6011234.191000001 | 2097831.41118 | 37.740878771736 | -122.403726387581 | (37.740878771736, -122.403726387581) | ||||
| 180143 | 180143 | 194090 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1 Apparel Way | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 14 | 6011245.93679 | 2097821.82718 | 37.740853112271 | -122.403685100604 | (37.740853112271, -122.403685100604) | ||||
| 177134 | 177134 | 246704 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1 Bonview St | 10 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | 6007707.12573 | 2099125.1145 | 37.7442333302171 | -122.416013295873 | (37.7442333302171, -122.416013295873) | ||||
| 883 | 883 | 251306 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1 Cashmere St | 5 | Back Yard : Yard 13 | Tree 1 | Private 1 | 3x3 | 6017463.0 | 2095772.0 | 37.7355700327415 | -122.382046041696 | (37.7355700327415, -122.382046041696) | ||||
| 885 | 885 | 251305 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1 Cashmere St | 4 | Back Yard : Yard 13 | Tree 1 | Private 1 | 3x3 | 6017463.0 | 2095772.0 | 37.7355700327415 | -122.382046041696 | (37.7355700327415, -122.382046041696) | ||||
| 891 | 891 | 251304 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1 Cashmere St | 3 | Back Yard : Yard 13 | Tree 1 | Private 1 | Health Dept 5 | 3x3 | 6017463.0 | 2095772.0 | 37.7355700327415 | -122.382046041696 | (37.7355700327415, -122.382046041696) | |||
| 188301 | 188301 | 232288 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1 Day St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6005609.575130001 | 2098736.17342 | 37.7430472314506 | -122.423238540044 | (37.7430472314506, -122.423238540044) | |||
| 95589 | 95589 | 119627 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1 El Sereno Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5999504.0 | 2097253.0 | 37.738628328633396 | -122.44424333392901 | (37.7386283286334, -122.444243333929) | ||||
| 148347 | 148347 | 194063 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1 Flower St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 19 | Width 4ft | 6010838.1657 | 2098339.02807 | 37.7422504473898 | -122.40513143798599 | (37.7422504473898, -122.405131437986) | |||
| 107126 | 107126 | 85498 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 1 Nebraska St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6009335.0 | 2098038.0 | 37.7413397420659 | -122.410307693317 | (37.7413397420659, -122.410307693317) | |||||
| 119719 | 119719 | 85507 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 1 Nebraska St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | Permit Number 49678 | 6009335.0 | 2098038.0 | 37.7413397420659 | -122.410307693317 | (37.7413397420659, -122.410307693317) | ||||
| 34540 | 34540 | 177827 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 10 Brotherhood Way | 5 | : 4 | Tree 1 | Private 1 | 22 | Width 0ft | 5993584.63921 | 2087685.0546799998 | 37.712017594599295 | -122.46401514608 | (37.7120175945993, -122.46401514608) | |||
| 70361 | 70361 | 177828 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 10 Brotherhood Way | 6 | : 4 | Tree 1 | Private 1 | 20 | Width 0ft | 5993567.2586900005 | 2087687.58972 | 37.712023553524205 | -122.464075401566 | (37.7120235535242, -122.464075401566) | |||
| 166693 | 166693 | 194049 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 100 Hampshire St | 6 | Front Yard : Yard 7 | Tree 1 | Private 1 | 8 | 6009981.034030001 | 2107543.0973799997 | 37.76747481202629 | -122.40874433479999 | (37.7674748120263, -122.4087443348) | ||||
| 11842 | 11842 | 19713 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 100 STAIRWAY13 | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 40ST | ||||||||
| 12182 | 12182 | 19712 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 100 STAIRWAY13 | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 40ST | ||||||||
| 14544 | 14544 | 19711 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 100 STAIRWAY13 | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 40ST | ||||||||
| 11201 | 11201 | 19747 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 100 STAIRWAY15 | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 10ST | ||||||||
| 14337 | 14337 | 19746 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 100 STAIRWAY15 | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 3X3 | ||||||||
| 16592 | 16592 | 19752 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 100 STAIRWAY15 | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 10ST | ||||||||
| 13008 | 13008 | 19766 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 100 STAIRWAY16 | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 30ST | ||||||||
| 15820 | 15820 | 19764 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 100 STAIRWAY16 | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 30ST | ||||||||
| 136262 | 136262 | 177829 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 100 Trumbull St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 26 | Width 4ft | 6003826.80299 | 2094267.18245 | 37.7306756258798 | -122.429084311385 | (37.7306756258798, -122.429084311385) | |||
| 137153 | 137153 | 177830 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 100 Trumbull St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 31 | Width 3ft | 6003869.42584 | 2094268.83295 | 37.7306825704475 | -122.42893707528201 | (37.7306825704475, -122.428937075282) | |||
| 161127 | 161127 | 177831 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 100 Trumbull St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 33 | Width 3ft | 6003962.8397 | 2094273.86284 | 37.730701668441895 | -122.428614487595 | (37.7307016684419, -122.428614487595) | |||
| 109844 | 109844 | 105371 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 100 WESTGATE DR | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | 3x3 | 5993373.5 | 2093728.3 | 37.7285987139119 | -122.465183566455 | (37.7285987139119, -122.465183566455) | |||
| 867 | 867 | 5563 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 1000 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 35 | 3 | 6005047.93676 | 2102495.8008 | 37.753338590028 | -122.42544803402399 | (37.753338590028, -122.425448034024) | |||
| 17849 | 17849 | 26939 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 1000 Dolores St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 35 | 3 | 6005048.52765 | 2102486.42553 | 37.7533128811044 | -122.42544532345501 | (37.7533128811044, -122.425445323455) | |||
| 168273 | 168273 | 232298 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1000 Dolores St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 2ft | 6005049.6768 | 2102466.11465 | 37.7532571770826 | -122.425439904132 | (37.7532571770826, -122.425439904132) | |||
| 74822 | 74822 | 194102 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1000 Oakdale Ave | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | 6018083.18788 | 2093260.00153 | 37.7287068084484 | -122.379727324058 | (37.7287068084484, -122.379727324058) | ||||
| 12286 | 12286 | 97316 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 1000 Taraval St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | 3x3 | 5990092.4633 | 2099074.5321 | 37.7430883471851 | -122.47691665284201 | (37.7430883471851, -122.476916652842) | |||
| 20958 | 20958 | 3909 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 1000X 14th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6002142.832230001 | 2107666.80115 | 37.7673723370035 | -122.43586443430901 | (37.7673723370035, -122.435864434309) | |||
| 78781 | 78781 | 121184 | Significant Tree 6 | Myoporum laetum :: Myoporum 1 | 1000x Duncan St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 775289 | 5999834.0 | 2099740.0 | 37.7454758595085 | -122.44328093408899 | (37.7454758595085, -122.443280934089) | |||
| 79242 | 79242 | 121190 | Significant Tree 6 | Myoporum laetum :: Myoporum 1 | 1000x Duncan St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 775289 | 5999834.0 | 2099740.0 | 37.7454758595085 | -122.44328093408899 | (37.7454758595085, -122.443280934089) | |||
| 80352 | 80352 | 121187 | Significant Tree 6 | Myoporum laetum :: Myoporum 1 | 1000x Duncan St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 775289 | 5999834.0 | 2099740.0 | 37.7454758595085 | -122.44328093408899 | (37.7454758595085, -122.443280934089) | |||
| 89056 | 89056 | 121188 | Significant Tree 6 | Myoporum laetum :: Myoporum 1 | 1000x Duncan St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 775289 | 5999834.0 | 2099740.0 | 37.7454758595085 | -122.44328093408899 | (37.7454758595085, -122.443280934089) | |||
| 90930 | 90930 | 121191 | Significant Tree 6 | Myoporum laetum :: Myoporum 1 | 1000x Duncan St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 775289 | 5999834.0 | 2099740.0 | 37.7454758595085 | -122.44328093408899 | (37.7454758595085, -122.443280934089) | |||
| 91506 | 91506 | 121193 | Significant Tree 6 | Myoporum laetum :: Myoporum 1 | 1000x Duncan St | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 775289 | 5999834.0 | 2099740.0 | 37.7454758595085 | -122.44328093408899 | (37.7454758595085, -122.443280934089) | |||
| 95270 | 95270 | 121186 | Significant Tree 6 | Myoporum laetum :: Myoporum 1 | 1000x Duncan St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 775289 | 5999834.0 | 2099740.0 | 37.7454758595085 | -122.44328093408899 | (37.7454758595085, -122.443280934089) | |||
| 100978 | 100978 | 121192 | Significant Tree 6 | Myoporum laetum :: Myoporum 1 | 1000x Duncan St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 775289 | 5999834.0 | 2099740.0 | 37.7454758595085 | -122.44328093408899 | (37.7454758595085, -122.443280934089) | |||
| 102605 | 102605 | 121181 | Significant Tree 6 | Myoporum laetum :: Myoporum 1 | 1000x Duncan St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 775289 | 5999834.0 | 2099740.0 | 37.7454758595085 | -122.44328093408899 | (37.7454758595085, -122.443280934089) | |||
| 104617 | 104617 | 121185 | Significant Tree 6 | Myoporum laetum :: Myoporum 1 | 1000x Duncan St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 775289 | 5999834.0 | 2099740.0 | 37.7454758595085 | -122.44328093408899 | (37.7454758595085, -122.443280934089) | |||
| 104788 | 104788 | 121183 | Significant Tree 6 | Myoporum laetum :: Myoporum 1 | 1000x Duncan St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 775289 | 5999834.0 | 2099740.0 | 37.7454758595085 | -122.44328093408899 | (37.7454758595085, -122.443280934089) | |||
| 123005 | 123005 | 121182 | Significant Tree 6 | Myoporum laetum :: Myoporum 1 | 1000x Duncan St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 775289 | 5999834.0 | 2099740.0 | 37.7454758595085 | -122.44328093408899 | (37.7454758595085, -122.443280934089) | |||
| 18158 | 18158 | 96243 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 100X 27th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3x3 | 6005866.5 | 2100251.5 | 37.7472224703829 | -122.42245781101299 | (37.7472224703829, -122.422457811013) | |||
| 91357 | 91357 | 49091 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 101 Athens St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 46240 | 6005012.04174128 | 2092633.4383737 | 37.7262567475706 | -122.424870568097 | (37.7262567475706, -122.424870568097) | ||||
| 113123 | 113123 | 49092 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 101 Athens St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 46240 | 6005012.04174128 | 2092633.4383737 | 37.7262567475706 | -122.424870568097 | (37.7262567475706, -122.424870568097) | ||||
| 108771 | 108771 | 114774 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 101 FREDERICK ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/23/2016 12:00:00 AM | 3 | 3x3 | 5999527.0 | 2107685.0 | 37.7672733650738 | -122.444913510993 | (37.7672733650738, -122.444913510993) | ||
| 114117 | 114117 | 114775 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 101 FREDERICK ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 30 | 3x3 | 5999527.0 | 2107685.0 | 37.7672733650738 | -122.444913510993 | (37.7672733650738, -122.444913510993) | |||
| 123166 | 123166 | 105073 | Significant Tree 6 | Myoporum laetum :: Myoporum 1 | 101 LUNDYS LN | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 18 | 6006875.0 | 2098969.0 | 37.7437578546964 | -122.41887954343599 | (37.7437578546964, -122.418879543436) | ||||
| 133646 | 133646 | 194053 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 101 Patterson St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 16 | Width 5ft | 6010891.45102 | 2098447.80375 | 37.7425521007081 | -122.40495484979999 | (37.7425521007081, -122.4049548498) | |||
| 137102 | 137102 | 194052 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 101 Patterson St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 19 | Width 5ft | 6010878.398080001 | 2098425.29219 | 37.7424895591595 | -122.404998398575 | (37.7424895591595, -122.404998398575) | |||
| 183762 | 183762 | 232287 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 101 Webster St | 1 | : 4 | Tree 1 | Private 1 | 18 | Width 3ft | 6004240.14437 | 2109135.1756700003 | 37.7715230535659 | -122.42871480966801 | (37.7715230535659, -122.428714809668) | |||
| 158968 | 158968 | 232309 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1012 Shrader St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | Width 3ft | 5997674.44536 | 2107027.2087 | 37.7653613359944 | -122.45127375459101 | (37.7653613359944, -122.451273754591) | |||
| 187126 | 187126 | 142895 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1015 DIVISADERO ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 26 | Width 0ft | 6000919.8741 | 2115393.3679 | 37.788517982728294 | -122.440648735369 | (37.7885179827283, -122.440648735369) | |||
| 1011 | 1011 | 232310 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 1018 Shrader St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/18/2016 12:00:00 AM | 26 | Width 3ft | Permit Number 17854 | 5997696.0 | 2107004.0 | 37.7652988449505 | -122.451197528579 | (37.7652988449505, -122.451197528579) | |
| 87521 | 87521 | 58634 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 1018 Shrader St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/18/2016 12:00:00 AM | 3 | 4x4 | Permit Number 17854 | 5997674.48741574 | 2107055.11858465 | 37.765437971850794 | -122.45127562216999 | (37.7654379718508, -122.45127562217) | |
| 92497 | 92497 | 99770 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1025x Douglass St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 595 Clipper St is true property address | 6001337.9 | 2100792.7 | 37.7484519666196 | -122.438156093062 | (37.7484519666196, -122.438156093062) | |||
| 11179 | 11179 | 97318 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 1026 Taraval St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | 3x3 | 5989977.5691 | 2099069.2019 | 37.7430670461122 | -122.477313532312 | (37.7430670461122, -122.477313532312) | |||
| 25950 | 25950 | 232321 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1027 Douglass St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 6001337.57778 | 2100767.91475 | 37.7483838939011 | -122.43815543204201 | (37.7483838939011, -122.438155432042) | |||
| 164341 | 164341 | 232320 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1027 Douglass St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 3ft | 6001339.44236 | 2100715.1600200003 | 37.74823914801971 | -122.438145205836 | (37.7482391480197, -122.438145205836) | |||
| 113873 | 113873 | 61358 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 1029 Douglass St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/14/1984 12:00:00 AM | Permit Number 21266 | 6001344.49519126 | 2100781.43952904 | 37.7484214231354 | -122.438132480542 | (37.7484214231354, -122.438132480542) | |||
| 153525 | 153525 | 232319 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1029 Douglass St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 3ft | 6001340.20421 | 2100694.82389 | 37.748183353177 | -122.438141114822 | (37.748183353177, -122.438141114822) | |||
| 40576 | 40576 | 177849 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 104 Woolsey St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 21 | 6011561.92381 | 2092191.20992 | 37.7254102643617 | -122.40219675676799 | (37.7254102643617, -122.402196756768) | ||||
| 154276 | 154276 | 182080 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1041 Taraval St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 5989949.2263 | 2099002.1098 | 37.7428811840861 | -122.477406630563 | (37.7428811840861, -122.477406630563) | |||
| 141137 | 141137 | 101256 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1049 Irving St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/08/2015 12:00:00 AM | 3x3 | 5992548.0 | 2106581.0 | 37.763841302397104 | -122.46897230376699 | (37.7638413023971, -122.468972303767) | |||
| 142212 | 142212 | 101257 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1049 Irving St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5992548.0 | 2106581.0 | 37.763841302397104 | -122.46897230376699 | (37.7638413023971, -122.468972303767) | ||||
| 160287 | 160287 | 248281 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 105 Lundy's Ln | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 20 | Width 5ft | 6006851.95643 | 2098931.00797 | 37.7436522395523 | -122.418956528726 | (37.7436522395523, -122.418956528726) | |||
| 47816 | 47816 | 210501 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 105 Upland Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 5993140.2263400005 | 2094328.28998 | 37.73023268367729 | -122.46603358088899 | (37.7302326836773, -122.466033580889) | |||
| 73143 | 73143 | 210502 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 105 Upland Dr | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5993378.93248 | 2094262.38115 | 37.7300654826285 | -122.46520356329201 | (37.7300654826285, -122.465203563292) | |||
| 16910 | 16910 | 7017 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 1055 Fell St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6002366.0432 | 2110180.0215 | 37.774285696400206 | -122.435272167554 | (37.7742856964002, -122.435272167554) | |||
| 11098 | 11098 | 64696 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 1055 Taraval St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/13/1988 12:00:00 AM | 6 | 3x3 | Permit Number 25639 | 5989879.8498 | 2099000.4177 | 37.742872512219 | -122.47764638889299 | (37.742872512219, -122.477646388893) | |
| 158794 | 158794 | 97321 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 1055 Taraval St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/13/1988 12:00:00 AM | 9 | 3x3 | 5989897.1093 | 2098999.7408 | 37.7428716552125 | -122.477586661544 | (37.7428716552125, -122.477586661544) | ||
| 99055 | 99055 | 98374 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 106 De Soto St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5993231.0 | 2091825.0 | 37.7233644995117 | -122.465537980019 | (37.7233644995117, -122.465537980019) | |||||
| 105502 | 105502 | 98375 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 106 De Soto St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5993231.0 | 2091825.0 | 37.7233644995117 | -122.465537980019 | (37.7233644995117, -122.465537980019) | |||||
| 23093 | 23093 | 26475 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 106 Gold Mine Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 19 | 3X3 | 6001338.90016 | 2098832.9571 | 37.7430710337942 | -122.438012277952 | (37.7430710337942, -122.438012277952) | |||
| 30894 | 30894 | 200231 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1079 Ingerson Ave | 5 | unknown : Yard 19 | Tree 1 | Private 1 | 5 | Width 0ft | 6013732.1076 | 2090145.865 | 37.719915054156296 | -122.39455141525299 | (37.7199150541563, -122.394551415253) | |||
| 138059 | 138059 | 200229 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1079 Ingerson Ave | 3 | unknown : Yard 19 | Tree 1 | Private 1 | 4 | Width 0ft | 6013701.2545 | 2090170.6816 | 37.719981480300795 | -122.39465980145201 | (37.7199814803008, -122.394659801452) | |||
| 154193 | 154193 | 232299 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 108 Valley St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 26 | Width 4ft | 6005119.98151 | 2099339.98705 | 37.7446775233394 | -122.424974374591 | (37.7446775233394, -122.424974374591) | |||
| 25169 | 25169 | 232371 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 109 Frederick St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5999451.75369 | 2107695.0323799998 | 37.767296616782396 | -122.44517449760001 | (37.7672966167824, -122.4451744976) | |||
| 92138 | 92138 | 101902 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 1100 Ocean Ave | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | Permit Number 769623 | 5996507.7 | 2092470.2 | 37.7253245106519 | -122.454257683967 | (37.7253245106519, -122.454257683967) | ||||
| 27451 | 27451 | 232290 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1100 San Jose Ave | 34 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 9ft | 6004782.10663 | 2096684.4357 | 37.737366892177704 | -122.425953683239 | (37.7373668921777, -122.425953683239) | |||
| 163978 | 163978 | 232291 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1100 San Jose Ave | 35 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 9ft | 6004778.102000001 | 2096680.6709599998 | 37.737356328728104 | -122.42596726120001 | (37.7373563287281, -122.4259672612) | |||
| 9880 | 9880 | 3771 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 1100X Carolina St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 18 | 18 | 6012538.0 | 2102781.0 | 37.75454202913279 | -122.39956569430599 | (37.7545420291328, -122.399565694306) | |||
| 147673 | 147673 | 194031 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1101 25th St | 7 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 22 | Width 9ft | 6015324.74216 | 2102030.33526 | 37.7526358040022 | -122.38987589096901 | (37.7526358040022, -122.389875890969) | |||
| 163213 | 163213 | 131758 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1109 Jones St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 4ft | 6008573.70037 | 2116368.91585 | 37.791629479864795 | -122.414236639307 | (37.7916294798648, -122.414236639307) | |||
| 10258 | 10258 | 173932 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1109x Alemany Blvd | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6003491.0 | 2094313.0 | 37.7307824159859 | -122.430248501015 | (37.7307824159859, -122.430248501015) | |||||
| 10036 | 10036 | 64803 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 110X VALLEY ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/24/2017 12:00:00 AM | 3 | Permit Number 779438 | 6005124.0 | 2099350.0 | 37.7447052436017 | -122.424961191686 | (37.7447052436017, -122.424961191686) | |
| 159088 | 159088 | 245127 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 112 Lyon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 6000343.614 | 2109412.9845 | 37.772064548609706 | -122.442213026376 | (37.7720645486097, -122.442213026376) | |||
| 72039 | 72039 | 182081 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1123 Taraval St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 5989680.5886 | 2098998.5521 | 37.742855824264204 | -122.47833523450899 | (37.7428558242642, -122.478335234509) | |||
| 127843 | 127843 | 97325 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 1123 Taraval St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/04/2007 12:00:00 AM | 15 | 3x3 | 5989733.4 | 2098972.0 | 37.7427859847726 | -122.478150688587 | (37.7427859847726, -122.478150688587) | ||
| 123302 | 123302 | 182084 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1143 Taraval St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 0ft | 5989609.7892 | 2098992.9724 | 37.7428363935584 | -122.478579628348 | (37.7428363935584, -122.478579628348) | |||
| 88219 | 88219 | 2210 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 1145 Broderick St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6000813.81573 | 2112576.3555400004 | 37.7807771513392 | -122.44081352531 | (37.7807771513392, -122.44081352531) | |||
| 147756 | 147756 | 124340 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 115 Palm Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 4ft | 5995872.99304 | 2113646.8815099997 | 37.7834339079411 | -122.457983613293 | (37.7834339079411, -122.457983613293) | |||
| 78648 | 78648 | 112011 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 115 Red Rock Way | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | 6000032.1 | 2099934.7 | 37.7460217534147 | -122.442609914587 | (37.7460217534147, -122.442609914587) |
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");