Street_Tree_List

Data source: data.sfgov.org

6,837 rows where qSpecies = 37

View and edit SQL

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

Link rowid ▼ TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
100 106679 Permitted Site 1 Tristaniopsis laurina :: Swamp Myrtle 37 2200 Lyon St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   06/24/2014 12:00:00 AM 10 3x3 Permit Number 773028 5999374.7893199995 2116379.94206 37.7911387486163 -122.44606546047702 (37.7911387486163, -122.446065460477)
326 251270 Permitted Site 1 Tristaniopsis laurina :: Swamp Myrtle 37 853 Lombard St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/04/2017 12:00:00 AM 3 3x3   6008278.12362 2120317.86249 37.8024557006055 -122.415539041664 (37.8024557006055, -122.415539041664)
355 182552 Undocumented 2 Tristaniopsis laurina :: Swamp Myrtle 37 2565 Judah St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 0ft   5986555.5107 2105693.4321 37.7610562355745 -122.489632951355 (37.7610562355745, -122.489632951355)
364 182551 Undocumented 2 Tristaniopsis laurina :: Swamp Myrtle 37 2565 Judah St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 0ft   5986541.5452 2105693.4321 37.7610554202125 -122.489681251316 (37.7610554202125, -122.489681251316)
390 251276 DPW Maintained 3 Tristaniopsis laurina :: Swamp Myrtle 37 1175X Hudson Ave 4 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2 Private 3 03/09/1998 12:00:00 AM   3x3   6017547.0 2094834.0 37.732999109091 -122.381690402626 (37.732999109091, -122.381690402626)
391 251275 DPW Maintained 3 Tristaniopsis laurina :: Swamp Myrtle 37 1175x Hudson Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2 Private 3 09/16/2011 12:00:00 AM   3x3   6017547.0 2094834.0 37.732999109091 -122.381690402626 (37.732999109091, -122.381690402626)
473 142160 Undocumented 2 Tristaniopsis laurina :: Swamp Myrtle 37 490X Baker St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     0 Width 0ft   6000657.0 2110488.0 37.7750341257837 -122.44120614609 (37.7750341257837, -122.44120614609)
485 142163 Undocumented 2 Tristaniopsis laurina :: Swamp Myrtle 37 490X Baker St 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     0 Width 0ft   6000657.0 2110488.0 37.7750341257837 -122.44120614609 (37.7750341257837, -122.44120614609)
546 12251 DPW Maintained 3 Tristaniopsis laurina :: Swamp Myrtle 37 512 Laguna St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   12/24/2014 12:00:00 AM 3 3X3   6005037.9059 2110678.2828 37.77580516874 -122.426065177531 (37.77580516874, -122.426065177531)
677 107511 Permitted Site 1 Tristaniopsis laurina :: Swamp Myrtle 37 2141 Chestnut St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   09/18/2014 12:00:00 AM 3 3x3   6001625.68296 2119729.38155 37.8004637136911 -122.43851754404601 (37.8004637136911, -122.438517544046)
679 187631 DPW Maintained 3 Tristaniopsis laurina :: Swamp Myrtle 37 4255x Judah St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2 Private 3 03/28/2017 11:56:00 AM 3 3x3   5981269.0 2105492.0 37.760193098921796 -122.50790142928699 (37.7601930989218, -122.507901429287)
834 140247 Undocumented 2 Tristaniopsis laurina :: Swamp Myrtle 37 100 Ashbury St 9 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 0ft   5998760.3863 2110325.7376 37.77448037673879 -122.447755234881 (37.7744803767388, -122.447755234881)
873 93400 DPW Maintained 3 Tristaniopsis laurina :: Swamp Myrtle 37 2101 Turk Blvd 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   12/09/2008 12:00:00 AM 3 3x3   5999886.3903 2111916.5396 37.7789126049307 -122.44397450733601 (37.7789126049307, -122.443974507336)
982 18283 DPW Maintained 3 Tristaniopsis laurina :: Swamp Myrtle 37 2000 Post St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   01/10/1994 12:00:00 AM 6 4X4   6002545.1088 2114076.0503 37.7849933804768 -122.434931434249 (37.7849933804768, -122.434931434249)
1024 97943 Permitted Site 1 Tristaniopsis laurina :: Swamp Myrtle 37 3003 Jackson St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/05/2011 12:00:00 AM 3 3x3 Permit Number 768278 5999754.4115699995 2116356.69568 37.791096591089 -122.44475031260099 (37.791096591089, -122.444750312601)
1082 22639 Permitted Site 1 Tristaniopsis laurina :: Swamp Myrtle 37 1200X Turk St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/07/2005 12:00:00 AM 3 3X3   6004184.7636 2112567.9201 37.780945391127 -122.429151179613 (37.780945391127, -122.429151179613)
1094 251442 DPW Maintained 3 Tristaniopsis laurina :: Swamp Myrtle 37 2700x San Jose Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   03/17/2006 12:00:00 AM   Width 3ft   5997075.0 2088509.0 37.7144804976148 -122.452010931306 (37.7144804976148, -122.452010931306)
1097 251443 DPW Maintained 3 Tristaniopsis laurina :: Swamp Myrtle 37 2700x San Jose Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   03/17/2006 12:00:00 AM   Width 3ft   5997075.0 2088509.0 37.7144804976148 -122.452010931306 (37.7144804976148, -122.452010931306)
1104 218512 Undocumented 2 Tristaniopsis laurina :: Swamp Myrtle 37 2700x San Jose Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 3ft   5997075.0 2088509.0 37.7144804976148 -122.452010931306 (37.7144804976148, -122.452010931306)
1118 26811 Permitted Site 1 Tristaniopsis laurina :: Swamp Myrtle 37 1850 Turk St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 3X3   6001133.0786 2112143.4834 37.7796067716282 -122.43967800032301 (37.7796067716282, -122.439678000323)
1129 251457 Permitted Site 1 Tristaniopsis laurina :: Swamp Myrtle 37 758 Cayuga Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   6001327.0 2092594.0 37.7259396258956 -122.437606717792 (37.7259396258956, -122.437606717792)
1180 251470 Planning Code 138.1 required 4 Tristaniopsis laurina :: Swamp Myrtle 37 194 Sweeny St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   05/04/2017 12:00:00 AM 3 3x3 Permit Number 777454 6009558.57553 2094850.0846799999 37.7325989441491 -122.409309728531 (37.7325989441491, -122.409309728531)
1240 241867 Permitted Site 1 Tristaniopsis laurina :: Swamp Myrtle 37 633 Prentiss St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   10/20/1987 12:00:00 AM 8 Width 2ft Permit Number 24800 6008703.52023 2095884.2711099999 37.735390653541295 -122.412338944781 (37.7353906535413, -122.412338944781)
1325 141834 Undocumented 2 Tristaniopsis laurina :: Swamp Myrtle 37 1131 TURK ST 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     30 Width 0ft   6004558.497 2112571.6053 37.7809766592124 -122.427858513843 (37.7809766592124, -122.427858513843)
1344 141858 Undocumented 2 Tristaniopsis laurina :: Swamp Myrtle 37 1110 TURK ST 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     11 Width 0ft   6004615.4703 2112626.4811 37.781130557433706 -122.427665325896 (37.7811305574337, -122.427665325896)
1354 14491 DPW Maintained 3 Tristaniopsis laurina :: Swamp Myrtle 37 320 Masonic Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     50 3X3   5999051.991 2111710.9656 37.77830051932229 -122.446846219186 (37.7783005193223, -122.446846219186)
1373 10189 DPW Maintained 3 Tristaniopsis laurina :: Swamp Myrtle 37 1153 Guerrero St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   05/11/2017 12:00:00 AM 3 2x3   6005799.04863 2102230.07657 37.752651382065395 -122.42283164626998 (37.7526513820654, -122.42283164627)
1436 251534 Planning Code 138.1 required 4 Tristaniopsis laurina :: Swamp Myrtle 37 1818 42nd Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   05/16/2017 12:00:00 AM 3 3x3   5983226.0 2102732.0 37.7527300247516 -122.500929082058 (37.7527300247516, -122.500929082058)
1439 185582 Undocumented 2 Tristaniopsis laurina :: Swamp Myrtle 37 2227 43rd Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 0ft   5982934.0602 2099947.7625 37.74506813637971 -122.501732671769 (37.7450681363797, -122.501732671769)
1445 22600 DPW Maintained 3 Tristaniopsis laurina :: Swamp Myrtle 37 837 Turk St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 4X4   6005887.44223 2112751.69518 37.78154623162111 -122.42327383483999 (37.7815462316211, -122.42327383484)
1447 139887 Permitted Site 1 Tristaniopsis laurina :: Swamp Myrtle 37 1575 TURK ST 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   01/19/2001 12:00:00 AM 6 Width 0ft   6002626.7608 2112299.1255 37.7801190291536 -122.434521848172 (37.7801190291536, -122.434521848172)
1458 246242 Undocumented 2 Tristaniopsis laurina :: Swamp Myrtle 37 100X Frederick St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 0ft   5999462.0 2107723.0 37.7673739936786 -122.445141068115 (37.7673739936786, -122.445141068115)
1460 139886 Permitted Site 1 Tristaniopsis laurina :: Swamp Myrtle 37 1575 TURK ST 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   06/06/1997 12:00:00 AM 7 Width 0ft   6002599.6871 2112295.0644 37.78010634148521 -122.434615217822 (37.7801063414852, -122.434615217822)
1467 246243 Undocumented 2 Tristaniopsis laurina :: Swamp Myrtle 37 100X Frederick St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 0ft   5999462.0 2107723.0 37.7673739936786 -122.445141068115 (37.7673739936786, -122.445141068115)
1469 247378 DPW Maintained 3 Tristaniopsis laurina :: Swamp Myrtle 37 1001 Oak St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   04/17/1991 12:00:00 AM 5 Width 0ft   6002208.0 2109818.0 37.7732826991746 -122.43579295981199 (37.7732826991746, -122.435792959812)
1482 140438 Undocumented 2 Tristaniopsis laurina :: Swamp Myrtle 37 1100 FILLMORE ST 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     18 Width 0ft   6003482.3387 2112124.8891 37.779689150174704 -122.43154957445299 (37.7796891501747, -122.431549574453)
1531 5189 DPW Maintained 3 Tristaniopsis laurina :: Swamp Myrtle 37 509 Divisadero St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 2X3   6001637.7109 2110249.8513 37.7744360439082 -122.43779659970501 (37.7744360439082, -122.437796599705)
1540 251588 Undocumented 2 Tristaniopsis laurina :: Swamp Myrtle 37 1430 17th Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   5990886.0 2105639.0 37.7611586563939 -122.47465184359501 (37.7611586563939, -122.474651843595)
1582 45051 DPW Maintained 3 Tristaniopsis laurina :: Swamp Myrtle 37 2243 26th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 05/08/2001 12:00:00 AM 3   Permit Number 43936 5988218.295 2100043.5647 37.7456401553342 -122.483467967859 (37.7456401553342, -122.483467967859)
1649 251584 Permitted Site 1 Tristaniopsis laurina :: Swamp Myrtle 37 2679 San Jose Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/16/1997 12:00:00 AM   3x3   5997280.0 2088608.0 37.714764069005604 -122.45130950851002 (37.7147640690056, -122.45130950851)
1697 42640 DPW Maintained 3 Tristaniopsis laurina :: Swamp Myrtle 37 1651 Union St 10 Sidewalk: Curb side : Cutout 1 Tree 1 SFUSD 4 DPW for City Agency 2 09/25/2015 02:08:00 PM 3 3x3 Permit Number 42688 6005273.82097 2118847.7065 37.7982497015198 -122.42583071712299 (37.7982497015198, -122.425830717123)
1725 24940 Permitted Site 1 Tristaniopsis laurina :: Swamp Myrtle 37 2733 Geary Blvd 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   08/01/1996 12:00:00 AM 6 3X3   5998612.3168 2113129.3587 37.782169931054604 -122.44846938258301 (37.7821699310546, -122.448469382583)
1758 251601 DPW Maintained 3 Tristaniopsis laurina :: Swamp Myrtle 37 2679 San Jose Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   12/16/1997 12:00:00 AM   3x3   5997280.0 2088608.0 37.714764069005604 -122.45130950851002 (37.7147640690056, -122.45130950851)
1833 251748 Undocumented 2 Tristaniopsis laurina :: Swamp Myrtle 37 2 South Hill Blvd 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   6002576.6751 2087720.0510900002 37.7126278178947 -122.43293862581999 (37.7126278178947, -122.43293862582)
1940 139586 DPW Maintained 3 Tristaniopsis laurina :: Swamp Myrtle 37 3 Saint Joseph's Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     8 Width 0ft   6000731.3449 2112139.6442 37.779573356306 -122.44106749101401 (37.779573356306, -122.441067491014)
1941 139579 DPW Maintained 3 Tristaniopsis laurina :: Swamp Myrtle 37 1920 TURK ST 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   11/20/2008 12:00:00 AM 2 Width 0ft   6000679.6696 2112100.9749 37.779464236796606 -122.4412434823 (37.7794642367966, -122.4412434823)
1942 139585 DPW Maintained 3 Tristaniopsis laurina :: Swamp Myrtle 37 5 Saint Joseph's Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     8 Width 0ft   6000729.6528 2112161.6416 37.7796336591807 -122.4410749233 (37.7796336591807, -122.4410749233)
1944 139582 DPW Maintained 3 Tristaniopsis laurina :: Swamp Myrtle 37 1920 TURK ST 5 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   11/20/2008 12:00:00 AM 2 Width 0ft   6000588.1654 2112088.9415 37.779425983334 -122.441559169487 (37.779425983334, -122.441559169487)
1952 139587 DPW Maintained 3 Tristaniopsis laurina :: Swamp Myrtle 37 1 Saint Joseph's Ave 4 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     11 Width 0ft   6000732.3602 2112121.031 37.7795223070318 -122.441062642932 (37.7795223070318, -122.441062642932)
1969 198010 Undocumented 2 Tristaniopsis laurina :: Swamp Myrtle 37 213 Clara St 1 : 4 Tree 1 Private 1     1 Width 3ft Permit Number 779305 6011863.46506 2111836.2655700003 37.7793681257663 -122.40253514649099 (37.7793681257663, -122.402535146491)
2022 198027 Undocumented 2 Tristaniopsis laurina :: Swamp Myrtle 37 101 Langton St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 3ft   6010199.0 2110711.0 37.7761853461059 -122.40821387035 (37.7761853461059, -122.40821387035)
2072 136839 Permitted Site 1 Tristaniopsis laurina :: Swamp Myrtle 37 1911 Green St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/02/2009 12:00:00 AM 4 Width 4ft Permit Number 52344 6003883.81928 2118306.5649 37.7966852175075 -122.43060190297199 (37.7966852175075, -122.430601902972)
2084 200756 Permitted Site 1 Tristaniopsis laurina :: Swamp Myrtle 37 1698 Revere Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Public Library 14   07/23/2010 12:00:00 AM 2 Width 0ft Permit Number 53643 6014807.3749 2094642.3361 37.732321185493 -122.39114868869899 (37.732321185493, -122.391148688699)
2106 252882 Undocumented 2 Tristaniopsis laurina :: Swamp Myrtle 37 726 El Camino Del Mar 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       Width 4ft   5986349.68151 2114864.86182 37.786226371002705 -122.491019750162 (37.7862263710027, -122.491019750162)
2118 252900 Undocumented 2 Tristaniopsis laurina :: Swamp Myrtle 37 598 Mount Vernon Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   5997754.0 2090179.0 37.7191048016003 -122.449784323005 (37.7191048016003, -122.449784323005)
2119 252901 Undocumented 2 Tristaniopsis laurina :: Swamp Myrtle 37 598 Mount Vernon Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   5997754.0 2090179.0 37.7191048016003 -122.449784323005 (37.7191048016003, -122.449784323005)
2152 242277 Permitted Site 1 Tristaniopsis laurina :: Swamp Myrtle 37 117 Conrad St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   06/27/2017 12:00:00 AM 3 Width 3ft Permit Number 46994 6001802.4938199995 2096648.3509099998 37.7370989679366 -122.43625299088801 (37.7370989679366, -122.436252990888)
2244 34670 Permitted Site 1 Tristaniopsis laurina :: Swamp Myrtle 37 2001X Filbert St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   05/22/2015 12:00:00 AM 3 3x3 Permit Number 38339 6003296.78192 2118922.23396 37.798342411735604 -122.432677184799 (37.7983424117356, -122.432677184799)
2245 5919 Permitted Site 1 Tristaniopsis laurina :: Swamp Myrtle 37 1300X Eddy St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   08/09/2007 12:00:00 AM 12 3x3 Permit Number 52201 6004140.9874 2112910.1496 37.7818825900403 -122.42932703435 (37.7818825900403, -122.42932703435)
2286 252896 Undocumented 2 Tristaniopsis laurina :: Swamp Myrtle 37 501x Mount Vernon Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   5997879.0 2089997.0 37.7186122227881 -122.44933914222901 (37.7186122227881, -122.449339142229)
2287 252897 Undocumented 2 Tristaniopsis laurina :: Swamp Myrtle 37 501x Mount Vernon Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   5997879.0 2089997.0 37.7186122227881 -122.44933914222901 (37.7186122227881, -122.449339142229)
2301 22734 Permitted Site 1 Tristaniopsis laurina :: Swamp Myrtle 37 1560 Turk St 6 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   05/02/1990 12:00:00 AM 18 3X3   6002510.1745 2112337.5363 37.780217876703794 -122.434927920426 (37.7802178767038, -122.434927920426)
2485 241979 Undocumented 2 Tristaniopsis laurina :: Swamp Myrtle 37 501 Tompkins Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     9 4.5x9   6007964.4907599995 2096517.14345 37.7370868837581 -122.41493883176202 (37.7370868837581, -122.414938831762)
2548 246850 Undocumented 2 Tristaniopsis laurina :: Swamp Myrtle 37 300 Broderick St 7 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 4ft   6001250.58672 2109911.08695 37.773483861619894 -122.43911144826099 (37.7734838616199, -122.439111448261)
2590 253131 Undocumented 2 Tristaniopsis laurina :: Swamp Myrtle 37 277 Edinburgh St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       Width 3ft   6003684.78158 2092034.78148 37.724537911193295 -122.429416163945 (37.7245379111933, -122.429416163945)
2698 21631 Permitted Site 1 Tristaniopsis laurina :: Swamp Myrtle 37 1615 Sutter St 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   06/29/1994 12:00:00 AM 12 4X4   6004720.5557 2114675.0873 37.7867614641574 -122.427447768121 (37.7867614641574, -122.427447768121)
2805 241582 Undocumented 2 Tristaniopsis laurina :: Swamp Myrtle 37 38X Java St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 3ft   5999751.0 2107467.0 37.7666875731096 -122.444123063419 (37.7666875731096, -122.444123063419)
2814 241583 Undocumented 2 Tristaniopsis laurina :: Swamp Myrtle 37 38X Java St 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     6 Width 3ft   5999751.0 2107467.0 37.7666875731096 -122.444123063419 (37.7666875731096, -122.444123063419)
2837 241584 Undocumented 2 Tristaniopsis laurina :: Swamp Myrtle 37 38X Java St 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     7 Width 3ft   5999751.0 2107467.0 37.7666875731096 -122.444123063419 (37.7666875731096, -122.444123063419)
2841 241585 Undocumented 2 Tristaniopsis laurina :: Swamp Myrtle 37 38X Java St 4 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     8 Width 3ft   5999751.0 2107467.0 37.7666875731096 -122.444123063419 (37.7666875731096, -122.444123063419)
2867 253263 Undocumented 2 Tristaniopsis laurina :: Swamp Myrtle 37 2425 Ocean Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   5991946.0 2094328.0 37.730162918760904 -122.470162120918 (37.7301629187609, -122.470162120918)
2896 253266 DPW Maintained 3 Tristaniopsis laurina :: Swamp Myrtle 37 2411 Ocean Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   04/26/1996 12:00:00 AM   3x3   5992016.868969999 2094311.4593 37.730121598969205 -122.469915916098 (37.7301215989692, -122.469915916098)
2928 18294 DPW Maintained 3 Tristaniopsis laurina :: Swamp Myrtle 37 2000 Post St 12 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   04/14/2005 12:00:00 AM 3 4X4   6002231.627 2114034.293 37.7848609216487 -122.436012990755 (37.7848609216487, -122.436012990755)
2953 192045 Undocumented 2 Tristaniopsis laurina :: Swamp Myrtle 37 405 Townsend St 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1   08/14/2017 12:00:00 AM 3 Width 8ft Permit Number 780033 6013178.04643 2110099.77457 37.7746734191738 -122.39786558493401 (37.7746734191738, -122.397865584934)
2963 192048 Undocumented 2 Tristaniopsis laurina :: Swamp Myrtle 37 405 Townsend St 4 Sidewalk: Property side : Yard 9 Tree 1 Private 1   08/14/2017 12:00:00 AM 3 Width 8ft Permit Number 780033 6013251.73009 2110171.5616599997 37.7748746334969 -122.39761573260401 (37.7748746334969, -122.397615732604)
2964 192047 Undocumented 2 Tristaniopsis laurina :: Swamp Myrtle 37 405 Townsend St 3 Sidewalk: Property side : Yard 9 Tree 1 Private 1   08/14/2017 12:00:00 AM 3 Width 8ft Permit Number 780033 6013240.399669999 2110155.0455099996 37.7748286529654 -122.397653768512 (37.7748286529654, -122.397653768512)
2979 192049 Undocumented 2 Tristaniopsis laurina :: Swamp Myrtle 37 405 Townsend St 5 Sidewalk: Property side : Yard 9 Tree 1 Private 1   08/14/2017 12:00:00 AM 3 Width 8ft Permit Number 780033 6013269.505969999 2110186.9808900002 37.77491796101779 -122.397555323332 (37.7749179610178, -122.397555323332)
2980 192046 Undocumented 2 Tristaniopsis laurina :: Swamp Myrtle 37 405 Townsend St 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1   08/14/2017 12:00:00 AM 3 Width 8ft Permit Number 780033 6013200.03931 2110117.49199 37.774723291973096 -122.39779074965 (37.7747232919731, -122.39779074965)
3009 192050 Undocumented 2 Tristaniopsis laurina :: Swamp Myrtle 37 405 Townsend St 6 Sidewalk: Property side : Yard 9 Tree 1 Private 1   08/14/2017 12:00:00 AM 3 Width 8ft Permit Number 780033 6013285.99525 2110202.74852 37.774962173497 -122.39749938908501 (37.774962173497, -122.397499389085)
3101 102774 Permitted Site 1 Tristaniopsis laurina :: Swamp Myrtle 37 1472 Filbert St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 3x3 Permit Number 31200 6005947.91695 2119337.23456 37.7996318920616 -122.42353296190201 (37.7996318920616, -122.423532961902)
3186 218743 Permitted Site 1 Tristaniopsis laurina :: Swamp Myrtle 37 141 Cresta Vista Dr 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1   07/06/1988 12:00:00 AM 8 Width 3ft Permit Number 25334 5995930.5324099995 2096235.39856 37.7356297230374 -122.456525038998 (37.7356297230374, -122.456525038998)
3298 28315 Permitted Site 1 Tristaniopsis laurina :: Swamp Myrtle 37 739 Cortland Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   08/30/2017 12:00:00 AM 3 3x3 Permit Number 780585 6008002.89443 2097198.9906200003 37.7389612444527 -122.414854295516 (37.7389612444527, -122.414854295516)
3321 140459 DPW Maintained 3 Tristaniopsis laurina :: Swamp Myrtle 37 1410 TURK ST 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   01/19/2001 12:00:00 AM 5 Width 0ft   6003139.0674 2112416.8164 37.7804712472963 -122.432757957966 (37.7804712472963, -122.432757957966)
3325 140465 Permitted Site 1 Tristaniopsis laurina :: Swamp Myrtle 37 1440 TURK ST 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   03/08/2001 12:00:00 AM 4 Width 0ft   6002943.0868 2112390.4269 37.780387671465505 -122.433434060142 (37.7803876714655, -122.433434060142)
3327 140458 Permitted Site 1 Tristaniopsis laurina :: Swamp Myrtle 37 1400 TURK ST 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   01/19/2001 12:00:00 AM 6 Width 0ft   6003273.7425 2112436.298 37.7805323760013 -122.432293445455 (37.7805323760013, -122.432293445455)
3332 140463 Permitted Site 1 Tristaniopsis laurina :: Swamp Myrtle 37 1440 TURK ST 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   01/19/2001 12:00:00 AM 3 Width 0ft   6003009.4486 2112400.1289 37.7804180754921 -122.43320517732201 (37.7804180754921, -122.433205177322)
3352 140464 Permitted Site 1 Tristaniopsis laurina :: Swamp Myrtle 37 1440 TURK ST 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   01/19/2001 12:00:00 AM 4 Width 0ft   6002964.8193 2112393.1435 37.780396363522 -122.433359071525 (37.780396363522, -122.433359071525)
3409 180620 Undocumented 2 Tristaniopsis laurina :: Swamp Myrtle 37 50 Naylor St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     0 Width 3ft   6002386.3591599995 2087019.9409599998 37.71069467209271 -122.43354641464501 (37.7106946720927, -122.433546414645)
3423 251752 Undocumented 2 Tristaniopsis laurina :: Swamp Myrtle 37 128 South Hill Blvd 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1       Width 6ft   6003064.16129 2086909.24662 37.7104291634552 -122.431195883608 (37.7104291634552, -122.431195883608)
3432 180655 Undocumented 2 Tristaniopsis laurina :: Swamp Myrtle 37 128 South Hill Blvd 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     31 Width 6ft   6003064.16129 2086909.24662 37.7104291634552 -122.431195883608 (37.7104291634552, -122.431195883608)
3439 251741 Undocumented 2 Tristaniopsis laurina :: Swamp Myrtle 37 300 Naylor St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   6002771.0 2086560.0 37.7094535905361 -122.432184185389 (37.7094535905361, -122.432184185389)
3449 71297 Undocumented 2 Tristaniopsis laurina :: Swamp Myrtle 37 1943 Turk St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   02/28/1987 12:00:00 AM 9 3x3   6000711.2858 2112029.2136 37.7792689994665 -122.441128958799 (37.7792689994665, -122.441128958799)
3488 251753 Undocumented 2 Tristaniopsis laurina :: Swamp Myrtle 37 128 South Hill Blvd 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1       Width 6ft   6003064.16129 2086909.24662 37.7104291634552 -122.431195883608 (37.7104291634552, -122.431195883608)
3512 241416 Permitted Site 1 Tristaniopsis laurina :: Swamp Myrtle 37 126 College Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   10/11/1985 12:00:00 AM 12 Width 2ft Permit Number 22471 6004614.54132 2095950.25242 37.7353415190975 -122.42648077318 (37.7353415190975, -122.42648077318)
3642 237734 Undocumented 2 Tristaniopsis laurina :: Swamp Myrtle 37 120 Corbett Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 2ft   6000607.58156 2105643.6338 37.7617298897441 -122.44102947734899 (37.7617298897441, -122.441029477349)
3754 253538 DPW Maintained 3 Tristaniopsis laurina :: Swamp Myrtle 37 1000 Cayuga Ave 6 Back Yard : Yard 13 Tree 1 DPW 2   09/22/2017 02:43:00 PM 3 3x3   6000652.979169999 2091201.14277 37.7220768117153 -122.43983693715201 (37.7220768117153, -122.439836937152)
3757 6923 DPW Maintained 3 Tristaniopsis laurina :: Swamp Myrtle 37 436 Fell St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     24 3x3   6005320.8239 2110648.3853 37.775739063409794 -122.425084363796 (37.7757390634098, -122.425084363796)
3769 136887 Undocumented 2 Tristaniopsis laurina :: Swamp Myrtle 37 1001x Bay St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 3ft   6005802.0 2120854.0 37.8037883050638 -122.424145815925 (37.8037883050638, -122.424145815925)
3772 136889 Undocumented 2 Tristaniopsis laurina :: Swamp Myrtle 37 1001x Bay St 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 3ft   6005802.0 2120854.0 37.8037883050638 -122.424145815925 (37.8037883050638, -122.424145815925)
3784 242020 Undocumented 2 Tristaniopsis laurina :: Swamp Myrtle 37 3154 17th St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     9 Width 3ft   6007751.06691 2106208.47613 37.7636851003982 -122.41636297119 (37.7636851003982, -122.41636297119)

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