trees
3,965 rows where qSpecies_id = 70 sorted by YCoord 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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 184677 | 142570 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2237 MASON ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 6008911.8135 | 2120966.7828 | 37.8042730722163 | -122.413392071992 | (37.8042730722163, -122.413392071992) | 3 | 1 | 10 | 308 | 23 | |||
| 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 | |||
| 154473 | 142986 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 291 Chestnut St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 6010426.2416 | 2120953.9134 | 37.8043226486754 | -122.40815034039 | (37.8043226486754, -122.40815034039) | 3 | 1 | 10 | 308 | 23 | |||
| 27065 | 142985 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 293 Chestnut St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 6010414.8862 | 2120952.2911 | 37.8043175584205 | -122.408189522377 | (37.8043175584205, -122.408189522377) | 3 | 1 | 10 | 308 | 23 | |||
| 167104 | 115721 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 3530 Baker St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | 3x5 | 5999222.11492 | 2120952.10002 | 37.8036839530115 | -122.44692285883 | (37.8036839530115, -122.44692285883) | 13 | 9 | 1 | 57 | 17 | |||
| 33821 | 142984 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 295 Chestnut St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 6010405.1529 | 2120950.1282 | 37.8043110746273 | -122.408223052773 | (37.8043110746273, -122.408223052773) | 3 | 1 | 10 | 308 | 23 | |||
| 116355 | 125051 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1700 North Point St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 2ft | 6002572.9052 | 2120948.52615 | 37.8038650000432 | -122.435327033633 | (37.8038650000432, -122.435327033633) | 13 | 9 | 1 | 57 | 17 | |||
| 111318 | 125052 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1700 North Point St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 2ft | 6002561.89793 | 2120947.67753 | 37.8038620448521 | -122.435365064168 | (37.8038620448521, -122.435365064168) | 13 | 9 | 1 | 57 | 17 | |||
| 123018 | 142571 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2237 MASON ST | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 6008916.052 | 2120946.0612 | 37.8042164138671 | -122.413375937957 | (37.8042164138671, -122.413375937957) | 3 | 1 | 10 | 308 | 23 | |||
| 98183 | 125053 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1700 North Point St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/24/2018 12:00:00 AM | 3 | Width 2ft | 6002522.90847 | 2120942.13769 | 37.8038446195968 | -122.435499592826 | (37.8038446195968, -122.435499592826) | 13 | 9 | 1 | 57 | 17 | ||
| 119753 | 102623 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 351 Chestnut St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6010148.1574 | 2120916.7901 | 37.8042051428233 | -122.409110056734 | (37.8042051428233, -122.409110056734) | 3 | 1 | 10 | 308 | 23 | |||
| 147053 | 125272 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 3000 Van Ness Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 4ft | 6005588.70975 | 2120905.81029 | 37.8039185177939 | -122.424887607998 | (37.8039185177939, -122.424887607998) | 5 | 9 | 1 | 28858 | 32 | |||
| 33407 | 125055 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1725 North Point St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 2ft | 6002469.3064 | 2120890.0959 | 37.8036986821095 | -122.435681360206 | (37.8036986821095, -122.435681360206) | 13 | 9 | 1 | 57 | 17 | |||
| 33026 | 125054 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1733 North Point St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 3ft | 6002453.36276 | 2120887.52869 | 37.8036907276167 | -122.435736350154 | (37.8036907276167, -122.435736350154) | 13 | 9 | 1 | 57 | 17 | |||
| 32977 | 125002 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 69 Cervantes Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 4ft | 6001637.34931 | 2120884.52761 | 37.8036361027929 | -122.438559986648 | (37.8036361027929, -122.438559986648) | 13 | 9 | 1 | 57 | 17 | |||
| 61387 | 114840 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 70 | 2455x HYDE ST | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 12 | 3x3 | 6006980 | 2120877 | 37.8039178984324 | -122.420070904619 | (37.8039178984324, -122.420070904619) | 5 | 1 | 1 | 28858 | 32 | ||||
| 174928 | 125271 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 3000 Van Ness Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 4ft | 6005598.03455 | 2120853.62944 | 37.8037757692909 | -122.424851624323 | (37.8037757692909, -122.424851624323) | 5 | 9 | 1 | 28858 | 32 | |||
| 2878 | 124826 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 56 Cervantes Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 3ft | 6001759.52883 | 2120853.50314 | 37.8035578671766 | -122.438134955373 | (37.8035578671766, -122.438134955373) | 13 | 9 | 1 | 57 | 17 | |||
| 92771 | 30421 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 530 Chestnut St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/11/1956 12:00:00 AM | Permit Number 75 | 6009285.11323863 | 2120849.80325768 | 37.803972827811 | -122.412091961384 | (37.803972827811, -122.412091961384) | 3 | 1 | 10 | 308 | 23 | |||
| 91547 | 95374 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 2270 Beach St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5999358 | 2120844 | 37.8033949017064 | -122.446444841619 | (37.8033949017064, -122.446444841619) | 13 | 9 | 1 | 57 | 17 | |||||
| 192584 | 23574 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 3035 Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 30 | 3x3 | 6005498.03712 | 2120829.33235 | 37.8037034071495 | -122.425195941456 | (37.8037034071495, -122.425195941456) | 13 | 9 | 1 | 28858 | 17 | |||
| 61043 | 68013 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2245 Beach St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/21/1993 12:00:00 AM | 21 | Permit Number 770742 | 5999478.95817 | 2120820.40604 | 37.8033370269329 | -122.446024564694 | (37.8033370269329, -122.446024564694) | 13 | 9 | 1 | 57 | 17 | ||
| 3857 | 104292 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 2245 Beach St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5999485.4 | 2120797.2 | 37.8032736772553 | -122.446000602494 | (37.8032736772553, -122.446000602494) | 13 | 9 | 1 | 57 | 17 | |||||
| 171407 | 23573 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 3025 Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 24 | 3x3 | 6005485.55606 | 2120793.85256 | 37.8036052836839 | -122.425236606678 | (37.8036052836839, -122.425236606678) | 13 | 9 | 1 | 28858 | 17 | |||
| 177957 | 125270 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 3000 Van Ness Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 4ft | 6005603.50522 | 2120793.11454 | 37.8036099199277 | -122.424828384943 | (37.8036099199277, -122.424828384943) | 5 | 9 | 1 | 28858 | 32 | |||
| 92195 | 124819 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2299 Beach St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 12 | Width 3ft | 5999280.13249 | 2120792.18692 | 37.803248189218 | -122.446710573859 | (37.803248189218, -122.446710573859) | 13 | 9 | 1 | 57 | 17 | |||
| 29568 | 125050 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 3025 Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 4ft | 6005509.11521 | 2120789.62029 | 37.8035949938703 | -122.425154777693 | (37.8035949938703, -122.425154777693) | 13 | 9 | 1 | 28858 | 17 | |||
| 103300 | 124827 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 36 Cervantes Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 3ft | 6001863.38162 | 2120780.81384 | 37.8033641873714 | -122.437770359437 | (37.8033641873714, -122.437770359437) | 13 | 9 | 1 | 57 | 17 | |||
| 122247 | 124828 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 32 Cervantes Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6001898.2901 | 2120756.22189 | 37.8032986492638 | -122.437647795317 | (37.8032986492638, -122.437647795317) | 13 | 9 | 1 | 57 | 17 | |||
| 164098 | 125269 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 3000 Van Ness Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | Width 4ft | 6005612.36157 | 2120739.21724 | 37.8034624320096 | -122.424793900439 | (37.8034624320096, -122.424793900439) | 5 | 9 | 1 | 28858 | 32 | |||
| 100260 | 49664 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 3630 Divisadero St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | 04/18/2011 12:00:00 AM | 26 | Permit Number 46510 | 6000238.4271 | 2120737.06693 | 37.8031515390838 | -122.443390413534 | (37.8031515390838, -122.443390413534) | 13 | 9 | 1 | 57 | 17 | ||
| 146800 | 172952 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 3000X Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | SFUSD | 0 | Width 3ft | 6005556.34576 | 2120733.12845 | 37.8034425497953 | -122.424987312212 | (37.8034425497953, -122.424987312212) | 13 | 9 | 1 | 28858 | 32 | ||
| 119367 | 104714 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 1043 Francisco St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 6006311.1 | 2120706.2 | 37.8034112154379 | -122.422373535783 | (37.8034112154379, -122.422373535783) | 5 | 9 | 1 | 28858 | 32 | |||||
| 161844 | 104713 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 1043 Francisco St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 6006311.1 | 2120706.2 | 37.8034112154379 | -122.422373535783 | (37.8034112154379, -122.422373535783) | 5 | 9 | 1 | 28858 | 32 | |||||
| 57110 | 125268 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 3000 Van Ness Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 13 | Width 9ft | 6005626.14224 | 2120703.55494 | 37.8033652908254 | -122.42474367328 | (37.8033652908254, -122.42474367328) | 5 | 9 | 1 | 28858 | 32 | |||
| 100154 | 23571 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 3000X Van Ness Ave | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 30 | 3X3 | 6005601.48469 | 2120643.06931 | 37.803197820157 | -122.424824696055 | (37.803197820157, -122.424824696055) | 5 | 9 | 1 | 28858 | 32 | |||
| 150074 | 23570 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 3000X Van Ness Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 30 | 3X3 | 6005601.48469 | 2120643.06931 | 37.803197820157 | -122.424824696055 | (37.803197820157, -122.424824696055) | 5 | 9 | 1 | 28858 | 32 | |||
| 155323 | 23568 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 3000X Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 30 | 3X3 | 6005601.48469 | 2120643.06931 | 37.803197820157 | -122.424824696055 | (37.803197820157, -122.424824696055) | 5 | 9 | 1 | 28858 | 32 | |||
| 167043 | 23569 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 3000X Van Ness Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 30 | 3X3 | 6005601.48469 | 2120643.06931 | 37.803197820157 | -122.424824696055 | (37.803197820157, -122.424824696055) | 5 | 9 | 1 | 28858 | 32 | |||
| 91896 | 124813 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 3434 Baker St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 05/22/2019 12:00:00 AM | 3 | Width 3ft | 5999267.34259 | 2120623.44736 | 37.802784145342 | -122.446742685044 | (37.802784145342, -122.446742685044) | 13 | 9 | 1 | 57 | 17 | ||
| 66355 | 124812 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 3434 Baker St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 05/22/2019 12:00:00 AM | 3 | Width 3ft | 5999269.00527 | 2120608.31767 | 37.8027426982766 | -122.446735842084 | (37.8027426982766, -122.446735842084) | 13 | 9 | 1 | 57 | 17 | ||
| 81795 | 46254 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 2161 North Point St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 44539 | 6000422.21933345 | 2120600.45809947 | 37.8027869270392 | -122.442744582339 | (37.8027869270392, -122.442744582339) | 13 | 9 | 1 | 57 | 17 | ||||
| 113025 | 124811 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 3420 Baker St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 3ft | 5999272.70884 | 2120585.70754 | 37.8026808285249 | -122.446721398098 | (37.8026808285249, -122.446721398098) | 13 | 9 | 1 | 57 | 17 | |||
| 184307 | 124810 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 3420 Baker St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 5999274.60897 | 2120571.44808 | 37.8026417844383 | -122.446713796118 | (37.8026417844383, -122.446713796118) | 13 | 9 | 1 | 57 | 17 | |||
| 149618 | 143044 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2011 Powell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 6009451.2656 | 2120567.4873 | 37.8032069795486 | -122.411497020223 | (37.8032069795486, -122.411497020223) | 3 | 1 | 10 | 308 | 23 | |||
| 45839 | 13066 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 604 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 30 | 2X2 | 6009404.55183 | 2120549.65161 | 37.803155386878 | -122.4116574143 | (37.803155386878, -122.4116574143) | 3 | 1 | 10 | 308 | 23 | |||
| 153545 | 13067 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 610 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 45 | 2X2 | 6009404.55183 | 2120549.65161 | 37.803155386878 | -122.4116574143 | (37.803155386878, -122.4116574143) | 3 | 1 | 10 | 308 | 23 | |||
| 101724 | 143045 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2009 Powell St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 6009452.8057 | 2120547.9796 | 37.8031535026428 | -122.411490311601 | (37.8031535026428, -122.411490311601) | 3 | 1 | 10 | 308 | 23 | |||
| 125350 | 113235 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 2001 POWELL ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6009409 | 2120545 | 37.8031428642343 | -122.411641692368 | (37.8031428642343, -122.411641692368) | 3 | 1 | 10 | 308 | 23 | ||||
| 134443 | 113236 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 2001 POWELL ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6009409 | 2120545 | 37.8031428642343 | -122.411641692368 | (37.8031428642343, -122.411641692368) | 3 | 1 | 10 | 308 | 23 | ||||
| 135812 | 13064 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 590 Lombard St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 30 | 2X2 | 6009534.3118 | 2120532.6199 | 37.8031159000828 | -122.411207170734 | (37.8031159000828, -122.411207170734) | 3 | 1 | 10 | 308 | 23 | |||
| 83922 | 143046 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 602 LOMBARD ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 6009427.651 | 2120519.2315 | 37.8030731565489 | -122.411575328122 | (37.8030731565489, -122.411575328122) | 3 | 1 | 10 | 308 | 23 | |||
| 141923 | 143047 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 602 LOMBARD ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 6009407.63 | 2120515.1246 | 37.803060756971 | -122.411644321188 | (37.803060756971, -122.411644321188) | 3 | 1 | 10 | 308 | 23 | |||
| 45455 | 249872 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 230 Greenwich St | 8 | Back Yard : Yard | Tree | Private 2 | 9 | Width 0ft | 6011683.12279 | 2120489.80597 | 37.8031186185004 | -122.403768099014 | (37.8031186185004, -122.403768099014) | 3 | 1 | 10 | 28860 | 6 | |||
| 47188 | 249874 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 230 Greenwich St | 10 | Back Yard : Yard | Tree | Private 2 | 21 | Width 0ft | 6011664.09828 | 2120483.35155 | 37.8030998334423 | -122.403833479743 | (37.8030998334423, -122.403833479743) | 3 | 1 | 10 | 28860 | 6 | |||
| 67363 | 125056 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 3051 Franklin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 4ft | 6005083.26804 | 2120476.13845 | 37.8027101877925 | -122.426606107185 | (37.8027101877925, -122.426606107185) | 13 | 9 | 1 | 57 | 17 | |||
| 24398 | 23561 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2930 Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 30 | 3X3 | 6005650.5577 | 2120458.20498 | 37.8026930017358 | -122.424641718951 | (37.8026930017358, -122.424641718951) | 5 | 9 | 1 | 28858 | 32 | |||
| 162767 | 249862 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 233 Greenwich St | 3 | Front Yard : Yard | Tree | Private 2 | 4 | Width 0ft | 6011661.36372 | 2120433.37836 | 37.8029624664958 | -122.403839424247 | (37.8029624664958, -122.403839424247) | 3 | 1 | 10 | 308 | 23 | |||
| 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 | |||
| 174242 | 249860 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 233 Greenwich St | 1 | Front Yard : Yard | Tree | Private 2 | 12 | Width 0ft | 6011669.48421 | 2120431.50277 | 37.8029577702374 | -122.403811190928 | (37.8029577702374, -122.403811190928) | 3 | 1 | 10 | 308 | 23 | |||
| 86417 | 125057 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 3033 Franklin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6005090.59949 | 2120431.22581 | 37.8025872837247 | -122.426577536638 | (37.8025872837247, -122.426577536638) | 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 | |||
| 139007 | 249914 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 356 Greenwich St | 3 | Front Yard : Yard | Tree | Private 2 | 28 | Width 0ft | 6011214.96486 | 2120409.42645 | 37.8028717518996 | -122.405382516107 | (37.8028717518996, -122.405382516107) | 3 | 1 | 10 | 308 | 23 | |||
| 76018 | 125059 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 3027 Franklin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6005095.64842 | 2120394.27764 | 37.802486118995 | -122.426557432296 | (37.802486118995, -122.426557432296) | 13 | 9 | 1 | 57 | 17 | |||
| 91681 | 125060 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 3027 Franklin St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6005098.29156 | 2120374.12611 | 37.8024309375051 | -122.426546849957 | (37.8024309375051, -122.426546849957) | 13 | 9 | 1 | 57 | 17 | |||
| 86411 | 249836 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 333 Greenwich St | 4 | Front Yard : Yard | Tree | Private 2 | 3 | Width 0ft | 6011225.58487 | 2120372.97732 | 37.8027722652867 | -122.405343196852 | (37.8027722652867, -122.405343196852) | 3 | 1 | 10 | 308 | 23 | |||
| 171800 | 249837 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 333 Greenwich St | 5 | Front Yard : Yard | Tree | Private 2 | 3 | Width 0ft | 6011222.46721 | 2120367.48226 | 37.8027570028893 | -122.405353598393 | (37.8027570028893, -122.405353598393) | 3 | 1 | 10 | 308 | 23 | |||
| 34145 | 23560 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2909 Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6005511.81289 | 2120357.28421 | 37.8024080624664 | -122.425114661564 | (37.8024080624664, -122.425114661564) | 13 | 9 | 1 | 28858 | 17 | |||
| 78253 | 125061 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 3021 Franklin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6005101.78877 | 2120350.91191 | 37.8023673949923 | -122.426533093922 | (37.8023673949923, -122.426533093922) | 13 | 9 | 1 | 57 | 17 | |||
| 67303 | 109049 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 2146 Bay St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 774033 | 6000515.3 | 2120331 | 37.8020523729009 | -122.442403120222 | (37.8020523729009, -122.442403120222) | 13 | 9 | 1 | 57 | 17 | ||||
| 119649 | 109048 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 2146 Bay St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 774033 | 6000515.3 | 2120331 | 37.8020523729009 | -122.442403120222 | (37.8020523729009, -122.442403120222) | 13 | 9 | 1 | 57 | 17 | ||||
| 50483 | 124988 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2152 Bay St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | Width 5ft | 6000486.93173 | 2120314.4675 | 37.8020053621167 | -122.442500100005 | (37.8020053621167, -122.442500100005) | 13 | 9 | 1 | 57 | 17 | |||
| 90347 | 143074 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 586 GREENWICH ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6010107.9769 | 2120266.5495 | 37.8024174920752 | -122.409203192611 | (37.8024174920752, -122.409203192611) | 3 | 1 | 10 | 308 | 23 | |||
| 89967 | 143073 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 586 GREENWICH ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 6010122.9219 | 2120266.0158 | 37.802416863921 | -122.40915143763 | (37.802416863921, -122.40915143763) | 3 | 1 | 10 | 308 | 23 | |||
| 12317 | 124989 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2330 Bay St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 2ft | 5999632.98493 | 2120193.24081 | 37.8016237941718 | -122.445446428326 | (37.8016237941718, -122.445446428326) | 13 | 9 | 1 | 57 | 17 | |||
| 178876 | 124809 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 3300 Baker St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 2ft | 5999327.69543 | 2120187.49755 | 37.8015905920894 | -122.446502451826 | (37.8015905920894, -122.446502451826) | 13 | 9 | 1 | 57 | 17 | |||
| 174503 | 124808 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 3300 Baker St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 2ft | 5999329.97888 | 2120181.10538 | 37.8015731713358 | -122.446494089942 | (37.8015731713358, -122.446494089942) | 13 | 9 | 1 | 57 | 17 | |||
| 14952 | 124990 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2354 Bay St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 5999518.65691 | 2120176.7884 | 37.8015720930274 | -122.44584087006 | (37.8015720930274, -122.44584087006) | 13 | 9 | 1 | 57 | 17 | |||
| 27095 | 104422 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2362 Bay St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 23 | 3x3 | 5999509.01294 | 2120174.0716 | 37.8015640827681 | -122.445874046945 | (37.8015640827681, -122.445874046945) | 13 | 9 | 1 | 57 | 17 | |||
| 42294 | 124818 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2390 Bay St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 5999369.64058 | 2120155.29961 | 37.8015045809211 | -122.446354985487 | (37.8015045809211, -122.446354985487) | 13 | 9 | 1 | 57 | 17 | |||
| 187689 | 124817 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2390 Bay St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 5999351.89108 | 2120153.56245 | 37.8014987974014 | -122.44641628148 | (37.8014987974014, -122.44641628148) | 13 | 9 | 1 | 57 | 17 | |||
| 169926 | 23548 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2822 Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 35 | 4X4 | 6005698.29125 | 2120114.21678 | 37.8017511939304 | -122.424452054622 | (37.8017511939304, -122.424452054622) | 5 | 9 | 1 | 28858 | 32 | |||
| 189674 | 125282 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1151 Lombard St | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 17 | 6006775.37415 | 2120099.55836 | 37.8017717101681 | -122.420723801756 | (37.8017717101681, -122.420723801756) | 5 | 1 | 1 | 28858 | 32 | ||||
| 128560 | 250218 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 310 Filbert St | 1 | Front Yard : Yard | Tree | Private 2 | 12 | Width 0ft | 6011294.98745 | 2120066.49067 | 37.8019346079448 | -122.40508143388 | (37.8019346079448, -122.40508143388) | 3 | 1 | 10 | 308 | 23 | |||
| 182360 | 23547 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2806 Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 35 | 4X4 | 6005703.65589 | 2120048.52482 | 37.8015711235559 | -122.424428815235 | (37.8015711235559, -122.424428815235) | 5 | 9 | 1 | 28858 | 32 | |||
| 116972 | 125295 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1306x Montgomery St | 24 | Median : Yard | Tree | DPW 1 | 5 | Width 8ft | 6011445.95838 | 2119999.7387 | 37.8017597617706 | -122.40455429894 | (37.8017597617706, -122.40455429894) | 3 | 1 | 10 | 308 | 23 | |||
| 98009 | 64087 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 474 Filbert St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/30/1987 12:00:00 AM | 19 | Permit Number 24849 | 6010630.0202 | 2119988.0407 | 37.8016820080225 | -122.407377010865 | (37.8016820080225, -122.407377010865) | 3 | 1 | 10 | 308 | 23 | ||
| 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 | |||
| 64098 | 124873 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1825 Chestnut St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6003120.45934 | 2119937.01258 | 37.8011187286059 | -122.433359866463 | (37.8011187286059, -122.433359866463) | 13 | 9 | 1 | 57 | 17 | |||
| 84294 | 124872 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 3349 Buchanan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6003223.45415 | 2119912.17321 | 37.8010563687224 | -122.433001684494 | (37.8010563687224, -122.433001684494) | 13 | 9 | 1 | 57 | 17 | |||
| 61209 | 105786 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 3230 LYON ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 36 | 6x4 | 5999056.8 | 2119897.7 | 37.8007794095396 | -122.447418998501 | (37.8007794095396, -122.447418998501) | 13 | 9 | 1 | 57 | 17 | |||
| 3691 | 121048 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 2652 Polk St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6006192.78395747 | 2119877.54417008 | 37.8011292630692 | -122.422724050002 | (37.8011292630692, -122.422724050002) | 13 | 9 | 1 | 28858 | 32 | ||||
| 138101 | 41284 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 2652 Polk St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/29/2000 12:00:00 AM | Permit Number 41962 | 6006192.78395747 | 2119877.54417008 | 37.8011292630692 | -122.422724050002 | (37.8011292630692, -122.422724050002) | 13 | 9 | 1 | 28858 | 32 | ||
| 125682 | 124871 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 3337 Buchanan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6003229.70384 | 2119862.87803 | 37.8009213714956 | -122.43297653406 | (37.8009213714956, -122.43297653406) | 13 | 9 | 1 | 57 | 17 | |||
| 49773 | 111913 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 3333 Buchanan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | 6003233.77012 | 2119841.33042 | 37.8008624380147 | -122.432960922718 | (37.8008624380147, -122.432960922718) | 13 | 9 | 1 | 57 | 17 | ||||
| 162137 | 49013 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2450 Francisco St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/31/2002 12:00:00 AM | 12 | Permit Number 46199 | 5999595.37201 | 2119840.257 | 37.8006524480994 | -122.445551188556 | (37.8006524480994, -122.445551188556) | 13 | 9 | 1 | 57 | 17 | ||
| 144819 | 68988 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 3336 Scott St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/04/1994 12:00:00 AM | 15 | Permit Number 32980 | 6000849.98968 | 2119837.16995 | 37.8007155175595 | -122.441209485631 | (37.8007155175595, -122.441209485631) | 13 | 9 | 1 | 57 | 17 | |
| 59777 | 113939 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 3333 BUCHANAN ST | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6003181 | 2119826 | 37.8008173514055 | -122.433142433403 | (37.8008173514055, -122.433142433403) | 13 | 9 | 1 | 57 | 17 | |||||
| 97577 | 18693 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 230X Richardson Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 36 | 3X3 | 5999111.30068 | 2119825.97999 | 37.8005855999524 | -122.447225239545 | (37.8005855999524, -122.447225239545) | 13 | 9 | 1 | 57 | 17 | |||
| 27997 | 111166 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 100X Magnolia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | 3x3 | 6003221.39002 | 2119816.29205 | 37.8007929869658 | -122.433001973165 | (37.8007929869658, -122.433001973165) | 13 | 9 | 1 | 57 | 17 |
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) );