trees

194,517 rows sorted by Location descending

✎ View and edit SQL

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)
159384 135126 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 1403 The Embarcadero 28 Sidewalk: Curb side : Yard Tree Private 2     7 Width 7ft   6009794.33207 2122480.55113 37.8084790122577 -122.410444987853 (37.8084790122577, -122.410444987853) 3 1 10 308 23
61438 107905 Undocumented 4 Platanus x hispanica :: Sycamore: London Plane 27 2650 Mason St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6008717 2122501 37.8084747060674 -122.414174852603 (37.8084747060674, -122.414174852603) 3 1 10 308 23
88031 107908 Undocumented 4 Platanus x hispanica :: Sycamore: London Plane 27 2650 Mason St 4 Sidewalk: Curb side : Cutout Tree Private 2           6008717 2122501 37.8084747060674 -122.414174852603 (37.8084747060674, -122.414174852603) 3 1 10 308 23
147498 107906 Undocumented 4 Platanus x hispanica :: Sycamore: London Plane 27 2650 Mason St 2 Sidewalk: Curb side : Cutout Tree Private 2           6008717 2122501 37.8084747060674 -122.414174852603 (37.8084747060674, -122.414174852603) 3 1 10 308 23
175877 107907 Undocumented 4 Platanus x hispanica :: Sycamore: London Plane 27 2650 Mason St 3 Sidewalk: Curb side : Cutout Tree Private 2           6008717 2122501 37.8084747060674 -122.414174852603 (37.8084747060674, -122.414174852603) 3 1 10 308 23
5415 135124 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 1403 The Embarcadero 25 Sidewalk: Curb side : Yard Tree Private 2     5 Width 7ft   6009811.99757 2122478.3969 37.8084740875856 -122.410383699057 (37.8084740875856, -122.410383699057) 3 1 10 308 23
116038 135135 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 1405 The Embarcadero 7 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 4ft   6009673.36232 2122480.3312 37.8084716261397 -122.410863623176 (37.8084716261397, -122.410863623176) 3 1 10 308 23
27006 135144 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 1411 The Embarcadero 1 Sidewalk: Curb side : Yard Tree Private 2     8 Width 6ft   6009592.59224 2122479.55439 37.8084649639619 -122.411143096484 (37.8084649639619, -122.411143096484) 3 1 10 308 23
115331 135131 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 1405 The Embarcadero 3 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 4ft   6009694.30992 2122477.21308 37.8084642391119 -122.410790907582 (37.8084642391119, -122.410790907582) 3 1 10 308 23
151614 135142 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 1405 The Embarcadero 14 Sidewalk: Curb side : Yard Tree Private 2     13 Width 6ft   6009611.73281 2122475.6117 37.8084552117099 -122.411076576336 (37.8084552117099, -122.411076576336) 3 1 10 308 23
5770 135182 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 102 Jefferson St 1 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 4ft   6008631.75152 2122495.19515 37.8084539787355 -122.414469468391 (37.8084539787355, -122.414469468391) 3 1 10 308 23
60022 135140 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 1405 The Embarcadero 12 Sidewalk: Curb side : Yard Tree Private 2     12 Width 6ft   6009635.03806 2122470.3531 37.8084420798001 -122.410995550124 (37.8084420798001, -122.410995550124) 3 1 10 308 23
56650 135183 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 102 Jefferson St 2 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 4ft   6008602.26751 2122490.00271 37.8084380652267 -122.414571138551 (37.8084380652267, -122.414571138551) 3 1 10 308 23
181757 135138 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 1405 The Embarcadero 10 Sidewalk: Curb side : Yard Tree Private 2     11 Width 6ft   6009649.70927 2122468.55895 37.8084379762014 -122.410944649373 (37.8084379762014, -122.410944649373) 3 1 10 308 23
22335 135123 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 1403 The Embarcadero 24 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 4ft   6009926.6128 2122461.41087 37.8084338726024 -122.409985839882 (37.8084338726024, -122.409985839882) 3 1 10 308 23
79975 135134 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 1405 The Embarcadero 6 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 3ft   6009670.63247 2122464.24581 37.8084273066306 -122.410871933791 (37.8084273066306, -122.410871933791) 3 1 10 308 23
187498 135184 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 102 Jefferson St 3 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 4ft   6008568.3734 2122486.00433 37.8084251824404 -122.414688155629 (37.8084251824404, -122.414688155629) 3 1 10 308 23
165221 135121 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 1403 The Embarcadero 22 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 4ft   6009946.94212 2122457.40911 37.8084240241286 -122.40991520173 (37.8084240241286, -122.40991520173) 3 1 10 308 23
127481 135130 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 1405 The Embarcadero 2 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 5ft   6009691.87426 2122460.8233 37.8084191003246 -122.410798178599 (37.8084191003246, -122.410798178599) 3 1 10 308 23
153822 135118 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 1403 The Embarcadero 19 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 4ft   6009967.89586 2122454.59011 37.8084174581688 -122.409842486156 (37.8084174581688, -122.409842486156) 3 1 10 308 23
183800 135115 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 1403 The Embarcadero 16 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 4ft   6009986.16168 2122452.42406 37.8084125343708 -122.409779119036 (37.8084125343708, -122.409779119036) 3 1 10 308 23
138782 135185 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 102 Jefferson St 4 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 4ft   6008537.7982 2122481.66229 37.8084115424152 -122.4147936623 (37.8084115424152, -122.4147936623) 3 1 10 308 23
109666 85055 Permitted Site 7 Platanus x hispanica :: Sycamore: London Plane 27 77X Jefferson St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/27/2007 12:00:00 AM     Permit Number 49393 6008831 2122475 37.8084097192397 -122.413778482528 (37.8084097192397, -122.413778482528) 3 1 10 308 23
101634 135098 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 1401 The Embarcadero 56 Sidewalk: Property side : Yard Tree Private 2     6     6010217.76574 2122446.50226 37.808409250946 -122.408977168373 (37.808409250946, -122.408977168373)   1 10 308 23
96491 135113 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 1403 The Embarcadero 13 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 6ft   6010004.11504 2122449.66633 37.8084059684239 -122.40971679149 (37.8084059684239, -122.40971679149) 3 1 10 308 23
140887 135122 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 1403 The Embarcadero 23 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 4ft   6009935.99448 2122450.45895 37.8084043271757 -122.409952598229 (37.8084043271757, -122.409952598229) 3 1 10 308 23
67984 135186 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 102 Jefferson St 5 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 4ft   6008499.16063 2122476.10539 37.8083941135688 -122.414926985002 (37.8083941135688, -122.414926985002) 3 1 10 308 23
123966 135120 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 1403 The Embarcadero 21 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 4ft   6009955.71768 2122446.17053 37.8083936576166 -122.409884037512 (37.8083936576166, -122.409884037512) 3 1 10 308 23
133961 135110 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 1403 The Embarcadero 10 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 4ft   6010045.12861 2122444.34572 37.808393657599 -122.409574476475 (37.808393657599, -122.409574476475) 3 1 10 308 23
89617 135117 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 1403 The Embarcadero 18 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 4ft   6009974.57717 2122443.69332 37.8083879127434 -122.409818593865 (37.8083879127434, -122.409818593865) 3 1 10 308 23
144013 135107 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 1403 The Embarcadero 7 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 4ft   6010064.28228 2122441.56354 37.8083870916662 -122.40950799322 (37.8083870916662, -122.40950799322) 3 1 10 308 23
73761 135187 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 102 Jefferson St 6 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 4ft   6008466.65712 2122472.35446 37.8083819880082 -122.415039206912 (37.8083819880082, -122.415039206912) 3 1 10 308 23
187815 135112 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 1403 The Embarcadero 12 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 6ft   6010033.25655 2122436.21857 37.8083706772342 -122.409614989141 (37.8083706772342, -122.409614989141) 3 1 10 308 23
158698 134958 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 2571 Powell St 1 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 3ft   6009185.01162 2122452.80097 37.8083686402722 -122.412551754077 (37.8083686402722, -122.412551754077) 3 1 10 308 23
51101 135097 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 1401 The Embarcadero 55 Sidewalk: Property side : Yard Tree Private 2     6     6010211.16016 2122431.69205 37.8083682157885 -122.408998983212 (37.8083682157885, -122.408998983212) 3 1 10 308 23
89810 135109 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 1403 The Embarcadero 9 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 4ft   6010051.49773 2122432.85725 37.808362470021 -122.409551622933 (37.808362470021, -122.409551622933) 3 1 10 308 23
53963 84931 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 101 Jefferson St 1 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 49345 6008717 2122460 37.8083621304447 -122.41417194996 (37.8083621304447, -122.41417194996) 3 1 10 308 23
78816 84934 Permitted Site 7 Tree(s) :: 17 101 Jefferson St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/06/2007 12:00:00 AM     Permit Number 49345 6008717 2122460 37.8083621304447 -122.41417194996 (37.8083621304447, -122.41417194996) 3 1 10 308 23
99636 84933 Permitted Site 7 Tree(s) :: 17 101 Jefferson St 1 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 49345 6008717 2122460 37.8083621304447 -122.41417194996 (37.8083621304447, -122.41417194996) 3 1 10 308 23
102582 84932 Permitted Site 7 Tree(s) :: 17 101 Jefferson St 1 Sidewalk: Curb side : Cutout Tree Private 2           6008717 2122460 37.8083621304447 -122.41417194996 (37.8083621304447, -122.41417194996) 3 1 10 308 23
177174 135188 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 102 Jefferson St 7 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 4ft   6008435.19986 2122465.54658 37.8083615275283 -122.415147591413 (37.8083615275283, -122.415147591413) 3 1 10 308 23
77891 135104 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 1403 The Embarcadero 4 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 4ft   6010089.2658 2122430.29329 37.8083575462248 -122.409420734681 (37.8083575462248, -122.409420734681) 3 1 10 308 23
176780 135189 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 102 Jefferson St 8 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 4ft   6008412.99212 2122463.79322 37.8083554652029 -122.415224323337 (37.8083554652029, -122.415224323337) 3 1 10 308 23
129984 135106 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 1403 The Embarcadero 6 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 5ft   6010072.1454 2122429.74587 37.8083550838852 -122.409479946046 (37.8083550838852, -122.409479946046) 3 1 10 308 23
94845 135102 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 1403 The Embarcadero 2 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 3ft   6010114.95326 2122424.09004 37.8083419528727 -122.409331397845 (37.8083419528727, -122.409331397845) 3 1 10 308 23
137141 135101 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 1403 The Embarcadero 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   6010136.77661 2122419.75891 37.8083312833417 -122.409255566093 (37.8083312833417, -122.409255566093) 3 1 10 308 23
171999 135119 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 1403 The Embarcadero 20 Sidewalk: Curb side : Yard Tree Private 2     6 Width 6ft   6009951.28667 2122420.2562 37.8083222550301 -122.409897541754 (37.8083222550301, -122.409897541754) 3 1 10 308 23
145071 134953 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 145 Jefferson St 12 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 3ft   6008630.92798 2122446.98018 37.8083215463747 -122.414468904523 (37.8083215463747, -122.414468904523) 3 1 10 308 23
47604 104262 Undocumented 4 Metrosideros excelsa :: New Zealand Xmas Tree 16 199X Jefferson St 1 Sidewalk: Curb side : Cutout Tree Private 2           6008482.28692 2122448.56477 37.8083175458446 -122.41498343065 (37.8083175458446, -122.41498343065) 3 1 10 308 23
66899 104263 Undocumented 4 Metrosideros excelsa :: New Zealand Xmas Tree 16 199X Jefferson St 2 Sidewalk: Curb side : Cutout Tree Private 2           6008482.28692 2122448.56477 37.8083175458446 -122.41498343065 (37.8083175458446, -122.41498343065) 3 1 10 308 23
94320 104266 Undocumented 4 Metrosideros excelsa :: New Zealand Xmas Tree 16 199X Jefferson St 5 Sidewalk: Curb side : Cutout Tree Private 2           6008482.28692 2122448.56477 37.8083175458446 -122.41498343065 (37.8083175458446, -122.41498343065) 3 1 10 308 23
108485 104265 Undocumented 4 Metrosideros excelsa :: New Zealand Xmas Tree 16 199X Jefferson St 4 Sidewalk: Curb side : Cutout Tree Private 2           6008482.28692 2122448.56477 37.8083175458446 -122.41498343065 (37.8083175458446, -122.41498343065) 3 1 10 308 23
178487 104264 Undocumented 4 Metrosideros excelsa :: New Zealand Xmas Tree 16 199X Jefferson St 3 Sidewalk: Curb side : Cutout Tree Private 2           6008482.28692 2122448.56477 37.8083175458446 -122.41498343065 (37.8083175458446, -122.41498343065) 3 1 10 308 23
77532 135116 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 1403 The Embarcadero 17 Sidewalk: Curb side : Yard Tree Private 2     6 Width 6ft   6009971.32821 2122416.85808 37.8083140478199 -122.409827942302 (37.8083140478199, -122.409827942302) 3 1 10 308 23
164876 135096 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 1401 The Embarcadero 54 Sidewalk: Property side : Yard Tree Private 2     5     6010210.74566 2122411.37483 37.8083124065619 -122.408998983215 (37.8083124065619, -122.408998983215) 3 1 10 308 23
129980 134952 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 145 Jefferson St 11 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 3ft   6008606.49793 2122443.43729 37.8083104460454 -122.414553200668 (37.8083104460454, -122.414553200668) 3 1 10 308 23
40181 135114 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 1403 The Embarcadero 14 Sidewalk: Curb side : Yard Tree Private 2     11 Width 6ft   6009988.36934 2122413.52121 37.8083058406042 -122.409768730958 (37.8083058406042, -122.409768730958) 3 1 10 308 23
175692 134959 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 2571 Powell St 2 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   6009188.56229 2122429.4929 37.8083048414551 -122.412537817266 (37.8083048414551, -122.412537817266) 3 1 10 308 23
168725 134951 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 145 Jefferson St 10 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 3ft   6008585.64556 2122440.14481 37.8083002342206 -122.414625132963 (37.8083002342206, -122.414625132963) 3 1 10 308 23
126863 135111 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 1403 The Embarcadero 11 Sidewalk: Curb side : Yard Tree Private 2     12 Width 6ft   6010025.47642 2122407.9816 37.8082927096198 -122.409639920168 (37.8082927096198, -122.409639920168) 3 1 10 308 23
122650 135100 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 1401 The Embarcadero 58 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   6010152.09213 2122405.39789 37.8082927096059 -122.409201548321 (37.8082927096059, -122.409201548321) 3 1 10 308 23
81431 135108 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 1403 The Embarcadero 8 Sidewalk: Curb side : Yard Tree Private 2     8 Width 6ft   6010050.31847 2122404.48556 37.8082845023835 -122.40955370034 (37.8082845023835, -122.40955370034) 3 1 10 308 23
98793 135105 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 1403 The Embarcadero 5 Sidewalk: Curb side : Yard Tree Private 2     6 Width 6ft   6010067.69012 2122402.63653 37.8082803987861 -122.409493450268 (37.8082803987861, -122.409493450268) 3 1 10 308 23
81212 134950 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 145 Jefferson St 3 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 3ft   6008530.77029 2122432.69748 37.808276702577 -122.414814516693 (37.808276702577, -122.414814516693) 3 1 10 308 23
84279 135103 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 1403 The Embarcadero 3 Sidewalk: Curb side : Yard Tree Private 2     7 Width 6ft   6010086.51333 2122398.36657 37.8082697292203 -122.409428005703 (37.8082697292203, -122.409428005703) 3 1 10 308 23
68369 134949 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 145 Jefferson St 2 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 3ft   6008502.47143 2122430.52761 37.8082691545757 -122.414912299066 (37.8082691545757, -122.414912299066) 3 1 10 308 23
35774 136578 DPW Maintained 1 Syagrus romanzoffianum :: Queen Palm 85 145 Jefferson St 9 Sidewalk: Property side : Yard Tree Private 2     10 Width 4ft   6008572.42572 2122428.93464 37.808268711206 -122.414670090059 (37.808268711206, -122.414670090059) 3 1 10 308 23
27175 131691 DPW Maintained 1 Musa spp :: Banana 380 145 Jefferson St 7 Sidewalk: Property side : Yard Tree Private 2     7 Width 4ft   6008568.16914 2122427.24291 37.8082638269937 -122.414684701334 (37.8082638269937, -122.414684701334) 3 1 10 308 23
118644 135094 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 1401 The Embarcadero 52 Sidewalk: Property side : Yard Tree Private 2     5     6010218.18108 2122393.28877 37.8082631632688 -122.408971973894 (37.8082631632688, -122.408971973894) 3 1 10 308 23
99543 136577 DPW Maintained 1 Syagrus romanzoffianum :: Queen Palm 85 145 Jefferson St 8 Sidewalk: Property side : Yard Tree Private 2     12 Width 4ft   6008571.571 2122426.85002 37.8082629393464 -122.414672900433 (37.8082629393464, -122.414672900433) 3 1 10 308 23
165471 134948 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 145 Jefferson St 1 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 3ft   6008484.71937 2122427.98044 37.8082611631784 -122.414973554579 (37.8082611631784, -122.414973554579) 3 1 10 308 23
70125 136575 DPW Maintained 1 Syagrus romanzoffianum :: Queen Palm 85 145 Jefferson St 5 Sidewalk: Property side : Yard Tree Private 2     11 Width 4ft   6008547.84348 2122425.87999 37.8082589427652 -122.414754947386 (37.8082589427652, -122.414754947386) 3 1 10 308 23
96464 136576 DPW Maintained 1 Syagrus romanzoffianum :: Queen Palm 85 145 Jefferson St 6 Sidewalk: Property side : Yard Tree Private 2     10 Width 4ft   6008548.79083 2122424.56718 37.8082553913493 -122.41475157585 (37.8082553913493, -122.41475157585) 3 1 10 308 23
177121 136574 DPW Maintained 1 Syagrus romanzoffianum :: Queen Palm 85 145 Jefferson St 4 Sidewalk: Property side : Yard Tree Private 2     10 Width 4ft   6008546.66406 2122423.80202 37.8082531709192 -122.414758881938 (37.8082531709192, -122.414758881938) 3 1 10 308 23
94047 135093 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 1401 The Embarcadero 51 Sidewalk: Property side : Yard Tree Private 2     5     6010231.51821 2122384.94629 37.8082410039906 -122.408925228011 (37.8082410039906, -122.408925228011) 3 1 10 308 23
14887 134960 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 2571 Powell St 3 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 3ft   6009191.48002 2122404.19262 37.8082355370081 -122.412525930024 (37.8082355370081, -122.412525930024) 3 1 10 308 23
69494 134965 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 2350 Stockton St 4 Sidewalk: Curb side : Yard Tree Private 2     11     6009712.7239 2122389.48119 37.8082243818107 -122.410720980795 (37.8082243818107, -122.410720980795) 3 1 10 308 23
44779 135099 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 1401 The Embarcadero 57 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   6010189.07255 2122378.93733 37.8082221272074 -122.409071698824 (37.8082221272074, -122.409071698824) 3 1 10 308 23
73610 134967 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 2100 The Embarcadero 1 Sidewalk: Curb side : Yard Tree Private 2     8     6009753.39142 2122386.8985 37.8082195704377 -122.410580057033 (37.8082195704377, -122.410580057033) 3 1 10 308 23
165158 30568 Permitted Site 7 Liquidambar styraciflua :: American Sweet Gum 37 2681 Mason St 1 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 34545 6008703.52928477 2122408.3500681 37.8082195561589 -122.414214912471 (37.8082195561589, -122.414214912471) 3 1 10 308 23
23851 134966 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 2350 Stockton St 5 Sidewalk: Curb side : Yard Tree Private 2     10     6009730.51186 2122386.61497 37.8082175092017 -122.41065921807 (37.8082175092017, -122.41065921807) 3 1 10 308 23
161987 134968 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 2100 The Embarcadero 2 Sidewalk: Curb side : Yard Tree Private 2     9     6009782.97322 2122383.0408 37.8082106365745 -122.410477408411 (37.8082106365745, -122.410477408411) 3 1 10 308 23
19851 41638 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 175 Jefferson St 6 Sidewalk: Curb side : Cutout Tree Private 2   06/05/2000 12:00:00 AM 10 2x2 Permit Number 42116 6008374.70502 2122409.49865 37.808204234292 -122.415352980375 (37.808204234292, -122.415352980375) 3 1 10 308 23
27564 135095 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 1401 The Embarcadero 53 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 4ft   6010206.33452 2122371.71058 37.8082032513446 -122.409011448713 (37.8082032513446, -122.409011448713) 3 1 10 308 23
188926 134969 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 2100 The Embarcadero 3 Sidewalk: Curb side : Yard Tree Private 2     9     6009807.03743 2122379.79592 37.8082030759684 -122.410393898262 (37.8082030759684, -122.410393898262) 3 1 10 308 23
136789 41643 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 175 Jefferson St 5 Sidewalk: Curb side : Cutout Tree Private 2   06/05/2000 12:00:00 AM 10 2x2 Permit Number 42116 6008364.2633 2122408.61155 37.8082012116738 -122.41538905396 (37.8082012116738, -122.41538905396) 3 1 10 308 23
2497 134970 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 2100 The Embarcadero 4 Sidewalk: Curb side : Yard Tree Private 2     10     6009821.57971 2122377.99729 37.8081989525817 -122.41034344359 (37.8081989525817, -122.41034344359) 3 1 10 308 23
66482 41642 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 175 Jefferson St 4 Sidewalk: Curb side : Cutout Tree Private 2   06/05/2000 12:00:00 AM 10 2x2 Permit Number 42116 6008347.81588 2122407.53263 37.8081973247997 -122.415445898318 (37.8081973247997, -122.415445898318) 3 1 10 308 23
144869 134971 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 2100 The Embarcadero 5 Sidewalk: Curb side : Yard Tree Private 2     9     6009844.16212 2122376.03453 37.8081948291999 -122.41026515223 (37.8081948291999, -122.41026515223) 3 1 10 308 23
114118 135092 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 1401 The Embarcadero 50 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 5ft   6010225.12119 2122365.6479 37.8081876571032 -122.408946004172 (37.8081876571032, -122.408946004172) 3 1 10 308 23
165504 135090 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 1401 The Embarcadero 48 Sidewalk: Property side : Yard Tree Private 2     9     6010270.12071 2122364.4312 37.8081868369173 -122.408790184942 (37.8081868369173, -122.408790184942) 3 1 10 308 23
153087 41641 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 175 Jefferson St 3 Sidewalk: Curb side : Cutout Tree Private 2   06/05/2000 12:00:00 AM 11 2x2 Permit Number 42116 6008318.31427 2122401.37399 37.8081787565193 -122.415547560374 (37.8081787565193, -122.415547560374) 3 1 10 308 23
144015 134972 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 2100 The Embarcadero 6 Sidewalk: Curb side : Yard Tree Private 2     10     6009871.42123 2122369.22021 37.8081776467351 -122.410170333112 (37.8081776467351, -122.410170333112) 3 1 10 308 23
176569 134973 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 2100 The Embarcadero 7 Sidewalk: Curb side : Yard Tree Private 2     10     6009889.50127 2122368.35067 37.8081762725918 -122.41010770071 (37.8081762725918, -122.41010770071) 3 1 10 308 23
52035 28280 Permitted Site 7 Platanus x hispanica :: Sycamore: London Plane 27 2799 Taylor St 1 Sidewalk: Curb side : Cutout Tree Private 2     6 3X3   6008221.59529 2122402.06867 37.8081752269627 -122.415882331929 (37.8081752269627, -122.415882331929) 3 1 10 308 23
173503 41640 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 175 Jefferson St 2 Sidewalk: Curb side : Cutout Tree Private 2   06/05/2000 12:00:00 AM 11 2x2 Permit Number 42116 6008303.89341 2122398.99555 37.8081714153313 -122.415597299176 (37.8081714153313, -122.415597299176) 3 1 10 308 23
42839 41639 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 175 Jefferson St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/05/2000 12:00:00 AM 11 2x2 Permit Number 42116 6008290.6132 2122398.32381 37.8081688244054 -122.415643211358 (37.8081688244054, -122.415643211358) 3 1 10 308 23
174361 134974 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 2100 The Embarcadero 8 Sidewalk: Curb side : Yard Tree Private 2     11     6009910.79688 2122364.91216 37.808168024892 -122.410033758463 (37.808168024892, -122.410033758463) 3 1 10 308 23
58158 135091 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 1401 The Embarcadero 49 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 5ft   6010242.35879 2122357.22585 37.8081654978158 -122.408885754071 (37.8081654978158, -122.408885754071) 3 1 10 308 23
122048 134975 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 2100 The Embarcadero 9 Sidewalk: Curb side : Yard Tree Private 2     11     6009928.57466 2122361.54548 37.8081597772147 -122.409971995727 (37.8081597772147, -122.409971995727) 3 1 10 308 23

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