trees
3,965 rows where qSpecies_id = 70 sorted by DBH descending
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 |
Advanced export
JSON shape: default, array, newline-delimited, object
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) );