trees

1,626 rows where qSpecies_id = 53 sorted by TreeID 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)
111853 99974 Permitted Site 7 Ficus nitida :: Laurel Fig 53 2295 Folsom St 12 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 47188 6008194 2105070 37.7605840051662 -122.414750422926 (37.7605840051662, -122.414750422926) 2 4 7 28859 19
8269 99967 Undocumented 4 Ficus nitida :: Laurel Fig 53 2270 Folsom St 9 Sidewalk: Curb side : Cutout Tree Private 2           6007986.9 2105322.2 37.7612648499102 -122.415484545241 (37.7612648499102, -122.415484545241) 2 4 7 28859 19
67556 9975 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 812X Fillmore St 2 Sidewalk: Curb side : Cutout Tree DPW 1     18 3X3   6003525.87553 2111110.58272 37.7769065842705 -122.431326537326 (37.7769065842705, -122.431326537326) 7 9 11 29492 10
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
133335 99718 Undocumented 4 Ficus nitida :: Laurel Fig 53 430 Hayes St 3 Sidewalk: Curb side : Cutout Tree Private 2     14 3x3   6005787 2111054 37.7768791059226 -122.423500585068 (37.7768791059226, -122.423500585068) 7 9 11 28852 10
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
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
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
67334 99615 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
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
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
99582 99612 Undocumented 4 Ficus nitida :: Laurel Fig 53 3233X Buchanan St 1 Sidewalk: Curb side : Cutout Tree Private 2     12 3x3   6003300 2119605 37.8002172925371 -122.432714848025 (37.8002172925371, -122.432714848025) 13 9 1 57 17
122922 99595 Undocumented 4 Ficus nitida :: Laurel Fig 53 1855X Evans Ave 10 Sidewalk: Curb side : Cutout Tree Private 2     10 3x3   6014349.8 2099426.2 37.7454312840379 -122.393065244865 (37.7454312840379, -122.393065244865) 10 3 8 58 1
19076 99594 Undocumented 4 Ficus nitida :: Laurel Fig 53 1855X Evans Ave 9 Sidewalk: Curb side : Cutout Tree Private 2     10 3x3   6014349.8 2099426.2 37.7454312840379 -122.393065244865 (37.7454312840379, -122.393065244865) 10 3 8 58 1
104635 9944 Permitted Site 7 Ficus nitida :: Laurel Fig 53 601X Green St 4 Sidewalk: Curb side : Cutout Tree Private 2     80 3X3   6010102.57699 2119179.92896 37.7994335971632 -122.409145158717 (37.7994335971632, -122.409145158717) 3 1 10 308 4
13713 9943 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 601X Green St 3 Sidewalk: Curb side : Cutout Tree DPW 1     80 6x5   6010129.67767 2119173.05666 37.7994162456962 -122.409050895178 (37.7994162456962, -122.409050895178) 3 1 10 308 4
93249 9942 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 601X Green St 2 Sidewalk: Curb side : Cutout Tree DPW 1     80 6x5   6010129.67767 2119173.05666 37.7994162456962 -122.409050895178 (37.7994162456962, -122.409050895178) 3 1 10 308 4
90288 9941 Permitted Site 7 Ficus nitida :: Laurel Fig 53 601X Green St 1 Sidewalk: Curb side : Cutout Tree Private 2   10/12/2016 12:00:00 AM 3 5x6 Resulted descion 9/7/16 -DE 6010050.95997 2119172.47111 37.7994102279433 -122.409323246083 (37.7994102279433, -122.409323246083) 3 1 10 308 4
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
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
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
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
69451 99244 Undocumented 4 Ficus nitida :: Laurel Fig 53 570 Ellis St 2 Sidewalk: Curb side : Cutout Tree Rec/Park 5     11 4x4   6008204 2113818 37.784604512923 -122.41533513918 (37.784604512923, -122.41533513918) 7 10 9 28858 36
154035 99243 Undocumented 4 Ficus nitida :: Laurel Fig 53 570 Ellis St 1 Sidewalk: Curb side : Cutout Tree Rec/Park 5     9 4x4   6008204 2113818 37.784604512923 -122.41533513918 (37.784604512923, -122.41533513918) 7 10 9 28858 36
55561 99240 Undocumented 4 Ficus nitida :: Laurel Fig 53 560X Ellis St 1 Sidewalk: Curb side : Cutout Tree Rec/Park 5     10 4x4   6008281 2113828 37.7846362978531 -122.415069452341 (37.7846362978531, -122.415069452341) 7 10 9 28858 36
84337 9917 Permitted Site 7 Ficus nitida :: Laurel Fig 53 1905X Gough St 1 Sidewalk: Curb side : Cutout Tree Rec/Park 5     30 3x3 Permit Number 768908 6005198.9827241 2116181.2464075 37.7909240477297 -122.425899774562 (37.7909240477297, -122.425899774562) 13 9 1 28858 27
180167 99046 Undocumented 4 Ficus nitida :: Laurel Fig 53 2194 15th St 1 Sidewalk: Curb side : Cutout Tree Private 2       6x6   6002943 2107121 37.7659191216839 -122.43305776744 (37.7659191216839, -122.43305776744) 15 5 5 28862 3
106301 98984 Permitted Site 7 Ficus nitida :: Laurel Fig 53 993 Steiner St 2 Sidewalk: Curb side : Cutout Tree Private 2     12 3x3 Permit Number 19087 6002920 2111648 37.7783478430736 -122.433460857601 (37.7783478430736, -122.433460857601) 15 9 11 29492 41
21498 98979 Undocumented 4 Ficus nitida :: Laurel Fig 53 38 MILEY ST 1 Sidewalk: Curb side : Cutout Tree Private 2     3 3x3 Permit Number 778225 5999656 2118689 37.7974948649915 -122.4452585722 (37.7974948649915, -122.4452585722) 13 9 1 57 17
173374 98862 Undocumented 4 Ficus nitida :: Laurel Fig 53 25 OAKWOOD ST 1 Sidewalk: Curb side : Cutout Tree Private 2       4x4   6005344.6 2105317.5 37.7611030726424 -122.424622816907 (37.7611030726424, -122.424622816907) 2 4 5 28859 19
124571 98660 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 701X Lombard St 1 Sidewalk: Curb side : Cutout Tree DPW 1     24 3x3   6008942.64461 2120384.58796 37.8026762417443 -122.41324418324 (37.8026762417443, -122.41324418324) 3 1 10 308 23
123904 98659 Permitted Site 7 Ficus nitida :: Laurel Fig 53 2110 Greenwich St 13 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW   20 7x7   6002683.8 2119245.6 37.7991955081761 -122.434821422435 (37.7991955081761, -122.434821422435) 13 9 1 57 17
139754 98643 Undocumented 4 Ficus nitida :: Laurel Fig 53 2391 Folsom St 2 Sidewalk: Curb side : Cutout Tree Private 2     10 3x3   6008222 2104509 37.7590452010005 -122.414613883143 (37.7590452010005, -122.414613883143) 2 4 7 28859 19
121324 98594 Undocumented 4 Ficus nitida :: Laurel Fig 53 2301 Jackson St 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3 Permit Number 10141 6003182 2116842 37.79262411554 -122.432925669748 (37.79262411554, -122.432925669748) 13 9 1 29490 27
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
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
159337 98224 Permitted Site 7 Ficus nitida :: Laurel Fig 53 4068 25th St 1 Sidewalk: Curb side : Cutout Tree Private 2   01/06/2012 12:00:00 AM   3x3 Permit Number 56734 6003417.8 2101304.1 37.7499742222019 -122.431000336814 (37.7499742222019, -122.431000336814) 2 4 5 28862 22
85172 98001 Undocumented 4 Ficus nitida :: Laurel Fig 53 30 Eagle St 3 Sidewalk: Curb side : Cutout Tree Private 2     12 3x3   6000135 2104379 37.7582305885461 -122.442573139957 (37.7582305885461, -122.442573139957) 2 4 5 28862 3
60853 97999 Undocumented 4 Ficus nitida :: Laurel Fig 53 30 Eagle St 1 Sidewalk: Curb side : Cutout Tree Private 2     12 3x3   6000135 2104379 37.7582305885461 -122.442573139957 (37.7582305885461, -122.442573139957) 2 4 5 28862 3
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
39348 97611 Permitted Site 7 Ficus nitida :: Laurel Fig 53 349 10th St 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6009106.7 2109348.6 37.7723832922197 -122.411896150488 (37.7723832922197, -122.411896150488) 8 2 9 28853 34
162257 97610 Permitted Site 7 Ficus nitida :: Laurel Fig 53 349 10th St 2 Sidewalk: Curb side : Cutout Tree Private 2     14 3x3   6009106.7 2109348.6 37.7723832922197 -122.411896150488 (37.7723832922197, -122.411896150488) 8 2 9 28853 34
27991 97561 Undocumented 4 Ficus nitida :: Laurel Fig 53 1251X 04th Ave 1 Sidewalk: Property side : Cutout Tree Private 2       3x3   5994791.4 2106981 37.7650689602603 -122.461242116604 (37.7650689602603, -122.461242116604) 15 5 11 56 12
193266 97278 Permitted Site 7 Ficus nitida :: Laurel Fig 53 60 Palm Ave 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3 Permit Number 768156 5995934.7 2114107.9 37.7847032866401 -122.457803503646 (37.7847032866401, -122.457803503646) 11 6 1 54 31
175062 97110 Undocumented 4 Ficus nitida :: Laurel Fig 53 1095X Noe St 2 Sidewalk: Curb side : Cutout Tree Private 2     14 3x3   6003193.9 2101874 37.751526344012 -122.431815280512 (37.751526344012, -122.431815280512) 2 4 5 28862 22
172156 97109 Undocumented 4 Ficus nitida :: Laurel Fig 53 1095X Noe St 1 Sidewalk: Curb side : Cutout Tree Private 2     14 3x3   6003187 2102045 37.7519954785262 -122.431851350128 (37.7519954785262, -122.431851350128) 2 4 5 28862 22
120227 96963 Undocumented 4 Ficus nitida :: Laurel Fig 53 3401X 16th St 2 Sidewalk: Curb side : Cutout Tree Private 2     12 5x5   6004198 2106595 37.7645459600586 -122.428679481968 (37.7645459600586, -122.428679481968) 8 4 5 28862 3
180301 96962 Undocumented 4 Ficus nitida :: Laurel Fig 53 3401X 16th St 1 Sidewalk: Curb side : Cutout Tree Private 2     12 5x5   6004198 2106595 37.7645459600586 -122.428679481968 (37.7645459600586, -122.428679481968) 8 4 5 28862 3
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
18243 96948 Undocumented 4 Ficus nitida :: Laurel Fig 53 900X Capp St 2 Sidewalk: Curb side : Cutout Tree Private 2     24 6x6   6007359.7 2102053.2 37.7522536530624 -122.417422091759 (37.7522536530624, -122.417422091759) 2 4 7 28859 19
41221 96947 Undocumented 4 Ficus nitida :: Laurel Fig 53 900X Capp St 1 Sidewalk: Curb side : Cutout Tree Private 2     24 6x6   6007389 2101516 37.750780272338 -122.417282702809 (37.750780272338, -122.417282702809) 2 4 7 28859 19
127066 96913 Undocumented 4 Ficus nitida :: Laurel Fig 53 65X Elizabeth St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6005919.1 2102263.8 37.7527507518094 -122.422418882903 (37.7527507518094, -122.422418882903) 2 4 5 28859 19
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
34036 9687 Permitted Site 7 Ficus nitida :: Laurel Fig 53 330 Gough St 1 Sidewalk: Curb side : Cutout Tree Private 2   01/10/2001 12:00:00 AM 16 3x3   6006025.52151 2110969.11138 37.7766594822933 -122.422669431679 (37.7766594822933, -122.422669431679) 7 9 11 28852 10
54208 9683 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 298 Gough St 3 Sidewalk: Curb side : Cutout Tree DPW 1   04/24/1982 12:00:00 AM 20 3X3   6006045.73768 2110624.99987 37.7757157759068 -122.422575039685 (37.7757157759068, -122.422575039685) 7 9 11 28852 10
48721 9675 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 235 Gough St 1 Sidewalk: Curb side : Cutout Tree DPW 1   12/19/1981 12:00:00 AM 12 3X3   6005972.11971 2110519.21136 37.7754211527567 -122.422822183014 (37.7754211527567, -122.422822183014) 7 9 11 28852 10
130738 96736 Undocumented 4 Ficus nitida :: Laurel Fig 53 520 South Van Ness Ave 3 Sidewalk: Curb side : Cutout Tree Private 2     14 3x3.5   6007401.6 2106571.6 37.7646624959011 -122.417597409955 (37.7646624959011, -122.417597409955) 8 4 7 28859 19
78654 96735 Undocumented 4 Ficus nitida :: Laurel Fig 53 520 South Van Ness Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     16 3x3.5   6007401.6 2106571.6 37.7646624959011 -122.417597409955 (37.7646624959011, -122.417597409955) 8 4 7 28859 19
44451 96734 Undocumented 4 Ficus nitida :: Laurel Fig 53 520 South Van Ness Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     14 3x3.5   6007401.6 2106571.6 37.7646624959011 -122.417597409955 (37.7646624959011, -122.417597409955) 8 4 7 28859 19
79996 96733 Undocumented 4 Ficus nitida :: Laurel Fig 53 514 South Van Ness Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     16 3x3.5   6007319.4 2106562.9 37.7646339820142 -122.417881101898 (37.7646339820142, -122.417881101898) 8 4 7 28859 19
24579 96732 Undocumented 4 Ficus nitida :: Laurel Fig 53 514 South Van Ness Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     14 3x3.5   6007319.4 2106562.9 37.7646339820142 -122.417881101898 (37.7646339820142, -122.417881101898) 8 4 7 28859 19
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
45836 9661 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 112 Gough St 1 Sidewalk: Curb side : Cutout Tree DPW 1     40 3X3   6006079.13931 2110176.88384 37.7744872417771 -122.422427647286 (37.7744872417771, -122.422427647286) 7 9 11 28852 10
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
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
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
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
171777 96409 Permitted Site 7 Ficus nitida :: Laurel Fig 53 3828 Jackson St 4 Sidewalk: Curb side : Cutout Tree Private 2           5995910 2115869 37.7895373746493 -122.458016450618 (37.7895373746493, -122.458016450618) 11 6 1 54 31
105995 96408 Permitted Site 7 Ficus nitida :: Laurel Fig 53 3828 Jackson St 3 Sidewalk: Curb side : Cutout Tree Private 2           5995910 2115869 37.7895373746493 -122.458016450618 (37.7895373746493, -122.458016450618) 11 6 1 54 31
62457 96407 Permitted Site 7 Ficus nitida :: Laurel Fig 53 3828 Jackson St 2 Sidewalk: Curb side : Cutout Tree Private 2           5995910 2115869 37.7895373746493 -122.458016450618 (37.7895373746493, -122.458016450618) 11 6 1 54 31
56472 96337 Undocumented 4 Ficus nitida :: Laurel Fig 53 1851 15th St 2 Sidewalk: Curb side : Cutout Tree Private 2     12 3x3   6005204.9 2107156.8 37.7661454629436 -122.42523686393 (37.7661454629436, -122.42523686393) 8 4 5 28853 19
24151 96336 Undocumented 4 Ficus nitida :: Laurel Fig 53 1851 15th St 1 Sidewalk: Curb side : Cutout Tree Private 2     12 3x3   6005204.9 2107156.8 37.7661454629436 -122.42523686393 (37.7661454629436, -122.42523686393) 8 4 5 28853 19
168783 96335 Undocumented 4 Ficus nitida :: Laurel Fig 53 3705 25th St 2 Sidewalk: Curb side : Cutout Tree Private 2     18 3x3 Permit Number 28622 6005781 2101380 37.7503162492489 -122.422833652647 (37.7503162492489, -122.422833652647) 2 4 5 28859 19
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
57390 9617 Permitted Site 7 Ficus nitida :: Laurel Fig 53 1050X Steiner St 4 Sidewalk: Curb side : Cutout Tree Private 2     12 4X4   6002921.99888 2111973.13636 37.7792406996886 -122.433477183837 (37.7792406996886, -122.433477183837) 15 9 11 29490 41
69526 9615 Permitted Site 7 Ficus nitida :: Laurel Fig 53 1050X Steiner St 2 Sidewalk: Curb side : Cutout Tree Private 2     12 4X4   6002927.21435 2111923.58629 37.7791049434867 -122.433455599491 (37.7791049434867, -122.433455599491) 15 9 11 29490 41
79391 96083 Undocumented 4 Ficus nitida :: Laurel Fig 53 2177 15th St 1 Sidewalk: Curb side : Cutout Tree Private 2     12 3x3   6003180 2107100 37.7658749013738 -122.432236534109 (37.7658749013738, -122.432236534109) 15 5 5 28862 3
43740 9577 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1290X Golden Gate Ave 5 Sidewalk: Curb side : Cutout Tree DPW 1     12 5x5   6003415.08005 2112113.96459 37.7796553418115 -122.431781470984 (37.7796553418115, -122.431781470984) 15 9 11 29490 41
80780 9576 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1290X Golden Gate Ave 4 Sidewalk: Curb side : Cutout Tree DPW 1     18 3X3   6003446.27659 2112118.33325 37.7796691054144 -122.431673860699 (37.7796691054144, -122.431673860699) 15 9 11 29490 41
120524 9575 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1290X Golden Gate Ave 3 Sidewalk: Curb side : Cutout Tree DPW 1     12 3X3   6003461.41634 2112120.31079 37.7796753933958 -122.431621626992 (37.7796753933958, -122.431621626992) 15 9 11 29490 41
87320 9574 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1290X Golden Gate Ave 2 Sidewalk: Curb side : Cutout Tree DPW 1     12 6x5   6003478.20667 2112124.62637 37.7796881945834 -122.431563850171 (37.7796881945834, -122.431563850171) 15 9 11 29490 41
39669 95554 Permitted Site 7 Ficus nitida :: Laurel Fig 53 1333@ Larkin Bush St 4 Sidewalk: Curb side : Cutout Tree Private 2           6007121 2115358 37.7887720478953 -122.419191239667 (37.7887720478953, -122.419191239667) 13 9 10 28858 21
148003 95416 Undocumented 4 Ficus nitida :: Laurel Fig 53 49X South Van Ness Ave 3 Sidewalk: Curb side : Cutout Tree Private 2     12 3x3 Created recoard for tree on 2/28/2011. Tree approx. 20 years old. 6007102.30356 2110018.85993 37.7741110108752 -122.418877107651 (37.7741110108752, -122.418877107651) 8 2 9 28853 19
19705 95415 Undocumented 4 Ficus nitida :: Laurel Fig 53 49X South Van Ness Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     12 3x3 Created record for this tree on 2/28/2011 although tree is approxmiately 20 years old. 6007102.30356 2110018.85993 37.7741110108752 -122.418877107651 (37.7741110108752, -122.418877107651) 8 2 9 28853 19
138208 95414 Undocumented 4 Ficus nitida :: Laurel Fig 53 49X South Van Ness Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     12 3x3 Creating record for 3 ficus trees at this address on 2/28/2011. 6007102.30356 2110018.85993 37.7741110108752 -122.418877107651 (37.7741110108752, -122.418877107651) 8 2 9 28853 19
140034 95413 Undocumented 4 Ficus nitida :: Laurel Fig 53 691 Chenery St 1 Sidewalk: Curb side : Cutout Tree Private 2   10/19/2016 12:00:00 AM 12 3x3 Permit Number 779045 6002523 2095666 37.7344425689427 -122.433691689524 (37.7344425689427, -122.433691689524) 2 7 5 63 7
166856 95409 Undocumented 4 Ficus nitida :: Laurel Fig 53 2885 Diamond St 1 Sidewalk: Curb side : Cutout Tree Private 2     10 3x3 Added tree to database on 2/28/11. Appears to be 15-20 yrs old. 6002410 2095371 37.7336261540057 -122.434061286386 (37.7336261540057, -122.434061286386) 2 7 5 63 7
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
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
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
35179 95222 Undocumented 4 Ficus nitida :: Laurel Fig 53 299 on 16th St Dolores St 3 Sidewalk: Curb side : Cutout Tree Private 2     12 3x3   6004880 2106610 37.7646257206218 -122.426321695151 (37.7646257206218, -122.426321695151) 8 4 5 28859 19
132426 95220 Undocumented 4 Ficus nitida :: Laurel Fig 53 3208 16th St 2 Sidewalk: Curb side : Cutout Tree Private 2     12 3x3   6005461 2106663 37.7648040703693 -122.424315938973 (37.7648040703693, -122.424315938973) 8 4 5 28853 19
48272 95217 Undocumented 4 Ficus nitida :: Laurel Fig 53 135 Albion St 1 Sidewalk: Curb side : Cutout Tree Private 2     18 3x3   6005910 2106464 37.7642830068396 -122.422748818687 (37.7642830068396, -122.422748818687) 8 4 5 28859 19
120981 95046 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 3224 Pierce St 10 Sidewalk: Property side : Cutout Tree DPW for City Agency 14     13 3x3   6001388 2119447 37.7996748454742 -122.4393197689 (37.7996748454742, -122.4393197689) 13 9 1 57 17
141424 95044 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 3224 Pierce St 6 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
11986 95043 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 3224 Pierce St 4 Sidewalk: Property side : Cutout Tree DPW for City Agency 14     9 3x3   6001388 2119447 37.7996748454742 -122.4393197689 (37.7996748454742, -122.4393197689) 13 9 1 57 17
142881 95042 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 3224 Pierce St 2 Sidewalk: Property side : Cutout Tree DPW for City Agency 14     11 3x3   6001388 2119447 37.7996748454742 -122.4393197689 (37.7996748454742, -122.4393197689) 13 9 1 57 17
129349 95041 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 3224 Pierce St 12 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
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
122270 95039 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 3224 Pierce St 11 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

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