trees

1,626 rows where qSpecies_id = 53 sorted by DBH

✎ 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)
70254 48702 Permitted Site 7 Ficus nitida :: Laurel Fig 53 405 Howard St 14 Sidewalk: Curb side : Cutout Tree Private 2   09/19/2002 12:00:00 AM     Permit Number 45976 6014070.00775547 2115349.03612356 37.7891363266664 -122.395147855931 (37.7891363266664, -122.395147855931) 6 2 9 28855 6
70447 44061 Permitted Site 7 Ficus nitida :: Laurel Fig 53 2700 Pierce St 4 Sidewalk: Curb side : Cutout Tree Private 2   10/19/2000 12:00:00 AM     Permit Number 43588 6001640.58397077 2117683.20689336 37.7948463022786 -122.438319307967 (37.7948463022786, -122.438319307967) 13 9 1 57 27
71167 114282 Undocumented 4 Ficus nitida :: Laurel Fig 53 200X STEUART ST 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6015060 2116254 37.7916761533754 -122.391785881413 (37.7916761533754, -122.391785881413) 6 2 9 28855 6
71942 50566 Permitted Site 7 Ficus nitida :: Laurel Fig 53 2295 Folsom St 9 Sidewalk: Curb side : Cutout Tree Private 2   11/18/2003 12:00:00 AM     Permit Number 47188 6008194 2105070 37.7605840051662 -122.414750422926 (37.7605840051662, -122.414750422926) 2 4 7 28859 19
72126 106522 Permitted Site 7 Ficus nitida :: Laurel Fig 53 2510 Jackson St 2 Sidewalk: Property side : Cutout Tree Private 2         Permit Number 772624 6002049.7 2116744.4 37.7922918429251 -122.436836472971 (37.7922918429251, -122.436836472971) 13 6 1 29490 27
72688 124729 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 198X Division St 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6010680 2108566 37.7703225929477 -122.406398777104 (37.7703225929477, -122.406398777104) 14 2 9 28853 34
72782 58078 Permitted Site 7 Ficus nitida :: Laurel Fig 53 4624 18th St 1 Sidewalk: Curb side : Cutout Tree Private 2   10/28/1977 12:00:00 AM     Permit Number 17049 6000401 2105218 37.7605494356876 -122.441713410467 (37.7605494356876, -122.441713410467) 15 4 5 28862 3
72817 121043 Undocumented 4 Ficus nitida :: Laurel Fig 53 2125 Polk St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6006363 2118096 37.7962471953974 -122.422008397548 (37.7962471953974, -122.422008397548) 13 9 10 28858 32
73128 63094 Permitted Site 7 Ficus nitida :: Laurel Fig 53 2780 Sacramento St 1 Sidewalk: Curb side : Cutout Tree Private 2   12/03/1986 12:00:00 AM   3x3 Permit Number 23579 6001505.6405737 2115674.07424093 37.789322069479 -122.438642199545 (37.789322069479, -122.438642199545) 13 6 1 29490 27
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
74559 115904 Undocumented 4 Ficus nitida :: Laurel Fig 53 500x WALLER ST 1 Sidewalk: Curb side : Cutout Tree Private 2       4x4   6003255 2109006 37.7711125644946 -122.432113248928 (37.7711125644946, -122.432113248928) 15 5 11 29492 9
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
75083 46223 Permitted Site 7 Ficus nitida :: Laurel Fig 53 1888 Lombard St 2 Sidewalk: Curb side : Cutout Tree Private 2   01/10/2002 12:00:00 AM     Permit Number 44530 6003335.27744655 2119677.01043482 37.8004170150887 -122.432597920925 (37.8004170150887, -122.432597920925) 13 9 1 57 17
75176 173949 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1306 Clayton St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5999102 2105133 37.7602419475954 -122.446199926833 (37.7602419475954, -122.446199926833) 15 5 5 28862 3
76306 108943 Permitted Site 7 Ficus nitida :: Laurel Fig 53 105 Richland Ave 2 Sidewalk: Curb side : Cutout Tree Private 2           6005294.9 2096235.5 37.7361631827636 -122.424148798432 (37.7361631827636, -122.424148798432) 2 7 7 28859 2
77006 108328 Permitted Site 7 Ficus nitida :: Laurel Fig 53 86 11TH ST 5 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6007396 2110315 37.7749406737789 -122.417882154347 (37.7749406737789, -122.417882154347) 8 2 9 28853 19
77226 121119 Undocumented 4 Ficus nitida :: Laurel Fig 53 2701X 24th St 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6010429 2102109 37.7525790830309 -122.406811850318 (37.7525790830309, -122.406811850318) 10 4 7 28859 19
77443 111583 Permitted Site 7 Ficus nitida :: Laurel Fig 53 1501-1555 Mariposa St 7 Sidewalk: Curb side : Cutout Tree Private 2           6012875.34483574 2106095.24513094 37.7636610173266 -122.398631621456 (37.7636610173266, -122.398631621456) 14 3 8 28856 29
77560 95038 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 3224 Pierce St 9 Sidewalk: Curb side : Cutout Tree DPW for City Agency 14       3x3   6001388 2119447 37.7996748454742 -122.4393197689 (37.7996748454742, -122.4393197689) 13 9 1 57 17
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
78273 45427 Permitted Site 7 Ficus nitida :: Laurel Fig 53 614 Alabama St 3 Sidewalk: Curb side : Cutout Tree Private 2   07/12/2001 12:00:00 AM   9x9 Permit Number 44218 6008960.61704517 2105361.82717089 37.7614283394777 -122.412119658359 (37.7614283394777, -122.412119658359) 2 4 7 28859 19
78580 114284 Undocumented 4 Ficus nitida :: Laurel Fig 53 200X STEUART ST 4 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6015060 2116254 37.7916761533754 -122.391785881413 (37.7916761533754, -122.391785881413) 6 2 9 28855 6
78708 120673 Permitted Site 7 Ficus nitida :: Laurel Fig 53 3876 18th St 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6003780.8 2105549.3 37.761651098806 -122.430047862208 (37.761651098806, -122.430047862208) 8 4 5 28862 3
78771 41194 Permitted Site 7 Ficus nitida :: Laurel Fig 53 500 16th St 9 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/24/1999 12:00:00 AM     Permit Number 41907 6015636.41824938 2107244.95796966 37.7669713213554 -122.389162129842 (37.7669713213554, -122.389162129842) 14 3 9 310 20
78831 99639 Undocumented 4 Ficus nitida :: Laurel Fig 53 2201 Polk St 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6006359 2118331 37.7968922206311 -122.422038941111 (37.7968922206311, -122.422038941111) 13 9 10 28858 32
79179 41198 Permitted Site 7 Ficus nitida :: Laurel Fig 53 500 16th St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/24/1999 12:00:00 AM     Permit Number 41907 6015636.41824938 2107244.95796966 37.7669713213554 -122.389162129842 (37.7669713213554, -122.389162129842) 14 3 9 310 20
79332 124728 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 198X Division St 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6010680 2108566 37.7703225929477 -122.406398777104 (37.7703225929477, -122.406398777104) 14 2 9 28853 34
79333 33008 Permitted Site 7 Ficus nitida :: Laurel Fig 53 1311 06th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   11/05/1996 12:00:00 AM   6x4 Permit Number 37302 5994224.05093468 2106581.50911401 37.7639393951455 -122.463175433011 (37.7639393951455, -122.463175433011) 1 5 11 56 12
79513 47917 Permitted Site 7 Ficus nitida :: Laurel Fig 53 999 Revised) Van Ness Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   06/21/2002 12:00:00 AM     Permit Number 45655 6006486.39229912 2113910.68802822 37.7847623267063 -122.421284078173 (37.7847623267063, -122.421284078173) 13 9 11 28858 41
80144 96411 Permitted Site 7 Ficus nitida :: Laurel Fig 53 3828 Jackson St 6 Sidewalk: Curb side : Cutout Tree Private 2   02/10/2012 12:00:00 AM     Permit Number 768662 5995910 2115869 37.7895373746493 -122.458016450618 (37.7895373746493, -122.458016450618) 11 6 1 54 31
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
81758 49264 Permitted Site 7 Ficus nitida :: Laurel Fig 53 2X Spear St 4 Sidewalk: Curb side : Cutout Tree Private 2   02/07/2003 12:00:00 AM     Permit Number 46305 6014371 2116872 37.7933347653256 -122.394213120763 (37.7933347653256, -122.394213120763) 12 2 9 28855 6
82003 41199 Permitted Site 7 Ficus nitida :: Laurel Fig 53 500 16th St 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/24/1999 12:00:00 AM     Permit Number 41907 6015636.41824938 2107244.95796966 37.7669713213554 -122.389162129842 (37.7669713213554, -122.389162129842) 14 3 9 310 20
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
83449 106526 Permitted Site 7 Ficus nitida :: Laurel Fig 53 2510 Jackson St 6 Sidewalk: Property side : Cutout Tree Private 2         Permit Number 772624 6002049.7 2116744.4 37.7922918429251 -122.436836472971 (37.7922918429251, -122.436836472971) 13 6 1 29490 27
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
84466 64020 Permitted Site 7 Ficus nitida :: Laurel Fig 53 2344 15TH ST 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/09/1987 12:00:00 AM     Permit Number 778144 6002015 2107091 37.7657840660528 -122.436265375372 (37.7657840660528, -122.436265375372) 15 5 5 28862 3
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
84798 48704 Permitted Site 7 Ficus nitida :: Laurel Fig 53 405 Howard St 6 Sidewalk: Curb side : Cutout Tree Private 2   09/19/2002 12:00:00 AM     Permit Number 45976 6014070.00775547 2115349.03612356 37.7891363266664 -122.395147855931 (37.7891363266664, -122.395147855931) 6 2 9 28855 6
84820 98591 Permitted Site 7 Ficus nitida :: Laurel Fig 53 2375 Jackson St 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3 Permit Number 9808 6002830 2116793 37.7924696026791 -122.434140096981 (37.7924696026791, -122.434140096981) 13 9 1 29490 27
85440 96410 Permitted Site 7 Ficus nitida :: Laurel Fig 53 3828 Jackson St 5 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 767718 5995910 2115869 37.7895373746493 -122.458016450618 (37.7895373746493, -122.458016450618) 11 6 1 54 31
85569 48875 Permitted Site 7 Ficus nitida :: Laurel Fig 53 650 Waller St 1 Sidewalk: Curb side : Cutout Tree Private 2   11/18/2002 12:00:00 AM     Permit Number 46082 6002579.05689486 2108874.6714316 37.7707136224387 -122.434441965818 (37.7707136224387, -122.434441965818) 15 5 11 29492 9
85979 120943 Undocumented 4 Ficus nitida :: Laurel Fig 53 485 Carolina St 5 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6012395 2105853 37.7629690927527 -122.400275979648 (37.7629690927527, -122.400275979648) 14 3 8 28856 29
86618 111873 Undocumented 4 Ficus nitida :: Laurel Fig 53 300X POTRERO AVE 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6010207 2106863 37.7656200738156 -122.407914780785 (37.7656200738156, -122.407914780785) 8 4 8 28853 19
86887 94302 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1150X Fillmore St 5 Sidewalk: Curb side : Cutout Tree DPW 1 Rec/Park         6003451.3 2112195.3 37.7798807216656 -122.431661979156 (37.7798807216656, -122.431661979156) 15 9 11 29490 41
86959 111872 Undocumented 4 Ficus nitida :: Laurel Fig 53 300X POTRERO AVE 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6010207 2106863 37.7656200738156 -122.407914780785 (37.7656200738156, -122.407914780785) 8 4 8 28853 19
87085 101725 Undocumented 4 Ficus nitida :: Laurel Fig 53 560 Wisconsin St 11 Sidewalk: Curb side : Cutout Tree Private 2           6012536 2104936 37.760459075101 -122.399723915341 (37.760459075101, -122.399723915341) 10 3 8 28856 29
87589 121254 Undocumented 4 Ficus nitida :: Laurel Fig 53 283 Dorland St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6003780 2105549 37.7616502297697 -122.430050607682 (37.7616502297697, -122.430050607682) 8 4 5 28862 3
87750 53929 Permitted Site 7 Ficus nitida :: Laurel Fig 53 1700 Laguna St 1 Sidewalk: Curb side : Cutout Tree Private 2   03/29/1972 12:00:00 AM   3x3 Permit Number 9642 6004487.99959123 2114676.46033991 37.786752078395 -122.428252455396 (37.786752078395, -122.428252455396) 13 9 11 28858 27
87780 95040 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 3224 Pierce St 13 Sidewalk: Property side : Cutout Tree DPW for City Agency 14       3x3   6001388 2119447 37.7996748454742 -122.4393197689 (37.7996748454742, -122.4393197689) 13 9 1 57 17
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
89256 111871 Undocumented 4 Ficus nitida :: Laurel Fig 53 300X POTRERO AVE 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6010207 2106863 37.7656200738156 -122.407914780785 (37.7656200738156, -122.407914780785) 8 4 8 28853 19
89944 108971 Undocumented 4 Ficus nitida :: Laurel Fig 53 20x ROUSSEAU ST 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6003466 2095297.3 37.7334836652593 -122.430405132046 (37.7334836652593, -122.430405132046) 2 7 5 28861 25
89965 116128 Undocumented 4 Ficus nitida :: Laurel Fig 53 2500X Keith St 4 Sidewalk: Curb side : Cutout Tree Rec/Park 5           6014198.52795 2092093.45262 37.7252886606488 -122.393075349238 (37.7252886606488, -122.393075349238) 10 3 8 58 1
90420 124731 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 198X Division St 5 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6010680 2108566 37.7703225929477 -122.406398777104 (37.7703225929477, -122.406398777104) 14 2 9 28853 34
90878 106915 Permitted Site 7 Ficus nitida :: Laurel Fig 53 3832 Jackson St 2 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 772728 5995876.04542 2115884.62189 37.7895783172049 -122.458135060161 (37.7895783172049, -122.458135060161) 11 6 1 54 31
91220 120660 Undocumented 4 Ficus nitida :: Laurel Fig 53 126 Folsom St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3 Permit Number 778623 6015082 2115536 37.7897059122539 -122.3916595384 (37.7897059122539, -122.3916595384) 6 2 9 28855 6
91238 49276 Permitted Site 7 Ficus nitida :: Laurel Fig 53 2X Spear St 16 Sidewalk: Curb side : Cutout Tree Private 2   02/07/2003 12:00:00 AM     Permit Number 46305 6014371 2116872 37.7933347653256 -122.394213120763 (37.7933347653256, -122.394213120763) 12 2 9 28855 6
92694 112578 Undocumented 4 Ficus nitida :: Laurel Fig 53 660x Ashbury St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5999086 2108401 37.7692141419233 -122.446490377962 (37.7692141419233, -122.446490377962) 15 5 11 29492 9
93090 108326 Permitted Site 7 Ficus nitida :: Laurel Fig 53 86 11TH ST 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6007396 2110315 37.7749406737789 -122.417882154347 (37.7749406737789, -122.417882154347) 8 2 9 28853 19
93776 110724 Undocumented 4 Ficus nitida :: Laurel Fig 53 3514 25TH ST 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6006378 2101471 37.7505997812246 -122.420775642469 (37.7505997812246, -122.420775642469) 2 4 5 28859 19
93895 173772 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 2235 15th St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6002649 2107045 37.7656937631635 -122.434069218237 (37.7656937631635, -122.434069218237) 15 5 5 28862 3
94460 101975 Permitted Site 7 Ficus nitida :: Laurel Fig 53 1230 19th St 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3 Permit Number 769454 6013882 2105282.2 37.7614846061652 -122.395092936828 (37.7614846061652, -122.395092936828) 10 3 8 28856 29
95195 58514 Permitted Site 7 Ficus nitida :: Laurel Fig 53 1460 Waller St 1 Sidewalk: Curb side : Cutout Tree Private 2   03/30/1979 12:00:00 AM   3x3 Permit Number 17691 5998731.52150291 2108338.88905051 37.7690233477366 -122.447712023248 (37.7690233477366, -122.447712023248) 15 5 11 29492 9
95381 49285 Permitted Site 7 Ficus nitida :: Laurel Fig 53 2X Spear St 13 Sidewalk: Curb side : Cutout Tree Private 2   02/07/2003 12:00:00 AM     Permit Number 46305 6014371 2116872 37.7933347653256 -122.394213120763 (37.7933347653256, -122.394213120763) 12 2 9 28855 6
95408 110726 Undocumented 4 Ficus nitida :: Laurel Fig 53 3514 25TH ST 4 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6006378 2101471 37.7505997812246 -122.420775642469 (37.7505997812246, -122.420775642469) 2 4 5 28859 19
95808 48700 Permitted Site 7 Ficus nitida :: Laurel Fig 53 405 Howard St 12 Sidewalk: Curb side : Cutout Tree Private 2   09/19/2002 12:00:00 AM     Permit Number 45976 6014070.00775547 2115349.03612356 37.7891363266664 -122.395147855931 (37.7891363266664, -122.395147855931) 6 2 9 28855 6
95901 110725 Undocumented 4 Ficus nitida :: Laurel Fig 53 3514 25TH ST 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6006378 2101471 37.7505997812246 -122.420775642469 (37.7505997812246, -122.420775642469) 2 4 5 28859 19
95982 49266 Permitted Site 7 Ficus nitida :: Laurel Fig 53 2X Spear St 7 Sidewalk: Curb side : Cutout Tree Private 2   02/07/2003 12:00:00 AM     Permit Number 46305 6014371 2116872 37.7933347653256 -122.394213120763 (37.7933347653256, -122.394213120763) 12 2 9 28855 6
96594 94566 Permitted Site 7 Ficus nitida :: Laurel Fig 53 100 Carl St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5998051 2107197 37.7658490933668 -122.449983584058 (37.7658490933668, -122.449983584058) 15 5 11 29492 9
97171 120147 Undocumented 4 Ficus nitida :: Laurel Fig 53 1X Hyde St 4 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6008026 2111839 37.7791606496002 -122.415810780563 (37.7791606496002, -122.415810780563) 7 10 9 28852 36
97368 64484 Permitted Site 7 Ficus nitida :: Laurel Fig 53 436 Bryant St 1 Sidewalk: Curb side : Cutout Tree Private 2   07/19/1988 12:00:00 AM     Permit Number 778749 6014198.52964849 2112913.46772182 37.782455962378 -122.39453256733 (37.782455962378, -122.39453256733) 6 2 9 28856 6
97537 58524 Permitted Site 7 Ficus nitida :: Laurel Fig 53 1544 Waller St 1 Sidewalk: Curb side : Cutout Tree Private 2   04/02/1979 12:00:00 AM     Permit Number 17701 5998255.7040764 2108272.5838384 37.7688140844915 -122.449353060877 (37.7688140844915, -122.449353060877) 15 5 11 29492 9
98424 94303 Significant Tree 6 Ficus nitida :: Laurel Fig 53 1150X Fillmore St 6 Sidewalk: Property side : Cutout Tree Rec/Park 5           6003451.3 2112195.3 37.7798807216656 -122.431661979156 (37.7798807216656, -122.431661979156) 15 9 11 29490 41
99255 111592 Undocumented 4 Ficus nitida :: Laurel Fig 53 398X BRYANT ST 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6014483 2113360 37.7836978486164 -122.393579678281 (37.7836978486164, -122.393579678281) 6 2 9 28856 6
99259 111393 Undocumented 4 Ficus nitida :: Laurel Fig 53 298x CLINTON PARK 6 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6004911 2108307 37.7692870280045 -122.426335307428 (37.7692870280045, -122.426335307428) 8 4 5 28862 19
99392 94300 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1150X Fillmore St 4 Sidewalk: Curb side : Cutout Tree DPW 1 Rec/Park     6x6   6003451.3 2112195.3 37.7798807216656 -122.431661979156 (37.7798807216656, -122.431661979156) 15 9 11 29490 41
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
100042 40805 Permitted Site 7 Ficus nitida :: Laurel Fig 53 585 Connecticut St 2 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 41753 6013296.02646982 2104345.28151099 37.758879430057 -122.397053895785 (37.758879430057, -122.397053895785) 10 3 8 28856 29
100462 110704 Undocumented 4 Ficus nitida :: Laurel Fig 53 2999X Turk St 10 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5996638 2111487 37.7775473668867 -122.455180869531 (37.7775473668867, -122.455180869531) 15 6 2 54 16
100521 111578 Permitted Site 7 Ficus nitida :: Laurel Fig 53 1501-1555 Mariposa St 2 Sidewalk: Curb side : Cutout Tree Private 2           6012875.34483574 2106095.24513094 37.7636610173266 -122.398631621456 (37.7636610173266, -122.398631621456) 14 3 8 28856 29
100582 48699 Permitted Site 7 Ficus nitida :: Laurel Fig 53 405 Howard St 11 Sidewalk: Curb side : Cutout Tree Private 2   09/19/2002 12:00:00 AM     Permit Number 45976 6014070.00775547 2115349.03612356 37.7891363266664 -122.395147855931 (37.7891363266664, -122.395147855931) 6 2 9 28855 6
100751 116905 Undocumented 4 Ficus nitida :: Laurel Fig 53 80 Beaver St 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6002383 2106795 37.7649922243231 -122.434971372236 (37.7649922243231, -122.434971372236) 15 5 5 28862 3
100811 111598 Undocumented 4 Ficus nitida :: Laurel Fig 53 398X BRYANT ST 9 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6014483 2113360 37.7836978486164 -122.393579678281 (37.7836978486164, -122.393579678281) 6 2 9 28856 6
101116 107368 Undocumented 4 Ficus nitida :: Laurel Fig 53 660 OFARRELL ST   Sidewalk: Curb side : Cutout Tree Private 2           6008096 2114145 37.7854963051764 -122.415731945695 (37.7854963051764, -122.415731945695) 13 10 9 28858 36
101430 111584 Permitted Site 7 Ficus nitida :: Laurel Fig 53 1501-1555 Mariposa St 8 Sidewalk: Curb side : Cutout Tree Private 2           6012875.34483574 2106095.24513094 37.7636610173266 -122.398631621456 (37.7636610173266, -122.398631621456) 14 3 8 28856 29
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
102319 61449 Permitted Site 7 Ficus nitida :: Laurel Fig 53 1330-1332 Castro St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/18/1984 12:00:00 AM     Permit Number 21384 6002514.93546023 2101705.58374617 37.7510254010171 -122.434151182595 (37.7510254010171, -122.434151182595) 2 4 5 28862 22
102388 113158 Undocumented 4 Ficus nitida :: Laurel Fig 53 1104 STANYAN ST 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5997339 2106686 37.764405251212 -122.452409351598 (37.764405251212, -122.452409351598) 15 5 11 29492 9
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
102782 109882 Undocumented 4 Ficus nitida :: Laurel Fig 53 1520 PAGE ST 4 Sidewalk: Curb side : Cutout Tree Private 2       6x8   5999172.7 2109108.7 37.7711622584795 -122.446241403234 (37.7711622584795, -122.446241403234) 15 5 11 29492 9
103493 49277 Permitted Site 7 Ficus nitida :: Laurel Fig 53 2X Spear St 15 Sidewalk: Curb side : Cutout Tree Private 2   02/07/2003 12:00:00 AM     Permit Number 46305 6014371 2116872 37.7933347653256 -122.394213120763 (37.7933347653256, -122.394213120763) 12 2 9 28855 6
103761 121256 Undocumented 4 Ficus nitida :: Laurel Fig 53 283 Dorland St 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6003780 2105549 37.7616502297697 -122.430050607682 (37.7616502297697, -122.430050607682) 8 4 5 28862 3
103831 58284 Permitted Site 7 Ficus nitida :: Laurel Fig 53 1528 15th St 1 Sidewalk: Curb side : Cutout Tree Private 2   09/21/1978 12:00:00 AM   4x4 Permit Number 17298 6007189.64621742 2107366.09742219 37.7668320707182 -122.418386841574 (37.7668320707182, -122.418386841574) 8 4 7 28853 19
104082 105456 Undocumented 4 Ficus nitida :: Laurel Fig 53 2301X Webster St 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6003203 2116540 37.7917960919718 -122.432831424804 (37.7917960919718, -122.432831424804) 13 9 1 29490 27
104097 62645 Permitted Site 7 Ficus nitida :: Laurel Fig 53 400 Baker St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/25/1988 12:00:00 AM     Permit Number 25453 6000705.45672766 2110331.40246789 37.7746069085927 -122.441027287197 (37.7746069085927, -122.441027287197) 15 5 11 29492 10

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