Street_Tree_List

Data source: data.sfgov.org

970 rows where qSpecies = 75 sorted by TreeID

View and edit SQL

Suggested facets: qLegalStatus, qSiteInfo, PlantType, qCaretaker, DBH

Link rowid TreeID ▼ qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
115728 474 DPW Maintained 3 Washingtonia robusta :: Mexican Fan Palm 75 2790 Harrison St 4 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   09/23/1992 12:00:00 AM 12 3x3   6008872.67231 2102220.8769099996 37.752799067118396 -122.412201825987 (37.7527990671184, -122.412201825987)
93041 619 DPW Maintained 3 Washingtonia robusta :: Mexican Fan Palm 75 3146 24th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   09/23/1992 12:00:00 AM 18 3x3   6008066.00463 2102184.1145200003 37.752652829489705 -122.414988836945 (37.7526528294897, -122.414988836945)
98043 637 Permitted Site 1 Washingtonia robusta :: Mexican Fan Palm 75 3205 24TH ST 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/01/1991 12:00:00 AM 18 3X3   6007653.0 2102067.0 37.7523080428222 -122.41640878881701 (37.7523080428222, -122.416408788817)
115639 666 DPW Maintained 3 Washingtonia robusta :: Mexican Fan Palm 75 3297X 24th St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   09/10/1992 12:00:00 AM 18 4x4   6007079.62061 2102029.84762 37.752173770171794 -122.418388996947 (37.7521737701718, -122.418388996947)
105855 667 DPW Maintained 3 Washingtonia robusta :: Mexican Fan Palm 75 3297X 24th St 3 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   09/10/1992 12:00:00 AM 18 4x4   6007079.62061 2102029.84762 37.752173770171794 -122.418388996947 (37.7521737701718, -122.418388996947)
84411 678 DPW Maintained 3 Washingtonia robusta :: Mexican Fan Palm 75 3323X 24th St 4 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     18 4X4   6006894.8894879995 2102019.509041 37.7521349819704 -122.41902709370001 (37.7521349819704, -122.4190270937)
99556 679 DPW Maintained 3 Washingtonia robusta :: Mexican Fan Palm 75 3323X 24th St 5 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     18 4X4   6006894.8894879995 2102019.509041 37.7521349819704 -122.41902709370001 (37.7521349819704, -122.4190270937)
97785 1774 DPW Maintained 3 Washingtonia robusta :: Mexican Fan Palm 75 2000X Bay Shore Blvd 1 Median : Cutout 11 Tree 1 DPW 2     12 6   6012375.8565272 2088505.2474916999 37.7153347551878 -122.399124435859 (37.7153347551878, -122.399124435859)
122506 1775 DPW Maintained 3 Washingtonia robusta :: Mexican Fan Palm 75 2000X Bay Shore Blvd 2 Median : Cutout 11 Tree 1 DPW 2     12 6   6012375.8565272 2088505.2474916999 37.7153347551878 -122.399124435859 (37.7153347551878, -122.399124435859)
91674 1776 DPW Maintained 3 Washingtonia robusta :: Mexican Fan Palm 75 2000X Bay Shore Blvd 3 Median : Cutout 11 Tree 1 DPW 2     12 6   6012375.8565272 2088505.2474916999 37.7153347551878 -122.399124435859 (37.7153347551878, -122.399124435859)
98783 1777 DPW Maintained 3 Washingtonia robusta :: Mexican Fan Palm 75 2000X Bay Shore Blvd 4 Median : Cutout 11 Tree 1 DPW 2     12 6   6012375.8565272 2088505.2474916999 37.7153347551878 -122.399124435859 (37.7153347551878, -122.399124435859)
11630 1793 DPW Maintained 3 Washingtonia robusta :: Mexican Fan Palm 75 2000 Bay Shore Blvd 1 Median : Cutout 11 Tree 1 DPW 2     12 6   6012296.32723 2088174.84774 37.7144231111167 -122.399376144697 (37.7144231111167, -122.399376144697)
13232 1794 DPW Maintained 3 Washingtonia robusta :: Mexican Fan Palm 75 2000 Bay Shore Blvd 2 Median : Cutout 11 Tree 1 DPW 2     12 6   6012280.2141 2088145.3083400002 37.7143411037303 -122.399429765893 (37.7143411037303, -122.399429765893)
11710 1795 DPW Maintained 3 Washingtonia robusta :: Mexican Fan Palm 75 2000 Bay Shore Blvd 3 Median : Cutout 11 Tree 1 DPW 2     12 6   6012264.68095 2088118.8470599998 37.714267580549105 -122.399481598293 (37.7142675805491, -122.399481598293)
11170 1796 DPW Maintained 3 Washingtonia robusta :: Mexican Fan Palm 75 2000 Bay Shore Blvd 4 Median : Cutout 11 Tree 1 DPW 2     12 6   6012245.53967 2088092.97358 37.714195470207 -122.39954594300899 (37.714195470207, -122.399545943009)
112272 1797 DPW Maintained 3 Washingtonia robusta :: Mexican Fan Palm 75 2010 Bay Shore Blvd 5 Median : Cutout 11 Tree 1 DPW 2   12/27/1991 12:00:00 AM 12     6012333.445831 2088436.5537268997 37.7151437722719 -122.399266207491 (37.7151437722719, -122.399266207491)
10723 1798 DPW Maintained 3 Washingtonia robusta :: Mexican Fan Palm 75 2000 Bay Shore Blvd 6 Median : Cutout 11 Tree 1 DPW 2   12/27/1991 12:00:00 AM 12 6   6012206.26499 2088043.30695 37.714056906280604 -122.39967820720899 (37.7140569062806, -122.399678207209)
139686 1799 DPW Maintained 3 Washingtonia robusta :: Mexican Fan Palm 75 2020 Bay Shore Blvd 1 Median : Cutout 11 Tree 1 DPW 2     12 6   6012311.362568799 2088370.0571878997 37.7149599552833 -122.399337871901 (37.7149599552833, -122.399337871901)
101386 1800 DPW Maintained 3 Washingtonia robusta :: Mexican Fan Palm 75 2020 Bay Shore Blvd 2 Median : Cutout 11 Tree 1 DPW 2   12/27/1991 12:00:00 AM 12 6   6012311.362568799 2088370.0571878997 37.7149599552833 -122.399337871901 (37.7149599552833, -122.399337871901)
81891 1801 DPW Maintained 3 Washingtonia robusta :: Mexican Fan Palm 75 2020 Bay Shore Blvd 3 Median : Cutout 11 Tree 1 DPW 2   12/27/1991 12:00:00 AM 12 6   6012311.362568799 2088370.0571878997 37.7149599552833 -122.399337871901 (37.7149599552833, -122.399337871901)
141476 1802 DPW Maintained 3 Washingtonia robusta :: Mexican Fan Palm 75 2020 Bay Shore Blvd 4 Median : Cutout 11 Tree 1 DPW 2   03/11/2007 12:00:00 AM 12 6   6012311.362568799 2088370.0571878997 37.7149599552833 -122.399337871901 (37.7149599552833, -122.399337871901)
144221 1803 DPW Maintained 3 Washingtonia robusta :: Mexican Fan Palm 75 2020 Bay Shore Blvd 5 Median : Cutout 11 Tree 1 DPW 2   03/11/2007 12:00:00 AM 12 6   6012311.362568799 2088370.0571878997 37.7149599552833 -122.399337871901 (37.7149599552833, -122.399337871901)
23356 1808 DPW Maintained 3 Washingtonia robusta :: Mexican Fan Palm 75 2000 Bay Shore Blvd 5 Median : Cutout 11 Tree 1 DPW 2     15 6   6012226.450619999 2088069.6740700002 37.7141304303483 -122.39961028768299 (37.7141304303483, -122.399610287683)
111393 1809 DPW Maintained 3 Washingtonia robusta :: Mexican Fan Palm 75 2040 Bay Shore Blvd 1 Median : Cutout 11 Tree 1 DPW 2     12 6   6012267.4866135 2088237.9390645002 37.7145947398058 -122.399480256716 (37.7145947398058, -122.399480256716)
97318 1810 DPW Maintained 3 Washingtonia robusta :: Mexican Fan Palm 75 2040 Bay Shore Blvd 2 Median : Cutout 11 Tree 1 DPW 2   12/27/1991 12:00:00 AM 12 6   6012267.4866135 2088237.9390645002 37.7145947398058 -122.399480256716 (37.7145947398058, -122.399480256716)
82072 1811 DPW Maintained 3 Washingtonia robusta :: Mexican Fan Palm 75 2040 Bay Shore Blvd 3 Median : Cutout 11 Tree 1 DPW 2     12 6   6012267.4866135 2088237.9390645002 37.7145947398058 -122.399480256716 (37.7145947398058, -122.399480256716)
11132 1820 DPW Maintained 3 Washingtonia robusta :: Mexican Fan Palm 75 2100 Bay Shore Blvd 1 Median : Cutout 11 Tree 1 DPW 2   12/30/1991 12:00:00 AM 3 6   6011846.03792 2087600.59079 37.7128212089973 -122.400892211026 (37.7128212089973, -122.400892211026)
11580 1821 DPW Maintained 3 Washingtonia robusta :: Mexican Fan Palm 75 2100 Bay Shore Blvd 2 Median : Cutout 11 Tree 1 DPW 2   12/30/1991 12:00:00 AM 6 6   6011817.461569999 2087571.87835 37.712740776339295 -122.400988964593 (37.7127407763393, -122.400988964593)
11934 1822 DPW Maintained 3 Washingtonia robusta :: Mexican Fan Palm 75 2100 Bay Shore Blvd 3 Median : Cutout 11 Tree 1 DPW 2     12 6   6011791.38112 2087549.257 37.7126772077525 -122.401077519005 (37.7126772077525, -122.401077519005)
12292 1840 DPW Maintained 3 Washingtonia robusta :: Mexican Fan Palm 75 2200 Bay Shore Blvd 1 Median : Cutout 11 Tree 1 DPW 2     12 6   6011305.78262 2087356.70002 37.7121213835762 -122.40274237725401 (37.7121213835762, -122.402742377254)
10446 1841 DPW Maintained 3 Washingtonia robusta :: Mexican Fan Palm 75 2200 Bay Shore Blvd 2 Median : Cutout 11 Tree 1 DPW 2     12 6   6011283.06964 2087344.7309400002 37.712087250691 -122.40282003911301 (37.712087250691, -122.402820039113)
12160 1842 DPW Maintained 3 Washingtonia robusta :: Mexican Fan Palm 75 2200 Bay Shore Blvd 3 Median : Cutout 11 Tree 1 DPW 2     6 6   6011254.373459999 2087325.01114 37.7120315017345 -122.402917835889 (37.7120315017345, -122.402917835889)
11567 1857 DPW Maintained 3 Washingtonia robusta :: Mexican Fan Palm 75 2500 Bay Shore Blvd 1 Median : Cutout 11 Tree 1 DPW 2     12 6   6010751.52595 2086559.13987 37.7099004816803 -122.404601950438 (37.7099004816803, -122.404601950438)
11400 1858 DPW Maintained 3 Washingtonia robusta :: Mexican Fan Palm 75 2500 Bay Shore Blvd 2 Median : Cutout 11 Tree 1 DPW 2     12 6   6010736.7682300005 2086529.19155 37.709817424799 -122.404650849269 (37.709817424799, -122.404650849269)
10337 1859 DPW Maintained 3 Washingtonia robusta :: Mexican Fan Palm 75 2500 Bay Shore Blvd 3 Median : Cutout 11 Tree 1 DPW 2     18 6   6010721.136519999 2086497.1887700001 37.7097286779125 -122.404702624138 (37.7097286779125, -122.404702624138)
10981 1860 DPW Maintained 3 Washingtonia robusta :: Mexican Fan Palm 75 2500 Bay Shore Blvd 4 Median : Cutout 11 Tree 1 DPW 2     6 6   6010703.231369999 2086455.7019 37.709613762523205 -122.404761589082 (37.7096137625232, -122.404761589082)
145369 6107 DPW Maintained 3 Washingtonia robusta :: Mexican Fan Palm 75 600X El Camino Del Mar 1 Median : Cutout 11 Tree 1 DPW 2     24 15-HOA   5986691.2678849995 2115146.1691739 37.787018710699 -122.48985866316099 (37.787018710699, -122.489858663161)
128687 6108 DPW Maintained 3 Washingtonia robusta :: Mexican Fan Palm 75 600X El Camino Del Mar 2 Median : Cutout 11 Tree 1 DPW 2     24 15-HOA   5986691.2678849995 2115146.1691739 37.787018710699 -122.48985866316099 (37.787018710699, -122.489858663161)
93045 6109 DPW Maintained 3 Washingtonia robusta :: Mexican Fan Palm 75 600X El Camino Del Mar 3 Median : Cutout 11 Tree 1 DPW 2     24 15-HOA   5986691.2678849995 2115146.1691739 37.787018710699 -122.48985866316099 (37.787018710699, -122.489858663161)
101360 6110 DPW Maintained 3 Washingtonia robusta :: Mexican Fan Palm 75 600X El Camino Del Mar 4 Median : Cutout 11 Tree 1 DPW 2     18 15-HOA   5986691.2678849995 2115146.1691739 37.787018710699 -122.48985866316099 (37.787018710699, -122.489858663161)
112905 6111 DPW Maintained 3 Washingtonia robusta :: Mexican Fan Palm 75 600X El Camino Del Mar 5 Median : Cutout 11 Tree 1 DPW 2     18 15-HOA   5986691.2678849995 2115146.1691739 37.787018710699 -122.48985866316099 (37.787018710699, -122.489858663161)
110321 6112 DPW Maintained 3 Washingtonia robusta :: Mexican Fan Palm 75 600X El Camino Del Mar 6 Median : Cutout 11 Tree 1 DPW 2     24 15-HOA   5986691.2678849995 2115146.1691739 37.787018710699 -122.48985866316099 (37.787018710699, -122.489858663161)
106348 6113 DPW Maintained 3 Washingtonia robusta :: Mexican Fan Palm 75 600X El Camino Del Mar 7 Median : Cutout 11 Tree 1 DPW 2     18 15-HOA   5986691.2678849995 2115146.1691739 37.787018710699 -122.48985866316099 (37.787018710699, -122.489858663161)
123108 6114 DPW Maintained 3 Washingtonia robusta :: Mexican Fan Palm 75 600X El Camino Del Mar 9 Median : Cutout 11 Tree 1 DPW 2     24 15-HOA   5986691.2678849995 2115146.1691739 37.787018710699 -122.48985866316099 (37.787018710699, -122.489858663161)
79235 6115 DPW Maintained 3 Washingtonia robusta :: Mexican Fan Palm 75 600X El Camino Del Mar 10 Median : Cutout 11 Tree 1 DPW 2     24 15-HOA   5986691.2678849995 2115146.1691739 37.787018710699 -122.48985866316099 (37.787018710699, -122.489858663161)
80227 6116 DPW Maintained 3 Washingtonia robusta :: Mexican Fan Palm 75 600X El Camino Del Mar 13 Median : Cutout 11 Tree 1 DPW 2     24 15-HOA   5986691.2678849995 2115146.1691739 37.787018710699 -122.48985866316099 (37.787018710699, -122.489858663161)
20931 15064 DPW Maintained 3 Washingtonia robusta :: Mexican Fan Palm 75 1X Minerva St 7 Median : Cutout 11 Tree 1 DPW 2     6 11   5995989.76979 2089004.05491 37.715777580947 -122.455797663726 (37.715777580947, -122.455797663726)
21404 15067 DPW Maintained 3 Washingtonia robusta :: Mexican Fan Palm 75 1 Minerva St 9 Median : Cutout 11 Tree 1 DPW 2     3 11   5996019.74584 2089003.9616 37.7157790450506 -122.455694046564 (37.7157790450506, -122.455694046564)
19986 15072 DPW Maintained 3 Washingtonia robusta :: Mexican Fan Palm 75 1X Minerva St 4 Median : Cutout 11 Tree 1 DPW 2     6 11   5995966.887709999 2089005.2550700002 37.71577956305239 -122.45587684097 (37.7157795630524, -122.45587684097)
19459 15076 DPW Maintained 3 Washingtonia robusta :: Mexican Fan Palm 75 1 Minerva St 2 Median : Cutout 11 Tree 1 DPW 2     6 11   5995952.59829 2089005.6317099999 37.7157797770894 -122.455926258705 (37.7157797770894, -122.455926258705)
17051 15346 Permitted Site 1 Washingtonia robusta :: Mexican Fan Palm 75 1900 Mission St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 4X4   6006752.3955 2107277.3553 37.766563781951106 -122.419892925221 (37.7665637819511, -122.419892925221)
20971 15348 DPW Maintained 3 Washingtonia robusta :: Mexican Fan Palm 75 1905X Mission St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 4X4   6006806.3918 2107279.3589 37.7665723252126 -122.41970630335199 (37.7665723252126, -122.419706303352)
20065 15349 Permitted Site 1 Washingtonia robusta :: Mexican Fan Palm 75 1906 Mission St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   08/16/1993 12:00:00 AM 12 4X4   6006754.9683 2107231.9019 37.7664391225711 -122.419880800641 (37.7664391225711, -122.419880800641)
19321 15351 DPW Maintained 3 Washingtonia robusta :: Mexican Fan Palm 75 1911 Mission St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 4X4   6006804.043 2107232.3827 37.766443207322105 -122.419711093977 (37.7664432073221, -122.419711093977)
21306 15355 DPW Maintained 3 Washingtonia robusta :: Mexican Fan Palm 75 1924 Mission St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 4X4   6006751.5378 2107181.3028 37.766299996101 -122.41988907525 (37.766299996101, -122.41988907525)
139015 15357 Permitted Site 1 Washingtonia robusta :: Mexican Fan Palm 75 1930 Mission St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 4X4   6006758.138809999 2107137.8138099997 37.7661809574571 -122.41986315730401 (37.7661809574571, -122.419863157304)
17363 15360 DPW Maintained 3 Washingtonia robusta :: Mexican Fan Palm 75 1939 Mission St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 4x4   6006819.3103 2107093.8027 37.7660635592898 -122.41964845362699 (37.7660635592898, -122.419648453627)
104508 15364 DPW Maintained 3 Washingtonia robusta :: Mexican Fan Palm 75 1950X Mission St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 4x4   6006764.6486243 2107014.2225799 37.7658419717714 -122.419831870418 (37.7658419717714, -122.419831870418)
143339 15367 DPW Maintained 3 Washingtonia robusta :: Mexican Fan Palm 75 1950X Mission St 6 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 4X4   6006764.6486243 2107014.2225799 37.7658419717714 -122.419831870418 (37.7658419717714, -122.419831870418)
99541 15369 DPW Maintained 3 Washingtonia robusta :: Mexican Fan Palm 75 1950X Mission St 8 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 4X4   6006764.6486243 2107014.2225799 37.7658419717714 -122.419831870418 (37.7658419717714, -122.419831870418)
114461 15373 DPW Maintained 3 Washingtonia robusta :: Mexican Fan Palm 75 1979 Mission St 3 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 4X4   6006845.42112 2106936.21263 37.7656323248047 -122.41954695962099 (37.7656323248047, -122.419546959621)
142224 15377 DPW Maintained 3 Washingtonia robusta :: Mexican Fan Palm 75 1979 Mission St 7 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 4X4   6006845.42112 2106936.21263 37.7656323248047 -122.41954695962099 (37.7656323248047, -122.419546959621)
117070 15381 Permitted Site 1 Washingtonia robusta :: Mexican Fan Palm 75 1980 Mission St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 4X4   6006772.91405 2106836.7155400002 37.765355044821206 -122.41979068552 (37.7653550448212, -122.41979068552)
19380 15382 DPW Maintained 3 Washingtonia robusta :: Mexican Fan Palm 75 1999X Mission St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 4X4   6006833.1096 2106780.5299 37.7652041631326 -122.419578496054 (37.7652041631326, -122.419578496054)
17732 15383 DPW Maintained 3 Washingtonia robusta :: Mexican Fan Palm 75 1999X Mission St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 4X4   6006833.6968 2106798.1459999997 37.7652525658811 -122.419577715012 (37.7652525658811, -122.419577715012)
21219 15384 DPW Maintained 3 Washingtonia robusta :: Mexican Fan Palm 75 1999X Mission St 3 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 4X4   6006831.9352 2106820.4597 37.7653137348321 -122.41958539125 (37.7653137348321, -122.41958539125)
21933 15385 DPW Maintained 3 Washingtonia robusta :: Mexican Fan Palm 75 2000X Mission St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 4X4   6006779.1887 2106674.7215 37.7649106007235 -122.41975748758001 (37.7649106007235, -122.41975748758)
17740 15386 DPW Maintained 3 Washingtonia robusta :: Mexican Fan Palm 75 2000X Mission St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 4X4   6006780.6313 2106653.0825 37.7648512663771 -122.41975096246 (37.7648512663771, -122.41975096246)
17721 15387 DPW Maintained 3 Washingtonia robusta :: Mexican Fan Palm 75 2000X Mission St 3 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 4X4   6006779.91 2106630.7221 37.764789829335896 -122.41975187054399 (37.7647898293359, -122.419751870544)
19704 15388 DPW Maintained 3 Washingtonia robusta :: Mexican Fan Palm 75 2000X Mission St 4 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 4X4   6006783.5165 2106606.9191 37.764724675050104 -122.41973770750299 (37.7647246750501, -122.419737707503)
21592 15389 DPW Maintained 3 Washingtonia robusta :: Mexican Fan Palm 75 2000X Mission St 5 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     18 4X4   6006783.5165 2106591.7718 37.764683084119895 -122.419736632649 (37.7646830841199, -122.419736632649)
18291 15395 DPW Maintained 3 Washingtonia robusta :: Mexican Fan Palm 75 2023 Mission St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     18 4X4   6006844.3209 2106537.7082 37.764538063234795 -122.419522489923 (37.7645380632348, -122.419522489923)
140689 15396 Permitted Site 1 Washingtonia robusta :: Mexican Fan Palm 75 2023 Mission St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 4X4   6006859.6818699995 2106566.5907 37.7646182330206 -122.419471409597 (37.7646182330206, -122.419471409597)
17383 15397 DPW Maintained 3 Washingtonia robusta :: Mexican Fan Palm 75 2023 Mission St 3 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     18 4X4   6006842.046 2106580.1715 37.7646545293596 -122.41953337107799 (37.7646545293596, -122.419533371078)
20108 15398 Permitted Site 1 Washingtonia robusta :: Mexican Fan Palm 75 2029 Mission St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     18 4X4   6006849.6288 2106465.6722 37.7643405682415 -122.41949902025699 (37.7643405682415, -122.419499020257)
17590 15399 Permitted Site 1 Washingtonia robusta :: Mexican Fan Palm 75 2027 Mission St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     18 4X4   6006845.0791 2106513.4435 37.7644714807654 -122.419518145883 (37.7644714807654, -122.419518145883)
19489 15400 Permitted Site 1 Washingtonia robusta :: Mexican Fan Palm 75 2035 Mission St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 4X4   6006850.0111 2106406.7679 37.7641788523727 -122.419493518679 (37.7641788523727, -122.419493518679)
96201 15401 Permitted Site 1 Washingtonia robusta :: Mexican Fan Palm 75 2035 Mission St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 4X4   6006859.26812 2106465.89528 37.7643417237025 -122.41946569630699 (37.7643417237025, -122.419465696307)
83511 15402 Permitted Site 1 Washingtonia robusta :: Mexican Fan Palm 75 2035 Mission St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     18 4X4   6006860.91141 2106484.2261799998 37.764392148614505 -122.41946131318501 (37.7643921486145, -122.419461313185)
19832 15404 Permitted Site 1 Washingtonia robusta :: Mexican Fan Palm 75 2040 Mission St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 4X4   6006793.6148 2106462.6587 37.764329138697 -122.41969254355601 (37.764329138697, -122.419692543556)
20884 15410 Permitted Site 1 Washingtonia robusta :: Mexican Fan Palm 75 2065 Mission St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 4X4   6006857.2115 2106321.6003 37.7639454076577 -122.41946257191601 (37.7639454076577, -122.419462571916)
20793 15419 Permitted Site 1 Washingtonia robusta :: Mexican Fan Palm 75 2090 Mission St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 4X4   6006808.7621 2106205.8751 37.7636249243563 -122.41962193297199 (37.7636249243563, -122.419621932972)
144838 15421 Permitted Site 1 Washingtonia robusta :: Mexican Fan Palm 75 2091X Mission St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 4X4   6006873.65675 2106185.57626 37.7635728437413 -122.419396042113 (37.7635728437413, -122.419396042113)
21136 15424 Permitted Site 1 Washingtonia robusta :: Mexican Fan Palm 75 2101 Mission St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     18 4X4   6006867.8273 2106045.5888 37.763188142588604 -122.419406272714 (37.7631881425886, -122.419406272714)
117641 15428 Permitted Site 1 Washingtonia robusta :: Mexican Fan Palm 75 2109 Mission St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   09/27/1994 12:00:00 AM 18 3X3   6006867.61446 2106023.64726 37.7631278842618 -122.419405452183 (37.7631278842618, -122.419405452183)
19865 15432 DPW Maintained 3 Washingtonia robusta :: Mexican Fan Palm 75 2128 Mission St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     18 4X4   6006812.3772 2105921.7678 37.7628450358121 -122.419589270998 (37.7628450358121, -122.419589270998)
21610 15437 Permitted Site 1 Washingtonia robusta :: Mexican Fan Palm 75 2148 Mission St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   10/10/1992 12:00:00 AM 18 4X4   6006821.0239 2105826.6543 37.762584363416295 -122.419552616574 (37.7625843634163, -122.419552616574)
20301 15438 DPW Maintained 3 Washingtonia robusta :: Mexican Fan Palm 75 2160 Mission St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   10/10/1992 12:00:00 AM 18 4X4   6006822.465 2105789.9059 37.762483542066704 -122.419545024984 (37.7624835420667, -122.419545024984)
21205 15439 Permitted Site 1 Washingtonia robusta :: Mexican Fan Palm 75 2162 Mission St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   10/10/1992 12:00:00 AM 18 4X4   6006823.9061 2105762.5248 37.7624084411332 -122.41953809802901 (37.7624084411332, -122.419538098029)
106919 15440 DPW Maintained 3 Washingtonia robusta :: Mexican Fan Palm 75 2224 Mission St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   10/10/1992 12:00:00 AM 18 4X4   6006834.95821 2105372.78301 37.7613389236012 -122.419472221327 (37.7613389236012, -122.419472221327)
18122 15443 Permitted Site 1 Washingtonia robusta :: Mexican Fan Palm 75 2230 Mission St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     18 3X3   6006851.2872 2105349.6458 37.7612763139256 -122.419414104618 (37.7612763139256, -122.419414104618)
17614 15444 DPW Maintained 3 Washingtonia robusta :: Mexican Fan Palm 75 2243 Mission St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   10/10/1992 12:00:00 AM 12 4X4   6006909.5324 2105286.5572 37.7611063676926 -122.41920818332599 (37.7611063676926, -122.419208183326)
19517 15447 DPW Maintained 3 Washingtonia robusta :: Mexican Fan Palm 75 2268 Mission St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     18 4X4   6006864.2573 2105151.4928 37.7607329624144 -122.41935518891 (37.7607329624144, -122.41935518891)
20054 15449 DPW Maintained 3 Washingtonia robusta :: Mexican Fan Palm 75 2290 Mission St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   10/10/1992 12:00:00 AM 18 4X4   6006865.6984 2105042.6887 37.7604342928211 -122.41934248602502 (37.7604342928211, -122.419342486025)
17338 15450 DPW Maintained 3 Washingtonia robusta :: Mexican Fan Palm 75 2301 Mission St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   10/10/1992 12:00:00 AM 12 4x4   6006934.5554 2104894.5299 37.760031361018 -122.41909383171001 (37.760031361018, -122.41909383171)
20606 15451 DPW Maintained 3 Washingtonia robusta :: Mexican Fan Palm 75 2337 Mission St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   10/10/1992 12:00:00 AM 12 4x4   6006940.6216 2104730.7429 37.7595819815227 -122.419061234067 (37.7595819815227, -122.419061234067)
17576 15453 DPW Maintained 3 Washingtonia robusta :: Mexican Fan Palm 75 2365 Mission St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   10/10/1992 12:00:00 AM 12 4X4   6006954.2705 2104542.6911 37.7590664034557 -122.41900069111901 (37.7590664034557, -122.419000691119)
17702 15454 DPW Maintained 3 Washingtonia robusta :: Mexican Fan Palm 75 2366 Mission St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   10/10/1992 12:00:00 AM 18 4X4   6006889.3715 2104582.8537 37.7591730259049 -122.419227992101 (37.7591730259049, -122.419227992101)
18494 15456 DPW Maintained 3 Washingtonia robusta :: Mexican Fan Palm 75 2389 Mission St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     18 4x4   6006956.5453 2104486.5788 37.758912460169505 -122.418988843881 (37.7589124601695, -122.418988843881)
126919 15464 Permitted Site 1 Washingtonia robusta :: Mexican Fan Palm 75 2434 Mission St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/21/2000 12:00:00 AM 12 4X4   6006931.67181 2104190.23259 37.7580973613707 -122.41905384857 (37.7580973613707, -122.41905384857)

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