Street_Tree_List

Data source: data.sfgov.org

321 rows where qSpecies = 109 sorted by rowid descending

View and edit SQL

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

Link rowid ▲ TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
189094 221424 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 900x Guerrero St 2 Median : Cutout 11 Tree 1 DPW 2     6 Width 3ft   6005689.534530001 2103630.03961 37.7564891759384 -122.423309876046 (37.7564891759384, -122.423309876046)
188083 221533 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 1100x Guerrero St 9 Median : Cutout 11 Tree 1 DPW 2     8 Width 3ft   6005767.42939 2102227.70946 37.75264309841 -122.422940823082 (37.75264309841, -122.422940823082)
185218 221536 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 1100x Guerrero St 5 Median : Cutout 11 Tree 1 DPW 2     9 Width 3ft   6005762.1987 2102333.32685 37.75293280420979 -122.422966417762 (37.7529328042098, -122.422966417762)
185178 221511 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 1300x Guerrero St 11 Median : Cutout 11 Tree 1 DPW 2     6 Width 3ft   6005835.54562 2100976.57743 37.749211620932606 -122.422616365666 (37.7492116209326, -122.422616365666)
184620 221570 Undocumented 2 Acacia stenophylla :: Shoestring Acacia 109 117 Alpine Ter 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 3ft   6001705.56397 2108155.3423 37.768688901296294 -122.437411868978 (37.7686889012963, -122.437411868978)
184414 221498 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 600x Guerrero St 5 Median : Cutout 11 Tree 1 DPW 2     3 Width 3ft   6005599.77613 2105242.7413 37.7609122108583 -122.423734955914 (37.7609122108583, -122.423734955914)
182868 221512 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 1300x Guerrero St 10 Median : Cutout 11 Tree 1 DPW 2     7 Width 3ft   6005835.43443 2101000.02463 37.749275995297296 -122.422618416129 (37.7492759952973, -122.422618416129)
182798 221555 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 1000x Guerrero St 13 Median : Cutout 11 Tree 1 DPW 2     2 Width 3ft   6005738.9106 2102712.57542 37.753972818908 -122.423073906548 (37.753972818908, -122.423073906548)
182320 221521 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 1200x Guerrero St 12 Median : Cutout 11 Tree 1 DPW 2     7 Width 3ft   6005805.669319999 2101529.55059 37.7507282726947 -122.422758971142 (37.7507282726947, -122.422758971142)
181350 187782 Undocumented 2 Acacia stenophylla :: Shoestring Acacia 109 101 Pennsylvania Ave 14 Front Yard : Yard 7 Tree 1 Private 1     1     6014325.58247 2106437.08289 37.764680319857995 -122.39363958970199 (37.764680319858, -122.393639589702)
180267 221556 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 1000x Guerrero St 14 Median : Cutout 11 Tree 1 DPW 2     3 Width 3ft   6005741.57845 2102677.06839 37.753875475376 -122.42306215689501 (37.753875475376, -122.423062156895)
179875 221564 Undocumented 2 Acacia stenophylla :: Shoestring Acacia 109 4286 23rd St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 3ft   6001316.917769999 2102341.7359599997 37.7527040553705 -122.438339609582 (37.7527040553705, -122.438339609582)
179323 221491 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 500x Guerrero St 11 Median : Cutout 11 Tree 1 DPW 2     1 Width 3ft   6005578.642000001 2105634.14294 37.7619857144891 -122.423835881448 (37.7619857144891, -122.423835881448)
179284 221563 Undocumented 2 Acacia stenophylla :: Shoestring Acacia 109 4286 23rd St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 3ft   6001305.60339 2102341.6071 37.752703058000705 -122.438378727412 (37.7527030580007, -122.438378727412)
179218 201712 Undocumented 2 Acacia stenophylla :: Shoestring Acacia 109 724 Jamestown Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 4ft   6015351.33364 2088303.0821 37.7149450173645 -122.388825682463 (37.7149450173645, -122.388825682463)
178961 221541 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 900x Guerrero St 8 Median : Cutout 11 Tree 1 DPW 2     6 Width 3ft   6005710.1718 2103251.3867 37.7554506478492 -122.423211590049 (37.7554506478492, -122.423211590049)
178254 221510 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 1300x Guerrero St 13 Median : Cutout 11 Tree 1 DPW 2     7 Width 3ft   6005838.80296 2100921.0233299998 37.7490592658716 -122.422601154533 (37.7490592658716, -122.422601154533)
177873 221550 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 1000x Guerrero St 7 Median : Cutout 11 Tree 1 DPW 2     1 Width 3ft   6005729.97057 2102894.68155 37.7544723356343 -122.423117766494 (37.7544723356343, -122.423117766494)
177057 221539 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 1100x Guerrero St 2 Median : Cutout 11 Tree 1 DPW 2     5 Width 3ft   6005756.51513 2102435.1394700003 37.753212037416 -122.422993308391 (37.753212037416, -122.422993308391)
176764 221549 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 1000x Guerrero St 6 Median : Cutout 11 Tree 1 DPW 2     1 Width 3ft   6005728.89674 2102911.59468 37.7545187145683 -122.423122682192 (37.7545187145683, -122.423122682192)
176544 221552 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 1000x Guerrero St 10 Median : Cutout 11 Tree 1 DPW 2     3 Width 3ft   6005734.10722 2102815.94179 37.754256367947704 -122.423097864468 (37.7542563679477, -122.423097864468)
174460 221422 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 800x Guerrero St 10 Median : Cutout 11 Tree 1 DPW 2     6 Width 3ft   6005661.88318 2104154.96713 37.7579289437835 -122.42344282103001 (37.7579289437835, -122.42344282103)
171233 221443 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 100x Guerrero St 16 Median : Cutout 11 Tree 1 DPW 2     1 Width 3ft   6005451.42839 2107920.02985 37.7682550341586 -122.42443846228599 (37.7682550341586, -122.424438462286)
169800 221482 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 500x Guerrero St 2 Median : Cutout 11 Tree 1 DPW 2     1 Width 3ft   6005559.28434 2105952.19302 37.762857912083795 -122.423925449408 (37.7628579120838, -122.423925449408)
169767 221481 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 500x Guerrero St 1 Median : Cutout 11 Tree 1 DPW 2     2 Width 3ft   6005557.328430001 2105982.39063 37.7629407171602 -122.423934361684 (37.7629407171602, -122.423934361684)
169550 221558 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 1000x Guerrero St 5 Median : Cutout 11 Tree 1 DPW 2     3 Width 3ft   6005728.5881 2102926.2105099997 37.754558828830106 -122.423124788381 (37.7545588288301, -122.423124788381)
168829 221544 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 900x Guerrero St 5 Median : Cutout 11 Tree 1 DPW 2     7 Width 3ft   6005705.623380001 2103333.32509 37.755675374928295 -122.423233144119 (37.7556753749283, -122.423233144119)
163113 221534 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 1100x Guerrero St 8 Median : Cutout 11 Tree 1 DPW 2     7 Width 3ft   6005765.63484 2102254.12398 37.7527155253202 -122.422948906168 (37.7527155253202, -122.422948906168)
161335 201715 Undocumented 2 Acacia stenophylla :: Shoestring Acacia 109 726 Jamestown Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 4ft   6015296.606380001 2088393.85947 37.715191240972 -122.38902117888901 (37.715191240972, -122.389021178889)
159995 221439 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 100x Guerrero St 12 Median : Cutout 11 Tree 1 DPW 2     1 Width 3ft   6005446.76573 2108031.65533 37.768561267704705 -122.424462530821 (37.7685612677047, -122.424462530821)
159637 221417 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 800x Guerrero St 3 Median : Cutout 11 Tree 1 DPW 2     1 Width 3ft   6005673.16306 2103886.4908 37.7571924071266 -122.42338472483101 (37.7571924071266, -122.423384724831)
159464 221532 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 1100x Guerrero St 10 Median : Cutout 11 Tree 1 DPW 2     8 Width 3ft   6005770.103999999 2102168.30473 37.7524801376575 -122.42292735211201 (37.7524801376575, -122.422927352112)
159086 221493 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 500x Guerrero St 13 Median : Cutout 11 Tree 1 DPW 2     2 Width 3ft   6005583.08285 2105563.4275 37.7617917972666 -122.42381549380801 (37.7617917972666, -122.423815493808)
158034 221565 Undocumented 2 Acacia stenophylla :: Shoestring Acacia 109 4286 23rd St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 3ft   6001328.916669999 2102339.67059 37.7526990668325 -122.438297967381 (37.7526990668325, -122.438297967381)
155379 221559 Undocumented 2 Acacia stenophylla :: Shoestring Acacia 109 1306 York St 4 : 4 Tree 1 Private 1     7 Width 3ft   6010039.89073 2101557.1439900002 37.7510420290671 -122.408118546954 (37.7510420290671, -122.408118546954)
155282 221421 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 800x Guerrero St 9 Median : Cutout 11 Tree 1 DPW 2     7 Width 3ft   6005663.971419999 2104121.3615 37.7578367884406 -122.42343320997499 (37.7578367884406, -122.423433209975)
155244 221567 Undocumented 2 Acacia stenophylla :: Shoestring Acacia 109 324 Hill St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 3ft   6004154.58593 2103373.98314 37.7556993571514 -122.428600021096 (37.7556993571514, -122.428600021096)
153605 221517 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 1300x Guerrero St 4 Median : Cutout 11 Tree 1 DPW 2     7 Width 3ft   6005823.4134 2101214.1336 37.7498632112216 -122.422675198428 (37.7498632112216, -122.422675198428)
151865 221485 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 500x Guerrero St 5 Median : Cutout 11 Tree 1 DPW 2     3 Width 3ft   6005566.92978 2105826.00789 37.762511869155105 -122.42389003321101 (37.7625118691551, -122.423890033211)
151374 221444 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 200x Guerrero St 12 Median : Cutout 11 Tree 1 DPW 2     1 Width 3ft   6005482.048359999 2107327.01142 37.766628476241294 -122.42429036821301 (37.7666284762413, -122.424290368213)
150449 221531 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 1100x Guerrero St 11 Median : Cutout 11 Tree 1 DPW 2     0 Width 3ft   6005769.92765 2102140.767 37.7524045154572 -122.422926004956 (37.7524045154572, -122.422926004956)
150263 221520 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 1200x Guerrero St 13 Median : Cutout 11 Tree 1 DPW 2     6 Width 3ft   6005805.491090001 2101500.8171 37.7506493670819 -122.422757545722 (37.7506493670819, -122.422757545722)
149575 221542 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 900x Guerrero St 7 Median : Cutout 11 Tree 1 DPW 2     8 Width 3ft   6005709.18006 2103278.9471400003 37.7555262664424 -122.423216978787 (37.7555262664424, -122.423216978787)
148926 221442 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 100x Guerrero St 15 Median : Cutout 11 Tree 1 DPW 2     1 Width 3ft   6005450.9028900005 2107942.8086599996 37.768317549645 -122.42444190036699 (37.768317549645, -122.424441900367)
148793 221561 Undocumented 2 Acacia stenophylla :: Shoestring Acacia 109 100 San Jose Ave 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 3ft   6006161.81341 2102510.42937 37.7534416280528 -122.42159704977 (37.7534416280528, -122.42159704977)
148070 221507 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 900x Guerrero St 2 Median : Cutout 11 Tree 1 DPW 2     5 Width 3ft   6005699.48542 2103446.5929900003 37.755986035831704 -122.42326242243999 (37.7559860358317, -122.42326242244)
147617 221420 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 800x Guerrero St 8 Median : Cutout 11 Tree 1 DPW 2     5 Width 3ft   6005663.71373 2104068.90036 37.7576927278639 -122.423430371709 (37.7576927278639, -122.423430371709)
146089 115514 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 200x Guerrero St 5 Median : Cutout 11 Tree 1 DPW 2   02/09/2016 11:36:00 AM 3     6005415.2 2107753.5 37.767795737129205 -122.424551925681 (37.7677957371292, -122.424551925681)
145556 66265 Permitted Site 1 Acacia stenophylla :: Shoestring Acacia 109 4020 26th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   10/30/1990 12:00:00 AM 3 6x9 Permit Number 29370 6003740.3803829 2100725.5739603 37.7484039979455 -122.429843577344 (37.7484039979455, -122.429843577344)
145184 91240 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 842x Guerrero St 2 Median : Cutout 11 Tree 1 DPW 2   11/20/2009 12:00:00 AM 3     6005622.0 2104059.0 37.7576631893365 -122.423573931211 (37.7576631893365, -122.423573931211)
144929 110773 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 1000X GUERRERO ST 2 Median : Cutout 11 Tree 1 DPW 2   05/26/2015 03:06:00 PM 3 3x3   6005663.0 2103080.0 37.7549773975701 -122.423362541701 (37.7549773975701, -122.423362541701)
144269 56594 Permitted Site 1 Acacia stenophylla :: Shoestring Acacia 109 533 Laidley St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   11/16/2012 12:00:00 AM 3 3x3 Permit Number 768959 6003224.0 2096098.0 37.7356684939052 -122.431298930259 (37.7356684939052, -122.431298930259)
144040 109702 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 600x GUERRERO ST 10 Median : Cutout 11 Tree 1 DPW 2   02/21/2015 11:06:00 PM 3 3x3   6005435.8 2105392.6 37.7613144297161 -122.42431273662201 (37.7613144297161, -122.424312736622)
143107 221551 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 1000x Guerrero St 9 Median : Cutout 11 Tree 1 DPW 2     2 Width 3ft   6005731.5319 2102850.00284 37.7543497463656 -122.423109191463 (37.7543497463656, -122.423109191463)
142527 109699 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 600x GUERRERO ST 7 Median : Cutout 11 Tree 1 DPW 2   02/28/2015 11:10:00 PM 3 3x3   6005435.8 2105392.6 37.7613144297161 -122.42431273662201 (37.7613144297161, -122.424312736622)
141675 91237 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 808 Guerrero St 1 Median : Cutout 11 Tree 1 DPW 2   11/20/2009 12:00:00 AM 3 4x15   6005611.0 2104262.0 37.7582199589604 -122.423626406477 (37.7582199589604, -122.423626406477)
141379 91281 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 1212x Guerrero St 1 Median : Cutout 11 Tree 1 DPW 2   11/20/2008 12:00:00 AM 3     6005738.0 2101906.0 37.7517580978369 -122.42301973133999 (37.7517580978369, -122.42301973134)
141128 91251 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 906X Guerrero St 1 Median : Cutout 11 Tree 1 DPW 2   11/20/2008 12:00:00 AM 3 3x100   6005675.14042 2103682.124768 37.756631377266295 -122.42336335858299 (37.7566313772663, -122.423363358583)
141030 43726 Permitted Site 1 Acacia stenophylla :: Shoestring Acacia 109 760 Lakeview Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/25/2000 12:00:00 AM     Permit Number 43365 5994428.64681371 2089956.34861374 37.7183026346731 -122.461262575973 (37.7183026346731, -122.461262575973)
141015 110784 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 1000X GUERRERO ST 13 Median : Cutout 11 Tree 1 DPW 2   05/26/2015 02:11:00 PM 3 3x3   6005663.0 2103080.0 37.7549773975701 -122.423362541701 (37.7549773975701, -122.423362541701)
140294 110759 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 300X GUERRERO ST 1 Median : Cutout 11 Tree 1 DPW 2   06/19/2015 10:59:00 AM 3 3x3   6005492.0 2106949.0 37.7655911088206 -122.424229059984 (37.7655911088206, -122.424229059984)
139744 110783 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 1000X GUERRERO ST 12 Median : Cutout 11 Tree 1 DPW 2   05/26/2015 02:16:00 PM 3 3x3   6005663.0 2103080.0 37.7549773975701 -122.423362541701 (37.7549773975701, -122.423362541701)
139621 91273 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 1140x Guerrero St 1 Median : Cutout 11 Tree 1 DPW 2   11/20/2009 12:00:00 AM 3     6005718.0 2102324.0 37.752904700718105 -122.423118602517 (37.7529047007181, -122.423118602517)
137049 221516 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 1300x Guerrero St 6 Median : Cutout 11 Tree 1 DPW 2     9 Width 3ft   6005827.472999999 2101138.31675 37.749655264584 -122.42265577304701 (37.749655264584, -122.422655773047)
136012 187785 Undocumented 2 Acacia stenophylla :: Shoestring Acacia 109 1740 20th St 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     1 Width 3ft   6012766.00153 2104746.33455 37.7599511143744 -122.39891512883499 (37.7599511143744, -122.398915128835)
135861 221547 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 1000x Guerrero St 3 Median : Cutout 11 Tree 1 DPW 2     3 Width 3ft   6005723.41397 2102999.7023 37.7547603282456 -122.42314790545299 (37.7547603282456, -122.423147905453)
134894 221423 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 800x Guerrero St 12 Median : Cutout 11 Tree 1 DPW 2     6 Width 3ft   6005658.05131 2104209.2390900003 37.7580777456208 -122.42345993152901 (37.7580777456208, -122.423459931529)
134735 221425 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 900x Guerrero St 3 Median : Cutout 11 Tree 1 DPW 2     6 Width 3ft   6005689.68683 2103597.2936 37.7563992716189 -122.42330702161301 (37.7563992716189, -122.423307021613)
133864 221441 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 100x Guerrero St 14 Median : Cutout 11 Tree 1 DPW 2     1 Width 3ft   6005450.56053 2107974.49254 37.768404526663396 -122.424445338474 (37.7684045266634, -122.424445338474)
131374 221548 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 1000x Guerrero St 4 Median : Cutout 11 Tree 1 DPW 2     3 Width 3ft   6005727.072790001 2102965.9789400003 37.7546679382008 -122.42313285530899 (37.7546679382008, -122.423132855309)
130218 221537 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 1100x Guerrero St 4 Median : Cutout 11 Tree 1 DPW 2     6 Width 3ft   6005757.84067 2102377.3752200003 37.753053504939 -122.422984619142 (37.753053504939, -122.422984619142)
129563 221535 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 1100x Guerrero St 6 Median : Cutout 11 Tree 1 DPW 2     4 Width 3ft   6005763.23809 2102308.0919 37.7528635735186 -122.42296102995199 (37.7528635735186, -122.422961029952)
129415 43734 Permitted Site 1 Acacia stenophylla :: Shoestring Acacia 109 777 Lakeview Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/25/2000 12:00:00 AM     Permit Number 43371 5994281.26699369 2089905.22565848 37.7181537802459 -122.46176829730601 (37.7181537802459, -122.461768297306)
129058 110623 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 400X GUERRERO ST 6 Median : Cutout 11 Tree 1 DPW 2   04/29/2015 10:20:00 AM 3 3x3   6005439.0 2106552.0 37.7644980484366 -122.42438413571101 (37.7644980484366, -122.424384135711)
128795 91254 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 928x Guerrero St 1 Median : Cutout 11 Tree 1 DPW 2   11/20/2008 12:00:00 AM 3 3x100   6005681.9790819995 2103558.204453 37.7562915069181 -122.423330899086 (37.7562915069181, -122.423330899086)
128230 110620 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 400X GUERRERO ST 3 Median : Cutout 11 Tree 1 DPW 2   04/29/2015 10:30:00 AM 3 3x3   6005439.0 2106552.0 37.7644980484366 -122.42438413571101 (37.7644980484366, -122.424384135711)
126939 110768 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 300X GUERRERO ST 10 Median : Cutout 11 Tree 1 DPW 2   06/19/2015 10:21:00 AM 3 3x3   6005492.0 2106949.0 37.7655911088206 -122.424229059984 (37.7655911088206, -122.424229059984)
126273 109695 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 600x GUERRERO ST 3 Median : Cutout 11 Tree 1 DPW 2   02/21/2015 12:00:00 AM 3 3x3   6005435.8 2105392.6 37.7613144297161 -122.42431273662201 (37.7613144297161, -122.424312736622)
124792 110780 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 1000X GUERRERO ST 9 Median : Cutout 11 Tree 1 DPW 2   05/26/2015 02:30:00 PM 3 3x3   6005663.0 2103080.0 37.7549773975701 -122.423362541701 (37.7549773975701, -122.423362541701)
123889 109693 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 600x GUERRERO ST 1 Median : Cutout 11 Tree 1 DPW 2   02/21/2015 10:53:00 PM 3 3x3   6005435.8 2105392.6 37.7613144297161 -122.42431273662201 (37.7613144297161, -122.424312736622)
123263 91272 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 1136x Guerrero St 1 Median : Cutout 11 Tree 1 DPW 2   11/20/2009 12:00:00 AM 3     6005717.0 2102348.0 37.752970542737295 -122.423123766486 (37.7529705427373, -122.423123766486)
123253 91277 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 1170x Guerrero St 1 Median : Cutout 11 Tree 1 DPW 2   11/20/2008 12:00:00 AM 3     6005728.0 2102148.0 37.752422009696005 -122.42307151190799 (37.752422009696, -122.423071511908)
123181 91238 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 812x Guerrero St 1 Median : Cutout 11 Tree 1 DPW 2   11/20/2008 12:00:00 AM 3     6005612.0 2104238.0 37.7581541170225 -122.423621241698 (37.7581541170225, -122.423621241698)
122606 110762 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 300X GUERRERO ST 4 Median : Cutout 11 Tree 1 DPW 2   06/19/2015 10:45:00 AM 3 3x3   6005492.0 2106949.0 37.7655911088206 -122.424229059984 (37.7655911088206, -122.424229059984)
121602 110760 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 300X GUERRERO ST 2 Median : Cutout 11 Tree 1 DPW 2   06/19/2015 10:54:00 AM 3 3x3   6005492.0 2106949.0 37.7655911088206 -122.424229059984 (37.7655911088206, -122.424229059984)
121580 110782 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 1000X GUERRERO ST 11 Median : Cutout 11 Tree 1 DPW 2   05/26/2015 02:21:00 PM 3 3x3   6005663.0 2103080.0 37.7549773975701 -122.423362541701 (37.7549773975701, -122.423362541701)
120589 91286 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 1212x Guerrero St 6 Median : Cutout 11 Tree 1 DPW 2   11/20/2008 12:00:00 AM 3     6005738.0 2101906.0 37.7517580978369 -122.42301973133999 (37.7517580978369, -122.42301973134)
120306 110649 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 400X GUERRERO ST 12 Median : Cutout 11 Tree 1 DPW 2   04/28/2015 07:46:00 PM 3 3x3   6005439.0 2106552.0 37.7644980484366 -122.42438413571101 (37.7644980484366, -122.424384135711)
118657 115521 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 200x Guerrero St 12 Median : Cutout 11 Tree 1 DPW 2           6005415.2 2107753.5 37.767795737129205 -122.424551925681 (37.7677957371292, -122.424551925681)
118503 91256 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 940X Guerrero St 2 Median : Cutout 11 Tree 1 DPW 2   11/20/2008 12:00:00 AM 3 3x100   6005685.709261 2103490.611554 37.75610612308 -122.423313194032 (37.75610612308, -122.423313194032)
118317 109694 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 600x GUERRERO ST 2 Median : Cutout 11 Tree 1 DPW 2   02/21/2015 10:54:00 PM 3 3x3   6005435.8 2105392.6 37.7613144297161 -122.42431273662201 (37.7613144297161, -122.424312736622)
118209 115511 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 200x Guerrero St 2 Median : Cutout 11 Tree 1 DPW 2   02/09/2016 12:48:00 PM 3     6005415.2 2107753.5 37.767795737129205 -122.424551925681 (37.7677957371292, -122.424551925681)
117919 91293 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 812x Guerrero St 2 Median : Cutout 11 Tree 1 DPW 2   11/20/2001 12:00:00 AM 3     6005612.0 2104238.0 37.7581541170225 -122.423621241698 (37.7581541170225, -122.423621241698)
116936 110767 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 300X GUERRERO ST 9 Median : Cutout 11 Tree 1 DPW 2   06/19/2015 10:25:00 AM 3 3x3   6005492.0 2106949.0 37.7655911088206 -122.424229059984 (37.7655911088206, -122.424229059984)
116885 96193 Undocumented 2 Acacia stenophylla :: Shoestring Acacia 109 1640 Jerrold Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 4x50   6015077.4 2097255.4 37.7395111076977 -122.39039765239299 (37.7395111076977, -122.390397652393)
116707 91266 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 1100X Guerrero St 2 Median : Cutout 11 Tree 1 DPW 2   06/21/2016 01:48:00 PM 3 3x500   6005744.445578 2102548.346221 37.753522195893105 -122.423043093148 (37.7535221958931, -122.423043093148)
116212 91274 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 1144x Guerrero St 1 Median : Cutout 11 Tree 1 DPW 2   11/20/2009 12:00:00 AM 3     6005719.0 2102300.0 37.7528388586979 -122.423113438558 (37.7528388586979, -122.423113438558)
115942 221483 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 500x Guerrero St 3 Median : Cutout 11 Tree 1 DPW 2     1 Width 3ft   6005560.35948 2105916.5024900003 37.7627599750213 -122.42391919281201 (37.7627599750213, -122.423919192812)
114885 110772 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 1000X GUERRERO ST 1 Median : Cutout 11 Tree 1 DPW 2   05/26/2015 03:10:00 PM 3 3x3   6005663.0 2103080.0 37.7549773975701 -122.423362541701 (37.7549773975701, -122.423362541701)
113634 91283 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 1212x Guerrero St 3 Median : Cutout 11 Tree 1 DPW 2   11/20/2008 12:00:00 AM 3     6005738.0 2101906.0 37.7517580978369 -122.42301973133999 (37.7517580978369, -122.42301973134)

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 88.088ms · Data source: data.sfgov.org