Street_Tree_List

Data source: data.sfgov.org

6,952 rows where qSpecies = 26 sorted by TreeID

View and edit SQL

Link rowid TreeID ▼ qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
120727 1606 Permitted Site 1 Pittosporum undulatum :: Victorian Box 26 732 Arguello Blvd 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 3X3   5995692.60539 2111112.91664 37.776465947954605 -122.45842420010901 (37.7764659479546, -122.458424200109)
88305 1607 DPW Maintained 3 Pittosporum undulatum :: Victorian Box 26 739 Arguello Blvd 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     36 3X3   5995626.86967 2111199.68058 37.7767004009287 -122.45865787974701 (37.7767004009287, -122.458657879747)
81192 1608 DPW Maintained 3 Pittosporum undulatum :: Victorian Box 26 738 Arguello Blvd 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     90 3X3   5995691.98224 2111083.1431 37.776384161860705 -122.45842420010099 (37.7763841618607, -122.458424200101)
92768 1610 DPW Maintained 3 Pittosporum undulatum :: Victorian Box 26 746 Arguello Blvd 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     30 3X3   5995694.62749 2111061.0380599997 37.7763236192695 -122.458413449074 (37.7763236192695, -122.458413449074)
112406 1611 Permitted Site 1 Pittosporum undulatum :: Victorian Box 26 749 Arguello Blvd 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     30 3X3   5995627.18047 2111130.441 37.776510305194705 -122.458651790964 (37.7765103051947, -122.458651790964)
110698 1612 DPW Maintained 3 Pittosporum undulatum :: Victorian Box 26 751 Arguello Blvd 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     40 3X3   5995630.882119999 2111097.0616099997 37.776418866952895 -122.458636569002 (37.7764188669529, -122.458636569002)
79715 1613 Permitted Site 1 Pittosporum undulatum :: Victorian Box 26 756 Arguello Blvd 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     28 3X3   5995698.02227 2110963.24944 37.7760553126026 -122.458394625749 (37.7760553126026, -122.458394625749)
141688 1614 Permitted Site 1 Pittosporum undulatum :: Victorian Box 26 757 Arguello Blvd 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     100 3X3   5995631.63313 2111076.8894 37.7763635225537 -122.458632510412 (37.7763635225537, -122.458632510412)
83664 1616 Permitted Site 1 Pittosporum undulatum :: Victorian Box 26 760 Arguello Blvd 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     14 3x3   5995699.215919999 2110924.34545 37.775948561099796 -122.45838767998899 (37.7759485610998, -122.458387679989)
122119 1618 Permitted Site 1 Pittosporum undulatum :: Victorian Box 26 768 Arguello Blvd 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     80 3X3   5995702.01701 2110876.96533 37.7758186287493 -122.458374560075 (37.7758186287493, -122.458374560075)
106480 1619 DPW Maintained 3 Pittosporum undulatum :: Victorian Box 26 774 Arguello Blvd 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     13 3X3   5995706.93678 2110845.53687 37.7757326172 -122.458355266086 (37.7757326172, -122.458355266086)
99017 1621 Permitted Site 1 Pittosporum undulatum :: Victorian Box 26 782 Arguello Blvd 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     30 3X3   5995704.2792 2110825.1531700003 37.7756764962121 -122.458362983512 (37.7756764962121, -122.458362983512)
80189 1623 DPW Maintained 3 Pittosporum undulatum :: Victorian Box 26 785 Arguello Blvd 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   02/05/2010 12:00:00 AM 3 4X4   5995638.674930001 2110894.74876 37.7758638171345 -122.458594962646 (37.7758638171345, -122.458594962646)
80368 1624 DPW Maintained 3 Pittosporum undulatum :: Victorian Box 26 788 Arguello Blvd 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     80 3X3   5995705.440230001 2110774.03064 37.775536193933895 -122.45835526607401 (37.7755361939339, -122.458355266074)
102601 1625 Permitted Site 1 Pittosporum undulatum :: Victorian Box 26 792 Arguello Blvd 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     70 3X3   5995706.99619 2110731.11956 37.7754184608254 -122.458346777008 (37.7754184608254, -122.458346777008)
109398 1626 Permitted Site 1 Pittosporum undulatum :: Victorian Box 26 794 Arguello Blvd 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     80 3X3   5995693.5307 2110708.35802 37.7753551898249 -122.45839170908998 (37.7753551898249, -122.45839170909)
18396 1627 DPW Maintained 3 Pittosporum undulatum :: Victorian Box 26 793 Arguello Blvd 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     70 3X3   5995638.85175 2110861.15065 37.7757715757475 -122.45859191824499 (37.7757715757475, -122.458591918245)
81618 1633 DPW Maintained 3 Pittosporum undulatum :: Victorian Box 26 808 Arguello Blvd 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   01/01/2008 12:00:00 AM 24 6X4   5995777.23426 2110607.05338 37.7750818437409 -122.45809482761001 (37.7750818437409, -122.45809482761)
140497 1636 Permitted Site 1 Pittosporum undulatum :: Victorian Box 26 827 Arguello Blvd 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     90 3x3   5995647.41415 2110653.56158 37.7752020829683 -122.458547268394 (37.7752020829683, -122.458547268394)
111066 1638 Permitted Site 1 Pittosporum undulatum :: Victorian Box 26 860 Arguello Blvd 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/26/1990 12:00:00 AM 11 3X3   5995717.36393 2110448.30424 37.774642520163205 -122.458290438244 (37.7746425201632, -122.458290438244)
114569 1639 Permitted Site 1 Pittosporum undulatum :: Victorian Box 26 838 Arguello Blvd 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     20 3X3   5995715.868009999 2110462.11021 37.774680341765 -122.458296612378 (37.774680341765, -122.458296612378)
128880 1643 Permitted Site 1 Pittosporum undulatum :: Victorian Box 26 860 Arguello Blvd 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   05/28/1997 12:00:00 AM 10 3X3   5995718.506630001 2110417.62102 37.7745583377727 -122.458284264147 (37.7745583377727, -122.458284264147)
95278 1644 Permitted Site 1 Pittosporum undulatum :: Victorian Box 26 831 Arguello Blvd 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 3X3   5995646.63214 2110630.20777 37.7751379146141 -122.458548282598 (37.7751379146141, -122.458548282598)
101660 1646 DPW Maintained 3 Pittosporum undulatum :: Victorian Box 26 899X Arguello Blvd 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     45 3X3   5995653.77717 2110396.9390000002 37.7744978305971 -122.458506677113 (37.7744978305971, -122.458506677113)
77821 1655 DPW Maintained 3 Pittosporum undulatum :: Victorian Box 26 355 Austin St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     6 3X3   6005609.818814 2115320.2855131 37.788583273262894 -122.42441703310699 (37.7885832732629, -122.424417033107)
100406 1656 DPW Maintained 3 Pittosporum undulatum :: Victorian Box 26 355 Austin St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     3 3X3   6005609.818814 2115320.2855131 37.788583273262894 -122.42441703310699 (37.7885832732629, -122.424417033107)
22725 1657 DPW Maintained 3 Pittosporum undulatum :: Victorian Box 26 351 Austin St 3 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     18 3X3PL   6005573.8449099995 2115325.6834 37.7885960630159 -122.424541881616 (37.7885960630159, -122.424541881616)
6453 1900 DPW Maintained 3 Pittosporum undulatum :: Victorian Box 26 20 Beideman St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   02/02/1990 12:00:00 AM 6 3X3   6001556.2481 2112999.4048 37.7819809912612 -122.438275412787 (37.7819809912612, -122.438275412787)
8522 1901 DPW Maintained 3 Pittosporum undulatum :: Victorian Box 26 20 Beideman St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   02/02/1990 12:00:00 AM 12 3X3   6001549.818 2113046.7838 37.782110716220295 -122.438301053255 (37.7821107162203, -122.438301053255)
127528 1902 DPW Maintained 3 Pittosporum undulatum :: Victorian Box 26 21X Beideman St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 3X3   6001519.8571031 2112941.0286629 37.781818635385605 -122.438397125073 (37.7818186353856, -122.438397125073)
117360 1903 DPW Maintained 3 Pittosporum undulatum :: Victorian Box 26 21X Beideman St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 3X3   6001519.8571031 2112941.0286629 37.781818635385605 -122.438397125073 (37.7818186353856, -122.438397125073)
98481 1904 DPW Maintained 3 Pittosporum undulatum :: Victorian Box 26 21X Beideman St 3 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 3X3   6001519.8571031 2112941.0286629 37.781818635385605 -122.438397125073 (37.7818186353856, -122.438397125073)
92832 1905 DPW Maintained 3 Pittosporum undulatum :: Victorian Box 26 21X Beideman St 4 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 3X3   6001519.8571031 2112941.0286629 37.781818635385605 -122.438397125073 (37.7818186353856, -122.438397125073)
7867 2211 Permitted Site 1 Pittosporum undulatum :: Victorian Box 26 1151 Broderick St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 3X3   6000821.1113 2112668.1744 37.781029677969606 -122.440794874823 (37.7810296779696, -122.440794874823)
6523 2219 Permitted Site 1 Pittosporum undulatum :: Victorian Box 26 1200X Broderick St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   05/27/1992 12:00:00 AM 3 4X4   6000837.1863 2112865.3051 37.7815718639656 -122.4407534082 (37.7815718639656, -122.4407534082)
7055 2223 Permitted Site 1 Pittosporum undulatum :: Victorian Box 26 1200X Broderick St 6 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   05/03/2002 12:00:00 AM 3 4X4   6000822.9726 2112969.5391 37.7818572544059 -122.440810060021 (37.7818572544059, -122.440810060021)
80714 2243 DPW Maintained 3 Pittosporum undulatum :: Victorian Box 26 11X Brompton Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   02/28/2008 12:00:00 AM 3 3X3   6002237.57574 2095673.3518700001 37.7344465557347 -122.43467901926701 (37.7344465557347, -122.434679019267)
114959 2245 DPW Maintained 3 Pittosporum undulatum :: Victorian Box 26 11X Brompton Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   06/08/1992 12:00:00 AM 6 3X3   6002237.57574 2095673.3518700001 37.7344465557347 -122.43467901926701 (37.7344465557347, -122.434679019267)
20580 2249 Permitted Site 1 Pittosporum undulatum :: Victorian Box 26 25 Brompton Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   02/21/2008 12:00:00 AM 3 3X3   6002175.63898 2095478.7215900002 37.7339086292652 -122.434879240483 (37.7339086292652, -122.434879240483)
113885 2250 DPW Maintained 3 Pittosporum undulatum :: Victorian Box 26 40 Brompton Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 3X3   6002146.24268 2095519.2153200002 37.7340181466679 -122.434983767345 (37.7340181466679, -122.434983767345)
90623 2251 DPW Maintained 3 Pittosporum undulatum :: Victorian Box 26 40 Brompton Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   06/04/1992 12:00:00 AM 8 3X3   6002140.73385 2095502.48934 37.7339719081741 -122.435001617226 (37.7339719081741, -122.435001617226)
101526 2252 DPW Maintained 3 Pittosporum undulatum :: Victorian Box 26 40 Brompton Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   06/04/1992 12:00:00 AM 6 3X3   6002134.79813 2095490.83672 37.733939575719496 -122.43502130569401 (37.7339395757195, -122.435021305694)
124208 2253 DPW Maintained 3 Pittosporum undulatum :: Victorian Box 26 40 Brompton Ave 4 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   09/26/1990 12:00:00 AM 6 3X3   6002131.11056 2095479.1240299998 37.7339072059768 -122.435033217323 (37.7339072059768, -122.435033217323)
89680 2456 DPW Maintained 3 Pittosporum undulatum :: Victorian Box 26 1801X Buchanan St 4 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     6 4X4   6003961.1396892 2114603.1916159 37.786521075947796 -122.430070036959 (37.7865210759478, -122.430070036959)
8786 2471 DPW Maintained 3 Pittosporum undulatum :: Victorian Box 26 1875 Buchanan St 3 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     10 5x5   6003929.8406 2114824.6112 37.7871272656763 -122.43019412622101 (37.7871272656763, -122.430194126221)
126770 2473 DPW Maintained 3 Pittosporum undulatum :: Victorian Box 26 2025X Bush St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 4X4   6003861.53141 2114902.08942 37.7873361321191 -122.430435991156 (37.7873361321191, -122.430435991156)
91301 2474 DPW Maintained 3 Pittosporum undulatum :: Victorian Box 26 2025X Bush St 3 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     14 4X4   6003880.06922 2114905.54658 37.787346674688294 -122.430372100987 (37.7873466746883, -122.430372100987)
14090 2537 DPW Maintained 3 Pittosporum undulatum :: Victorian Box 26 1575 Burke Ave 5 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   08/03/2016 12:00:00 AM 6 3X3   6016279.43485 2099056.14622 37.7445221951468 -122.386367018739 (37.7445221951468, -122.386367018739)
15707 2538 Permitted Site 1 Pittosporum undulatum :: Victorian Box 26 1575 Burke Ave 6 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   03/01/2000 12:00:00 AM 3 3X3   6016293.38997 2099044.81151 37.7444918448175 -122.38631797421301 (37.7444918448175, -122.386317974213)
104592 2562 Permitted Site 1 Pittosporum undulatum :: Victorian Box 26 1540 Bush St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   05/12/1992 12:00:00 AM 3 4X4 Permit Number 769088 6006089.41636 2115263.27302 37.7884538021286 -122.422753642534 (37.7884538021286, -122.422753642534)
22470 2563 Permitted Site 1 Pittosporum undulatum :: Victorian Box 26 1558 Bush St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 4X4   6006017.3895 2115255.79017 37.788429192002 -122.42300231241998 (37.788429192002, -122.42300231242)
22385 2564 Permitted Site 1 Pittosporum undulatum :: Victorian Box 26 1564 Bush St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 4X4   6005982.01908 2115249.41521 37.7884096919951 -122.42312423531999 (37.7884096919951, -122.42312423532)
22755 2565 Permitted Site 1 Pittosporum undulatum :: Victorian Box 26 1572 Bush St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     10 4X4   6005955.089790001 2115245.5126099996 37.7883974567225 -122.423217128975 (37.7883974567225, -122.423217128975)
94329 2566 DPW Maintained 3 Pittosporum undulatum :: Victorian Box 26 1600 Bush St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     11 4X4   6005796.28674 2115223.5609999998 37.7883282198218 -122.423765001328 (37.7883282198218, -122.423765001328)
99683 2567 Permitted Site 1 Pittosporum undulatum :: Victorian Box 26 1610 Bush St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 4X4   6005768.3880199995 2115219.3667599997 37.7883151285459 -122.423861228102 (37.7883151285459, -122.423861228102)
22472 2568 DPW Maintained 3 Pittosporum undulatum :: Victorian Box 26 1616 Bush St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 4X4   6005744.2022 2115214.96701 37.7883016825273 -122.423944594184 (37.7883016825273, -122.423944594184)
22800 2569 DPW Maintained 3 Pittosporum undulatum :: Victorian Box 26 1616 Bush St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     10 4X4   6005720.9755 2115211.8957700003 37.788291938357794 -122.42402473634701 (37.7882919383578, -122.424024736347)
22802 2570 DPW Maintained 3 Pittosporum undulatum :: Victorian Box 26 1635 Bush St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 4X4   6005649.96237 2115147.50764 37.7881111350574 -122.42426584911301 (37.7881111350574, -122.424265849113)
22798 2571 DPW Maintained 3 Pittosporum undulatum :: Victorian Box 26 1635 Bush St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   11/17/2003 12:00:00 AM 3 4X4   6005663.66572 2115149.59161 37.7881176308733 -122.424218586115 (37.7881176308733, -122.424218586115)
22509 2572 Permitted Site 1 Pittosporum undulatum :: Victorian Box 26 1660 Bush St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 4x4   6005547.67277 2115189.23885 37.7882199422297 -122.42462272348301 (37.7882199422297, -122.424622723483)
22767 2573 Permitted Site 1 Pittosporum undulatum :: Victorian Box 26 1660 Bush St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 4x4   6005558.391419999 2115190.59546 37.788224272479894 -122.424585735258 (37.7882242724799, -122.424585735258)
10136 2574 DPW Maintained 3 Pittosporum undulatum :: Victorian Box 26 1660 Bush St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   01/31/2017 10:41:00 AM 3 4x4   6005557.1199 2115192.90397 37.7882305392646 -122.42459029878599 (37.7882305392646, -122.424590298786)
22669 2575 Permitted Site 1 Pittosporum undulatum :: Victorian Box 26 1663 Bush St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 4X4   6005551.117769999 2115135.3456 37.788072159349 -122.424606969163 (37.788072159349, -122.424606969163)
22513 2577 Permitted Site 1 Pittosporum undulatum :: Victorian Box 26 1668 Bush St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 4X4   6005525.41084 2115184.9649 37.7882069497456 -122.424699441931 (37.7882069497456, -122.424699441931)
22601 2578 Permitted Site 1 Pittosporum undulatum :: Victorian Box 26 1668 Bush St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 4X4   6005504.17531 2115182.44441 37.7881988297468 -122.42477273397101 (37.7881988297468, -122.424772733971)
23360 2579 DPW Maintained 3 Pittosporum undulatum :: Victorian Box 26 1668 Bush St 3 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     9 4X4   6005479.75685 2115179.20105 37.7881885451021 -122.424856986956 (37.7881885451021, -122.424856986956)
22485 2582 Permitted Site 1 Pittosporum undulatum :: Victorian Box 26 1677 Bush St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 4X4   6005478.254430001 2115125.40956 37.788040762217605 -122.42485835663601 (37.7880407622176, -122.424858356636)
22526 2583 Permitted Site 1 Pittosporum undulatum :: Victorian Box 26 1677 Bush St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 4X4   6005501.6468 2115126.90011 37.788046176130294 -122.424777529168 (37.7880461761303, -122.424777529168)
110688 2584 DPW Maintained 3 Pittosporum undulatum :: Victorian Box 26 1700 Bush St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     9 3x3   6005279.70082 2115165.61382 37.7881399362565 -122.425548180053 (37.7881399362565, -122.425548180053)
82191 2585 Permitted Site 1 Pittosporum undulatum :: Victorian Box 26 1700 Bush St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 3x3   6005279.70082 2115165.61382 37.7881399362565 -122.425548180053 (37.7881399362565, -122.425548180053)
81501 2586 Permitted Site 1 Pittosporum undulatum :: Victorian Box 26 1700 Bush St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 3x3   6005279.70082 2115165.61382 37.7881399362565 -122.425548180053 (37.7881399362565, -122.425548180053)
106997 2591 Permitted Site 1 Pittosporum undulatum :: Victorian Box 26 1712 Bush St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   03/16/2013 12:00:00 AM 3 2x2   6005174.701219999 2115137.24934 37.788056121148706 -122.425909441022 (37.7880561211487, -122.425909441022)
86830 2592 DPW Maintained 3 Pittosporum undulatum :: Victorian Box 26 1717 Bush St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     10 4x4   6005272.315669999 2115067.9020700003 37.7878712268979 -122.425566774536 (37.7878712268979, -122.425566774536)
146107 2593 DPW Maintained 3 Pittosporum undulatum :: Victorian Box 26 1717 Bush St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     8 4x4   6005272.315669999 2115067.9020700003 37.7878712268979 -122.425566774536 (37.7878712268979, -122.425566774536)
97564 2594 DPW Maintained 3 Pittosporum undulatum :: Victorian Box 26 1717 Bush St 3 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     7 4x4   6005272.315669999 2115067.9020700003 37.7878712268979 -122.425566774536 (37.7878712268979, -122.425566774536)
114502 2595 Permitted Site 1 Pittosporum undulatum :: Victorian Box 26 1717 Bush St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 4x4   6005272.315669999 2115067.9020700003 37.7878712268979 -122.425566774536 (37.7878712268979, -122.425566774536)
121925 2596 Permitted Site 1 Pittosporum undulatum :: Victorian Box 26 1717 Bush St 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 4x4   6005272.315669999 2115067.9020700003 37.7878712268979 -122.425566774536 (37.7878712268979, -122.425566774536)
122601 2597 DPW Maintained 3 Pittosporum undulatum :: Victorian Box 26 1701 Bush St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     10 4x4   6005274.0 2115079.0 37.7879017942142 -122.425561737206 (37.7879017942142, -122.425561737206)
386 2602 Permitted Site 1 Pittosporum undulatum :: Victorian Box 26 1760 Bush St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 3X3   6005112.3923 2115130.7833 37.7880348455319 -122.42612455857201 (37.7880348455319, -122.426124558572)
6692 2603 DPW Maintained 3 Pittosporum undulatum :: Victorian Box 26 1760 Bush St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     6 3X3   6005091.5069 2115126.1421 37.788020921497605 -122.42619648785801 (37.7880209214976, -122.426196487858)
5674 2605 DPW Maintained 3 Pittosporum undulatum :: Victorian Box 26 1760 Bush St 4 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   07/04/2011 12:00:00 AM 3 3x3   6005035.0389 2115121.5009 37.788004986085895 -122.42639152665001 (37.7880049860859, -122.42639152665)
5359 2607 DPW Maintained 3 Pittosporum undulatum :: Victorian Box 26 1760 Bush St 6 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   05/12/1992 12:00:00 AM 6 3X3   6004969.2886 2115108.3508 37.787965162278205 -122.426618074327 (37.7879651622782, -122.426618074327)
112207 2610 Permitted Site 1 Pittosporum undulatum :: Victorian Box 26 1801 Bush St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 4X4   6004783.021369999 2115010.63808 37.787686335398796 -122.427255562633 (37.7876863353988, -122.427255562633)
86192 2611 Permitted Site 1 Pittosporum undulatum :: Victorian Box 26 1801 Bush St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 4X4   6004783.021369999 2115010.63808 37.787686335398796 -122.427255562633 (37.7876863353988, -122.427255562633)
110735 2612 Permitted Site 1 Pittosporum undulatum :: Victorian Box 26 1801 Bush St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 4X4   6004783.021369999 2115010.63808 37.787686335398796 -122.427255562633 (37.7876863353988, -122.427255562633)
112362 2613 Permitted Site 1 Pittosporum undulatum :: Victorian Box 26 1801 Bush St 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 4X4   6004783.021369999 2115010.63808 37.787686335398796 -122.427255562633 (37.7876863353988, -122.427255562633)
80780 2620 DPW Maintained 3 Pittosporum undulatum :: Victorian Box 26 1802 Bush St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     6 4X4   6004870.33588 2115093.89579 37.787919877729394 -122.426959403176 (37.7879198777294, -122.426959403176)
5584 2623 DPW Maintained 3 Pittosporum undulatum :: Victorian Box 26 1810 Bush St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   12/03/1997 12:00:00 AM 9 3X3   6004694.7357 2115072.9947 37.787852557835706 -122.42756545836599 (37.7878525578357, -122.427565458366)
9519 2634 DPW Maintained 3 Pittosporum undulatum :: Victorian Box 26 1899 Steiner St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   01/30/2003 12:00:00 AM 3 3X3   6002489.7887 2114689.0422 37.7866733591964 -122.435166683453 (37.7866733591964, -122.435166683453)
9387 2635 Permitted Site 1 Pittosporum undulatum :: Victorian Box 26 1902 Bush St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     10 3X3   6004361.9252 2115026.7925 37.787706868157 -122.428713626267 (37.787706868157, -122.428713626267)
9317 2636 Permitted Site 1 Pittosporum undulatum :: Victorian Box 26 1902 Bush St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     10 3X3   6004333.4898 2115020.9919 37.787689331805396 -122.42881159361099 (37.7876893318054, -122.428811593611)
9071 2637 Permitted Site 1 Pittosporum undulatum :: Victorian Box 26 1902 Bush St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     11 3X3   6004310.9716 2115017.5275 37.7876785449104 -122.428889255161 (37.7876785449104, -122.428889255161)
6458 2638 Permitted Site 1 Pittosporum undulatum :: Victorian Box 26 1902 Bush St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     10 3X3   6004294.2274 2115016.9501 37.787676011765 -122.428947145676 (37.787676011765, -122.428947145676)
6237 2645 Permitted Site 1 Pittosporum undulatum :: Victorian Box 26 1922 Bush St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 3X3   6004273.4414 2115014.6406 37.7876684938964 -122.42901889648998 (37.7876684938964, -122.42901889649)
7552 2646 Permitted Site 1 Pittosporum undulatum :: Victorian Box 26 1936 Bush St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 3X3   6004216.8574 2115005.9798 37.787641510438704 -122.42921404836001 (37.7876415104387, -122.42921404836)
5620 2650 Permitted Site 1 Pittosporum undulatum :: Victorian Box 26 1950 Bush St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 3X3   6004171.8211 2114999.0511 37.7876199363476 -122.429369370882 (37.7876199363476, -122.429369370882)
8673 2652 Permitted Site 1 Pittosporum undulatum :: Victorian Box 26 1960 Bush St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 3X3   6004122.1657 2114993.8546 37.7876028567046 -122.42954079807 (37.7876028567046, -122.42954079807)
6956 2655 Permitted Site 1 Pittosporum undulatum :: Victorian Box 26 1998 Bush St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 3X3   6003984.7473 2114974.2234 37.78754117279421 -122.43001483766001 (37.7875411727942, -122.43001483766)
120596 2656 Permitted Site 1 Pittosporum undulatum :: Victorian Box 26 1999X Bush St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     10 4X4   6003957.3836 2114915.8399 37.787379316671 -122.43010534402 (37.787379316671, -122.43010534402)
89689 2657 Permitted Site 1 Pittosporum undulatum :: Victorian Box 26 1999X Bush St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     10 4X4   6003957.3836 2114915.8399 37.787379316671 -122.43010534402 (37.787379316671, -122.43010534402)

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