trees

7,157 rows where qSpecies_id = 36 sorted by TreeID

✎ View and edit SQL

This data as json, CSV (advanced)

rowid TreeID ▼ qLegalStatus_id qSpecies_id qAddress SiteOrder qSiteInfo PlantType qCaretaker_id qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location Fire Prevention Districts Police Districts Supervisor Districts Zip Codes Neighborhoods (old)
79602 102925 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 1461 Pine St 3 Sidewalk: Curb side : Cutout Tree Private 2   03/12/2013 12:00:00 AM 2 3x3 Permit Number 769193 6006968.60659 2115679.26963 37.7896455916283 -122.419741305022 (37.7896455916283, -122.419741305022) 13 9 10 28858 21
165206 102926 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 1461 Pine St 4 Sidewalk: Curb side : Cutout Tree Private 2   03/12/2013 12:00:00 AM 2 3x3 Permit Number 769193 6006985.25286 2115680.45015 37.7896497707556 -122.419683794298 (37.7896497707556, -122.419683794298) 13 9 10 28858 21
189358 103035 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 147 07th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     12 3x3   5993637.70862 2114534.07495 37.7857412186942 -122.465781241486 (37.7857412186942, -122.465781241486) 11 6 2 54 11
179026 103140 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 2955 Pierce St 1 Sidewalk: Curb side : Cutout Tree Private 2     12 5x6   6001459.04133 2118628.63612 37.7974318760394 -122.439015258551 (37.7974318760394, -122.439015258551) 13 9 1 57 17
91830 103141 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 2953 Pierce St 1 Sidewalk: Curb side : Cutout Tree Private 2     12 4x5   6001463.20474 2118596.68178 37.7973443746971 -122.438998560856 (37.7973443746971, -122.438998560856) 13 9 1 57 17
30763 103142 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 2925 Pierce St 1 Sidewalk: Curb side : Cutout Tree Private 2     18 5x6   6001475.42368 2118512.20554 37.7971131203233 -122.438950223183 (37.7971131203233, -122.438950223183) 13 9 1 57 17
189001 103249 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 2659 Green St 1 Sidewalk: Curb side : Cutout Tree Private 2     12 3x3   6000303.19114 2117809.86382 37.79511791052 -122.442955960953 (37.79511791052, -122.442955960953) 13 9 1 57 27
23792 103250 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 2659 Green St 2 Sidewalk: Curb side : Cutout Tree Private 2     10 3x3   6000309.96771 2117811.76496 37.7951235169026 -122.442932649645 (37.7951235169026, -122.442932649645) 13 9 1 57 27
135104 103251 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 2659 Green St 3 Sidewalk: Curb side : Cutout Tree Private 2     10 3x3   6000320.25805 2117813.59346 37.7951291241572 -122.442897174967 (37.7951291241572, -122.442897174967) 13 9 1 57 27
175118 103274 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 55 Waterville St 1 Sidewalk: Curb side : Cutout Tree Private 2   03/28/2013 12:00:00 AM 3 3x3 Permit Number 770098 6011488.19627 2095796.38903 37.7353052188485 -122.402705048216 (37.7353052188485, -122.402705048216) 10 3 8 58 1
144756 10328 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 820 Haight St 2 Sidewalk: Curb side : Cutout Tree Private 2     20 3X3   6002200.749 2109167.913 37.7714973097013 -122.435771521087 (37.7714973097013, -122.435771521087) 15 5 11 29492 9
61146 103459 Permitted Site 7 Pittosporum undulatum :: Victorian Box 36 1028 Sacramento St 2 Sidewalk: Curb side : Cutout Tree Private 2   05/15/2013 12:00:00 AM   3x3 Permit Number 770176 6009851 2116823 37.7929479491773 -122.409849243387 (37.7929479491773, -122.409849243387) 3 1 10 28857 21
78391 103491 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 2601 Vallejo St 4 Sidewalk: Curb side : Cutout Tree Private 2   05/14/2013 12:00:00 AM 3 3x3 Permit Number 770190 6001073.64785 2117573.06263 37.794511612778 -122.440273079139 (37.794511612778, -122.440273079139) 13 9 1 57 27
159658 103492 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 2601 Vallejo St 5 Sidewalk: Curb side : Cutout Tree Private 2   05/14/2013 12:00:00 AM 3 3x3 Permit Number 770190 6001089.77016 2117573.6035 37.7945140157724 -122.440217332873 (37.7945140157724, -122.440217332873) 13 9 1 57 27
141731 103495 Undocumented 4 Pittosporum undulatum :: Victorian Box 36 141 Marview Way 1 Sidewalk: Curb side : Cutout Tree Private 2     13 3x3 Permit Number 770303 5998318.6 2103174 37.7548182509721 -122.448768222318 (37.7548182509721, -122.448768222318) 1 5 4 63 38
24675 103503 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 1028 Sacramento St 1 Sidewalk: Curb side : Cutout Tree Private 2     6 3x3   6009840.22204 2116824.48974 37.7929514356157 -122.409886641058 (37.7929514356157, -122.409886641058) 3 1 10 28857 21
186206 103529 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 23 Ervine St 1 Sidewalk: Curb side : Cutout Tree Private 2     6     6009696.39175 2089318.75297 37.7174187879145 -122.408443235483 (37.7174187879145, -122.408443235483) 9 7 8 309 39
143723 103544 Undocumented 4 Pittosporum undulatum :: Victorian Box 36 905X Phelps St 1 Sidewalk: Property side : Cutout Tree Private 2     10 6x12   6014832.8 2097357.7 37.7397784309436 -122.39125052869 (37.7397784309436, -122.39125052869) 10 3 8 58 1
188603 103545 Undocumented 4 Pittosporum undulatum :: Victorian Box 36 905X Phelps St 2 Sidewalk: Property side : Cutout Tree Private 2     10 6x12   6014832.8 2097357.7 37.7397784309436 -122.39125052869 (37.7397784309436, -122.39125052869) 10 3 8 58 1
75842 103617 Significant Tree 6 Pittosporum undulatum :: Victorian Box 36 201X Haight St 2 Sidewalk: Property side : Yard Tree Private 2           6004725 2109149 37.7715884407354 -122.427038651796 (37.7715884407354, -122.427038651796) 7 9 11 28852 10
95437 103618 Significant Tree 6 Pittosporum undulatum :: Victorian Box 36 201X Haight St 3 Sidewalk: Property side : Yard Tree Private 2           6004725 2109149 37.7715884407354 -122.427038651796 (37.7715884407354, -122.427038651796) 7 9 11 28852 10
9190 103620 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 132 10th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     19 6x8   5992751.57388 2114579.30418 37.7858142507268 -122.468850281745 (37.7858142507268, -122.468850281745) 11 6 2 54 11
110087 103646 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 172 07th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     19 6x9   5993691.62049 2114431.87897 37.7854637260822 -122.4655872961 (37.7854637260822, -122.4655872961) 11 6 2 54 11
18953 103670 Undocumented 4 Pittosporum undulatum :: Victorian Box 36 4428-4430 17th St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   5 3x3 Permit Number 770987 6000065 2105781 37.7620761444221 -122.442915908064 (37.7620761444221, -122.442915908064) 15 5 5 28862 3
37279 104067 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 590 19th Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     10 6x6   5990047.19427 2111365.95474 37.776834675693 -122.477971573004 (37.776834675693, -122.477971573004) 11 6 2 55 26
22882 104175 Undocumented 4 Pittosporum undulatum :: Victorian Box 36 636-640 14TH ST 1 Sidewalk: Curb side : Cutout Tree Private 2     8 3x3   6004572 2107817 37.7679224380491 -122.427472979212 (37.7679224380491, -122.427472979212) 8 4 5 28862 3
180189 104176 Undocumented 4 Pittosporum undulatum :: Victorian Box 36 636-640 14TH ST 1 Sidewalk: Curb side : Cutout Tree Private 2     8 3x3   6004572 2107817 37.7679224380491 -122.427472979212 (37.7679224380491, -122.427472979212) 8 4 5 28862 3
124529 104177 Undocumented 4 Pittosporum undulatum :: Victorian Box 36 636-640 14TH ST 2 Sidewalk: Curb side : Cutout Tree Private 2     2 3x3   6004572 2107817 37.7679224380491 -122.427472979212 (37.7679224380491, -122.427472979212) 8 4 5 28862 3
66711 104407 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 2601 Broadway 2 Sidewalk: Curb side : Cutout Tree Private 2   10/02/2013 12:00:00 AM 4   Permit Number 770702 6001060.93215 2117212.93468 37.7935220716505 -122.440291238273 (37.7935220716505, -122.440291238273) 13 9 1 29490 27
90369 104408 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 2601 Broadway 3 Sidewalk: Curb side : Cutout Tree Private 2   10/02/2013 12:00:00 AM 4   Permit Number 770702 6001074.76991 2117214.52254 37.7935272193468 -122.440243472573 (37.7935272193468, -122.440243472573) 13 9 1 29490 27
83393 104409 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 2601 Broadway 4 Sidewalk: Curb side : Cutout Tree Private 2   10/02/2013 12:00:00 AM 5   Permit Number 770702 6001086.06637 2117214.60045 37.7935280764126 -122.440204391613 (37.7935280764126, -122.440204391613) 13 9 1 29490 27
136622 104410 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 2601 Broadway 5 Sidewalk: Curb side : Cutout Tree Private 2   10/02/2013 12:00:00 AM 5   Permit Number 770702 6001110.58636 2117216.90392 37.7935357971 -122.440119715967 (37.7935357971, -122.440119715967) 13 9 1 29490 27
75421 104411 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 2601 Broadway 6 Sidewalk: Curb side : Cutout Tree Private 2   10/02/2013 12:00:00 AM 6   Permit Number 770702 6001134.17208 2117219.53924 37.7935443757141 -122.440038296751 (37.7935443757141, -122.440038296751) 13 9 1 29490 27
136140 104412 Permitted Site 7 Pittosporum undulatum :: Victorian Box 36 2601 Broadway 7 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 770702 6001104.6 2117191.9 37.7934668020598 -122.440138635367 (37.7934668020598, -122.440138635367) 13 6 1 29490 27
145975 104414 Permitted Site 7 Pittosporum undulatum :: Victorian Box 36 2545X Scott St 2 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 770702 6001211.96275 2117087.23286 37.7931855250671 -122.439759645381 (37.7931855250671, -122.439759645381) 13 6 1 29490 27
37758 104438 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 1919 Broderick St 1 Sidewalk: Curb side : Cutout Tree Private 2     8 6x12   6000436.16515 2115404.26145 37.7885203364851 -122.442323071177 (37.7885203364851, -122.442323071177) 13 6 1 29490 27
65618 104440 Permitted Site 7 Pittosporum undulatum :: Victorian Box 36 200X Chattanooga St 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3 Permit Number 770343 6004765.42963 2102220.02594 37.7525654108037 -122.426405368946 (37.7525654108037, -122.426405368946) 2 4 5 28862 22
84220 104654 Significant Tree 6 Pittosporum undulatum :: Victorian Box 36 352-354 Coleridge St 1 Front Yard : Yard Tree Private 2         Permit Number 768244 6006091.8 2098091.1 37.7413032079582 -122.421525330669 (37.7413032079582, -122.421525330669) 2 7 7 28859 2
24833 104679 Significant Tree 6 Pittosporum undulatum :: Victorian Box 36 33 08th St 1 Front Yard : Yard Tree Private 2         Permit Number 770764 6008457.3 2111569.1 37.7784438055662 -122.414299630615 (37.7784438055662, -122.414299630615) 8 2 9 28853 34
64486 104680 Significant Tree 6 Pittosporum undulatum :: Victorian Box 36 33 08th St 2 Front Yard : Yard Tree Private 2         Permit Number 770764 6008457.3 2111569.1 37.7784438055662 -122.414299630615 (37.7784438055662, -122.414299630615) 8 2 9 28853 34
104445 104681 Significant Tree 6 Pittosporum undulatum :: Victorian Box 36 33 08th St 3 Front Yard : Yard Tree Private 2         Permit Number 770764 6008457.3 2111569.1 37.7784438055662 -122.414299630615 (37.7784438055662, -122.414299630615) 8 2 9 28853 34
43381 104682 Significant Tree 6 Pittosporum undulatum :: Victorian Box 36 33 08th St 4 Front Yard : Yard Tree Private 2         Permit Number 770764 6008457.3 2111569.1 37.7784438055662 -122.414299630615 (37.7784438055662, -122.414299630615) 8 2 9 28853 34
47325 104683 Significant Tree 6 Pittosporum undulatum :: Victorian Box 36 33 08th St 5 Front Yard : Yard Tree Private 2         Permit Number 770764 6008457.3 2111569.1 37.7784438055662 -122.414299630615 (37.7784438055662, -122.414299630615) 8 2 9 28853 34
148345 104684 Significant Tree 6 Pittosporum undulatum :: Victorian Box 36 33 08th St 6 Front Yard : Yard Tree Private 2         Permit Number 770764 6008457.3 2111569.1 37.7784438055662 -122.414299630615 (37.7784438055662, -122.414299630615) 8 2 9 28853 34
19958 104685 Significant Tree 6 Pittosporum undulatum :: Victorian Box 36 33 08th St 7 Front Yard : Yard Tree Private 2         Permit Number 770764 6008457.3 2111569.1 37.7784438055662 -122.414299630615 (37.7784438055662, -122.414299630615) 8 2 9 28853 34
22849 104752 Undocumented 4 Pittosporum undulatum :: Victorian Box 36 1547 Alabama St 1 Sidewalk: Curb side : Cutout Tree Private 2     8 6x7.5 Expanded basin to a 6x7.5 6009347 2100236 37.7473756401997 -122.410421366201 (37.7473756401997, -122.410421366201) 2 7 7 28859 2
188866 104754 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 50 Walnut St 1 Sidewalk: Curb side : Cutout Tree Private 2   09/28/2018 12:00:00 AM 3 3x3 Permit Number 781111 5998483.43829 2116249.0389 37.7907283825673 -122.449140058165 (37.7907283825673, -122.449140058165) 13 6 1 54 31
78022 104755 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 50 Walnut St 2 Sidewalk: Curb side : Cutout Tree Private 2     12 3x3 Permit Number 781111 5998481.68854 2116256.67872 37.7907492594091 -122.449146662803 (37.7907492594091, -122.449146662803) 13 6 1 54 31
155797 104756 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 50 Walnut St 3 Sidewalk: Curb side : Cutout Tree Private 2     13 3x3   5998478.12993 2116269.10777 37.7907831827466 -122.449159871157 (37.7907831827466, -122.449159871157) 13 6 1 54 31
142711 104757 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 50 Walnut St 4 Sidewalk: Curb side : Cutout Tree Private 2     11 3x3 Permit Number 770671 5998472.8958 2116292.739 37.7908477684628 -122.449179684098 (37.7908477684628, -122.449179684098) 13 6 1 54 31
190979 104758 Undocumented 4 Pittosporum undulatum :: Victorian Box 36 50 Walnut St 5 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5998501.2 2116298 37.790863832623 -122.449082132455 (37.790863832623, -122.449082132455) 13 6 1 54 31
131197 104759 Undocumented 4 Pittosporum undulatum :: Victorian Box 36 3296X Jackson St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5998712.875 2116239.5889 37.7907155553239 -122.448345541495 (37.7907155553239, -122.448345541495) 13 6 1 54 31
169151 104760 Undocumented 4 Pittosporum undulatum :: Victorian Box 36 3296X Jackson St 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5998712.875 2116239.5889 37.7907155553239 -122.448345541495 (37.7907155553239, -122.448345541495) 13 6 1 54 31
88562 104781 Permitted Site 7 Pittosporum undulatum :: Victorian Box 36 162 Clipper St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/14/2013 12:00:00 AM   3x3 Permit Number 770184 6004075 2101047.4 37.7493066009479 -122.428709408465 (37.7493066009479, -122.428709408465) 2 4 5 28862 22
68310 104784 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 50 Walnut St 6 Sidewalk: Curb side : Cutout Tree Private 2     14 3x3   5998470.92552 2116324.14308 37.7909338830388 -122.449188764564 (37.7909338830388, -122.449188764564) 13 6 1 54 31
55614 104904 Significant Tree 6 Pittosporum undulatum :: Victorian Box 36 417 Gonzalez Dr 1 Front Yard : Yard Tree Private 2           5990435 2090585 37.7197981072685 -122.475112652722 (37.7197981072685, -122.475112652722) 1 8 4 64 40
125330 104932 Significant Tree 6 Pittosporum undulatum :: Victorian Box 36 717 Gonzalez Dr 1 Front Yard : Yard Tree Private 2           5990427 2090598 37.7198333383806 -122.475141254145 (37.7198333383806, -122.475141254145) 1 8 4 64 40
181383 104933 Significant Tree 6 Pittosporum undulatum :: Victorian Box 36 755 Gonzalez Dr 1 Front Yard : Yard Tree Private 2           5990427 2090598 37.7198333383806 -122.475141254145 (37.7198333383806, -122.475141254145) 1 8 4 64 40
167034 10495 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 1701 Haight St 1 Sidewalk: Curb side : Cutout Tree Private 2     90 3x3   5997835.7259 2108510.475 37.7694432404816 -122.450822883239 (37.7694432404816, -122.450822883239) 15 5 11 29492 9
188766 104984 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 246 Ritch St 1 Sidewalk: Curb side : Cutout Tree Private 2   12/02/2013 12:00:00 AM 3   Permit Number 58498 6013841.69397 2112138.93882 37.780309438982 -122.395712786018 (37.780309438982, -122.395712786018) 6 2 9 28856 34
57369 104985 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 246 Ritch St 2 Sidewalk: Curb side : Cutout Tree Private 2   12/02/2013 12:00:00 AM 3 3x3 Permit Number 58498 6013853.79601 2112123.83329 37.7802686358384 -122.395669860472 (37.7802686358384, -122.395669860472) 6 2 9 28856 34
14544 105135 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 175X ESMERALDA AVE 1 unknown : Yard Tree DPW 1     26     6007213 2098808 37.7433348108676 -122.417699407763 (37.7433348108676, -122.417699407763) 2 7 7 28859 2
20096 105204 Undocumented 4 Pittosporum undulatum :: Victorian Box 36 251 MISSOURI ST 1 Sidewalk: Curb side : Cutout Tree Private 2     22 5x 6 Permit Number 770827 6013514.6 2105914.7 37.763200874456 -122.396407965734 (37.763200874456, -122.396407965734) 14 3 8 28856 29
142322 105313 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 111 12th Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     14 3x3   5992082.39186 2114666.93966 37.786016189943 -122.471171829359 (37.786016189943, -122.471171829359) 11 6 2 54 11
178594 105314 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 111 12th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     12 3x3   5992082.47647 2114684.30503 37.7860638753414 -122.471172802257 (37.7860638753414, -122.471172802257) 11 6 2 54 11
178746 105440 Undocumented 4 Pittosporum undulatum :: Victorian Box 36 606 NOE ST 1 Sidewalk: Curb side : Cutout Tree Private 2     13 6x9   6003362.3 2098210.5 37.7414767713792 -122.430971495561 (37.7414767713792, -122.430971495561) 2 7 5 63 7
151563 105464 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 2200 Larkin St 2 Sidewalk: Curb side : Cutout Tree Private 2     11     6006821.65374 2118818.27853 37.7982562476961 -122.420472652592 (37.7982562476961, -122.420472652592) 5 9 10 28858 32
160506 105465 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 2200 Larkin St 3 Sidewalk: Curb side : Cutout Tree Private 2     9     6006816.21458 2118838.71454 37.7983120533164 -122.420492925119 (37.7983120533164, -122.420492925119) 5 9 10 28858 32
62097 1055 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 2048 Alemany Blvd 1 Sidewalk: Curb side : Cutout Tree DPW 1     20 3X3   6000420.28016 2090223.93091 37.7193803613008 -122.44057126285 (37.7193803613008, -122.44057126285) 9 7 6 28861 25
23766 105500 Undocumented 4 Pittosporum undulatum :: Victorian Box 36 3929 19TH ST 2 Sidewalk: Curb side : Cutout Tree Private 2     12 3x3   6003450.9 2104734.8 37.7593959875427 -122.431130714429 (37.7593959875427, -122.431130714429) 2 4 5 28862 3
119056 105696 Permitted Site 7 Pittosporum undulatum :: Victorian Box 36 324 Maple St   Sidewalk: Curb side : Cutout Tree Private 2       5X4.7 Permit Number 772550 5996728 2115070.1 37.7873907738138 -122.45512851997 (37.7873907738138, -122.45512851997) 11 6 1 54 31
150632 10571 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 1627X Alemany Blvd 3 Sidewalk: Curb side : Cutout Tree DPW 1     15 3X3   6001710.57045 2092579.82288 37.7259225000291 -122.436279728401 (37.7259225000291, -122.436279728401) 9 7 6 28861 25
127371 105801 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 571 02nd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     15 5x9   5995294.01171 2111682.80981 37.778007809231 -122.459844330573 (37.778007809231, -122.459844330573) 11 6 2 54 11
132968 105802 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 2550 Fulton St 3 Sidewalk: Curb side : Cutout Tree Private 2     20 6x9   5995439.69423 2110335.70003 37.7743173788567 -122.459242790784 (37.7743173788567, -122.459242790784) 11 6 2 54 11
7926 105855 Undocumented 4 Pittosporum undulatum :: Victorian Box 36 4X Duncan St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6006273.18234 2099962.59464 37.746452135478 -122.421031022521 (37.746452135478, -122.421031022521) 2 7 7 28859 2
167207 105856 Undocumented 4 Pittosporum undulatum :: Victorian Box 36 26X Duncan St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6006273.18234 2099962.59464 37.746452135478 -122.421031022521 (37.746452135478, -122.421031022521) 2 7 7 28859 2
182948 105860 Significant Tree 6 Pittosporum undulatum :: Victorian Box 36 3615-3623X Cesar Chavez St 1 Front Yard : Yard Tree Private 2           6005538 2100417 37.7476583584974 -122.423605504909 (37.7476583584974, -122.423605504909) 2 7 5 28859 22
22846 105861 Significant Tree 6 Pittosporum undulatum :: Victorian Box 36 3615-3623X Cesar Chavez St 2 Front Yard : Yard Tree Private 2           6005538 2100417 37.7476583584974 -122.423605504909 (37.7476583584974, -122.423605504909) 2 7 5 28859 22
75419 105862 Significant Tree 6 Pittosporum undulatum :: Victorian Box 36 3615-3623X Cesar Chavez St 3 Front Yard : Yard Tree Private 2           6005538 2100417 37.7476583584974 -122.423605504909 (37.7476583584974, -122.423605504909) 2 7 5 28859 22
23771 105863 Significant Tree 6 Pittosporum undulatum :: Victorian Box 36 3615-3623X Cesar Chavez St 4 Front Yard : Yard Tree Private 2           6005538 2100417 37.7476583584974 -122.423605504909 (37.7476583584974, -122.423605504909) 2 7 5 28859 22
35675 105864 Significant Tree 6 Pittosporum undulatum :: Victorian Box 36 3615-3623X Cesar Chavez St 5 Front Yard : Yard Tree Private 2           6005538 2100417 37.7476583584974 -122.423605504909 (37.7476583584974, -122.423605504909) 2 7 5 28859 22
126862 105865 Significant Tree 6 Pittosporum undulatum :: Victorian Box 36 3615-3623X Cesar Chavez St 6 Front Yard : Yard Tree Private 2           6005538 2100417 37.7476583584974 -122.423605504909 (37.7476583584974, -122.423605504909) 2 7 5 28859 22
161345 106209 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 585X Bush St 7 Sidewalk: Curb side : Cutout Tree MTA 3     16 3x16   6010847.77195 2115873.69146 37.7903971865333 -122.406333425049 (37.7903971865333, -122.406333425049) 5 1 10 28857 6
72326 106243 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 580 De Haro St 6 Sidewalk: Property side : Yard Tree Private 2     3   Permit Number 770844 6012044.67282 2105739.34228 37.7626374729575 -122.401479659865 (37.7626374729575, -122.401479659865) 8 3 8 28856 29
41899 106286 Undocumented 4 Pittosporum undulatum :: Victorian Box 36 1600X Clay St 3 Sidewalk: Curb side : Cutout Tree Private 2           6007107 2116756 37.7926098218975 -122.419338891627 (37.7926098218975, -122.419338891627) 5 9 10 28858 32
69079 10633 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 830 Hayes St 2 Sidewalk: Curb side : Cutout Tree DPW 1   10/24/2012 12:00:00 AM 3 3X3   6003876.660435 2110789.6935297 37.7760453753156 -122.430090168762 (37.7760453753156, -122.430090168762) 7 9 11 29492 10
60220 10635 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 840 Hayes St 1 Sidewalk: Curb side : Cutout Tree DPW 1   10/24/2012 12:00:00 AM 3 3X3   6003802.20017 2110804.91092 37.776082941088 -122.430348832427 (37.776082941088, -122.430348832427) 7 9 11 29492 10
32599 106351 Undocumented 4 Pittosporum undulatum :: Victorian Box 36 100 PUTNAM ST 1 Sidewalk: Curb side : Cutout Tree Private 2     12 3x3   6009115.8 2096842.2 37.7380440457606 -122.410981172443 (37.7380440457606, -122.410981172443) 10 7 7 28859 2
86766 106352 Undocumented 4 Pittosporum undulatum :: Victorian Box 36 100 PUTNAM ST 2 Sidewalk: Curb side : Cutout Tree Private 2     12 3x3   6009115.8 2096842.2 37.7380440457606 -122.410981172443 (37.7380440457606, -122.410981172443) 10 7 7 28859 2
106641 10641 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 890 Hayes St 1 Sidewalk: Curb side : Cutout Tree DPW 1     12 3X3   6003718.4017 2110767.1906 37.7759746233785 -122.430636021327 (37.7759746233785, -122.430636021327) 7 9 11 29492 10
163465 10642 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 890 Hayes St 4 Sidewalk: Curb side : Cutout Tree DPW 1     9 3X3   6003622.9464 2110752.6543 37.7759293020711 -122.430965188348 (37.7759293020711, -122.430965188348) 7 9 11 29492 10
129864 106693 Undocumented 4 Pittosporum undulatum :: Victorian Box 36 48 CUMBERLAND ST 1 Sidewalk: Curb side : Cutout Tree Private 2     14 5x5   6005336.4 2104626.9 37.7592063845811 -122.424602050336 (37.7592063845811, -122.424602050336) 2 4 5 28859 19
31492 106694 Undocumented 4 Pittosporum undulatum :: Victorian Box 36 68 CUMBERLAND ST 1 Sidewalk: Curb side : Cutout Tree Private 2     20 3x3   6005199.5 2104630.3 37.7592079877543 -122.425075758694 (37.7592079877543, -122.425075758694) 2 4 5 28859 19
182623 106870 Significant Tree 6 Pittosporum undulatum :: Victorian Box 36 38 08th St 1 Front Yard : Cutout Tree Private 2   07/31/2014 12:00:00 AM 2   Permit Number 769156 6008504.13663 2111439.18954 37.7780897331906 -122.414128411309 (37.7780897331906, -122.414128411309) 8 2 9 28853 34
135261 106871 Significant Tree 6 Pittosporum undulatum :: Victorian Box 36 38 08th St 2 Front Yard : Cutout Tree Private 2   07/31/2014 12:00:00 AM     Permit Number 769156 6008506.93846 2111466.36236 37.7781645006636 -122.414120641632 (37.7781645006636, -122.414120641632) 8 2 9 28853 34
69806 106872 Significant Tree 6 Pittosporum undulatum :: Victorian Box 36 38 08th St 3 Front Yard : Cutout Tree Private 2   07/31/2014 12:00:00 AM     Permit Number 769156 6008506.93846 2111466.36236 37.7781645006636 -122.414120641632 (37.7781645006636, -122.414120641632) 8 2 9 28853 34
14597 106873 Significant Tree 6 Pittosporum undulatum :: Victorian Box 36 38 08th St 4 Front Yard : Cutout Tree Private 2         Permit Number 769156 6008506.93846 2111466.36236 37.7781645006636 -122.414120641632 (37.7781645006636, -122.414120641632) 8 2 9 28853 34
76208 106874 Significant Tree 6 Pittosporum undulatum :: Victorian Box 36 38 08th St 5 Front Yard : Cutout Tree Private 2         Permit Number 769156 6008506.93846 2111466.36236 37.7781645006636 -122.414120641632 (37.7781645006636, -122.414120641632) 8 2 9 28853 34
155624 106893 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 580 Pacific Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     16     6011306.03673 2118337.60033 37.7971881129931 -122.404921401297 (37.7971881129931, -122.404921401297) 3 1 10 308 23
133188 106894 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 580 Pacific Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     8     6011295.22918 2118336.45684 37.7971843691246 -122.404958717764 (37.7971843691246, -122.404958717764) 3 1 10 308 23

Next page

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE "trees" (
   [rowid] INTEGER PRIMARY KEY,
   [TreeID] TEXT,
   [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]),
   [qSpecies_id] INTEGER,
   [qAddress] TEXT,
   [SiteOrder] TEXT,
   [qSiteInfo] TEXT,
   [PlantType] TEXT,
   [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]),
   [qCareAssistant] TEXT,
   [PlantDate] TEXT,
   [DBH] TEXT,
   [PlotSize] TEXT,
   [PermitNotes] TEXT,
   [XCoord] TEXT,
   [YCoord] TEXT,
   [Latitude] TEXT,
   [Longitude] TEXT,
   [Location] TEXT,
   [Fire Prevention Districts] TEXT,
   [Police Districts] TEXT,
   [Supervisor Districts] TEXT,
   [Zip Codes] TEXT,
   [Neighborhoods (old)] TEXT,
   FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id)
);