221 rows where Police Districts = 1 and qSpecies_id = 53 sorted by DBH

View and edit SQL

Police Districts

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)
3804 117402 Undocumented 4 Ficus nitida :: Laurel Fig 53 75x BEACH ST 5 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6009846 2122112 37.8074699595292 -122.410240137563 (37.8074699595292, -122.410240137563) 3 1 10 308 23
9205 96542 Permitted Site 7 Ficus nitida :: Laurel Fig 53 100 Pine St 3 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
11284 117186 Undocumented 4 Ficus nitida :: Laurel Fig 53 201x GREENWICH ST 3 Sidewalk: Curb side : Cutout Tree Private 2       6x6   6011833 2120374 37.8028090150843 -122.40324129087 (37.8028090150843, -122.40324129087) 3 1 10 308 23
11874 110985 Permitted Site 7 Ficus nitida :: Laurel Fig 53 245x North Point St 4 Sidewalk: Curb side : Cutout Tree Private 2           6009556.06624176 2121873.83782792 37.8067997698403 -122.41122668881 (37.8067997698403, -122.41122668881) 3 1 10 308 23
12765 117400 Undocumented 4 Ficus nitida :: Laurel Fig 53 75x BEACH ST 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6009846 2122112 37.8074699595292 -122.410240137563 (37.8074699595292, -122.410240137563) 3 1 10 308 23
18979 110983 Permitted Site 7 Ficus nitida :: Laurel Fig 53 245x North Point St 2 Sidewalk: Curb side : Cutout Tree Private 2           6009556.06624176 2121873.83782792 37.8067997698403 -122.41122668881 (37.8067997698403, -122.41122668881) 3 1 10 308 23
20131 113298 Undocumented 4 Ficus nitida :: Laurel Fig 53 700X DAVIS ST 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6013208 2119104 37.7993985951424 -122.398393892143 (37.7993985951424, -122.398393892143) 3 1 10 28860 6
25834 93215 Permitted Site 7 Ficus nitida :: Laurel Fig 53 499 Jackson St   Sidewalk: Curb side : Cutout Tree Private 2   02/25/2010 12:00:00 AM   3x3 Permit Number 53209 6011715 2118034 37.7963773511427 -122.403484907832 (37.7963773511427, -122.403484907832) 3 1 10 28860 4
25882 40606 Permitted Site 7 Ficus nitida :: Laurel Fig 53 744 Montgomery St 1 Sidewalk: Curb side : Cutout Tree Private 2   07/18/2005 12:00:00 AM     Permit Number 48110 6011762.49765618 2117875.03517526 37.7959435248288 -122.403309366526 (37.7959435248288, -122.403309366526) 3 1 10 28860 4
28305 121625 Undocumented 4 Ficus nitida :: Laurel Fig 53 101x Trenton St 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6010049 2117862 37.7958118850813 -122.409237502382 (37.7958118850813, -122.409237502382) 3 1 10 308 4
28662 99265 Undocumented 4 Ficus nitida :: Laurel Fig 53 1340 Leavenworth St 2 Sidewalk: Curb side : Cutout Tree Private 2           6008042 2117018 37.7933818247157 -122.416122311937 (37.7933818247157, -122.416122311937) 5 1 10 28858 21
29680 65045 Permitted Site 7 Ficus nitida :: Laurel Fig 53 1066 Filbert St 1 Sidewalk: Curb side : Cutout Tree Private 2   02/02/2004 12:00:00 AM     Permit Number 45972 6007827.74406772 2119607.84984942 37.8004808586212 -122.417047244449 (37.8004808586212, -122.417047244449) 5 1 1 308 32
31247 106090 Permitted Site 7 Ficus nitida :: Laurel Fig 53 615 Front St 2 Sidewalk: Curb side : Cutout Tree Private 2           6012797.6 2118350.4 37.7973065196251 -122.399761086072 (37.7973065196251, -122.399761086072) 3 1 10 28860 6
35016 120999 Undocumented 4 Ficus nitida :: Laurel Fig 53 390 Sutter St 1 Sidewalk: Curb side : Cutout Tree Private 2       4x6   6010815 2115725 37.7899870820688 -122.406436332672 (37.7899870820688, -122.406436332672) 5 1 10 28857 6
35445 253642 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 427 Columbus Ave 2 Sidewalk: Curb side : Cutout Tree DPW 1       3x3   6010361.39347 2118971.94152 37.7988770104459 -122.408234880635 (37.7988770104459, -122.408234880635) 3 1 10 308 4
35514 110994 Permitted Site 7 Ficus nitida :: Laurel Fig 53 245x North Point St 13 Sidewalk: Curb side : Cutout Tree Private 2           6009556.06624176 2121873.83782792 37.8067997698403 -122.41122668881 (37.8067997698403, -122.41122668881) 3 1 10 308 23
41004 99266 Undocumented 4 Ficus nitida :: Laurel Fig 53 1340 Leavenworth St 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6008042 2117018 37.7933818247157 -122.416122311937 (37.7933818247157, -122.416122311937) 5 1 10 28858 21
41372 95268 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 2245 Jones St 7 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency         6007968.5 2120121.7 37.801899679212 -122.416596591624 (37.801899679212, -122.416596591624) 5 1 10 308 32
43430 112751 Undocumented 4 Ficus nitida :: Laurel Fig 53 135X TRENTON ST 5 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
44244 110995 Permitted Site 7 Ficus nitida :: Laurel Fig 53 245x North Point St 14 Sidewalk: Curb side : Cutout Tree Private 2           6009556.06624176 2121873.83782792 37.8067997698403 -122.41122668881 (37.8067997698403, -122.41122668881) 3 1 10 308 23
46917 122714 Undocumented 4 Ficus nitida :: Laurel Fig 53 855x Kearny St 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6011188 2117923 37.7960431220576 -122.40530062832 (37.7960431220576, -122.40530062832) 3 1 10 28857 4
47816 107839 Undocumented 4 Ficus nitida :: Laurel Fig 53 1000x LEAVENWORTH ST 4 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6008256 2115925 37.790392745036 -122.415304443955 (37.790392745036, -122.415304443955) 5 1 10 28858 21
48222 100107 Undocumented 4 Ficus nitida :: Laurel Fig 53 461 Jefferson St 5 Sidewalk: Curb side : Cutout Tree Private 2           6007004.8 2122229.7 37.8076334645768 -122.420081138169 (37.8076334645768, -122.420081138169) 5 1 1 308 32
52074 117185 Undocumented 4 Ficus nitida :: Laurel Fig 53 201x GREENWICH ST 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6011833 2120374 37.8028090150843 -122.40324129087 (37.8028090150843, -122.40324129087) 3 1 10 308 23
53203 110987 Permitted Site 7 Ficus nitida :: Laurel Fig 53 245x North Point St 6 Sidewalk: Curb side : Cutout Tree Private 2           6009556.06624176 2121873.83782792 37.8067997698403 -122.41122668881 (37.8067997698403, -122.41122668881) 3 1 10 308 23
55775 44125 Permitted Site 7 Ficus nitida :: Laurel Fig 53 431 Jackson St 1 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 43629 6012046.82946857 2118068.4414971 37.796490448112 -122.402339123693 (37.796490448112, -122.402339123693) 3 1 10 28860 4
56447 117399 Undocumented 4 Ficus nitida :: Laurel Fig 53 75x BEACH ST 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6009846 2122112 37.8074699595292 -122.410240137563 (37.8074699595292, -122.410240137563) 3 1 10 308 23
57914 106105 Permitted Site 7 Ficus nitida :: Laurel Fig 53 744x MONTGOMERY ST 2 Sidewalk: Curb side : Cutout Tree Private 2           6011751.6 2117873.5 37.7959387009634 -122.403346966666 (37.7959387009634, -122.403346966666) 3 1 10 28860 4
59611 106127 Undocumented 4 Ficus nitida :: Laurel Fig 53 1609 POWELL ST 2 Sidewalk: Curb side : Cutout Tree Private 2       5x5   6009609.6 2119208.8 37.7994852403002 -122.410853080764 (37.7994852403002, -122.410853080764) 3 1 10 308 4
65259 105658 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 901X Lombard St 5 Sidewalk: Curb side : Cutout Tree DPW 1 SFUSD         6007813.03508 2120272.88823 37.8023060594642 -122.417145293832 (37.8023060594642, -122.417145293832) 5 1 1 308 32
67256 110998 Permitted Site 7 Ficus nitida :: Laurel Fig 53 245x North Point St 17 Sidewalk: Curb side : Cutout Tree Private 2           6009556.06624176 2121873.83782792 37.8067997698403 -122.41122668881 (37.8067997698403, -122.41122668881) 3 1 10 308 23
68154 113299 Undocumented 4 Ficus nitida :: Laurel Fig 53 700X DAVIS ST 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6013208 2119104 37.7993985951424 -122.398393892143 (37.7993985951424, -122.398393892143) 3 1 10 28860 6
73243 110988 Permitted Site 7 Ficus nitida :: Laurel Fig 53 245x North Point St 7 Sidewalk: Curb side : Cutout Tree Private 2           6009556.06624176 2121873.83782792 37.8067997698403 -122.41122668881 (37.8067997698403, -122.41122668881) 3 1 10 308 23
73387 113573 Undocumented 4 Ficus nitida :: Laurel Fig 53 901 LOMBARD ST 4 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency     3x3   6007813 2120272 37.8023036186348 -122.417145352251 (37.8023036186348, -122.417145352251) 5 1 10 308 32
74708 52076 Permitted Site 7 Ficus nitida :: Laurel Fig 53 245x North Point St 1 Sidewalk: Curb side : Cutout Tree Private 2   08/19/2005 12:00:00 AM     Permit Number 48272 6009556.06624176 2121873.83782792 37.8067997698403 -122.41122668881 (37.8067997698403, -122.41122668881) 3 1 10 308 23
77923 256355 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1000 Bay St 1 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW     3x3   6005985 2121074 37.804402699388 -122.423528183462 (37.804402699388, -122.423528183462) 5 1 1 28858 32
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
171851 110997 Permitted Site 7 Ficus nitida :: Laurel Fig 53 245x North Point St 16 Sidewalk: Curb side : Cutout Tree Private 2           6009556.06624176 2121873.83782792 37.8067997698403 -122.41122668881 (37.8067997698403, -122.41122668881) 3 1 10 308 23
177916 113574 Undocumented 4 Ficus nitida :: Laurel Fig 53 901 LOMBARD ST 5 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency     3x3   6007968 2120121 37.8018977290678 -122.416598272247 (37.8018977290678, -122.416598272247) 5 1 10 308 32
178040 120998 Undocumented 4 Ficus nitida :: Laurel Fig 53 370 Sutter St 1 Sidewalk: Curb side : Cutout Tree Private 2       4x6   6010792 2115565 37.789546473623 -122.406504631878 (37.789546473623, -122.406504631878) 5 1 10 28857 6
179087 105657 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 901X Lombard St 4 Sidewalk: Curb side : Cutout Tree DPW 1 SFUSD         6007813.03508 2120272.88823 37.8023060594642 -122.417145293832 (37.8023060594642, -122.417145293832) 5 1 1 308 32
182487 256357 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1000 Bay St 3 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW     3x3   6005985 2121074 37.804402699388 -122.423528183462 (37.804402699388, -122.423528183462) 5 1 1 28858 32
182516 44225 Permitted Site 7 Ficus nitida :: Laurel Fig 53 2 Broadway 1 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 43670 6013393.18767606 2119056.04835121 37.799277245684 -122.397749707821 (37.799277245684, -122.397749707821) 3 1 10 28860 6
182781 117184 Undocumented 4 Ficus nitida :: Laurel Fig 53 201x GREENWICH ST 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6011833 2120374 37.8028090150843 -122.40324129087 (37.8028090150843, -122.40324129087) 3 1 10 308 23
183563 110986 Permitted Site 7 Ficus nitida :: Laurel Fig 53 245x North Point St 5 Sidewalk: Curb side : Cutout Tree Private 2           6009556.06624176 2121873.83782792 37.8067997698403 -122.41122668881 (37.8067997698403, -122.41122668881) 3 1 10 308 23
185775 117401 Undocumented 4 Ficus nitida :: Laurel Fig 53 75x BEACH ST 4 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6009846 2122112 37.8074699595292 -122.410240137563 (37.8074699595292, -122.410240137563) 3 1 10 308 23
186331 122713 Undocumented 4 Ficus nitida :: Laurel Fig 53 855x Kearny St 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6011188 2117923 37.7960431220576 -122.40530062832 (37.7960431220576, -122.40530062832) 3 1 10 28857 4
188867 121000 Undocumented 4 Ficus nitida :: Laurel Fig 53 390 Sutter St 2 Sidewalk: Curb side : Cutout Tree Private 2       4x6   6010815 2115725 37.7899870820688 -122.406436332672 (37.7899870820688, -122.406436332672) 5 1 10 28857 6
191099 100527 Undocumented 4 Ficus nitida :: Laurel Fig 53 1728 Jones St 1 Sidewalk: Curb side : Cutout Tree Private 2       4.5x6   6008341 2118363 37.7970916696404 -122.415182998934 (37.7970916696404, -122.415182998934) 5 1 10 308 21
191709 52838 Permitted Site 7 Ficus nitida :: Laurel Fig 53 795on Trenton Pacific Ave 1 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 48857 6010309.20673902 2118158.51574656 37.7966406195852 -122.408358059553 (37.7966406195852, -122.408358059553) 3 1 10 308 4
192030 256356 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1000 Bay St 2 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW     3x3   6005985 2121074 37.804402699388 -122.423528183462 (37.804402699388, -122.423528183462) 5 1 1 28858 32
193319 257913 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 690X Vallejo St 2 Sidewalk: Curb side : Cutout Tree DPW 1       3x3   6010415 2118850 37.7985451903817 -122.408040779349 (37.7985451903817, -122.408040779349) 3 1 10 308 4
74524 95408 Undocumented 4 Ficus nitida :: Laurel Fig 53 1257 Union St 1 Sidewalk: Curb side : Cutout Tree Private 2     10 3x3 No record of tree being permitted for planting. 6006989.2 2119073.6 37.7989667366731 -122.419911018667 (37.7989667366731, -122.419911018667) 5 1 10 28858 32
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
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
34305 102625 Permitted Site 7 Ficus nitida :: Laurel Fig 53 1865X Grant Ave 3 Sidewalk: Curb side : Cutout Tree Private 2     12 3x3 Permit Number 17346 6010349.4 2120908.5 37.804193651889 -122.408413053021 (37.804193651889, -122.408413053021) 3 1 10 308 23
38641 102621 Permitted Site 7 Ficus nitida :: Laurel Fig 53 190X Pfeiffer St 5 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
54854 18511 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 626 Powell St 1 Sidewalk: Curb side : Cutout Tree DPW 1     12 4x4   6010143.9604039 2115933.8512359 37.7905229751065 -122.408772822924 (37.7905229751065, -122.408772822924) 5 1 10 28857 21
63395 21810 Permitted Site 7 Ficus nitida :: Laurel Fig 53 2627 Taylor St 2 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
64595 20258 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 495X Lombard St 2 Sidewalk: Curb side : Cutout Tree DPW 1     12 8x8   6009991.46116 2120547.45752 37.8031822677113 -122.409626234652 (37.8031822677113, -122.409626234652) 3 1 10 308 23
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
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
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
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
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
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
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

Next page

Advanced export

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

CSV options:

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