3,965 rows where qSpecies_id = 70 sorted by DBH descending

View and edit SQL

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)
105726 3685 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 100X Cargo Way 121 Sidewalk: Property side : Cutout Tree Port 6     8 3x3   6016762.06772 2099192.87656 37.744924332395 -122.38470767872 (37.744924332395, -122.38470767872) 10 3 8 58 1
105800 183587 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 2601 28th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 0ft   5987684.8952 2097383.7142 37.7383058487898 -122.485117240602 (37.7383058487898, -122.485117240602) 1 8 3 29491 35
108388 120069 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 301 El Camino Del Mar 4 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 3ft   5987671.41415 2115292.92868 37.7874788518943 -122.486478399556 (37.7874788518943, -122.486478399556) 11 6 1 55 33
108549 203852 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 366 Staples Ave 2 Sidewalk: Property side : Yard Tree Private 2     8     5997653.19535 2093836.43462 37.7291414912794 -122.450396278864 (37.7291414912794, -122.450396278864) 9 7 4 28861 40
108565 181563 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1300 Sunset Blvd 41 Sidewalk: Property side : Yard Tree Private 2     8 Width 0ft   5984874.1846 2106092.4508 37.7620535245146 -122.495477273587 (37.7620535245146, -122.495477273587) 1 8 3 56 35
109829 188680 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 2 Middle Point Rd 3 Sidewalk: Curb side : Yard Tree Private 2     8     6018245.47476 2096448.12124 37.7374697107694 -122.379387650125 (37.7374697107694, -122.379387650125) 10 3 8 58 1
113147 187753 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1000 Oakdale Ave 5 Sidewalk: Property side : Yard Tree Private 2     8     6018088.91826 2093246.2132 37.7286692644523 -122.379706556009 (37.7286692644523, -122.379706556009) 10 3 8 58 1
115062 124840 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 100 Retiro Way 2 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 3ft   6001764.3271 2121501.21341 37.805336580469 -122.43816477779 (37.805336580469, -122.43816477779) 13 9 1 57 17
115838 220217 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 89 Chattanooga St 1 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 3ft   6004733.05876 2103154.09475 37.7551283155433 -122.426583820187 (37.7551283155433, -122.426583820187) 2 4 5 28862 22
116275 175028 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 50 Desmond St 1 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 3ft   6010596.82334 2086951.59743 37.7109694437689 -122.405164251526 (37.7109694437689, -122.405164251526) 9 7 8 309 39
116441 124603 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 3945 Clay St 2 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 2ft   5995769.4152 2115154.75083 37.7875681608689 -122.458451133385 (37.7875681608689, -122.458451133385) 11 6 1 54 31
116700 181916 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 2050 Taraval St 1 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 0ft   5986816.6249 2098962.0068 37.7425888056646 -122.488235202776 (37.7425888056646, -122.488235202776) 1 8 3 29491 35
117055 203705 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 2104 16th Ave 1 Sidewalk: Curb side : Yard Tree Private 2     8 Width 3ft   5991328.52937 2101050.88664 37.7485865336432 -122.472786786201 (37.7485865336432, -122.472786786201) 1 8 4 29491 40
117377 125317 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 550 Davis St 12 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 4ft   6013195.02023 2118529.35833 37.7978200432104 -122.398398464716 (37.7978200432104, -122.398398464716) 3 1 10 28860 6
119294 203878 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 2 Cranleigh Dr 20 Front Yard : Yard Tree Private 2     8 Width 0ft   5991362.95772 2095918.02159 37.7344949935417 -122.472293616873 (37.7344949935417, -122.472293616873) 1 8 4 64 40
120406 142467 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 441 FILBERT ST 1 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 0ft   6010784.5859 2119967.7244 37.8016348742048 -122.406840707299 (37.8016348742048, -122.406840707299) 3 1 10 308 23
122918 124842 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 104 Retiro Way 1 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 3ft   6001792.10412 2121538.65269 37.8054409584916 -122.438071335542 (37.8054409584916, -122.438071335542) 13 9 1 57 17
124553 122184 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 2 14th Ave 4 Sidewalk: Curb side : Yard Tree Private 2     8     5991498.86392 2114923.62724 37.7866872133365 -122.473209385401 (37.7866872133365, -122.473209385401) 11 6 1 54 33
125953 137832 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 2017 PINE ST 1 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 0ft   6004150.6439 2115288.9088 37.7884146135851 -122.429463318752 (37.7884146135851, -122.429463318752) 13 9 11 29490 27
128374 105220 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1443 28th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     8 3x3   5987410.3461 2105455.8349 37.7604537297774 -122.486659037253 (37.7604537297774, -122.486659037253) 1 8 3 56 35
128838 125199 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 2105 Buchanan St 4 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 4ft   6003806.51543 2115732.82152 37.7896139957428 -122.430685637947 (37.7896139957428, -122.430685637947) 13 9 1 29490 27
129147 220261 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 429 Grand View Ave 2 Sidewalk: Property side : Yard Tree Private 2     8     6000142.33485 2102107.70076 37.7519945730121 -122.442384714298 (37.7519945730121, -122.442384714298) 2 4 5 28862 22
130342 125044 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 3601 Webster St 4 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 3ft   6002592.66803 2120965.92412 37.803913892587 -122.435259888451 (37.803913892587, -122.435259888451) 13 9 1 57 17
132575 203999 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1570 07th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 3ft   5994019.78969 2104963.13543 37.7594839930198 -122.463764433977 (37.7594839930198, -122.463764433977) 1 5 4 56 12
133038 124858 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 55 Retiro Way 1 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 3ft   6001741.90446 2121417.26802 37.8051048134933 -122.43823635662 (37.8051048134933, -122.43823635662) 13 9 1 57 17
136521 125165 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 2647 Vallejo St 1 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 4ft   6000932.35187 2117553.82374 37.7944507421594 -122.440760598931 (37.7944507421594, -122.440760598931) 13 9 1 57 27
138086 120073 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 101 26th Ave 4 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 3ft   5987689.48695 2115234.87158 37.787320497195 -122.486411608023 (37.787320497195, -122.486411608023) 11 6 1 55 33
139192 125011 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 799 Marina Blvd 4 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 3ft   5999200.00704 2121464.14199 37.8050886184966 -122.447036234534 (37.8050886184966, -122.447036234534) 13 9 1 57 17
140162 125022 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1432 Jefferson St 1 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 3ft   6002347.61136 2121611.58572 37.8056727893385 -122.436154153595 (37.8056727893385, -122.436154153595) 13 9 1 57 17
140312 97227 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1301X Newcomb Ave 7 Median : Cutout Tree DPW 1     8 15x200   6016638.64484 2094938.128 37.7332348257283 -122.384838105605 (37.7332348257283, -122.384838105605) 10 3 8 58 1
140345 124956 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 222 Maple St 5 Sidewalk: Curb side : Yard Tree Private 2     8 Width 4ft   5996636.78937 2115543.77284 37.7886861193288 -122.455478336084 (37.7886861193288, -122.455478336084) 11 6 1 54 31
140398 124889 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 342 Cherry St 2 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 3ft   5996228.81729 2115003.39409 37.7871789661719 -122.456850751862 (37.7871789661719, -122.456850751862) 11 6 1 54 31
142440 47878 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 41X 17th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   06/19/2002 12:00:00 AM 8 3x3 Permit Number 45624 5990495.13219 2114853.70227 37.7864370505627 -122.476676909352 (37.7864370505627, -122.476676909352) 11 6 1 55 33
143807 220190 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1101 San Jose Ave 78 Front Yard : Yard Tree Private 2     8     6004897.78998 2096535.50608 37.7369645021978 -122.425543115723 (37.7369645021978, -122.425543115723) 2 7 5 28859 2
143953 220187 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1101 San Jose Ave 75 Front Yard : Yard Tree Private 2     8     6004907.90324 2096539.115 37.7369749829053 -122.42550840641 (37.7369749829053, -122.42550840641) 2 7 5 28859 2
144170 125315 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 550 Davis St 10 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 4ft   6013199.69177 2118499.63281 37.7977386842466 -122.398380212981 (37.7977386842466, -122.398380212981) 3 1 10 28860 6
145904 203253 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 345 Hazelwood Ave 1 Sidewalk: Property side : Yard Tree Private 2     8 Width 3ft   5996049.39925 2095464.35542 37.7335194494626 -122.456058346634 (37.7335194494626, -122.456058346634) 9 7 4 59 40
146062 120072 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 101 26th Ave 3 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 3ft   5987688.32967 2115247.71242 37.7873556870051 -122.486416555037 (37.7873556870051, -122.486416555037) 11 6 1 55 33
148537 124867 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 12 Rico Way 2 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 3ft   6001659.8265 2121355.87963 37.8049315887888 -122.438515995417 (37.8049315887888, -122.438515995417) 13 9 1 57 17
148722 68096 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 2336 Octavia St 1 Sidewalk: Curb side : Cutout Tree Private 2   04/26/1993 12:00:00 AM 8   Permit Number 31841 6004611.78604 2117244.74895 37.7938109545695 -122.428007268927 (37.7938109545695, -122.428007268927) 13 9 1 28858 27
149033 220151 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1001 San Jose Ave 6 Front Yard : Yard Tree Private 2     8     6005128.65815 2096758.77235 37.7375905832326 -122.424760779309 (37.7375905832326, -122.424760779309) 2 7 5 28859 2
149631 125314 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 550 Davis St 9 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 4ft   6013200.68159 2118482.22968 37.7976909545355 -122.398375566176 (37.7976909545355, -122.398375566176) 3 1 10 28860 6
150181 124995 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 251 Cervantes Blvd 2 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 2ft   6000785.78079 2121487.92009 37.8052443792868 -122.441550200077 (37.8052443792868, -122.441550200077) 13 9 1 57 17
150879 125058 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 3033 Franklin St 2 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 2ft   6005092.29403 2120409.57144 37.8025279221992 -122.426570129825 (37.8025279221992, -122.426570129825) 13 9 1 57 17
152369 118277 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 5940 Fulton St 1 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 4ft   5984912.75175 2109761.00867 37.772128606737 -122.495614486107 (37.772128606737, -122.495614486107) 11 6 2 55 26
156353 203920 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 44 Hillway Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 5ft   5996122.28949 2106572.30441 37.7640232904618 -122.456609367551 (37.7640232904618, -122.456609367551) 15 5 11 29492 12
156648 204010 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1283 Portola Dr 4 Sidewalk: Curb side : Yard Tree Private 2     8 Width 3ft   5993933.64457 2097839.94788 37.7399205683667 -122.463545404995 (37.7399205683667, -122.463545404995) 1 8 4 59 40
157789 203773 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1571 Portola Dr 2 Sidewalk: Curb side : Yard Tree Private 2     8 Width 5ft   5992214.47034 2096605.26407 37.736431233023 -122.469399690257 (37.736431233023, -122.469399690257) 1 8 4 59 40
160477 120067 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 301 El Camino Del Mar 2 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 3ft   5987646.00495 2115291.68795 37.7874739640581 -122.486566217974 (37.7874739640581, -122.486566217974) 11 6 1 55 33
160561 102187 Undocumented 4 Acacia melanoxylon :: Blackwood Acacia 70 3999X Folsom St 2 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   8 3x3   6008408 2096514 37.7371031642446 -122.41340519256 (37.7371031642446, -122.41340519256) 10 7 7 28859 2
160865 220180 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1101 San Jose Ave 45 Front Yard : Yard Tree Private 2     8     6004956.45114 2096571.71335 37.7370672335752 -122.425342873587 (37.7370672335752, -122.425342873587) 2 7 5 28859 2
171949 181720 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1212 28th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 0ft   5987401.7088 2107010.6502 37.7647223218617 -122.486803086498 (37.7647223218617, -122.486803086498) 1 8 3 56 35
174402 203259 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 76 Brentwood Ave 1 Sidewalk: Property side : Yard Tree Private 2     8 Width 3ft   5996134.27449 2095680.63011 37.7341181587163 -122.455780538853 (37.7341181587163, -122.455780538853) 9 7 4 59 40
176515 58355 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1340 Taylor St 1 Sidewalk: Curb side : Cutout Tree Private 2   11/13/1978 12:00:00 AM 8   Permit Number 17382 6008945.85978 2117518.13372 37.7948058484612 -122.413030259943 (37.7948058484612, -122.413030259943) 3 1 10 28857 21
177689 125023 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1436 Jefferson St 1 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 3ft   6002327.23032 2121607.6758 37.8056608957886 -122.436224405044 (37.8056608957886, -122.436224405044) 13 9 1 57 17
177936 122911 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 2 12th Ave 2 Sidewalk: Curb side : Yard Tree Private 2     8 Width 6ft   5992125.45609 2114866.35711 37.7865662259147 -122.471037373124 (37.7865662259147, -122.471037373124) 11 6 1 54 11
178399 203258 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 80 Brentwood Ave 1 Sidewalk: Property side : Yard Tree Private 2     8 Width 3ft   5996117.24825 2095689.22308 37.7341407757719 -122.45584002452 (37.7341407757719, -122.45584002452) 9 7 4 59 40
178672 124849 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 170 Retiro Way 3 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 3ft   6001917.78024 2121717.54489 37.8059392953167 -122.437649236947 (37.8059392953167, -122.437649236947) 13 9 1 57 17
180909 140779 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 89 Terra Vista Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 0ft   6000037.9186 2112803.9662 37.7813578932052 -122.443514076205 (37.7813578932052, -122.443514076205) 15 5 1 29490 16
182310 249861 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 233 Greenwich St 2 Front Yard : Yard Tree Private 2     8 Width 0ft   6011664.77155 2120432.02609 37.8029589438729 -122.403827536111 (37.8029589438729, -122.403827536111) 3 1 10 308 23
182601 125221 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1903 Broadway 5 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 4ft   6004472.26489 2117678.12387 37.7949929973772 -122.428520930193 (37.7949929973772, -122.428520930193) 13 9 1 28858 27
183060 4749 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1255 Columbus Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   08/03/2015 12:00:00 AM 8 3X3   6007516.58505 2121541.63395 37.8057730322633 -122.418261164826 (37.8057730322633, -122.418261164826) 5 1 1 308 32
183377 200531 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1400x La Salle Ave 7 Median : Cutout Tree DPW 1     8 Width 0ft   6016156.3167 2095682.0459 37.7352507861079 -122.386557515095 (37.7352507861079, -122.386557515095) 10 3 8 58 1
183898 73288 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1600X GREEN ST 7 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 11/20/1999 12:00:00 AM 8 3x3   6005364 2118556 37.7974538454152 -122.425497899433 (37.7974538454152, -122.425497899433) 13 9 1 57 17
185184 124864 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 2 Rico Way 3 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 3ft   6001713.03536 2121362.39581 37.8049525070285 -122.438332327771 (37.8049525070285, -122.438332327771) 13 9 1 57 17
185310 184837 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1201 Sunset Blvd 26 Sidewalk: Property side : Yard Tree Private 2     8 Width 0ft   5984687.4123 2106865.8247 37.7641660538384 -122.496180298656 (37.7641660538384, -122.496180298656) 1 8 3 56 35
185599 174993 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 82 Curtis St 1 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 2ft   6000637.15099 2088042.26781 37.7134023518192 -122.439665300239 (37.7134023518192, -122.439665300239) 9 7 6 28861 5
185899 120950 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 2750 Ortega St 2 Sidewalk: Curb side : Cutout Tree Private 2     8 3x3   5985459.2715 2102315.3249 37.7517168221741 -122.493175446174 (37.7517168221741, -122.493175446174) 1 8 3 56 35
186120 181921 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 2390 31st Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 0ft   5986744.7102 2098996.695 37.7426798542726 -122.488486408325 (37.7426798542726, -122.488486408325) 1 8 3 29491 35
187358 184774 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1301 Sunset Blvd 35 Sidewalk: Property side : Yard Tree Private 2     8 Width 0ft   5984678.2991 2105977.4713 37.7617263510589 -122.496146272255 (37.7617263510589, -122.496146272255) 1 8 3 56 35
189187 203863 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 68 Williar Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 3ft   5997075.35009 2090631.23429 37.720307679246 -122.452162755132 (37.720307679246, -122.452162755132) 9 8 6 28861 24
191672 217842 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 2 Cranleigh Dr 32 Front Yard : Yard Tree Private 2     8     5991425.94511 2095892.37177 37.734428210799 -122.472073981738 (37.734428210799, -122.472073981738) 1 8 4 64 40
192871 173728 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 994 Carolina St 1 Median : Cutout Tree DPW 1     8 3x3   6012439 2103318 37.7560109950145 -122.399945772243 (37.7560109950145, -122.399945772243) 10 3 8 28856 29
41980 22564 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 225 Topaz Way 1 Sidewalk: Curb side : Cutout Tree DPW 1     75 3X3   6001403.30325 2097649.91071 37.7398263284251 -122.437704879797 (37.7398263284251, -122.437704879797) 2 7 5 63 7
104155 6270 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1355 Ellis St 5 Sidewalk: Curb side : Cutout Tree DPW 1     75 3X3   6004445.8756 2113251.7643 37.7828378352732 -122.428296616989 (37.7828378352732, -122.428296616989) 7 9 11 29490 41
169531 6267 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1355 Ellis St 2 Sidewalk: Curb side : Cutout Tree DPW 1     75 3X3   6004345.2786 2113236.3953 37.7827899431792 -122.428643544595 (37.7827899431792, -122.428643544595) 7 9 11 29490 41
53784 23853 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1400 Webster St 2 Sidewalk: Curb side : Cutout Tree DPW 1     70 4X4   6003700.6561807 2113512.2535027 37.7835108780695 -122.430893359317 (37.7835108780695, -122.430893359317) 13 9 11 29490 41
55934 10263 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 212 Haight St 2 Sidewalk: Curb side : Cutout Tree DPW 1     70 3X3   6005030.70582 2109564.31462 37.7727460760509 -122.426010766966 (37.7727460760509, -122.426010766966) 7 9 11 28852 10
59858 11451 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 30 ARGUELLO BLVD 2 Sidewalk: Curb side : Cutout Tree DPW 1     70 3X12   5995510 2115730 37.789132728017 -122.459390328068 (37.789132728017, -122.459390328068) 11 6 1 54 31
77456 10426 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1418 Haight St 1 Sidewalk: Curb side : Cutout Tree DPW 1     70 3x4   5999318.43579 2108766.88191 37.7702320345214 -122.44571271379 (37.7702320345214, -122.44571271379) 15 5 11 29492 9
82748 27434 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1275 Columbus Ave 2 Sidewalk: Curb side : Cutout Tree DPW 1   08/03/2015 12:00:00 AM 70 3X3   6007539.61625 2121483.94928 37.8056159411906 -122.418177369469 (37.8056159411906, -122.418177369469) 5 1 1 308 32
94530 4884 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 639X Dolores St 1 Sidewalk: Curb side : Cutout Tree DPW 1     70 4X4   6005016.1788 2104614.45196 37.7591541153895 -122.425708644037 (37.7591541153895, -122.425708644037) 2 4 5 28859 19
112258 12730 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1619 Lake St 1 Sidewalk: Curb side : Cutout Tree Private 2     70 3x3   5990437.55256 2114717.69591 37.7860602752433 -122.476866177185 (37.7860602752433, -122.476866177185) 11 6 2 55 26
178855 5354 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 214 Dolores St 1 Sidewalk: Curb side : Cutout Tree DPW 1     70 6   6004794.21046 2107092.80643 37.7659465419134 -122.426652801811 (37.7659465419134, -122.426652801811) 8 4 5 28862 3
4842 204009 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1283 Portola Dr 3 Sidewalk: Curb side : Yard Tree Private 2     7 Width 3ft   5993898.99812 2097834.64802 37.7399040199511 -122.463664812507 (37.7399040199511, -122.463664812507) 1 8 4 59 40
8988 125125 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 2921 Vallejo St 1 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 4ft Permit Number 784827 5999533.93344 2117358.43143 37.7938345087112 -122.445585222496 (37.7938345087112, -122.445585222496) 13 9 1 57 27
12857 125310 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 550 Davis St 5 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 4ft   6013216.03203 2118385.20589 37.7974254053999 -122.398315638071 (37.7974254053999, -122.398315638071) 3 1 10 28860 6
23204 125307 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 10 Jackson St 6 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 4ft   6013381 2118288 37.7971676890736 -122.397737980255 (37.7971676890736, -122.397737980255) 3 1 10 28860 6
24150 203998 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 55 Merced Ave 1 Sidewalk: Curb side : Yard Tree Private 2     7 Width 3ft   5995084.78347 2099948.84972 37.7457773474569 -122.459717986591 (37.7457773474569, -122.459717986591) 1 8 4 59 40
25198 203763 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1701 Portola Dr 5 Sidewalk: Curb side : Yard Tree Private 2     7 Width 5ft   5991783.45029 2096172.36825 37.7352176923484 -122.470858369923 (37.7352176923484, -122.470858369923) 1 8 4 59 40
25341 138422 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1739 PIERCE ST 3 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 0ft   6002029.7373 2114496.7631 37.786119275153 -122.436744579025 (37.786119275153, -122.436744579025) 13 6 1 29490 27
25606 220176 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1101 San Jose Ave 41 Front Yard : Yard Tree Private 2     7     6004978.26443 2096560.74559 37.7370383509436 -122.425266674926 (37.7370383509436, -122.425266674926) 2 7 5 28859 2
25896 187702 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 51 Executive Park Blvd 1 Sidewalk: Curb side : Yard Tree Private 2     7 Width 4ft   6013770.9191 2087051.91118 37.7114218243198 -122.394200759471 (37.7114218243198, -122.394200759471) 10 3 8 58 1
26461 183598 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 116 Escolta Way 1 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 0ft   5986616.6908 2097250.4752 37.7378777278495 -122.488800725476 (37.7378777278495, -122.488800725476) 1 8 3 29491 35
26679 124855 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1 Casa Way 1 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 3ft   6001720.89506 2121441.74849 37.805170835422 -122.438310816889 (37.805170835422, -122.438310816889) 13 9 1 57 17
26908 203269 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 61 Burnside Ave 2 Sidewalk: Property side : Yard Tree Private 2     7     6001195.67234 2095721.17604 37.7345186646045 -122.438284639447 (37.7345186646045, -122.438284639447) 2 7 5 63 7
27003 184514 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1975 42nd Ave 5 Sidewalk: Property side : Yard Tree Private 2     7 Width 0ft   5983188.0663 2101693.9168 37.749877509903 -122.500983494265 (37.749877509903, -122.500983494265) 1 8 3 29491 35
30846 220142 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 2300 22nd St 4 Sidewalk: Curb side : Yard Tree Private 2     7     6011259.06651 2103712.6119 37.7570286576638 -122.40405416618 (37.7570286576638, -122.40405416618) 10 4 8 28859 19
35677 184848 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1201 Sunset Blvd 37 Sidewalk: Property side : Yard Tree Private 2     7 Width 0ft   5984690.0704 2106845.3199 37.7641099091262 -122.496169592258 (37.7641099091262, -122.496169592258) 1 8 3 56 35
36070 125169 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 2647 Vallejo St 7 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 4ft   6001017.71367 2117559.63744 37.7944715659634 -122.440465654581 (37.7944715659634, -122.440465654581) 13 9 1 57 27

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)
);