Street_Tree_List

Data source: data.sfgov.org

144 rows where qSpecies = 93 sorted by DBH

View and edit SQL

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

Link rowid TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH ▼ PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
14525 43623 Permitted Site 1 Melaleuca nesophila :: Pink Melaleuca 93 210 35th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/20/2000 12:00:00 AM     Permit Number 43272          
18556 31172 Permitted Site 1 Melaleuca nesophila :: Pink Melaleuca 93 100 Shields St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   03/21/1995 12:00:00 AM     Permit Number 34871 5993759.19888335 2089860.63162869 37.7180012684503 -122.46356961432801 (37.7180012684503, -122.463569614328)
58677 31171 Permitted Site 1 Melaleuca nesophila :: Pink Melaleuca 93 100 Shields St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   03/21/1995 12:00:00 AM     Permit Number 34871 5993759.19888335 2089860.63162869 37.7180012684503 -122.46356961432801 (37.7180012684503, -122.463569614328)
78297 31635 Permitted Site 1 Melaleuca nesophila :: Pink Melaleuca 93 2538 Great Hwy 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 05/22/1995 12:00:00 AM     Permit Number 35152 5981511.7242527 2097800.56430497 37.739088877646395 -122.506491564023 (37.7390888776464, -122.506491564023)
78788 40218 Permitted Site 1 Melaleuca nesophila :: Pink Melaleuca 93 139 Seal Rock Dr 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 05/06/1999 12:00:00 AM     Permit Number 41397 5981206.29115693 2112930.16439571 37.7806124308083 -122.50867053303499 (37.7806124308083, -122.508670533035)
79217 43824 Permitted Site 1 Melaleuca nesophila :: Pink Melaleuca 93 2539 35th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/27/2000 12:00:00 AM     Permit Number 43452 5985490.59688758 2097934.34218836 37.7396896615859 -122.492744480822 (37.7396896615859, -122.492744480822)
80008 31638 Permitted Site 1 Melaleuca nesophila :: Pink Melaleuca 93 2562 Great Hwy 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 05/22/1995 12:00:00 AM     Permit Number 35155 5981524.37597425 2097644.9749882 37.7386624172308 -122.506436285686 (37.7386624172308, -122.506436285686)
81901 31640 Permitted Site 1 Melaleuca nesophila :: Pink Melaleuca 93 2594 Great Hwy 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 05/22/1995 12:00:00 AM     Permit Number 35156 5981541.24493631 2097437.52256583 37.738093803256 -122.50636258222201 (37.738093803256, -122.506362582222)
83318 31642 Permitted Site 1 Melaleuca nesophila :: Pink Melaleuca 93 3601 Taraval St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 05/22/1995 12:00:00 AM     Permit Number 35157 5982065.15070434 2098736.73871701 37.7416919237879 -122.504647444825 (37.7416919237879, -122.504647444825)
83587 114672 Permitted Site 1 Melaleuca nesophila :: Pink Melaleuca 93 85X Peralta Ave 2 Side Yard : Yard 17 Tree 1 Private 1   11/30/2015 12:00:00 AM     Permit Number 775155 6010502.29579 2100335.12269 37.7477125069204 -122.40643339757601 (37.7477125069204, -122.406433397576)
84488 37087 Permitted Site 1 Melaleuca nesophila :: Pink Melaleuca 93 1431 46th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 06/01/1998 12:00:00 AM     Permit Number 39687 5981822.5647819 2105347.10091721 37.7598278475269 -122.50597620053001 (37.7598278475269, -122.50597620053)
86011 43610 Permitted Site 1 Melaleuca nesophila :: Pink Melaleuca 93 2174 33rd Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/20/2000 12:00:00 AM     Permit Number 43264 5986078.58326706 2100441.09799391 37.746606905591996 -122.49089591351401 (37.746606905592, -122.490895913514)
86051 38919 Permitted Site 1 Melaleuca nesophila :: Pink Melaleuca 93 739 Lakeview Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 05/25/2002 12:00:00 AM     Permit Number 40729 5994644.0321122 2089899.68618843 37.7181594465135 -122.460513981509 (37.7181594465135, -122.460513981509)
86529 37248 Permitted Site 1 Melaleuca nesophila :: Pink Melaleuca 93 3038 Pacheco St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 06/12/1998 12:00:00 AM     Permit Number 39801 5985578.39129143 2101634.00517992 37.7498530704582 -122.492713344722 (37.7498530704582, -122.492713344722)
86628 39996 Permitted Site 1 Melaleuca nesophila :: Pink Melaleuca 93 870 Innes Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 02/03/1999 12:00:00 AM     Permit Number 41254 6019158.47829216 2094538.87688533 37.7322776068337 -122.376098579608 (37.7322776068337, -122.376098579608)
88155 114671 Permitted Site 1 Melaleuca nesophila :: Pink Melaleuca 93 85X Peralta Ave 1 Side Yard : Yard 17 Tree 1 Private 1   11/30/2015 12:00:00 AM     Permit Number 775155 6010502.29579 2100335.12269 37.7477125069204 -122.40643339757601 (37.7477125069204, -122.406433397576)
89643 46398 Permitted Site 1 Melaleuca nesophila :: Pink Melaleuca 93 2363 46th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   03/05/2002 12:00:00 AM     Permit Number 44628 5982038.69993379 2099019.08157606 37.7424656032555 -122.504759817001 (37.7424656032555, -122.504759817001)
90351 37484 Permitted Site 1 Melaleuca nesophila :: Pink Melaleuca 93 1246 17th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 06/22/1998 12:00:00 AM     Permit Number 39953 5990822.12261544 2106914.97361747 37.7646584370326 -122.47496590913099 (37.7646584370326, -122.474965909131)
90838 31634 Permitted Site 1 Melaleuca nesophila :: Pink Melaleuca 93 2526 Great Hwy 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 05/22/1995 12:00:00 AM     Permit Number 35151 5981505.3983929 2097878.35895124 37.739302107799894 -122.506519203426 (37.7393021077999, -122.506519203426)
91487 35511 Permitted Site 1 Melaleuca nesophila :: Pink Melaleuca 93 3484 22nd St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 03/23/1998 12:00:00 AM     Permit Number 38913 6005154.64040446 2103144.1330954 37.75512478765 -122.42512515813999 (37.75512478765, -122.42512515814)
94765 38360 Permitted Site 1 Melaleuca nesophila :: Pink Melaleuca 93 1610 Great Hwy 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 01/06/1999 12:00:00 AM     Permit Number 41156 5980983.59087853 2104088.99570474 37.756324030904395 -122.50878433832399 (37.7563240309044, -122.508784338324)
97252 37811 Permitted Site 1 Melaleuca nesophila :: Pink Melaleuca 93 354 Athens St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/07/1998 12:00:00 AM     Permit Number 40131 6004085.30799236 2091240.01678916 37.722378331197206 -122.427974988755 (37.7223783311972, -122.427974988755)
98714 38927 Permitted Site 1 Melaleuca nesophila :: Pink Melaleuca 93 30 Lunado Way 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 11/02/1998 12:00:00 AM     Permit Number 40735 5991530.391079799 2091455.54556163 37.7222518366051 -122.47138970523199 (37.7222518366051, -122.471389705232)
99708 30671 Permitted Site 1 Melaleuca nesophila :: Pink Melaleuca 93 39 McCoppin St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   01/30/1995 12:00:00 AM     Permit Number 34597 6006368.06236527 2109117.19408355 37.7715938820876 -122.421352936259 (37.7715938820876, -122.421352936259)
100012 37107 Permitted Site 1 Melaleuca nesophila :: Pink Melaleuca 93 4501 Irving St 6 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 06/01/1998 12:00:00 AM     Permit Number 39705 5981809.38189346 2106215.79884963 37.7622122675222 -122.506086203855 (37.7622122675222, -122.506086203855)
100449 35513 Permitted Site 1 Melaleuca nesophila :: Pink Melaleuca 93 3488 22nd St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 10/21/2006 12:00:00 AM     Permit Number 38915 6005128.06949501 2103142.26204564 37.755118149138 -122.42521691501899 (37.755118149138, -122.425216915019)
102014 31632 Permitted Site 1 Melaleuca nesophila :: Pink Melaleuca 93 2518 Great Hwy 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 05/22/1995 12:00:00 AM     Permit Number 35149 5981501.18115239 2097930.22205683 37.7394442612499 -122.506537629785 (37.7394442612499, -122.506537629785)
103759 40210 Permitted Site 1 Melaleuca nesophila :: Pink Melaleuca 93 418 45th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 05/06/1999 12:00:00 AM     Permit Number 41392 5981924.63262302 2112926.84029829 37.780645617869894 -122.506185243392 (37.7806456178699, -122.506185243392)
104329 37633 Permitted Site 1 Melaleuca nesophila :: Pink Melaleuca 93 793 18th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 06/26/1998 12:00:00 AM     Permit Number 40051 5990357.97842308 2109989.05024853 37.773072107347495 -122.476795862973 (37.7730721073475, -122.476795862973)
104475 46397 Permitted Site 1 Melaleuca nesophila :: Pink Melaleuca 93 2363 46th Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   03/05/2002 12:00:00 AM     Permit Number 44628 5982038.69993379 2099019.08157606 37.7424656032555 -122.504759817001 (37.7424656032555, -122.504759817001)
104871 40219 Permitted Site 1 Melaleuca nesophila :: Pink Melaleuca 93 165 Seal Rock Dr 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 05/06/1999 12:00:00 AM     Permit Number 41398 5981062.91201163 2112924.76539407 37.780589154708295 -122.50916613998699 (37.7805891547083, -122.509166139987)
106401 39832 Permitted Site 1 Melaleuca nesophila :: Pink Melaleuca 93 1900 48th Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 01/06/1999 12:00:00 AM     Permit Number 41153 5981364.12857436 2102124.06115885 37.7509513011754 -122.507322554156 (37.7509513011754, -122.507322554156)
107890 35514 Permitted Site 1 Melaleuca nesophila :: Pink Melaleuca 93 3492 22nd St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 03/23/1998 12:00:00 AM     Permit Number 38916 6005101.49857239 2103140.39099496 37.7551115105514 -122.425308671927 (37.7551115105514, -122.425308671927)
109235 31643 Permitted Site 1 Melaleuca nesophila :: Pink Melaleuca 93 3601 Taraval St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 05/22/1995 12:00:00 AM     Permit Number 35157 5982065.15070434 2098736.73871701 37.7416919237879 -122.504647444825 (37.7416919237879, -122.504647444825)
109535 31636 Permitted Site 1 Melaleuca nesophila :: Pink Melaleuca 93 2542 Great Hwy 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 10/29/1996 12:00:00 AM     Permit Number 37115 5981513.83287394 2097774.63274006 37.73901780088121 -122.506482350919 (37.7390178008812, -122.506482350919)
109875 39831 Permitted Site 1 Melaleuca nesophila :: Pink Melaleuca 93 1900 48th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 01/06/1999 12:00:00 AM     Permit Number 41153 5981364.12857436 2102124.06115885 37.7509513011754 -122.507322554156 (37.7509513011754, -122.507322554156)
110105 31641 Permitted Site 1 Melaleuca nesophila :: Pink Melaleuca 93 2594 Great Hwy 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 05/22/1995 12:00:00 AM     Permit Number 35156 5981541.24493631 2097437.52256583 37.738093803256 -122.50636258222201 (37.738093803256, -122.506362582222)
110594 44258 Permitted Site 1 Melaleuca nesophila :: Pink Melaleuca 93 401 Diamond St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   02/20/2001 12:00:00 AM     Permit Number 43691 6001829.66372376 2103503.31899472 37.7559226344565 -122.436649584408 (37.7559226344565, -122.436649584408)
110671 40211 Permitted Site 1 Melaleuca nesophila :: Pink Melaleuca 93 418 45th Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   05/06/1999 12:00:00 AM     Permit Number 41392 5981924.63262302 2112926.84029829 37.780645617869894 -122.506185243392 (37.7806456178699, -122.506185243392)
112258 114673 Permitted Site 1 Melaleuca nesophila :: Pink Melaleuca 93 85X Peralta Ave 3 Side Yard : Yard 17 Tree 1 Private 1   11/30/2015 12:00:00 AM     Permit Number 775155 6010502.29579 2100335.12269 37.7477125069204 -122.40643339757601 (37.7477125069204, -122.406433397576)
112675 48954 Permitted Site 1 Melaleuca nesophila :: Pink Melaleuca 93 1425 Florida St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 11/26/2002 12:00:00 AM     Permit Number 46141 6009586.08390989 2100908.24074194 37.7492348647629 -122.409642067631 (37.7492348647629, -122.409642067631)
113920 40206 Permitted Site 1 Melaleuca nesophila :: Pink Melaleuca 93 540 43rd Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 05/06/1999 12:00:00 AM     Permit Number 41388 5982575.37732497 2112101.53347145 37.778417854750096 -122.503872900243 (37.7784178547501, -122.503872900243)
114723 31628 Permitted Site 1 Melaleuca nesophila :: Pink Melaleuca 93 2518 47th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 05/22/1995 12:00:00 AM     Permit Number 35145 5981817.84640139 2097939.09313644 37.7394872587943 -122.505443416468 (37.7394872587943, -122.505443416468)
117097 39998 Permitted Site 1 Melaleuca nesophila :: Pink Melaleuca 93 880 Innes Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 02/03/1999 12:00:00 AM     Permit Number 41256 6019141.64317919 2094551.4292426002 37.732311146345296 -122.376157653218 (37.7323111463453, -122.376157653218)
120495 37116 Permitted Site 1 Melaleuca nesophila :: Pink Melaleuca 93 4542 Irving St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 06/01/1998 12:00:00 AM     Permit Number 39708 5981682.74450716 2106263.49145698 37.762335762281 -122.506527724058 (37.762335762281, -122.506527724058)
121472 37635 Permitted Site 1 Melaleuca nesophila :: Pink Melaleuca 93 797 18th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 06/26/1998 12:00:00 AM     Permit Number 40053 5990358.92841621 2109962.95608948 37.7730005150319 -122.476790669979 (37.7730005150319, -122.476790669979)
121538 49208 Permitted Site 1 Melaleuca nesophila :: Pink Melaleuca 93 1425 Waller St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   02/05/2003 12:00:00 AM     Permit Number 46297 5998885.49389444 2108307.84265086 37.768946901017706 -122.447177209779 (37.7689469010177, -122.447177209779)
122101 39993 Permitted Site 1 Melaleuca nesophila :: Pink Melaleuca 93 860 Innes Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 01/27/1999 12:00:00 AM     Permit Number 41251 6019175.31340513 2094526.32452806 37.73224406729229 -122.376039506051 (37.7322440672923, -122.376039506051)
122518 39825 Permitted Site 1 Melaleuca nesophila :: Pink Melaleuca 93 2311 46th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 01/06/1999 12:00:00 AM     Permit Number 41150 5982026.95424167 2099360.52748006 37.7434024282005 -122.504825724634 (37.7434024282005, -122.504825724634)
123186 31639 Permitted Site 1 Melaleuca nesophila :: Pink Melaleuca 93 2594 Great Hwy 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 05/22/1995 12:00:00 AM     Permit Number 35156 5981541.24493631 2097437.52256583 37.738093803256 -122.50636258222201 (37.738093803256, -122.506362582222)
128271 119904 Undocumented 2 Melaleuca nesophila :: Pink Melaleuca 93 517 Laidley St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   6003302.0 2096146.0 37.7358047110715 -122.43103267909099 (37.7358047110715, -122.431032679091)
129052 39836 Permitted Site 1 Melaleuca nesophila :: Pink Melaleuca 93 2048 Great Hwy 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 01/06/1999 12:00:00 AM     Permit Number 41158 5981224.57274912 2101126.86261798 37.7482050538241 -122.50773115252399 (37.7482050538241, -122.507731152524)
129115 40541 Permitted Site 1 Melaleuca nesophila :: Pink Melaleuca 93 389 San Benito Way 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 06/30/2005 12:00:00 AM     Permit Number 48035 5992634.70647519 2093966.0670834 37.7292089323345 -122.467754881103 (37.7292089323345, -122.467754881103)
129256 39830 Permitted Site 1 Melaleuca nesophila :: Pink Melaleuca 93 1900 48th Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 01/06/1999 12:00:00 AM     Permit Number 41153 5981364.12857436 2102124.06115885 37.7509513011754 -122.507322554156 (37.7509513011754, -122.507322554156)
139347 51245 Permitted Site 1 Melaleuca nesophila :: Pink Melaleuca 93 35 Majestic Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 08/17/2004 12:00:00 AM     Permit Number 47620 5997371.20755939 2089722.08093206 37.7178282993487 -122.451074550694 (37.7178282993487, -122.451074550694)
139703 31626 Permitted Site 1 Melaleuca nesophila :: Pink Melaleuca 93 2562 46th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 05/22/1995 12:00:00 AM     Permit Number 35143 5982137.33816038 2097664.20833434 37.738751296749705 -122.50431841396299 (37.7387512967497, -122.504318413963)
140057 31631 Permitted Site 1 Melaleuca nesophila :: Pink Melaleuca 93 2506 Great Hwy 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 09/09/2000 12:00:00 AM     Permit Number 35148 5981494.85529112 2098008.01672128 37.739657491429796 -122.506565269459 (37.7396574914298, -122.506565269459)
140746 44259 Permitted Site 1 Melaleuca nesophila :: Pink Melaleuca 93 401 Diamond St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   02/20/2001 12:00:00 AM     Permit Number 43691 6001829.66372376 2103503.31899472 37.7559226344565 -122.436649584408 (37.7559226344565, -122.436649584408)
140797 37132 Permitted Site 1 Melaleuca nesophila :: Pink Melaleuca 93 4447 Kirkham St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 06/01/1998 12:00:00 AM     Permit Number 39714 5981086.08651436 2104832.07084282 37.7583703439041 -122.508485038953 (37.7583703439041, -122.508485038953)
141727 38353 Permitted Site 1 Melaleuca nesophila :: Pink Melaleuca 93 1800 48th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/31/1998 12:00:00 AM     Permit Number 40421 5981341.25756614 2102804.1865841 37.7528173861664 -122.507452100184 (37.7528173861664, -122.507452100184)
142338 43216 Permitted Site 1 Melaleuca nesophila :: Pink Melaleuca 93 44 Dunsmuir St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/11/2000 12:00:00 AM     Permit Number 43006 6008111.99433178 2094081.5468642 37.73040755168461 -122.41425657074 (37.7304075516846, -122.41425657074)
142496 31633 Permitted Site 1 Melaleuca nesophila :: Pink Melaleuca 93 2522 Great Hwy 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 05/22/1995 12:00:00 AM     Permit Number 35150 5981503.28977265 2097904.29050404 37.739373184525704 -122.506528416597 (37.7393731845257, -122.506528416597)
144523 30672 Permitted Site 1 Melaleuca nesophila :: Pink Melaleuca 93 39 McCoppin St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 03/08/2003 12:00:00 AM     Permit Number 34597 6006368.06236527 2109117.19408355 37.7715938820876 -122.421352936259 (37.7715938820876, -122.421352936259)
145753 31644 Permitted Site 1 Melaleuca nesophila :: Pink Melaleuca 93 3601 Taraval St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 05/22/1995 12:00:00 AM     Permit Number 35157 5982065.15070434 2098736.73871701 37.7416919237879 -122.504647444825 (37.7416919237879, -122.504647444825)
28357 31627 Permitted Site 1 Melaleuca nesophila :: Pink Melaleuca 93 2430 47th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 05/22/1995 12:00:00 AM 0   Permit Number 35144 5981797.10260903 2098537.8771738 37.7411301336904 -122.50555951218399 (37.7411301336904, -122.505559512184)
36904 31305 Permitted Site 1 Melaleuca nesophila :: Pink Melaleuca 93 561 Birch St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 04/12/1995 12:00:00 AM 0   Permit Number 34946 6005105.48028119 2111430.55673025 37.7778745481219 -122.425884980842 (37.7778745481219, -122.425884980842)
134786 37114 Permitted Site 1 Melaleuca nesophila :: Pink Melaleuca 93 4540 Irving St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 06/01/1998 12:00:00 AM 0   Permit Number 39707 5981688.69009077 2106263.69511954 37.7623366715481 -122.506507175967 (37.7623366715481, -122.506507175967)
135660 37119 Permitted Site 1 Melaleuca nesophila :: Pink Melaleuca 93 4731 Irving St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 06/01/1998 12:00:00 AM 0   Permit Number 39709 5981101.19035238 2106191.54023256 37.762103946482505 -122.508533725105 (37.7621039464825, -122.508533725105)
150825 31310 Permitted Site 1 Melaleuca nesophila :: Pink Melaleuca 93 577 Birch St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 04/12/1995 12:00:00 AM 0   Permit Number 34948 6005032.34705274 2111420.35666119 37.777842407995294 -122.42613724809999 (37.7778424079953, -122.4261372481)
157476 31309 Permitted Site 1 Melaleuca nesophila :: Pink Melaleuca 93 577 Birch St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 04/12/1995 12:00:00 AM 0   Permit Number 34948 6005032.34705274 2111420.35666119 37.777842407995294 -122.42613724809999 (37.7778424079953, -122.4261372481)
164869 37115 Permitted Site 1 Melaleuca nesophila :: Pink Melaleuca 93 4540 Irving St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 06/01/1998 12:00:00 AM 0   Permit Number 39707 5981688.69009077 2106263.69511954 37.7623366715481 -122.506507175967 (37.7623366715481, -122.506507175967)
174810 31307 Permitted Site 1 Melaleuca nesophila :: Pink Melaleuca 93 569 Birch St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 04/12/1995 12:00:00 AM 0   Permit Number 34947 6005068.91365842 2111425.45669453 37.7778584781223 -122.42601111452801 (37.7778584781223, -122.426011114528)
178533 31308 Permitted Site 1 Melaleuca nesophila :: Pink Melaleuca 93 569 Birch St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 04/12/1995 12:00:00 AM 0   Permit Number 34947 6005068.91365842 2111425.45669453 37.7778584781223 -122.42601111452801 (37.7778584781223, -122.426011114528)
180771 31306 Permitted Site 1 Melaleuca nesophila :: Pink Melaleuca 93 561 Birch St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 04/12/1995 12:00:00 AM 0   Permit Number 34946 6005105.48028119 2111430.55673025 37.7778745481219 -122.425884980842 (37.7778745481219, -122.425884980842)
182887 37113 Permitted Site 1 Melaleuca nesophila :: Pink Melaleuca 93 4523 IRVING ST 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 06/01/1998 12:00:00 AM 0   Permit Number 39706 5981665.2 2106185.8 37.7621214108202 -122.506582640723 (37.7621214108202, -122.506582640723)
187630 47074 Permitted Site 1 Melaleuca nesophila :: Pink Melaleuca 93 106 Beaumont Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 05/03/2002 12:00:00 AM 0   Permit Number 45062 5996796.88091549 2112360.28017641 37.7799542788822 -122.454694357616 (37.7799542788822, -122.454694357616)
159827 193548 DPW Maintained 3 Melaleuca nesophila :: Pink Melaleuca 93 1300x De Haro St 12 Median : Yard 3 Tree 1 DPW 2     1     6012271.58863 2102171.1791 37.7528527402726 -122.400444188549 (37.7528527402726, -122.400444188549)
5374 120897 Undocumented 2 Melaleuca nesophila :: Pink Melaleuca 93 3760 Webster St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   10/04/2016 12:00:00 AM 3 2x5 Permit Number 778876 6002560.418 2121574.39052 37.805582749215105 -122.43541504397301 (37.8055827492151, -122.435415043973)
54311 46406 Permitted Site 1 Melaleuca nesophila :: Pink Melaleuca 93 2443 44th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/03/2008 12:00:00 AM 3 3x3 Permit Number 51149 5982682.2949 2098486.1858 37.741040257888706 -122.50249506178801 (37.7410402578887, -122.502495061788)
56979 193543 Undocumented 2 Melaleuca nesophila :: Pink Melaleuca 93 610 22nd St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 5ft   6016026.74063 2103985.73325 37.7580438195766 -122.38758464502399 (37.7580438195766, -122.387584645024)
80926 87297 Permitted Site 1 Melaleuca nesophila :: Pink Melaleuca 93 4227 Lincoln Way   Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   10/16/2014 12:00:00 AM 3 3x3 Permit Number 773956 5982573.0 2106897.6 37.764129220397294 -122.50349567213001 (37.7641292203973, -122.50349567213)
81132 15073 DPW Maintained 3 Melaleuca nesophila :: Pink Melaleuca 93 30X Minerva St 5 Median : Cutout 11 Tree 1 DPW 2     3 11   5996426.1222644 2089040.1488729 37.7159017196126 -122.45429204268801 (37.7159017196126, -122.454292042688)
89003 15081 DPW Maintained 3 Melaleuca nesophila :: Pink Melaleuca 93 80X Minerva St 2 Median : Cutout 11 Tree 1 DPW 2     3 11   5996060.1066716 2089044.9734463 37.7158939701237 -122.455557504311 (37.7158939701237, -122.455557504311)
186695 193542 Undocumented 2 Melaleuca nesophila :: Pink Melaleuca 93 610 22nd St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 5ft   6016043.65792 2103986.82395 37.7580477514291 -122.387526213378 (37.7580477514291, -122.387526213378)
53662 210096 Undocumented 2 Melaleuca nesophila :: Pink Melaleuca 93 300 Junipero Serra Blvd 45 : 4 Tree 1 Private 1     4 Width 0ft   5991386.500659999 2094355.8588400001 37.73020705030461 -122.47209839385201 (37.7302070503046, -122.472098393852)
61265 184530 Undocumented 2 Melaleuca nesophila :: Pink Melaleuca 93 4045 Ortega St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 0ft   5981394.5999 2102116.7749 37.7509330899515 -122.50721664272801 (37.7509330899515, -122.507216642728)
131557 210095 DPW Maintained 3 Melaleuca nesophila :: Pink Melaleuca 93 1x Minerva St 47 Median : Cutout 11 Tree 1 DPW 2     4 Width 0ft   5996479.95925 2088997.21564 37.7157869222034 -122.454102858955 (37.7157869222034, -122.454102858955)
176806 38370 Permitted Site 1 Melaleuca nesophila :: Pink Melaleuca 93 4245 Lawton St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 01/06/1999 12:00:00 AM 4   Permit Number 41159 5981126.11155374 2104152.1959616 37.7565059606627 -122.508296152224 (37.7565059606627, -122.508296152224)
6133 27582 Permitted Site 1 Melaleuca nesophila :: Pink Melaleuca 93 1777 Turk St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   08/25/2015 12:00:00 AM 5 3X3   6001533.8276 2112150.0507 37.7796476052413 -122.438292110376 (37.7796476052413, -122.438292110376)
17904 27583 Permitted Site 1 Melaleuca nesophila :: Pink Melaleuca 93 1781 Turk St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   08/25/2015 12:00:00 AM 5 3X3   6001531.97079 2112100.50741 37.7795114663002 -122.43829498357901 (37.7795114663002, -122.438294983579)
45817 39814 Permitted Site 1 Melaleuca nesophila :: Pink Melaleuca 93 2079 45th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 01/06/1999 12:00:00 AM 5   Permit Number 41145 5982286.3414 2100973.7552 37.747847159841704 -122.50404831238701 (37.7478471598417, -122.504048312387)
56108 183035 Undocumented 2 Melaleuca nesophila :: Pink Melaleuca 93 2522 Lower Great Hwy 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 0ft   5981504.4178 2097898.5163 37.7393573965741 -122.506524088332 (37.7393573965741, -122.506524088332)
137605 80263 Permitted Site 1 Melaleuca nesophila :: Pink Melaleuca 93 2074 45th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   06/09/2008 12:00:00 AM 5 3x3 Permit Number 50734 5982335.751 2100990.6763 37.747896525944796 -122.50387871228399 (37.7478965259448, -122.503878712284)
146438 43057 Permitted Site 1 Melaleuca nesophila :: Pink Melaleuca 93 1922 48th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 10/27/2010 12:00:00 AM 5 3x3 Permit Number 53821 5981365.4957 2101971.9303 37.750533673272706 -122.507306541093 (37.7505336732727, -122.507306541093)
174219 40023 Permitted Site 1 Melaleuca nesophila :: Pink Melaleuca 93 1571 McKinnon Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 02/03/1999 12:00:00 AM 5   Permit Number 41268 6015526.3634 2095776.2911 37.73547467040311 -122.388742090508 (37.7354746704031, -122.388742090508)
180522 250985 Undocumented 2 Melaleuca nesophila :: Pink Melaleuca 93 169 Seal Rock Dr 1 : 4 Tree 1 Private 1     5 Width 3ft   5981053.81587 2112927.8042099997 37.7805969621145 -122.509197833038 (37.7805969621145, -122.509197833038)
59532 250982 Undocumented 2 Melaleuca nesophila :: Pink Melaleuca 93 145 Seal Rock Dr 2 : 4 Tree 1 Private 1     6 Width 3ft   5981196.97714 2112934.78303 37.7806245632172 -122.50870309708901 (37.7806245632172, -122.508703097089)
71380 141700 Undocumented 2 Melaleuca nesophila :: Pink Melaleuca 93 150 BEAUMONT AVE 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 0ft   5996841.3555 2111986.1699 37.778929621332004 -122.454513467721 (37.778929621332, -122.454513467721)
71672 46376 Permitted Site 1 Melaleuca nesophila :: Pink Melaleuca 93 2231 43rd Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 03/05/2002 12:00:00 AM 6   Permit Number 44613 5982943.5226 2099924.3833 37.7450044993486 -122.501698223647 (37.7450044993486, -122.501698223647)
136846 39815 Permitted Site 1 Melaleuca nesophila :: Pink Melaleuca 93 2090 45th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 01/06/1999 12:00:00 AM 6   Permit Number 41146 5982333.7204 2100889.1498 37.747617643049104 -122.50387821553801 (37.7476176430491, -122.503878215538)

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