Street_Tree_List

Data source: data.sfgov.org

246 rows where qSpecies = 118 sorted by rowid descending

View and edit SQL

Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, DBH, PlotSize

Link rowid ▲ TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
188618 120450 Undocumented 2 Cupaniopsis anacardioides :: Carrotwood 118 5 West Clay St 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     6 Width 6ft   5988889.9604 2114983.8966900003 37.786701292081 -122.482239876772 (37.786701292081, -122.482239876772)
188475 223278 Undocumented 2 Cupaniopsis anacardioides :: Carrotwood 118 674 29th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     10 Width 2ft   6002236.285630001 2098883.15145 37.743259848274704 -122.43491295427201 (37.7432598482747, -122.434912954272)
188183 45080 Permitted Site 1 Cupaniopsis anacardioides :: Carrotwood 118 2131 29th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 05/08/2001 12:00:00 AM 2   Permit Number 43963 5987257.3685 2100779.0687 37.747603677476796 -122.486844665894 (37.7476036774768, -122.486844665894)
186594 190958 Undocumented 2 Cupaniopsis anacardioides :: Carrotwood 118 580 07th St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 3ft   6011508.79909 2109607.3250599997 37.7732281627925 -122.403605223729 (37.7732281627925, -122.403605223729)
185935 248032 Undocumented 2 Cupaniopsis anacardioides :: Carrotwood 118 123 Faith St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     10 Width 2ft   6010451.01277 2099046.16811 37.7441704496095 -122.40651991836 (37.7441704496095, -122.40651991836)
185821 57816 Permitted Site 1 Cupaniopsis anacardioides :: Carrotwood 118 953 De Haro St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/22/2005 12:00:00 AM 3   Permit Number 48159 6012187.5358 2104146.00992 37.7582705054092 -122.400873595956 (37.7582705054092, -122.400873595956)
185454 88660 Permitted Site 1 Cupaniopsis anacardioides :: Carrotwood 118 601 25th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   08/05/2008 12:00:00 AM 4 3x3 Permit Number 51637 6016339.82415 2102089.15306 37.7528535460529 -122.38636962767299 (37.7528535460529, -122.386369627673)
184540 223682 Undocumented 2 Cupaniopsis anacardioides :: Carrotwood 118 3952 25th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 3ft   6004131.52495 2101329.89232 37.7500854579739 -122.428534077398 (37.7500854579739, -122.428534077398)
184278 88667 Permitted Site 1 Cupaniopsis anacardioides :: Carrotwood 118 601 25th St 8 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   08/05/2008 12:00:00 AM 4 3x3 Permit Number 51637 6016620.614130001 2102104.21301 37.7529104362915 -122.38539964408001 (37.7529104362915, -122.38539964408)
183902 126406 Undocumented 2 Cupaniopsis anacardioides :: Carrotwood 118 2451 Steiner St 15 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 3ft   6002291.50038 2116148.81234 37.7906702521829 -122.435957203858 (37.7906702521829, -122.435957203858)
183649 126402 Undocumented 2 Cupaniopsis anacardioides :: Carrotwood 118 267 Laurel St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 3ft   5998048.61589 2115563.13153 37.788820183941205 -122.450595042542 (37.7888201839412, -122.450595042542)
183279 223677 Undocumented 2 Cupaniopsis anacardioides :: Carrotwood 118 300 Clipper St 11 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 Width 3ft   6002838.68018 2100959.36112 37.748994818662894 -122.43297833449499 (37.7489948186629, -122.432978334495)
183081 206801 Undocumented 2 Cupaniopsis anacardioides :: Carrotwood 118 258 Monterey Blvd 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     10 Width 3ft   6000353.90895 2094705.0903200002 37.7316808170083 -122.441122012192 (37.7316808170083, -122.441122012192)
183036 223272 Undocumented 2 Cupaniopsis anacardioides :: Carrotwood 118 90 Jersey St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 Width 5ft   6004552.00541 2101644.43892 37.7509729161719 -122.427102433147 (37.7509729161719, -122.427102433147)
182949 223273 Undocumented 2 Cupaniopsis anacardioides :: Carrotwood 118 336 Banks St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 2ft   6008607.352659999 2097091.32906 37.738699575030104 -122.412756741042 (37.7386995750301, -122.412756741042)
182422 176089 Undocumented 2 Cupaniopsis anacardioides :: Carrotwood 118 301 Tunnel Ave 6 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 3ft   6011754.14508 2086751.7067200001 37.71048521639379 -122.401150212131 (37.7104852163938, -122.401150212131)
181409 190959 Undocumented 2 Cupaniopsis anacardioides :: Carrotwood 118 580 07th St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 3ft   6011525.3711 2109592.00933 37.773187034992 -122.403546820846 (37.773187034992, -122.403546820846)
180539 67529 Permitted Site 1 Cupaniopsis anacardioides :: Carrotwood 118 662 Connecticut St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 09/22/1992 12:00:00 AM 13   Permit Number 31067 6013257.86111 2104004.0948 37.757940481179205 -122.397161966172 (37.7579404811792, -122.397161966172)
180363 223671 Undocumented 2 Cupaniopsis anacardioides :: Carrotwood 118 2 Powhattan Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 3ft   6007506.0274 2098173.94158 37.74161031266821 -122.41664128437999 (37.7416103126682, -122.41664128438)
180020 176090 Undocumented 2 Cupaniopsis anacardioides :: Carrotwood 118 301 Tunnel Ave 7 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 3ft   6011757.62292 2086765.56215 37.7105234546691 -122.401139164846 (37.7105234546691, -122.401139164846)
179066 223669 Undocumented 2 Cupaniopsis anacardioides :: Carrotwood 118 2 Powhattan Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 3ft   6007464.47007 2098181.71647 37.741629323436 -122.416785526654 (37.741629323436, -122.416785526654)
178266 202196 Undocumented 2 Cupaniopsis anacardioides :: Carrotwood 118 1996 Armstrong Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     5 Width 3ft   6012954.27353 2093570.5990799998 37.7292754057276 -122.397480193965 (37.7292754057276, -122.397480193965)
178225 88669 Permitted Site 1 Cupaniopsis anacardioides :: Carrotwood 118 601 25th St 10 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   08/05/2008 12:00:00 AM 4 3x3 Permit Number 51637 6016819.28345 2102114.55479 37.7529498220865 -122.384713321982 (37.7529498220865, -122.384713321982)
178182 223679 Undocumented 2 Cupaniopsis anacardioides :: Carrotwood 118 300 Clipper St 13 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 3ft   6002778.97625 2100958.54485 37.7489891907177 -122.43318473251301 (37.7489891907177, -122.433184732513)
177392 223270 Undocumented 2 Cupaniopsis anacardioides :: Carrotwood 118 3525 17th St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 4ft   6005390.76115 2106030.8763200003 37.763064442299104 -122.42451390998899 (37.7630644422991, -122.424513909989)
177315 223667 Undocumented 2 Cupaniopsis anacardioides :: Carrotwood 118 10 Gladys St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 3ft   6005813.9989 2097648.1123599997 37.7400711958267 -122.42245440134701 (37.7400711958267, -122.422454401347)
175973 202198 Undocumented 2 Cupaniopsis anacardioides :: Carrotwood 118 1998 Armstrong Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     8 Width 3ft   6012950.89039 2093587.34994 37.7293212117817 -122.39749306417102 (37.7293212117817, -122.397493064171)
175817 202153 Undocumented 2 Cupaniopsis anacardioides :: Carrotwood 118 1943 Armstrong Ave 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     8 Width 7ft   6013054.85353 2093433.92218 37.7289057187068 -122.397122897799 (37.7289057187068, -122.397122897799)
175219 126403 Undocumented 2 Cupaniopsis anacardioides :: Carrotwood 118 267 Laurel St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 3ft   5998050.21205 2115538.80014 37.7887534677578 -122.450587765208 (37.7887534677578, -122.450587765208)
175143 248034 Undocumented 2 Cupaniopsis anacardioides :: Carrotwood 118 120 Faith St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     9 Width 2ft   6010483.27046 2099064.9388900003 37.7442237946989 -122.40640970014299 (37.7442237946989, -122.406409700143)
174424 121794 Permitted Site 1 Cupaniopsis anacardioides :: Carrotwood 118 953 De Haro St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4     6012184.336680001 2104198.44513 37.7584143024936 -122.40088834394399 (37.7584143024936, -122.400888343944)
174410 32057 Permitted Site 1 Cupaniopsis anacardioides :: Carrotwood 118 3525 17th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   08/20/2003 12:00:00 AM 4   Permit Number 46894 6005365.81768 2106030.42117 37.7630617839077 -122.424600148687 (37.7630617839077, -122.424600148687)
174247 190951 Undocumented 2 Cupaniopsis anacardioides :: Carrotwood 118 50 Southern Heights Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     3 Width 7ft   6012249.68745 2104070.76225 37.758067358448294 -122.40065336098301 (37.7580673584483, -122.400653360983)
173616 121793 Permitted Site 1 Cupaniopsis anacardioides :: Carrotwood 118 953 De Haro St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4     6012186.53897 2104166.90751 37.75832782998339 -122.40087851165501 (37.7583278299834, -122.400878511655)
172917 70102 Undocumented 2 Cupaniopsis anacardioides :: Carrotwood 118 3016 Anza St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 05/22/1993 12:00:00 AM 5     5989286.3225 2111962.37495 37.778428088511795 -122.48064729942301 (37.7784280885118, -122.480647299423)
172763 248033 Undocumented 2 Cupaniopsis anacardioides :: Carrotwood 118 110 Faith St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     10 Width 2ft   6010558.59528 2099039.59827 37.74415842836721 -122.406147456957 (37.7441584283672, -122.406147456957)
171518 68911 Permitted Site 1 Cupaniopsis anacardioides :: Carrotwood 118 1037 Broadway 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 12/29/1993 12:00:00 AM 5   Permit Number 32888 6008631.3882 2118270.06785 37.7968528160714 -122.414171603039 (37.7968528160714, -122.414171603039)
171425 202159 Undocumented 2 Cupaniopsis anacardioides :: Carrotwood 118 1907 Armstrong Ave 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     6 Width 7ft   6013147.17786 2093363.32947 37.7287170247605 -122.39679877674999 (37.7287170247605, -122.39679877675)
171264 67387 Permitted Site 1 Cupaniopsis anacardioides :: Carrotwood 118 772 17th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/28/1992 12:00:00 AM 6   Permit Number 30884 5990710.6374699995 2110145.5351 37.77352222225821 -122.475587411896 (37.7735222222582, -122.475587411896)
170918 120449 Undocumented 2 Cupaniopsis anacardioides :: Carrotwood 118 5 West Clay St 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     4 Width 6ft   5988902.13193 2114984.1138299997 37.7867025962493 -122.4821977826 (37.7867025962493, -122.4821977826)
170843 202194 Undocumented 2 Cupaniopsis anacardioides :: Carrotwood 118 1928 Armstrong Ave 3 Sidewalk: Property side : Yard 9 Tree 1 Private 1     5 Width 7ft   6013120.24399 2093453.13638 37.72896211700179 -122.396898183325 (37.7289621170018, -122.396898183325)
170081 88671 Permitted Site 1 Cupaniopsis anacardioides :: Carrotwood 118 601 25th St 12 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   08/05/2008 12:00:00 AM 4 3x3 Permit Number 51637 6016898.1799800005 2102118.1456400002 37.7529640448765 -122.38444073025299 (37.7529640448765, -122.384440730253)
168277 190953 Undocumented 2 Cupaniopsis anacardioides :: Carrotwood 118 28 Fremont St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 5ft   6013222.073969999 2116219.26645 37.7914785844106 -122.398142697526 (37.7914785844106, -122.398142697526)
166754 190950 Undocumented 2 Cupaniopsis anacardioides :: Carrotwood 118 50 Southern Heights Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     4 Width 4ft   6012271.113530001 2104059.64338 37.7580380234458 -122.40057847891701 (37.7580380234458, -122.400578478917)
164371 223277 Undocumented 2 Cupaniopsis anacardioides :: Carrotwood 118 950 Corbett Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 3ft   5999782.99991 2102046.02662 37.751804743197 -122.44362291258899 (37.751804743197, -122.443622912589)
164286 202206 Undocumented 2 Cupaniopsis anacardioides :: Carrotwood 118 1976 Armstrong Ave 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     7 Width 7ft   6013013.79593 2093534.14859 37.7291786341692 -122.397271863302 (37.7291786341692, -122.397271863302)
163960 248035 Undocumented 2 Cupaniopsis anacardioides :: Carrotwood 118 132 Faith St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 2ft   6010441.24954 2099079.47689 37.744261362076294 -122.40655602435899 (37.7442613620763, -122.406556024359)
162671 206797 Undocumented 2 Cupaniopsis anacardioides :: Carrotwood 118 415 Garfield St 1 : 4 Tree 1 Private 1     2 Width 3ft   5992912.29675 2090464.70197 37.7196110652749 -122.466540843488 (37.7196110652749, -122.466540843488)
161512 190957 Undocumented 2 Cupaniopsis anacardioides :: Carrotwood 118 580 07th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     9 Width 3ft   6011496.47934 2109620.41486 37.773263416204294 -122.403648760805 (37.7732634162043, -122.403648760805)
161404 36946 Permitted Site 1 Cupaniopsis anacardioides :: Carrotwood 118 165 03rd Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 05/29/1998 12:00:00 AM 7   Permit Number 39581 5994879.55101 2114458.4572900003 37.7856051482988 -122.461479365875 (37.7856051482988, -122.461479365875)
161132 202144 Undocumented 2 Cupaniopsis anacardioides :: Carrotwood 118 1999 Armstrong Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     7 Width 7ft   6012917.46969 2093534.23595 37.7291735107263 -122.39760487958598 (37.7291735107263, -122.397604879586)
159166 202148 Undocumented 2 Cupaniopsis anacardioides :: Carrotwood 118 1973 Armstrong Ave 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     8 Width 7ft   6012979.956230001 2093488.41205 37.7290511669581 -122.397385644629 (37.7290511669581, -122.397385644629)
158962 202201 Undocumented 2 Cupaniopsis anacardioides :: Carrotwood 118 1948 Armstrong Ave 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     9 Width 7ft   6013078.4423 2093486.02938 37.729050107561605 -122.39704500125099 (37.7290501075616, -122.397045001251)
158662 223670 Undocumented 2 Cupaniopsis anacardioides :: Carrotwood 118 2 Powhattan Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 3ft   6007488.19675 2098176.2850900004 37.7416157445795 -122.416703102889 (37.7416157445795, -122.416703102889)
156099 88662 Permitted Site 1 Cupaniopsis anacardioides :: Carrotwood 118 601 25th St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   08/05/2008 12:00:00 AM 3 3x3 Permit Number 51637 6016419.5289900005 2102093.1245 37.7528688624307 -122.386094267831 (37.7528688624307, -122.386094267831)
155539 190952 Undocumented 2 Cupaniopsis anacardioides :: Carrotwood 118 50 Southern Heights Ave 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     5 Width 7ft   6012228.79731 2104083.07063 37.7580999894276 -122.400726473151 (37.7580999894276, -122.400726473151)
155140 202207 Undocumented 2 Cupaniopsis anacardioides :: Carrotwood 118 1968 Armstrong Ave 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     9 Width 7ft   6013020.76239 2093529.61913 37.72916658504629 -122.397247462005 (37.7291665850463, -122.397247462005)
154499 88668 Permitted Site 1 Cupaniopsis anacardioides :: Carrotwood 118 601 25th St 9 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   08/05/2008 12:00:00 AM 5 3x3 Permit Number 51637 6016777.6314900005 2102112.60454 37.7529421634534 -122.38485722789 (37.7529421634534, -122.38485722789)
152240 202158 Undocumented 2 Cupaniopsis anacardioides :: Carrotwood 118 1913 Armstrong Ave 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     5 Width 7ft   6013140.94695 2093368.78005 37.7287316441256 -122.39682069951701 (37.7287316441256, -122.396820699517)
151741 176091 Undocumented 2 Cupaniopsis anacardioides :: Carrotwood 118 301 Tunnel Ave 8 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 3ft   6011761.10909 2086779.81535 37.7105627856051 -122.401128116692 (37.7105627856051, -122.401128116692)
151533 126407 Undocumented 2 Cupaniopsis anacardioides :: Carrotwood 118 2610 Clay St 22 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     10 Width 5ft   6001526.97686 2116002.32801 37.7902245832452 -122.43859190811399 (37.7902245832452, -122.438591908114)
150287 176084 Undocumented 2 Cupaniopsis anacardioides :: Carrotwood 118 301 Tunnel Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 3ft   6011735.35451 2086672.5104200002 37.710266710803104 -122.401209595273 (37.7102667108031, -122.401209595273)
148055 202149 Undocumented 2 Cupaniopsis anacardioides :: Carrotwood 118 1967 Armstrong Ave 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     7 Width 7ft   6012987.61375 2093482.17002 37.7290344539678 -122.39735873424101 (37.7290344539678, -122.397358734241)
147774 223681 Undocumented 2 Cupaniopsis anacardioides :: Carrotwood 118 300 Clipper St 17 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     13 Width 3ft   6002667.71298 2100952.64567 37.7489666806705 -122.433569059575 (37.7489666806705, -122.433569059575)
147051 223674 Undocumented 2 Cupaniopsis anacardioides :: Carrotwood 118 300 Clipper St 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 3ft   6003026.25386 2100972.90795 37.7490426526966 -122.432330671519 (37.7490426526966, -122.432330671519)
146611 206798 Undocumented 2 Cupaniopsis anacardioides :: Carrotwood 118 714 Detroit St 15 Side Yard : Yard 17 Tree 1 Private 1     13     5999465.474230001 2095438.72707 37.7336445658277 -122.444246198512 (37.7336445658277, -122.444246198512)
145817 91476 Permitted Site 1 Cupaniopsis anacardioides :: Carrotwood 118 601 25th St 7 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   08/05/2008 12:00:00 AM   3x3 Permit Number 51637 6016776.9 2102119.9 37.7529621548081 -122.384860265748 (37.7529621548081, -122.384860265748)
145468 32758 Permitted Site 1 Cupaniopsis anacardioides :: Carrotwood 118 100x THRIFT ST 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 10/29/1996 12:00:00 AM     Permit Number 37135 5995486.0 2089629.0 37.7174646081384 -122.45758410365801 (37.7174646081384, -122.457584103658)
145322 33995 Permitted Site 1 Cupaniopsis anacardioides :: Carrotwood 118 120 Faith St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 10/18/1997 12:00:00 AM     Permit Number 38457 6010502.26399862 2099074.74698805 37.7442517881202 -122.40634471521003 (37.7442517881202, -122.40634471521)
145175 108885 Private 5 Cupaniopsis anacardioides :: Carrotwood 118 707 NOE ST 5 Back Yard : Yard 13 Tree 1 Private 1       3x3   6003152.4 2104071.5 37.757557804850705 -122.43211570496099 (37.7575578048507, -122.432115704961)
144321 91475 Permitted Site 1 Cupaniopsis anacardioides :: Carrotwood 118 601 25th St 6 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   08/05/2008 12:00:00 AM   3x3 Permit Number 51637 6016776.9 2102119.9 37.7529621548081 -122.384860265748 (37.7529621548081, -122.384860265748)
144300 42749 Permitted Site 1 Cupaniopsis anacardioides :: Carrotwood 118 333 Tunnel Ave 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 06/26/2000 12:00:00 AM     Permit Number 42738 6011765.57664352 2086774.37059761 37.7105480846287 -122.40111229342399 (37.7105480846287, -122.401112293424)
144135 42747 Permitted Site 1 Cupaniopsis anacardioides :: Carrotwood 118 333 Tunnel Ave 6 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 06/26/2000 12:00:00 AM     Permit Number 42738 6011765.57664352 2086774.37059761 37.7105480846287 -122.40111229342399 (37.7105480846287, -122.401112293424)
141602 42744 Permitted Site 1 Cupaniopsis anacardioides :: Carrotwood 118 333 Tunnel Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 06/26/2000 12:00:00 AM     Permit Number 42738 6011765.57664352 2086774.37059761 37.7105480846287 -122.40111229342399 (37.7105480846287, -122.401112293424)
141272 91473 Permitted Site 1 Cupaniopsis anacardioides :: Carrotwood 118 601 25th St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   08/05/2008 12:00:00 AM   3x3 Permit Number 51637 6016776.9 2102119.9 37.7529621548081 -122.384860265748 (37.7529621548081, -122.384860265748)
141049 91471 Permitted Site 1 Cupaniopsis anacardioides :: Carrotwood 118 601 25th St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   08/05/2008 12:00:00 AM   3x3 Permit Number 51637 6016776.9 2102119.9 37.7529621548081 -122.384860265748 (37.7529621548081, -122.384860265748)
141044 46131 Permitted Site 1 Cupaniopsis anacardioides :: Carrotwood 118 137 Beulah St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 12/27/2001 12:00:00 AM     Permit Number 44481 5997450.10216271 2107762.76782376 37.7673681457069 -122.452102777266 (37.7673681457069, -122.452102777266)
140007 100278 Undocumented 2 Cupaniopsis anacardioides :: Carrotwood 118 3460X 20th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 3x3   6007182.0 2104415.0 37.7587286142457 -122.41820403955799 (37.7587286142457, -122.418204039558)
138514 100279 Undocumented 2 Cupaniopsis anacardioides :: Carrotwood 118 3460X 20th St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 3x3   6007182.0 2104415.0 37.7587286142457 -122.41820403955799 (37.7587286142457, -122.418204039558)
137005 120451 Undocumented 2 Cupaniopsis anacardioides :: Carrotwood 118 5 West Clay St 4 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     3 Width 6ft   5988873.724640001 2114983.29043 37.7866986830782 -122.482296003521 (37.7866986830782, -122.482296003521)
135878 223668 Undocumented 2 Cupaniopsis anacardioides :: Carrotwood 118 10 Gladys St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 3ft   6005828.6404800005 2097671.05304 37.740135011734 -122.42240540628299 (37.740135011734, -122.422405406283)
135598 88666 Permitted Site 1 Cupaniopsis anacardioides :: Carrotwood 118 601 25th St 7 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   08/05/2008 12:00:00 AM 4 3x3 Permit Number 51637 6016578.93003 2102100.6702900003 37.7528984024518 -122.385543550016 (37.7528984024518, -122.385543550016)
135441 36943 Permitted Site 1 Cupaniopsis anacardioides :: Carrotwood 118 152 03rd Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 05/29/1998 12:00:00 AM 4   Permit Number 39580 5994926.19435 2114520.7878400004 37.7857789756862 -122.46132251465099 (37.7857789756862, -122.461322514651)
135209 202143 Undocumented 2 Cupaniopsis anacardioides :: Carrotwood 118 1999 Armstrong Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     11 Width 3ft   6012908.83816 2093533.00853 37.7291696598447 -122.39763463365601 (37.7291696598447, -122.397634633656)
135159 223673 Undocumented 2 Cupaniopsis anacardioides :: Carrotwood 118 300 Clipper St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     11 Width 3ft   6003155.02499 2100979.4719700003 37.7490679767212 -122.43188584885799 (37.7490679767212, -122.431885848858)
135109 223274 Undocumented 2 Cupaniopsis anacardioides :: Carrotwood 118 91 Bronte St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     10 Width 3ft   6009343.02898 2096929.97476 37.738297795693995 -122.41020172124901 (37.738297795694, -122.410201721249)
134346 223676 Undocumented 2 Cupaniopsis anacardioides :: Carrotwood 118 300 Clipper St 10 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 3ft   6002874.24252 2100962.2133 37.749004667153 -122.432855563559 (37.749004667153, -122.432855563559)
131951 176083 Undocumented 2 Cupaniopsis anacardioides :: Carrotwood 118 120 Lathrop Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     9 Width 3ft   6011939.3192 2086886.00886 37.7108643121037 -122.40051963449899 (37.7108643121037, -122.400519634499)
131603 126404 Undocumented 2 Cupaniopsis anacardioides :: Carrotwood 118 2501 Jackson St 7 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 3ft   6001524.31807 2116606.64238 37.7918837227069 -122.438644426709 (37.7918837227069, -122.438644426709)
129334 91470 Permitted Site 1 Cupaniopsis anacardioides :: Carrotwood 118 601 25th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   08/05/2008 12:00:00 AM   3x3 Permit Number 51637 6016776.9 2102119.9 37.7529621548081 -122.384860265748 (37.7529621548081, -122.384860265748)
128365 39517 Permitted Site 1 Cupaniopsis anacardioides :: Carrotwood 118 3964 25TH ST 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 12/28/1998 12:00:00 AM 8   Permit Number 40967 6004074.0 2101323.0 37.750063277719704 -122.42873251065399 (37.7500632777197, -122.428732510654)
126803 45808 Permitted Site 1 Cupaniopsis anacardioides :: Carrotwood 118 151 Charles St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/04/2001 12:00:00 AM     Permit Number 44436 6004877.73984335 2097041.07807041 37.7383515558837 -122.42564841052 (37.7383515558837, -122.42564841052)
125526 41098 Permitted Site 1 Cupaniopsis anacardioides :: Carrotwood 118 2 Powhattan Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   11/10/1999 12:00:00 AM     Permit Number 41846 6007385.16398243 2098172.89678414 37.741600645555295 -122.41705911631 (37.7416006455553, -122.41705911631)
124807 32759 Permitted Site 1 Cupaniopsis anacardioides :: Carrotwood 118 100x THRIFT ST 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 10/29/1996 12:00:00 AM     Permit Number 37135 5995486.0 2089629.0 37.7174646081384 -122.45758410365801 (37.7174646081384, -122.457584103658)
123965 41097 Permitted Site 1 Cupaniopsis anacardioides :: Carrotwood 118 2 Powhattan Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 11/10/1999 12:00:00 AM     Permit Number 41846 6007385.16398243 2098172.89678414 37.741600645555295 -122.41705911631 (37.7416006455553, -122.41705911631)
123357 34213 Permitted Site 1 Cupaniopsis anacardioides :: Carrotwood 118 137 Faith St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 10/18/1997 12:00:00 AM     Permit Number 38029 6010403.59737914 2099053.11250995 37.7441868646564 -122.40668436049499 (37.7441868646564, -122.406684360495)
123346 42750 Permitted Site 1 Cupaniopsis anacardioides :: Carrotwood 118 333 Tunnel Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 06/26/2000 12:00:00 AM     Permit Number 42738 6011765.57664352 2086774.37059761 37.7105480846287 -122.40111229342399 (37.7105480846287, -122.401112293424)
123033 16091 DPW Maintained 3 Cupaniopsis anacardioides :: Carrotwood 118 284 Monterey Blvd 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 3X3   6000198.548030901 2094712.9146897998 37.7316934502774 -122.44165968578001 (37.7316934502774, -122.44165968578)
122851 33431 Permitted Site 1 Cupaniopsis anacardioides :: Carrotwood 118 127 Stillings Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 11/19/1996 12:00:00 AM     Permit Number 37535 5999930.67607914 2095733.95298446 37.7344817167018 -122.44265905551799 (37.7344817167018, -122.442659055518)
122799 34212 Permitted Site 1 Cupaniopsis anacardioides :: Carrotwood 118 146 Faith St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 10/18/1997 12:00:00 AM     Permit Number 38028 6010380.78922037 2099115.666634 37.74435734854671 -122.40676763416599 (37.7443573485467, -122.406767634166)

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE "Street_Tree_List" (
"TreeID" INTEGER,
  "qLegalStatus" INTEGER,
  "qSpecies" INTEGER,
  "qAddress" TEXT,
  "SiteOrder" INTEGER,
  "qSiteInfo" INTEGER,
  "PlantType" INTEGER,
  "qCaretaker" INTEGER,
  "qCareAssistant" INTEGER,
  "PlantDate" TEXT,
  "DBH" INTEGER,
  "PlotSize" TEXT,
  "PermitNotes" TEXT,
  "XCoord" REAL,
  "YCoord" REAL,
  "Latitude" REAL,
  "Longitude" REAL,
  "Location" TEXT
,
FOREIGN KEY ("PlantType") REFERENCES [PlantType](id),
    FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id),
    FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id),
    FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id),
    FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id),
    FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id));
CREATE INDEX ["Street_Tree_List_PlantType"] ON [Street_Tree_List]("PlantType");
CREATE INDEX ["Street_Tree_List_qCaretaker"] ON [Street_Tree_List]("qCaretaker");
CREATE INDEX ["Street_Tree_List_qSpecies"] ON [Street_Tree_List]("qSpecies");
CREATE INDEX ["Street_Tree_List_qSiteInfo"] ON [Street_Tree_List]("qSiteInfo");
CREATE INDEX ["Street_Tree_List_qCareAssistant"] ON [Street_Tree_List]("qCareAssistant");
CREATE INDEX ["Street_Tree_List_qLegalStatus"] ON [Street_Tree_List]("qLegalStatus");
Powered by Datasette · Query took 72.93ms · Data source: data.sfgov.org