trees
1,626 rows where qSpecies_id = 53 sorted by Police Districts
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
77953 | 4657 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 599X Columbus Ave | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 75 | 3x3 | 6009795.85928 | 2119479.51144 | 37.8002389893085 | -122.41022767808 | (37.8002389893085, -122.41022767808) | 3 | 1 | 10 | 308 | 4 | |||
79373 | 29910 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 791x Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 6008575.10006 | 2120353.42874 | 37.8025700449008 | -122.414513871045 | (37.8025700449008, -122.414513871045) | 3 | 1 | 10 | 308 | 32 | ||||
79809 | 4593 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 100 Columbus Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 90 | 3X3 | 6011460.12974 | 2118136.30046 | 37.7966440043551 | -122.404374021953 | (37.7966440043551, -122.404374021953) | 3 | 1 | 10 | 308 | 4 | |||
80346 | 122712 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 855x Kearny St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6011188 | 2117923 | 37.7960431220576 | -122.40530062832 | (37.7960431220576, -122.40530062832) | 3 | 1 | 10 | 28857 | 4 | ||||
82064 | 117188 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 200x GREENWICH ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9x6 | 6011596 | 2120619 | 37.8034684863456 | -122.404078688914 | (37.8034684863456, -122.404078688914) | 3 | 1 | 10 | 28860 | 6 | ||||
82985 | 51836 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 601 Jackson St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/13/2005 12:00:00 AM | Permit Number 48064 | 6011231.99946686 | 2117956.55670314 | 37.7961377205174 | -122.405150744824 | (37.7961377205174, -122.405150744824) | 3 | 1 | 10 | 28857 | 4 | |||
83480 | 120997 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 360 Sutter St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x6 | 6010836 | 2115566 | 37.7895516808253 | -122.406352466288 | (37.7895516808253, -122.406352466288) | 5 | 1 | 10 | 28857 | 6 | ||||
83502 | 112109 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 699x COLUMBUS AVE | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6009471 | 2119722 | 37.8008865881446 | -122.411368963081 | (37.8008865881446, -122.411368963081) | 3 | 1 | 10 | 308 | 4 | |||
84456 | 254739 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 501 Columbus Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6009970 | 2119286 | 37.7997174141149 | -122.409611414659 | (37.7997174141149, -122.409611414659) | 3 | 1 | 10 | 308 | 4 | ||||
84659 | 117187 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 200x GREENWICH ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9x6 | 6011596 | 2120619 | 37.8034684863456 | -122.404078688914 | (37.8034684863456, -122.404078688914) | 3 | 1 | 10 | 28860 | 6 | ||||
85015 | 21812 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 2631 Taylor St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 4X4 | 6008221.30715 | 2121822.90168 | 37.806584965078 | -122.415842290697 | (37.806584965078, -122.415842290697) | 5 | 1 | 10 | 308 | 23 | |||
87782 | 21807 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 2600X Taylor St | 12 | Sidewalk: Property side : Cutout | Tree | DPW 1 | 03/01/2016 12:00:00 AM | 3 | 3X3 | 6008553.39113 | 2121935.04647 | 37.8069115498008 | -122.414700989571 | (37.8069115498008, -122.414700989571) | 3 | 1 | 10 | 308 | 23 | ||
88644 | 4629 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 427 Columbus Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 22 | 3x3 | 6010259.97829 | 2119047.3818 | 37.7990784717377 | -122.408591136664 | (37.7990784717377, -122.408591136664) | 3 | 1 | 10 | 308 | 4 | |||
88657 | 110984 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 245x North Point St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6009556.06624176 | 2121873.83782792 | 37.8067997698403 | -122.41122668881 | (37.8067997698403, -122.41122668881) | 3 | 1 | 10 | 308 | 23 | |||||
89782 | 4755 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1250 Columbus Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 70 | 4X4 | 6007719.65165 | 2121534.55679 | 37.8057650284682 | -122.417557918763 | (37.8057650284682, -122.417557918763) | 5 | 1 | 10 | 308 | 23 | |||
90288 | 9941 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 601X Green St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/12/2016 12:00:00 AM | 3 | 5x6 | Resulted descion 9/7/16 -DE | 6010050.95997 | 2119172.47111 | 37.7994102279433 | -122.409323246083 | (37.7994102279433, -122.409323246083) | 3 | 1 | 10 | 308 | 4 | |
93249 | 9942 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 601X Green St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 80 | 6x5 | 6010129.67767 | 2119173.05666 | 37.7994162456962 | -122.409050895178 | (37.7994162456962, -122.409050895178) | 3 | 1 | 10 | 308 | 4 | |||
94426 | 23139 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 406X Columbus Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 25 | 6x3 | 6010454.05392 | 2118948.49862 | 37.798817830036 | -122.407912589535 | (37.798817830036, -122.407912589535) | 3 | 1 | 10 | 308 | 23 | |||
95573 | 106226 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 350 Sutter St | 1 | Sidewalk: Curb side : Cutout | Tree | MTA 3 | 22 | 3x5 | 6010879 | 2115572 | 37.7895705607022 | -122.406204113006 | (37.7895705607022, -122.406204113006) | 5 | 1 | 10 | 28857 | 6 | |||
96003 | 4693 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 781 Columbus Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | 6009263.30605 | 2120079.28345 | 37.801855948749 | -122.412112938993 | (37.801855948749, -122.412112938993) | 3 | 1 | 10 | 308 | 23 | |||
96257 | 4573 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 2X Columbus Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 75 | 4 | 6011767.886 | 2117749.45401 | 37.7955990100454 | -122.403281883117 | (37.7955990100454, -122.403281883117) | 3 | 1 | 10 | 28860 | 4 | |||
99464 | 112750 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 135X TRENTON ST | 4 | Sidewalk: Curb side : Cutout | Tree | Housing Authority 15 | Private | 3x3 | 6009947 | 2118097 | 37.7964514227226 | -122.409607037418 | (37.7964514227226, -122.409607037418) | 3 | 1 | 10 | 308 | 4 | |||
99484 | 116156 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 755 SANSOME ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6012110 | 2118369 | 37.7973192357085 | -122.402141679915 | (37.7973192357085, -122.402141679915) | 3 | 1 | 10 | 308 | 4 | ||||
100883 | 103485 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 2375X Jones St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 24 | 9x9 | 6007909 | 2120582.3 | 37.8031610244278 | -122.416835141288 | (37.8031610244278, -122.416835141288) | 5 | 1 | 1 | 308 | 32 | |||
101743 | 98254 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 571 Broadway | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6010764.4 | 2118536 | 37.797702579203 | -122.406809598565 | (37.797702579203, -122.406809598565) | 3 | 1 | 10 | 308 | 4 | ||||
102458 | 99269 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 1327 Leavenworth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6008010 | 2116967 | 37.7932399920042 | -122.416229420814 | (37.7932399920042, -122.416229420814) | 5 | 1 | 10 | 28858 | 32 | ||||
103171 | 4672 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 659 Columbus Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 60 | 3X3 | 6009562.16476 | 2119705.53614 | 37.8008464951643 | -122.411052329729 | (37.8008464951643, -122.411052329729) | 3 | 1 | 10 | 308 | 4 | |||
103458 | 59152 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 190X Pfeiffer St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/02/1980 12:00:00 AM | 12 | 3x3 | Permit Number 18461 | 6009909.46799044 | 2121095.5996991 | 37.8046827351828 | -122.409948693589 | (37.8046827351828, -122.409948693589) | 3 | 1 | 10 | 308 | 23 | |
104635 | 9944 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 601X Green St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 80 | 3X3 | 6010102.57699 | 2119179.92896 | 37.7994335971632 | -122.409145158717 | (37.7994335971632, -122.409145158717) | 3 | 1 | 10 | 308 | 4 | |||
105476 | 120996 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 352 SUTTER ST | 2 | Sidewalk: Curb side : Cutout | Tree | MTA 3 | 3x5 | 6010871.2 | 2115571.1 | 37.789567653219 | -122.406231036885 | (37.789567653219, -122.406231036885) | 5 | 1 | 10 | 28857 | 6 | ||||
107778 | 51837 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 601 Jackson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/13/2005 12:00:00 AM | Permit Number 48064 | 6011231.99946686 | 2117956.55670314 | 37.7961377205174 | -122.405150744824 | (37.7961377205174, -122.405150744824) | 3 | 1 | 10 | 28857 | 4 | |||
108315 | 251688 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 925 Sutter St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6008132 | 2115128 | 37.788197407905 | -122.415677021756 | (37.788197407905, -122.415677021756) | 13 | 1 | 10 | 28858 | 21 | ||||
109285 | 11031 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1469 Hyde St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 30 | 3x3 | 6007466.43149 | 2117407.25122 | 37.7944182331434 | -122.418141434433 | (37.7944182331434, -122.418141434433) | 5 | 1 | 10 | 28858 | 32 | |||
110473 | 49870 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 607@ JACKSON Front St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/23/2003 12:00:00 AM | Permit Number 46636 | 6012838.36008757 | 2118235.08187981 | 37.7969921557212 | -122.399611944085 | (37.7969921557212, -122.399611944085) | 3 | 1 | 10 | 28860 | 6 | |||
111411 | 253520 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 2626 Larkin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/19/2017 12:00:00 AM | 3 | 3x3 | 6006643 | 2120264 | 37.8022157634914 | -122.42119356192 | (37.8022157634914, -122.42119356192) | 5 | 1 | 1 | 28858 | 32 | ||
113684 | 13012 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 400 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 125 | 3X3 | 6010380.84909 | 2120676.56867 | 37.8035585868989 | -122.408287852113 | (37.8035585868989, -122.408287852113) | 3 | 1 | 10 | 308 | 23 | |||
114077 | 100108 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 461 Jefferson St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6007004.8 | 2122229.7 | 37.8076334645768 | -122.420081138169 | (37.8076334645768, -122.420081138169) | 5 | 1 | 1 | 308 | 32 | |||||
117475 | 97938 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 2133 Stockton St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6009831.3 | 2121360.2 | 37.8054048804892 | -122.410237896013 | (37.8054048804892, -122.410237896013) | 3 | 1 | 10 | 308 | 23 | ||||
118093 | 102618 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 190X Pfeiffer St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | Permit Number 18461 | 6009953.9 | 2121114.8 | 37.8047379445266 | -122.409796287705 | (37.8047379445266, -122.409796287705) | 3 | 1 | 10 | 308 | 23 | ||
118656 | 96541 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 100 Pine St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 767720 | 6013094 | 2116579 | 37.7924591936564 | -122.398611089295 | (37.7924591936564, -122.398611089295) | 4 | 1 | 10 | 28860 | 6 | ||||
119311 | 4652 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 599X Columbus Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 22 | 3x3 | 6009795.85928 | 2119479.51144 | 37.8002389893085 | -122.41022767808 | (37.8002389893085, -122.41022767808) | 3 | 1 | 10 | 308 | 4 | |||
119461 | 11088 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1896 Hyde St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 45 | 4x4 | 6007314.6733074 | 2118798.6130291 | 37.7982300223497 | -122.418765257989 | (37.7982300223497, -122.418765257989) | 5 | 1 | 10 | 28858 | 32 | |||
120103 | 40159 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 2211 Stockton St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/12/1999 12:00:00 AM | Permit Number 41353 | 6009783.18603588 | 2121626.8328918 | 37.8061342908169 | -122.410423240295 | (37.8061342908169, -122.410423240295) | 3 | 1 | 10 | 308 | 23 | |||
122731 | 100106 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 461 Jefferson St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6007004.8 | 2122229.7 | 37.8076334645768 | -122.420081138169 | (37.8076334645768, -122.420081138169) | 5 | 1 | 1 | 308 | 32 | |||||
122874 | 94039 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 722 Columbus Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 20 | 3x3 | 6009288 | 2119899 | 37.801362320674 | -122.412014738208 | (37.801362320674, -122.412014738208) | 3 | 1 | 10 | 308 | 4 | |||
122892 | 21816 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 2669 Taylor St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 4X4 | 6008202.59065 | 2121958.17011 | 37.8069553257036 | -122.415916647815 | (37.8069553257036, -122.415916647815) | 5 | 1 | 10 | 308 | 23 | |||
124571 | 98660 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 701X Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 3x3 | 6008942.64461 | 2120384.58796 | 37.8026762417443 | -122.41324418324 | (37.8026762417443, -122.41324418324) | 3 | 1 | 10 | 308 | 23 | |||
126032 | 110991 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 245x North Point St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6009556.06624176 | 2121873.83782792 | 37.8067997698403 | -122.41122668881 | (37.8067997698403, -122.41122668881) | 3 | 1 | 10 | 308 | 23 | |||||
126231 | 112107 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 699x COLUMBUS AVE | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6009471 | 2119722 | 37.8008865881446 | -122.411368963081 | (37.8008865881446, -122.411368963081) | 3 | 1 | 10 | 308 | 4 | |||
126620 | 13077 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 645X Lombard St | 7 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 18 | 3X3 | 6009269.1098284 | 2120449.52185 | 37.8028728569333 | -122.412119036156 | (37.8028728569333, -122.412119036156) | 3 | 1 | 10 | 308 | 23 | |||
127504 | 4686 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 722 Columbus Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 4x4 | 6009336.3456 | 2120034.69791 | 37.8017376257964 | -122.411857034683 | (37.8017376257964, -122.411857034683) | 3 | 1 | 10 | 308 | 23 | |||
128036 | 4704 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 940 Columbus Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 30 | 3X3 | 6008705.2823 | 2120549.3769 | 37.8031153821632 | -122.414077244448 | (37.8031153821632, -122.414077244448) | 3 | 1 | 10 | 308 | 23 | |||
131150 | 51835 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 601 Jackson St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/13/2005 12:00:00 AM | Permit Number 48064 | 6011231.99946686 | 2117956.55670314 | 37.7961377205174 | -122.405150744824 | (37.7961377205174, -122.405150744824) | 3 | 1 | 10 | 28857 | 4 | |||
131827 | 99267 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 1340 Leavenworth St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6008042 | 2117018 | 37.7933818247157 | -122.416122311937 | (37.7933818247157, -122.416122311937) | 5 | 1 | 10 | 28858 | 21 | ||||
132857 | 11053 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1603 Hyde St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 70 | 3X3 | 6007388.39144 | 2117874.05515 | 37.795695567741 | -122.418444578472 | (37.795695567741, -122.418444578472) | 5 | 1 | 10 | 28858 | 32 | |||
134743 | 107366 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 851 POST ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6008079.7 | 2114773.8 | 37.7872219209064 | -122.415832880524 | (37.7872219209064, -122.415832880524) | 13 | 1 | 9 | 28858 | 36 | |||
135761 | 11176 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 2740 Hyde St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 24 | 3X3 | Permit Number 769071 | 6006912.1976315 | 2121679.9811894 | 37.8061188596167 | -122.420362567782 | (37.8061188596167, -122.420362567782) | 5 | 1 | 1 | 28858 | 32 | ||
136446 | 110992 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 245x North Point St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6009556.06624176 | 2121873.83782792 | 37.8067997698403 | -122.41122668881 | (37.8067997698403, -122.41122668881) | 3 | 1 | 10 | 308 | 23 | |||||
138529 | 4746 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 1199X Columbus Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | 3X4 | 6007816.30894 | 2121179.41413 | 37.8047953349468 | -122.417198239329 | (37.8047953349468, -122.417198239329) | 5 | 1 | 1 | 308 | 32 | |||
138724 | 19491 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 10X Saroyan Pl | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6010944.42859 | 2118456.69114 | 37.7974948878134 | -122.406181056735 | (37.7974948878134, -122.406181056735) | 3 | 1 | 10 | 308 | 4 | |||
138743 | 11090 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1903 Hyde St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 26 | 6x6 | 6007250.95739 | 2118862.55474 | 37.7984020026002 | -122.418990272151 | (37.7984020026002, -122.418990272151) | 5 | 1 | 10 | 28858 | 32 | |||
138984 | 110996 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 245x North Point St | 15 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6009556.06624176 | 2121873.83782792 | 37.8067997698403 | -122.41122668881 | (37.8067997698403, -122.41122668881) | 3 | 1 | 10 | 308 | 23 | |||||
139551 | 112828 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 101X COLUMBUS AVE | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 8 | 3x3 | 6011274 | 2118052 | 37.7964021326886 | -122.405012137355 | (37.7964021326886, -122.405012137355) | 3 | 1 | 10 | 308 | 4 | |||
140945 | 4683 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 707 Columbus Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 3x3 | 6009355.02929 | 2119856.39151 | 37.8012490888204 | -122.41177977375 | (37.8012490888204, -122.41177977375) | 3 | 1 | 10 | 308 | 4 | |||
141238 | 11085 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1865 Hyde St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 60 | 3X3 | 6007279.7286506 | 2118687.2113849 | 37.7979221737821 | -122.418878272086 | (37.7979221737821, -122.418878272086) | 5 | 1 | 10 | 28858 | 32 | |||
142193 | 102620 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 190X Pfeiffer St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | Permit Number 18461 | 6009953.9 | 2121114.8 | 37.8047379445266 | -122.409796287705 | (37.8047379445266, -122.409796287705) | 3 | 1 | 10 | 308 | 23 | ||
142924 | 18508 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 605X Powell St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 4X4 | 6010109.02253 | 2115823.8794949 | 37.7902190622309 | -122.408885944172 | (37.7902190622309, -122.408885944172) | 5 | 1 | 10 | 28857 | 21 | |||
143163 | 4654 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 599X Columbus Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 19 | 3x3 | 6009795.85928 | 2119479.51144 | 37.8002389893085 | -122.41022767808 | (37.8002389893085, -122.41022767808) | 3 | 1 | 10 | 308 | 4 | |||
143675 | 107836 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 1000x LEAVENWORTH ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 3x3 | 6008256 | 2115925 | 37.790392745036 | -122.415304443955 | (37.790392745036, -122.415304443955) | 5 | 1 | 10 | 28858 | 21 | |||
143936 | 106224 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 340 SUTTER ST | 1 | Sidewalk: Curb side : Cutout | Tree | MTA 3 | 24 | 3x5 | 6010923.2 | 2115578.3 | 37.7895903312377 | -122.406051628897 | (37.7895903312377, -122.406051628897) | 5 | 1 | 10 | 28857 | 6 | |||
145382 | 56574 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 100x Pfeiffer St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | 6010338.9406 | 2121168.3232 | 37.8049064763082 | -122.408467587357 | (37.8049064763082, -122.408467587357) | 3 | 1 | 10 | 308 | 23 | ||||
145725 | 112106 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 699x COLUMBUS AVE | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10 | 3x3 | 6009471 | 2119722 | 37.8008865881446 | -122.411368963081 | (37.8008865881446, -122.411368963081) | 3 | 1 | 10 | 308 | 4 | |||
146277 | 18498 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 501 Powell St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 4X4 | 6010152.17541 | 2115498.44033 | 37.7893279015823 | -122.408713669265 | (37.7893279015823, -122.408713669265) | 5 | 1 | 10 | 28857 | 21 | |||
147035 | 13023 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 440 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/04/2015 08:29:00 AM | 3 | 4X4 | 6010228.79362 | 2120718.91833 | 37.8036663528767 | -122.408817039093 | (37.8036663528767, -122.408817039093) | 3 | 1 | 10 | 308 | 23 | ||
148636 | 112826 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 101X COLUMBUS AVE | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 8 | 3x3 | 6011274 | 2118052 | 37.7964021326886 | -122.405012137355 | (37.7964021326886, -122.405012137355) | 3 | 1 | 10 | 308 | 4 | |||
150358 | 258047 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 1250 Columbus Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/13/2019 12:00:00 AM | 3 | 3x3 | 6007719 | 2121534 | 37.805763462997 | -122.417560134413 | (37.805763462997, -122.417560134413) | 5 | 1 | 10 | 308 | 23 | ||
150414 | 117403 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 75x BEACH ST | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6009846 | 2122112 | 37.8074699595292 | -122.410240137563 | (37.8074699595292, -122.410240137563) | 3 | 1 | 10 | 308 | 23 | ||||
150611 | 4595 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 170 Columbus Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 35 | 3X3 | 6011285.22621 | 2118219.63855 | 37.7968630551885 | -122.404985101368 | (37.7968630551885, -122.404985101368) | 3 | 1 | 10 | 308 | 4 | |||
151684 | 4640 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 501 Columbus Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 25 | 3x3 | 6010023.44398 | 2119255.15348 | 37.7996357117478 | -122.409424299905 | (37.7996357117478, -122.409424299905) | 3 | 1 | 10 | 308 | 4 | |||
151930 | 18509 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 605X Powell St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 4X4 | 6010109.02253 | 2115823.8794949 | 37.7902190622309 | -122.408885944172 | (37.7902190622309, -122.408885944172) | 5 | 1 | 10 | 28857 | 21 | |||
151939 | 257912 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 690X Vallejo St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6010415 | 2118850 | 37.7985451903817 | -122.408040779349 | (37.7985451903817, -122.408040779349) | 3 | 1 | 10 | 308 | 4 | ||||
152048 | 92896 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 226 North Point St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/21/2009 12:00:00 AM | 3x3 | 6009506.8 | 2122067 | 37.8073273816355 | -122.411410840149 | (37.8073273816355, -122.411410840149) | 3 | 1 | 10 | 308 | 23 | |||
154699 | 121624 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 101x Trenton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6010049 | 2117862 | 37.7958118850813 | -122.409237502382 | (37.7958118850813, -122.409237502382) | 3 | 1 | 10 | 308 | 4 | ||||
154973 | 21805 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 2600X Taylor St | 10 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/01/2016 12:00:00 AM | 3 | 3X3 | 6008553.39113 | 2121935.04647 | 37.8069115498008 | -122.414700989571 | (37.8069115498008, -122.414700989571) | 3 | 1 | 10 | 308 | 23 | ||
155310 | 11113 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 2037 Hyde St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 3X3 | 6007192.03327 | 2119340.88684 | 37.7997120641075 | -122.41922811701 | (37.7997120641075, -122.41922811701) | 5 | 1 | 1 | 28858 | 32 | |||
155532 | 13054 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 562 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 32 | 3x3 | 6009643.06131 | 2120540.81886 | 37.80314451067 | -122.41083141813 | (37.80314451067, -122.41083141813) | 3 | 1 | 10 | 308 | 23 | |||
157130 | 11034 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 1509 HYDE ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 70 | 3X3 | 6007406.1 | 2117518.3 | 37.7947197495209 | -122.418358066687 | (37.7947197495209, -122.418358066687) | 5 | 1 | 10 | 28858 | 32 | |||
157239 | 44224 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 150 Pacific Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 43669 | 6012974 | 2118691 | 37.7982515579635 | -122.399174613744 | (37.7982515579635, -122.399174613744) | 3 | 1 | 10 | 28860 | 6 | ||||
158673 | 117398 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 75x BEACH ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6009846 | 2122112 | 37.8074699595292 | -122.410240137563 | (37.8074699595292, -122.410240137563) | 3 | 1 | 10 | 308 | 23 | ||||
159297 | 106225 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 340 SUTTER ST | 2 | Sidewalk: Curb side : Cutout | Tree | MTA 3 | 22 | 3x5 | 6010923.2 | 2115578.3 | 37.7895903312377 | -122.406051628897 | (37.7895903312377, -122.406051628897) | 5 | 1 | 10 | 28857 | 6 | |||
159895 | 113553 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 700 TAYLOR ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/24/2015 12:00:00 AM | 3x3 | 6009263 | 2115423 | 37.7890709188275 | -122.411784791395 | (37.7890709188275, -122.411784791395) | 5 | 1 | 10 | 28857 | 21 | |||
159917 | 122820 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 776 Bush St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 6009771.51732552 | 2115777.23613944 | 37.7900720800575 | -122.410050397484 | (37.7900720800575, -122.410050397484) | 5 | 1 | 10 | 28857 | 21 | ||||
160977 | 4597 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 170 Columbus Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 40 | 3X3 | 6011285.22621 | 2118219.63855 | 37.7968630551885 | -122.404985101368 | (37.7968630551885, -122.404985101368) | 3 | 1 | 10 | 308 | 4 | |||
162852 | 19490 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 10X Saroyan Pl | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6010944.42859 | 2118456.69114 | 37.7974948878134 | -122.406181056735 | (37.7974948878134, -122.406181056735) | 3 | 1 | 10 | 308 | 4 | |||
163667 | 102619 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 190X Pfeiffer St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | Permit Number 18461 | 6009953.9 | 2121114.8 | 37.8047379445266 | -122.409796287705 | (37.8047379445266, -122.409796287705) | 3 | 1 | 10 | 308 | 23 | ||
166051 | 18510 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 605X Powell St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 4X4 | 6010109.02253 | 2115823.8794949 | 37.7902190622309 | -122.408885944172 | (37.7902190622309, -122.408885944172) | 5 | 1 | 10 | 28857 | 21 | |||
166466 | 11087 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1896 Hyde St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 70 | 4x4 | 6007314.6733074 | 2118798.6130291 | 37.7982300223497 | -122.418765257989 | (37.7982300223497, -122.418765257989) | 5 | 1 | 10 | 28858 | 32 | |||
168220 | 258046 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 1250 Columbus Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/13/2019 12:00:00 AM | 3 | 3x3 | 6007719 | 2121534 | 37.805763462997 | -122.417560134413 | (37.805763462997, -122.417560134413) | 5 | 1 | 10 | 308 | 23 | ||
168362 | 95269 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 2245 Jones St | 8 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 6x6 | 6007968.5 | 2120121.7 | 37.801899679212 | -122.416596591624 | (37.801899679212, -122.416596591624) | 5 | 1 | 10 | 308 | 32 | |||
168710 | 21809 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 2627 Taylor St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 4X4 | 6008310.29957 | 2121825.65474 | 37.806597526846 | -122.415534509856 | (37.806597526846, -122.415534509856) | 5 | 1 | 10 | 308 | 23 |
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) );