408 rows where Police Districts = 9 and qSpecies_id = 53 sorted by rowid descending

View and edit SQL

These facets timed out: 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)
193965 108150 Undocumented 4 Ficus nitida :: Laurel Fig 53 2232 Webster St 2 Sidewalk: Curb side : Cutout Tree Private 2           6003295.44003 2116396.66877 37.7914077834913 -122.432501340527 (37.7914077834913, -122.432501340527) 13 9 1 29490 27
193625 255507 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1290X Golden Gate Ave 2 Sidewalk: Curb side : Cutout Tree DPW 1       3x3   6003415.08005 2112113.96459 37.7796553418115 -122.431781470984 (37.7796553418115, -122.431781470984) 15 9 11 29490 41
193568 26953 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 2040 Sutter St 12 Sidewalk: Curb side : Cutout Tree DPW 1     18 5x6   6002643.91242 2114436.71459 37.7859892824562 -122.43461540376 (37.7859892824562, -122.43461540376) 13 9 11 29490 27
193344 13225 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 2265 Lombard St 2 Sidewalk: Curb side : Cutout Tree DPW 1     12 3X3   6001602.67751 2119341.9386 37.799398588794 -122.438569375951 (37.799398588794, -122.438569375951) 13 9 1 57 17
192852 16949 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 625 Oak St 1 Sidewalk: Curb side : Cutout Tree DPW 1     18 3X3   6003989.24409 2110039.43116 37.7739917148646 -122.429647190447 (37.7739917148646, -122.429647190447) 7 9 11 29492 10
192777 48866 Permitted Site 7 Ficus nitida :: Laurel Fig 53 129 Oak St 1 Sidewalk: Curb side : Cutout Tree Private 2   11/15/2002 12:00:00 AM     Permit Number 46075 6006370.62112219 2110394.65908683 37.7751016387897 -122.421434823029 (37.7751016387897, -122.421434823029) 7 9 11 28852 10
191412 2431 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 490X Oak St 1 Sidewalk: Curb side : Cutout Tree DPW 1     25 3X3   6004657.78302 2110211.29448 37.7745014417711 -122.427346845616 (37.7745014417711, -122.427346845616) 7 9 11 28852 10
191157 16897 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 385 Oak St 1 Sidewalk: Curb side : Cutout Tree DPW 1     18 3x3   6005198.99692 2110159.80887 37.7743906686767 -122.425471016021 (37.7743906686767, -122.425471016021) 7 9 11 28852 10
191064 21654 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1698 Sutter St 1 Sidewalk: Curb side : Cutout Tree DPW 1     12 3X3   6004474.7477956 2114689.3781886 37.7867867977452 -122.428299224496 (37.7867867977452, -122.428299224496) 13 9 11 28858 27
190628 7233 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1045 Fillmore St 2 Sidewalk: Curb side : Cutout Tree DPW 1     12 4X4   6003367.24511 2111893.72513 37.7790479074603 -122.431931222001 (37.7790479074603, -122.431931222001) 15 9 11 29490 41
190566 21751 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1787X Steiner St 1 Sidewalk: Curb side : Cutout Tree DPW 1     12 4X4   6002537.7996519 2114344.6571005 37.7857304915222 -122.434975938446 (37.7857304915222, -122.434975938446) 13 9 11 29490 13
190125 52718 Permitted Site 7 Ficus nitida :: Laurel Fig 53 1330on LARKIN Bush St 3 Sidewalk: Curb side : Cutout Tree Private 2   04/04/2006 12:00:00 AM     Permit Number 48769 6007121.03491046 2115409.40396286 37.7889131924877 -122.419194766666 (37.7889131924877, -122.419194766666) 13 9 10 28858 21
189695 21726 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1942 Sutter St 1 Sidewalk: Curb side : Cutout Tree DPW 1     18 4X4   6003284.347 2114523.85502 37.7862648839776 -122.432405902047 (37.7862648839776, -122.432405902047) 13 9 11 29490 27
188786 99614 Undocumented 4 Ficus nitida :: Laurel Fig 53 3233X Buchanan St 3 Sidewalk: Curb side : Cutout Tree Private 2     12 3x3   6003300 2119605 37.8002172925371 -122.432714848025 (37.8002172925371, -122.432714848025) 13 9 1 57 17
188563 10618 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 350 Gough St 1 Sidewalk: Curb side : Cutout Tree DPW 1     18 3x3   6006025.52151 2110969.11138 37.7766594822933 -122.422669431679 (37.7766594822933, -122.422669431679) 7 9 11 28852 10
188273 2450 Permitted Site 7 Ficus nitida :: Laurel Fig 53 1805X Sutter St 1 Sidewalk: Curb side : Cutout Tree Private 2     12 4x4   6003959.520066 2114567.2690482 37.7864223498862 -122.430073076908 (37.7864223498862, -122.430073076908) 13 9 11 29490 13
188066 9689 Permitted Site 7 Ficus nitida :: Laurel Fig 53 332 Gough St 2 Sidewalk: Curb side : Cutout Tree Private 2     16 3x3   6006025.5202 2110969.11106 37.7766594813407 -122.422669436188 (37.7766594813407, -122.422669436188) 7 9 11 28852 10
187860 22712 Permitted Site 7 Ficus nitida :: Laurel Fig 53 1401X Turk St 12 Sidewalk: Curb side : Cutout Tree Police Dept 10     18 4x4   6003306.8488585 2112395.4775226 37.7804221702729 -122.43217599894 (37.7804221702729, -122.43217599894) 15 9 11 29490 41
187443 22718 Permitted Site 7 Ficus nitida :: Laurel Fig 53 1401X Turk St 6 Sidewalk: Curb side : Cutout Tree Police Dept 10     18 4x4   6003306.8488585 2112395.4775226 37.7804221702729 -122.43217599894 (37.7804221702729, -122.43217599894) 15 9 11 29490 41
187091 100051 Undocumented 4 Ficus nitida :: Laurel Fig 53 3233X Buchanan St 3 Sidewalk: Curb side : Cutout Tree Private 2     12 3x3   6003300 2119605 37.8002172925371 -122.432714848025 (37.8002172925371, -122.432714848025) 13 9 1 57 17
186717 107211 Undocumented 4 Ficus nitida :: Laurel Fig 53 2255 CLAY ST 1 Sidewalk: Curb side : Cutout Tree Private 2           6003966.3 2116269.9 37.7910977281266 -122.430171131086 (37.7910977281266, -122.430171131086) 13 9 1 29490 27
186277 13199 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 2130X Lombard St 1 Sidewalk: Curb side : Cutout Tree DPW 1     90 3X3   6002179.06604 2119515.41872 37.7999076905723 -122.436587295662 (37.7999076905723, -122.436587295662) 13 9 1 57 17
186252 116029 Undocumented 4 Ficus nitida :: Laurel Fig 53 1500 PACIFIC AVE 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6006937 2117734 37.7952855901943 -122.419996533467 (37.7952855901943, -122.419996533467) 13 9 10 28858 32
186128 21645 Permitted Site 7 Ficus nitida :: Laurel Fig 53 1657 Sutter St 2 Sidewalk: Curb side : Cutout Tree Private 2   03/23/1990 12:00:00 AM 18 4X4   6004676.7022509 2114666.9735246 37.7867367053745 -122.427598912468 (37.7867367053745, -122.427598912468) 13 9 11 28858 13
185695 60219 Permitted Site 7 Ficus nitida :: Laurel Fig 53 1812 Broadway 1 Sidewalk: Curb side : Cutout Tree Private 2   07/07/1982 12:00:00 AM 18 3x3 Permit Number 19769 6004928.04684857 2117801.00675234 37.795356184696 -122.426952612815 (37.795356184696, -122.426952612815) 13 9 1 28858 27
184916 20245 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1823 Steiner St 1 Sidewalk: Curb side : Cutout Tree DPW 1   09/13/1989 12:00:00 AM 12 3X3   6002519.5885419 2114476.0123893 37.7860901257054 -122.435048341611 (37.7860901257054, -122.435048341611) 13 9 1 29490 27
184850 2719 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 2185X Bush St 2 Sidewalk: Curb side : Cutout Tree DPW 1     12 3X3   6003092.7695 2114646.14799 37.786589804405 -122.433077450713 (37.786589804405, -122.433077450713) 13 9 11 29490 27
184672 113275 Permitted Site 7 Ficus nitida :: Laurel Fig 53 2147 Union St 2 Sidewalk: Curb side : Cutout Tree Private 2           6002730.25600058 2118492.02135193 37.7971290147198 -122.43460675571 (37.7971290147198, -122.43460675571) 13 9 1 57 17
184329 173906 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 2510 Van Ness Ave 2 Sidewalk: Curb side : Cutout Tree DPW 1           6005854.79213 2118988.36383 37.7986687249765 -122.423830387644 (37.7986687249765, -122.423830387644) 13 9 1 28858 32
184158 127219 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 2864 Broadway 8 Front Yard : Yard Tree Private 2     8 Width 4ft Permit Number 782825 5999916.98549 2117117.82475 37.7931957274607 -122.444242532876 (37.7931957274607, -122.444242532876) 13 9 1 57 27
183408 50980 Permitted Site 7 Ficus nitida :: Laurel Fig 53 201 Richardson Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   07/06/2004 12:00:00 AM   3x3 Permit Number 47465 5999116.7 2119758.3 37.8004000774175 -122.447201682136 (37.8004000774175, -122.447201682136) 13 9 1 57 17
183181 108106 Undocumented 4 Ficus nitida :: Laurel Fig 53 1990X Laguna St 1 Sidewalk: Curb side : Cutout Tree Private 2 Port         6004838 2115780 37.7898019192352 -122.427120168027 (37.7898019192352, -122.427120168027) 13 9 1 28858 27
183127 7232 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1045 Fillmore St 1 Sidewalk: Curb side : Cutout Tree DPW 1     12 4X4   6003365.392 2111902.08022 37.7790707434033 -122.431938229416 (37.7790707434033, -122.431938229416) 15 9 11 29490 41
183120 17367 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 2308X Gough St 4 Sidewalk: Curb side : Cutout Tree DPW 1     24 3X3   6005067.32521 2117488.78546 37.794506778582 -122.426448444628 (37.794506778582, -122.426448444628) 13 9 1 28858 27
183025 26841 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 100 Van Ness Ave 3 Sidewalk: Curb side : Cutout Tree DPW 1     18 3X3 Permit Number 779930 6006975.88726 2110943.04151 37.7766414730488 -122.419379980819 (37.7766414730488, -122.419379980819) 7 9 9 28852 36
182795 26424 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 555 Fulton St 12 Sidewalk: Curb side : Cutout Tree DPW 1     6 3X3   6005277.15037 2111634.16402 37.7784433040001 -122.425305605903 (37.7784433040001, -122.425305605903) 7 9 11 28852 10
182401 99616 Undocumented 4 Ficus nitida :: Laurel Fig 53 3233X Buchanan St 5 Sidewalk: Curb side : Cutout Tree Private 2     12 3x3   6003300 2119605 37.8002172925371 -122.432714848025 (37.8002172925371, -122.432714848025) 13 9 1 57 17
182329 21698 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1890 Sutter St 3 Sidewalk: Curb side : Cutout Tree DPW 1     18 4x4   6003576.7245218 2114564.5327129 37.7863931493079 -122.431397256992 (37.7863931493079, -122.431397256992) 13 9 11 29490 27
181893 7246 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1700 Fillmore St 3 Sidewalk: Curb side : Cutout Tree DPW 1     18 5x5   6003087.664 2114207.65389 37.7853855210138 -122.433063773672 (37.7853855210138, -122.433063773672) 13 9 11 29490 13
181230 7271 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1761 Fillmore St 4 Sidewalk: Curb side : Cutout Tree DPW 1     12 4X4   6003011.13827 2114398.62455 37.7859055370085 -122.433342180608 (37.7859055370085, -122.433342180608) 13 9 11 29490 13
180211 18159 Permitted Site 7 Ficus nitida :: Laurel Fig 53 1401X Gough St 1 Sidewalk: Curb side : Cutout Tree Private 2     40 3x3   6005423.15 2114537.67279 37.7864238707484 -122.425007174907 (37.7864238707484, -122.425007174907) 13 9 11 28858 13
179910 27490 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 2107 Van Ness Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1     20 3X3   6005886.29279 2117665.93165 37.7950394389183 -122.42362731207 (37.7950394389183, -122.42362731207) 13 9 1 28858 27
179011 100052 Undocumented 4 Ficus nitida :: Laurel Fig 53 3233X Buchanan St 4 Sidewalk: Curb side : Cutout Tree Private 2     12 3x3   6003300 2119605 37.8002172925371 -122.432714848025 (37.8002172925371, -122.432714848025) 13 9 1 57 17
178705 59665 Permitted Site 7 Ficus nitida :: Laurel Fig 53 993 Steiner St 1 Sidewalk: Curb side : Cutout Tree Private 2   03/30/1981 12:00:00 AM 12 2x2 Permit Number 19087 6002914.43276984 2111641.44659541 37.7783295332017 -122.433479648258 (37.7783295332017, -122.433479648258) 15 9 11 29492 41
177482 255340 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1881 Sutter St 6 Sidewalk: Curb side : Cutout Tree DPW 1           6003626.50122 2114526.01983 37.7862902235864 -122.431222292272 (37.7862902235864, -122.431222292272) 13 9 11 29490 13
176842 99613 Undocumented 4 Ficus nitida :: Laurel Fig 53 3233X Buchanan St 2 Sidewalk: Curb side : Cutout Tree Private 2     12 3x3   6003300 2119605 37.8002172925371 -122.432714848025 (37.8002172925371, -122.432714848025) 13 9 1 57 17
176749 6380 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 310 Elm St 3 Sidewalk: Curb side : Cutout Tree DPW 1     18 4X4   6006136.3622128 2112667.0618885 37.7813278942368 -122.422406674363 (37.7813278942368, -122.422406674363) 7 9 11 28852 41
176167 16388 Permitted Site 7 Ficus nitida :: Laurel Fig 53 238 Myrtle St 2 Sidewalk: Curb side : Cutout Tree Private 2     6 3X3   6006262.13214 2114058.51032 37.7851555645201 -122.422070450769 (37.7851555645201, -122.422070450769) 13 9 11 28858 41
175601 7197 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 949 Fillmore St 4 Sidewalk: Curb side : Cutout Tree DPW 1     12 3X3   6003395.68163 2111577.87165 37.7781822644093 -122.431810290332 (37.7781822644093, -122.431810290332) 15 9 11 29492 41
175212 13101 Permitted Site 7 Ficus nitida :: Laurel Fig 53 1501 Lombard St 4 Sidewalk: Curb side : Cutout Tree Private 2     12 3x3   6005049.00181 2119804.80205 37.800864933484 -122.426676850993 (37.800864933484, -122.426676850993) 13 9 1 57 17
174828 21667 Permitted Site 7 Ficus nitida :: Laurel Fig 53 1773 Sutter St 1 Sidewalk: Curb side : Cutout Tree Private 2     12 4X4   6004123.7222039 2114590.0968475 37.7864943276059 -122.429506607504 (37.7864943276059, -122.429506607504) 13 9 11 29490 13
174162 16730 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 19X Hollis St 1 Sidewalk: Curb side : Cutout Tree DPW 1     6 4X4   6003888.91549 2113509.70556 37.7835145469728 -122.430241873385 (37.7835145469728, -122.430241873385) 7 9 11 29490 41
174129 16872 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 259 Oak St 1 Sidewalk: Curb side : Cutout Tree DPW 1     18 4X4   6005773.57352 2110239.8238 37.7746428175577 -122.423489134945 (37.7746428175577, -122.423489134945) 7 9 11 28852 10
173262 16934 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 534 Oak St 1 Sidewalk: Property side : Cutout Tree DPW 1     24 3X3   6004202.21217 2110156.57626 37.7743254232669 -122.428918851232 (37.7743254232669, -122.428918851232) 7 9 11 28852 10
172889 7892 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1187 Franklin St 9 Sidewalk: Curb side : Cutout Tree DPW 1     24 3X3   6006000.38049 2113895.86172 37.7846942050769 -122.422964467171 (37.7846942050769, -122.422964467171) 13 9 11 28858 41
172277 10647 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 913 Hayes St 1 Sidewalk: Curb side : Cutout Tree DPW 1   01/02/1991 12:00:00 AM 12 3X3   6003471.55966 2110689.4075 37.775747062973 -122.431484357932 (37.775747062973, -122.431484357932) 15 9 11 29492 10
172169 117345 Undocumented 4 Ficus nitida :: Laurel Fig 53 395 HAYES ST 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6006014 2111158 37.7771774746178 -122.422722714586 (37.7771774746178, -122.422722714586) 7 9 11 28852 10
171543 18697 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 251X Richardson Ave 4 Median : Cutout Tree DPW 1     12 100   5999064.164064 2119841.396854 37.8006252370733 -122.447389461083 (37.8006252370733, -122.447389461083) 13 9 1 57 17
171446 257980 Significant Tree 6 Ficus nitida :: Laurel Fig 53 2864 Broadway 3 Front Yard : Yard Tree Private 2         Permit Number 782825 5999909.76407 2117098.92712 37.7931434275556 -122.444266160734 (37.7931434275556, -122.444266160734) 13 9 1 57 27
170574 114952 Undocumented 4 Ficus nitida :: Laurel Fig 53 601X OCTAVIA ST 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6005348 2111368 37.7777164851071 -122.42504156742 (37.7777164851071, -122.42504156742) 7 9 11 28852 10
169890 21652 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1697 Sutter St 1 Sidewalk: Curb side : Cutout Tree DPW 1     12 4X4   6004490.7268551 2114641.118768 37.7866551936091 -122.428240500008 (37.7866551936091, -122.428240500008) 13 9 11 28858 13
169402 50375 Permitted Site 7 Ficus nitida :: Laurel Fig 53 2727 Pierce St 5 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 47038 6001577.22511674 2117761.13132823 37.7950566585474 -122.43854412401 (37.7950566585474, -122.43854412401) 13 9 1 57 27
168743 7855 Permitted Site 7 Ficus nitida :: Laurel Fig 53 915 Franklin St 1 Sidewalk: Curb side : Cutout Tree Private 2     12 3X3   6006074.49976 2113274.48833 37.7829922485484 -122.422663866925 (37.7829922485484, -122.422663866925) 7 9 11 28858 41
168672 9974 Permitted Site 7 Ficus nitida :: Laurel Fig 53 812X Fillmore St 1 Sidewalk: Curb side : Cutout Tree Private 2     18 3X3   6003525.87553 2111110.58272 37.7769065842705 -122.431326537326 (37.7769065842705, -122.431326537326) 7 9 11 29492 10
166398 9620 Permitted Site 7 Ficus nitida :: Laurel Fig 53 1165X Steiner St 2 Sidewalk: Curb side : Cutout Tree Private 2   04/16/1990 12:00:00 AM 50 3X3   6002862.99505 2112096.1743 37.779575183286 -122.433690098242 (37.779575183286, -122.433690098242) 15 9 11 29490 41
165652 21672 Permitted Site 7 Ficus nitida :: Laurel Fig 53 1781 Sutter St 1 Sidewalk: Curb side : Cutout Tree Private 2     12 4X4   6004087.4531427 2114585.0546301 37.7864784293602 -122.429631729681 (37.7864784293602, -122.429631729681) 13 9 11 29490 13
165633 23541 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 2750 Van Ness Ave 16 Sidewalk: Curb side : Cutout Tree DPW 1     30 3x3   6005750.94301 2119762.60418 37.8007887287045 -122.42424483346 (37.8007887287045, -122.42424483346) 13 9 1 28858 32
164782 26423 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 555 Fulton St 11 Sidewalk: Curb side : Cutout Tree DPW 1     6 3X3   6005252.46633 2111627.39845 37.7784233328254 -122.425390515771 (37.7784233328254, -122.425390515771) 7 9 11 28852 10
164124 57410 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 109 Wilmot St 1 Sidewalk: Curb side : Cutout Tree Private 2   09/08/1976 12:00:00 AM 15   Permit Number 770100 6002753.5601 2114939.9175 37.7873771736852 -122.434272041026 (37.7873771736852, -122.434272041026) 13 9 11 29490 27
163968 16919 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 500 Oak St 2 Sidewalk: Curb side : Cutout Tree DPW 1     24 13x6   6004493.27484 2110185.04209 37.7744200538695 -122.427914040239 (37.7744200538695, -122.427914040239) 7 9 11 28852 10
163768 9696 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 414 Gough St 4 Sidewalk: Curb side : Cutout Tree DPW 1     22 3X3   6005964.80411 2111186.62637 37.7772532999259 -122.422894934036 (37.7772532999259, -122.422894934036) 7 9 11 28852 10
163074 110027 Undocumented 4 Ficus nitida :: Laurel Fig 53 1101X WEBSTER ST 2 Sidewalk: Curb side : Cutout Tree Private 2       3X3   6003707 2112516 37.7807757743573 -122.430800292528 (37.7807757743573, -122.430800292528) 15 9 11 29490 41
163000 20243 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1801X Steiner St 2 Sidewalk: Curb side : Cutout Tree DPW 1     12 3X3   6002529.5506914 2114404.1561918 37.7858933925245 -122.435008734319 (37.7858933925245, -122.435008734319) 13 9 1 29490 27
162520 10628 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 805 Hayes St 2 Sidewalk: Curb side : Cutout Tree DPW 1   08/02/1990 12:00:00 AM 6 3X4   6003942.23141 2110755.32974 37.775954734286 -122.429860889744 (37.775954734286, -122.429860889744) 7 9 11 29492 10
162297 108098 Undocumented 4 Ficus nitida :: Laurel Fig 53 2800X Pierce St 2 Sidewalk: Curb side : Cutout Tree Private 2           5999639 2117762 37.7949485989127 -122.445250712888 (37.7949485989127, -122.445250712888) 13 9 1 57 17
161493 6285 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1480 Ellis St 1 Sidewalk: Curb side : Cutout Tree DPW 1     6 4x4   6003867.05631 2113210.81806 37.7826926384963 -122.43029616652 (37.7826926384963, -122.43029616652) 7 9 11 29490 41
160693 108107 Undocumented 4 Ficus nitida :: Laurel Fig 53 1990X Laguna St 2 Sidewalk: Curb side : Cutout Tree Private 2 Port         6004838 2115780 37.7898019192352 -122.427120168027 (37.7898019192352, -122.427120168027) 13 9 1 28858 27
160258 6989 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 848 Fell St 1 Sidewalk: Curb side : Cutout Tree DPW 1     12 15x3.5   6003368.38608 2110385.91832 37.7749079085756 -122.431819586637 (37.7749079085756, -122.431819586637) 15 9 11 29492 10
159266 7227 Permitted Site 7 Ficus nitida :: Laurel Fig 53 1025 Fillmore St 2 Sidewalk: Curb side : Cutout Tree Private 2     12 4X4   6003385.45092 2111827.8386 37.7788680315263 -122.431863535021 (37.7788680315263, -122.431863535021) 15 9 11 29490 41
158341 1760 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 3041X Van Ness Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1     24 4x4   6005500.29496 2120778.87447 37.8035649903432 -122.425184535531 (37.8035649903432, -122.425184535531) 13 9 1 28858 17
158220 9662 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 112 Gough St 2 Sidewalk: Curb side : Cutout Tree DPW 1     22 3X3   6006086.53311 2110106.07673 37.7742932396102 -122.422397038566 (37.7742932396102, -122.422397038566) 7 9 11 28852 10
156870 21690 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1881 Sutter St 5 Sidewalk: Curb side : Cutout Tree DPW 1     12 4x4   6003627.3299403 2114521.0871369 37.7862767266181 -122.431219072895 (37.7862767266181, -122.431219072895) 13 9 11 29490 13
156467 109326 Undocumented 4 Ficus nitida :: Laurel Fig 53 1624 VALLEJO ST   Sidewalk: Curb side : Cutout Tree Private 2       3x3   6005582.1 2118270.7 37.7966828044962 -122.424722909098 (37.7966828044962, -122.424722909098) 13 9 1 57 17
156320 6133 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 900X ELLIS ST 3 Sidewalk: Curb side : Cutout Tree DPW 1     30 4x4   6006542 2113585 37.7838712020833 -122.421068560353 (37.7838712020833, -122.421068560353) 7 9 11 28858 41
156308 7284 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1840 Fillmore St 1 Sidewalk: Curb side : Cutout Tree DPW 1     14 3X3   6003030.41064 2114610.94925 37.7864896201648 -122.433290680867 (37.7864896201648, -122.433290680867) 13 9 11 29490 27
156157 59335 Permitted Site 7 Ficus nitida :: Laurel Fig 53 201 Steiner St 1 Sidewalk: Curb side : Cutout Tree Private 2   11/05/1980 12:00:00 AM   4x4 Permit Number 18682 6003287.79827449 2108952.35112135 37.7709671172915 -122.431995967048 (37.7709671172915, -122.431995967048) 15 9 11 29492 9
155915 6134 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 900X Ellis St 6 Sidewalk: Curb side : Cutout Tree DPW 1     30 4x4   6006541.37151 2113590.32225 37.7838857802496 -122.421071112727 (37.7838857802496, -122.421071112727) 7 9 11 28858 41
155737 117286 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 3500 FILLMORE ST 1 Sidewalk: Curb side : Cutout Tree SFUSD 4       3x3   6002513 2120207 37.8018255621759 -122.435481260672 (37.8018255621759, -122.435481260672) 13 9 1 57 17
155245 7236 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1065 Fillmore St 1 Sidewalk: Curb side : Cutout Tree DPW 1     12 4X4   6003355.08756 2111967.13899 37.7792487944095 -122.431978523544 (37.7792487944095, -122.431978523544) 15 9 11 29490 41
155152 26943 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 2040 Sutter St 2 Sidewalk: Curb side : Cutout Tree DPW 1     20 5x6   6002846.96094 2114462.84733 37.7860725610737 -122.43391478048 (37.7860725610737, -122.43391478048) 13 9 11 29490 27
154378 26949 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 2040 Sutter St 8 Sidewalk: Curb side : Cutout Tree DPW 1     20 3X3   6002710.37506 2114446.07693 37.7860187618492 -122.434386130989 (37.7860187618492, -122.434386130989) 13 9 11 29490 27
153353 7273 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1801 Fillmore St 1 Sidewalk: Curb side : Cutout Tree DPW 1     12 4X4   6002991.82699 2114526.90059 37.7862566549301 -122.433418162207 (37.7862566549301, -122.433418162207) 13 9 11 29490 27
153320 99638 Undocumented 4 Ficus nitida :: Laurel Fig 53 2201 Polk St 1 Sidewalk: Curb side : Cutout Tree Private 2     18 3x3   6006359 2118331 37.7968922206311 -122.422038941111 (37.7968922206311, -122.422038941111) 13 9 10 28858 32
152976 17360 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 2298X Gough St 1 Sidewalk: Curb side : Cutout Tree DPW 1     16 3X3   6005094.42253 2117295.11988 37.7939765536908 -122.426340889125 (37.7939765536908, -122.426340889125) 13 9 1 28858 27
151746 10712 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 17X Hollis St 3 Sidewalk: Curb side : Cutout Tree DPW 1     6 4X4   6003917.66999 2113282.5787 37.7828925420276 -122.430126185708 (37.7828925420276, -122.430126185708) 7 9 11 29490 41
151636 20239 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1757X Steiner St 1 Sidewalk: Curb side : Cutout Tree DPW 1     12 4x4   6002551.4219946 2114246.4002369 37.7854614766008 -122.434921779618 (37.7854614766008, -122.434921779618) 13 9 11 29490 13
149790 22717 Permitted Site 7 Ficus nitida :: Laurel Fig 53 1401X Turk St 7 Sidewalk: Curb side : Cutout Tree Police Dept 10     18 4x4   6003306.8488585 2112395.4775226 37.7804221702729 -122.43217599894 (37.7804221702729, -122.43217599894) 15 9 11 29490 41
148675 7262 Permitted Site 7 Ficus nitida :: Laurel Fig 53 1727 Fillmore St 3 Sidewalk: Curb side : Cutout Tree Private 2     12 4X4   6003024.60166 2114236.6744 37.7854616266825 -122.433284024643 (37.7854616266825, -122.433284024643) 13 9 11 29490 13
148416 26945 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 2040 Sutter St 4 Sidewalk: Curb side : Cutout Tree DPW 1     18 3X3   6002804.14495 2114458.42232 37.7860579812909 -122.434062595727 (37.7860579812909, -122.434062595727) 13 9 11 29490 27
147848 101072 Undocumented 4 Ficus nitida :: Laurel Fig 53 1828 Union St 3 Sidewalk: Curb side : Cutout Tree Private 2     12 3x3   6004239 2118751 37.7979256371892 -122.429404607028 (37.7979256371892, -122.429404607028) 13 9 1 57 17

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