Street_Tree_List

Data source: data.sfgov.org

977 rows where qSpecies = 48 sorted by rowid descending

View and edit SQL

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

Link rowid ▲ TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
189111 227095 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 3651 20th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 6ft   6005946.521790001 2104309.35666 37.7583689226977 -122.422469389447 (37.7583689226977, -122.422469389447)
188942 227580 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 23 Belcher St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 3ft   6003811.04552 2108200.21185 37.7689315761679 -122.430132375016 (37.7689315761679, -122.430132375016)
188753 129387 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 2507 Larkin St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 3ft   6006679.63776 2119843.90732 37.801064360981606 -122.42103693222602 (37.8010643609816, -122.421036932226)
188573 206988 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 1304 11th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 2ft   5992723.70798 2106532.5962799997 37.76371854889079 -122.468361066814 (37.7637185488908, -122.468361066814)
188215 183121 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 2327 41st Ave 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 0ft   5983581.7952 2099373.3538 37.7435289932417 -122.49945051311 (37.7435289932417, -122.49945051311)
187717 227565 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 290 Douglass St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     9 Width 3ft   6001097.22568 2104712.62438 37.7592014422066 -122.43926926488501 (37.7592014422066, -122.439269264885)
187586 227141 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 266 Rivoli St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 3ft   5997670.57496 2105917.36363 37.7623137611024 -122.451207095032 (37.7623137611024, -122.451207095032)
187445 176900 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 167 Madison St 3 Sidewalk: Property side : Yard 9 Tree 1 Private 1     1 Width 4ft   6005606.72127 2092829.9713400002 37.7268299557374 -122.42282875044701 (37.7268299557374, -122.422828750447)
187437 119231 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 4327 Cabrillo St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 3ft   5982159.48772 2110285.61161 37.7734074014784 -122.505176976845 (37.7734074014784, -122.505176976845)
187386 129377 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 2500 Steiner St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 4ft   6002239.2844 2116842.37021 37.7925716168296 -122.43618752203699 (37.7925716168296, -122.436187522037)
187240 191224 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 2350 20th St 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     4     6011129.67031 2104650.44992 37.7595965215873 -122.404567686256 (37.7595965215873, -122.404567686256)
187121 58124 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 527 15th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   02/10/1978 12:00:00 AM 1   Permit Number 17106 5991241.869630001 2111793.32926 37.778077396785 -122.473870058582 (37.778077396785, -122.473870058582)
186693 247762 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 61 Alpine Ter 1 : 4 Tree 1 Private 1     5 Width 3ft   6001652.093859999 2108463.90123 37.769533087721896 -122.437618918075 (37.7695330877219, -122.437618918075)
186541 206994 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 607 Judah St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 3ft   5992653.289 2105901.13559 37.761980656709 -122.468558674846 (37.761980656709, -122.468558674846)
186108 176878 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 526 Lathrop Ave 17 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 3ft   6013154.94381 2086496.55313 37.709862662502104 -122.396290845073 (37.7098626625021, -122.396290845073)
185857 227155 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 3460 20th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 3ft   6007164.41586 2104418.82 37.758738113297795 -122.418265124561 (37.7587381132978, -122.418265124561)
185807 182658 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 2242 Ortega St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 0ft   5987004.6631 2102364.6195 37.751942436508706 -122.487834969288 (37.7519424365087, -122.487834969288)
185174 227098 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 1646 Alabama St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 3ft   6009270.38668 2099790.7272200002 37.7461487242839 -122.41065485095801 (37.7461487242839, -122.410654850958)
185083 227152 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 19 Stoneman St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 4ft   6008287.17043 2099413.88012 37.7450588116185 -122.414028044267 (37.7450588116185, -122.414028044267)
184902 95429 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 1437 23rd Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 03/01/2011 12:00:00 AM 2 3x3 Permit Number 767294 5988962.2823 2105532.8441 37.760755525792 -122.48129730761801 (37.760755525792, -122.481297307618)
184622 93188 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 1675 Jerrold Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   02/18/2010 12:00:00 AM 10 3x3 Permit Number 53196 6014934.44131 2097265.12572 37.73952988128521 -122.39089262491001 (37.7395298812852, -122.39089262491)
184324 191220 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 2300 18th St 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 4ft   6010900.2167 2105543.22676 37.762035060293 -122.405424130428 (37.762035060293, -122.405424130428)
183878 176896 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 70 La Grande Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 2ft   6005242.33299 2091887.7351799998 37.7242222149627 -122.424021456542 (37.7242222149627, -122.424021456542)
183647 80237 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 1675 35th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1   2     5985295.5529 2103816.7715 37.7558298048279 -122.49385223473601 (37.7558298048279, -122.493852234736)
183576 227102 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 1451 Sanchez St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     13 Width 6ft   6003961.991330001 2099782.46881 37.745826997234104 -122.42901002020001 (37.7458269972341, -122.4290100202)
183197 129383 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 91 McAllister St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 4ft   6008721.10925 2112450.3341200002 37.7808782799549 -122.413449351208 (37.7808782799549, -122.413449351208)
182506 83202 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 405 27th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1   4     5987450.31295 2113217.36399 37.7817670537285 -122.487090859235 (37.7817670537285, -122.487090859235)
182444 227104 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 35 Carmel St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 4ft   5998773.50017 2105374.28879 37.76088570063521 -122.44735341554701 (37.7608857006352, -122.447353415547)
181980 60927 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 1506 Silver Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   06/13/1983 12:00:00 AM 5   Permit Number 20728 6010428.9415 2094674.9694599998 37.732166840331104 -122.406288313254 (37.7321668403311, -122.406288313254)
180870 227099 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 75 Montcalm St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 3ft   6010635.77556 2100089.10311 37.7470444571367 -122.40595450111401 (37.7470444571367, -122.405954501114)
180853 227108 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 102 Anderson St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 3ft   6007939.95228 2098099.81155 37.741431163228604 -122.41513566820299 (37.7414311632286, -122.415135668203)
180458 227096 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 3639 20th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 5ft   6006022.631569999 2104312.28056 37.7583812443163 -122.422206375532 (37.7583812443163, -122.422206375532)
180255 207036 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 1645 Ulloa St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 3ft   5990861.16949 2098351.90974 37.7411487751831 -122.474205983836 (37.7411487751831, -122.474205983836)
180010 118666 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 465 43rd Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 4ft   5982506.22463 2112651.7557200002 37.779924536981504 -122.50415288931299 (37.7799245369815, -122.504152889313)
179963 227566 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 91 Clover Ln 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 5ft   6000468.027480001 2104951.63177 37.7598218728073 -122.44146247932301 (37.7598218728073, -122.441462479323)
179922 227114 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 1168 Treat Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 3ft   6008645.7783699995 2101760.1601299997 37.7515213083843 -122.412953897625 (37.7515213083843, -122.412953897625)
179813 137671 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 756 LYON ST 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 0ft   6000049.6788 2111547.4906 37.7779086039439 -122.443383113797 (37.7779086039439, -122.443383113797)
179772 176916 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 380 Rolph St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 3ft   6001888.93185 2087835.8979599997 37.7129068748214 -122.43532396063601 (37.7129068748214, -122.435323960636)
179306 95828 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 174 Langton St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 08/29/2011 12:00:00 AM 6 3x3 Permit Number 767563 6010564.55165 2110346.83579 37.775205897855 -122.40692364921301 (37.775205897855, -122.406923649213)
179235 191222 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 1143 Mariposa St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 3ft   6013778.5148599995 2106149.81223 37.76386112381729 -122.39551163825001 (37.7638611238173, -122.39551163825)
179043 201807 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 273 Friedell St 1 : 4 Tree 1 Private 1     2 Width 6ft   6020893.117219999 2092989.08595 37.728117517799795 -122.36999438334298 (37.7281175177998, -122.369994383343)
178920 201812 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 101 Friedell St 3 : 4 Tree 1 Private 1     1 Width 6ft   6021065.67541 2093224.76894 37.728774126326705 -122.369414113788 (37.7287741263267, -122.369414113788)
178499 227109 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 72 Gates St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 3ft   6008318.15108 2098296.22562 37.741991719651 -122.41384187381 (37.741991719651, -122.41384187381)
178180 207030 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 835 Sargent St 2 : 4 Tree 1 Private 1     7 Width 3ft   5991738.49074 2089190.01168 37.716043271265704 -122.470505441771 (37.7160432712657, -122.470505441771)
178120 181690 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 1374 45th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 0ft   5982168.1662 2105754.9295 37.760967965591604 -122.504811174863 (37.7609679655916, -122.504811174863)
178063 83917 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 1484 47th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   01/24/2008 12:00:00 AM 4 3x3 Permit Number 50173 5981576.71105327 2104986.37444115 37.75882292099771 -122.50679971705401 (37.7588229209977, -122.506799717054)
178000 95108 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 445 Cayuga Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 12/28/2010 12:00:00 AM 5 3x3 Permit Number 54037 6002085.32525 2093826.71651 37.7293674729177 -122.435073368138 (37.7293674729177, -122.435073368138)
177664 118188 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 762 34th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 3ft   5985415.78787 2110692.34221 37.7747152280145 -122.49394311659901 (37.7747152280145, -122.493943116599)
177014 95521 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 1510 35th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 03/01/2011 12:00:00 AM 1 3x3 Permit Number 767313 5985302.4962 2104889.3961 37.7587753414156 -122.49390726731899 (37.7587753414156, -122.493907267319)
176471 182700 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 1651 Moraga St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 0ft   5989102.9459 2103739.8915 37.7558407372502 -122.48067956122401 (37.7558407372502, -122.480679561224)
176219 88398 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 405 27th Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/10/2008 12:00:00 AM 5 3x3 Permit Number 51376 5987449.923219999 2113199.01189 37.7817166413541 -122.48709085924 (37.7817166413541, -122.48709085924)
176002 95742 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 86 Ina Ct 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 09/07/2011 12:00:00 AM 5 3x3 Permit Number 767488 6004830.443109999 2091416.58174 37.7229052675357 -122.42541178684799 (37.7229052675357, -122.425411786848)
175916 227573 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 4658 18th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 3ft   6000184.94355 2105205.65777 37.7605032342671 -122.442459762729 (37.7605032342671, -122.442459762729)
175819 117934 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 867 42nd Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 3ft   5982916.92515 2109877.9656700003 37.7723326617078 -122.502526759002 (37.7723326617078, -122.502526759002)
175666 49818 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 1300 De Haro St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 06/11/2003 12:00:00 AM 7 3x3 Permit Number 46609 6012222.38132 2102319.17957 37.7532563730854 -122.400624753529 (37.7532563730854, -122.400624753529)
175623 184549 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 3501 Moraga St 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     1 Width 0ft   5983411.1343 2103548.3965 37.754982490057 -122.50034921882099 (37.754982490057, -122.500349218821)
174850 60223 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 1230 Mason St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   06/30/2009 12:00:00 AM 8 3x3 Permit Number 52240 6009426.5919699995 2117542.6242 37.7949000677337 -122.41136858440399 (37.7949000677337, -122.411368584404)
174682 31938 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 1335 47th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   01/29/2008 12:00:00 AM 4 3x3 Permit Number 50210 5981495.7067 2105969.8095 37.761518381611 -122.507152818801 (37.761518381611, -122.507152818801)
174335 48448 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 238 Cole St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/31/2002 12:00:00 AM 7   Permit Number 45820 5997868.1487 2109737.2703 37.7728135614974 -122.45079920226999 (37.7728135614974, -122.45079920227)
174137 84659 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 187 Beaumont Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1   1     5996845.0781 2111686.6666 37.7781074773999 -122.45447894833201 (37.7781074773999, -122.454478948332)
174068 45661 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 315 London St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 12/03/2005 12:00:00 AM 6   Permit Number 44357 6002302.86118 2091870.5211200002 37.72400855223739 -122.43418153744899 (37.7240085522374, -122.434181537449)
174051 176889 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 277 Athens St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 3ft   6004392.5622 2091665.65248 37.7235644112504 -122.42694318119499 (37.7235644112504, -122.426943181195)
173618 207031 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 1528 11th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 3ft   5992776.06817 2105054.20165 37.7596622898883 -122.46807242402599 (37.7596622898883, -122.468072424026)
173458 184640 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 1650 42nd Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 0ft   5983160.9711 2103902.0944 37.7559389581009 -122.501240500695 (37.7559389581009, -122.501240500695)
173018 227119 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 799 Duncan St 4 Sidewalk: Property side : Yard 9 Tree 1 Private 1     11 Width 4ft   6001473.16561 2099668.76787 37.7453736076231 -122.437607869022 (37.7453736076231, -122.437607869022)
172938 176884 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 96 Alpha St 2 Front Yard : Yard 7 Tree 1 Private 1     1     6011062.55449 2088258.87965 37.7145850034576 -122.40364648639601 (37.7145850034576, -122.403646486396)
172906 207014 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 651 Joost Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 1ft   5997782.54111 2094977.3620200001 37.732281609092496 -122.45003132048201 (37.7322816090925, -122.450031320482)
172851 129382 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 91 McAllister St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 4ft   6008704.563080001 2112447.63135 37.7808699297471 -122.41350640150401 (37.7808699297471, -122.413506401504)
172822 207034 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 100 Quintara St 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     4 Width 3ft   5993127.0368800005 2101215.11136 37.7491414027515 -122.466579558421 (37.7491414027515, -122.466579558421)
172334 227113 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 201 Ogden Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 2ft   6007896.8692 2096132.1903 37.736026086627 -122.415145389863 (37.736026086627, -122.415145389863)
172020 184126 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 1643 32nd Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 0ft   5986219.0266 2104040.7857 37.756498872957394 -122.490675089245 (37.7564988729574, -122.490675089245)
171469 227092 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 100 Alemany Blvd 30 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     3 Width 9ft   6009197.49082 2095788.0482299998 37.7351541534232 -122.410624304588 (37.7351541534232, -122.410624304588)
171343 83264 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 483 Paris St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/01/2009 12:00:00 AM 8 3x3 Permit Number 52321 6001958.211069999 2090814.3138299999 37.721088877137795 -122.43529742254 (37.7210888771378, -122.43529742254)
171144 176918 DPW Maintained 3 Lagunaria patersonii :: Primrose Tree 48 1041x Naples St 9 Median : Yard 3 Tree 1 DPW 2     4     6001604.803669999 2088215.9120200002 37.713934169489704 -122.43633317895599 (37.7139341694897, -122.436333178956)
171127 227091 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 100 Alemany Blvd 29 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     8 Width 5ft   6009293.034440001 2095834.7354700002 37.735287702767 -122.410297269721 (37.735287702767, -122.410297269721)
171120 184598 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 1795 40th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 0ft   5983770.321 2103008.0087 37.7535198125919 -122.499067143504 (37.7535198125919, -122.499067143504)
171102 41786 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 101 15th St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 06/20/2000 12:00:00 AM 11   Permit Number 42194 6011862.446140001 2107450.91483 37.767326897836206 -122.40223026280898 (37.7673268978362, -122.402230262809)
171029 191247 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 1453 Hudson Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 6ft   6016461.47366 2096825.2224700002 37.7384066073881 -122.385582111127 (37.7384066073881, -122.385582111127)
170920 207016 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 409 Edna St 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 1ft   5998750.98669 2094179.12135 37.7301451967391 -122.446625784855 (37.7301451967391, -122.446625784855)
170912 227554 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 359 Douglass St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     9 Width 3ft   6001158.33464 2104306.33401 37.7580893450524 -122.439028803251 (37.7580893450524, -122.439028803251)
170816 227585 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 115 Fillmore St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 3ft   6003798.52213 2108785.73673 37.7705385756322 -122.430217470683 (37.7705385756322, -122.430217470683)
170337 227090 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 100 Alemany Blvd 22 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     8 Width 3ft   6009411.625 2095915.20486 37.7355153013828 -122.40989293540702 (37.7355153013828, -122.409892935407)
169835 227154 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 211 San Jose Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 3ft   6006179.62036 2101927.37044 37.751841686457894 -122.42149406392001 (37.7518416864579, -122.42149406392)
169727 227134 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 200 Portola Dr 10 : 4 Tree 1 Private 1     3 Width 3ft   5999484.90108 2100375.94772 37.747202105595 -122.44453375672501 (37.747202105595, -122.444533756725)
169335 176907 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 769 Silver Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 3ft   6006492.037819999 2093629.408 37.7290749477448 -122.419824929392 (37.7290749477448, -122.419824929392)
169214 207041 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 1414 Plymouth Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     8 Width 3ft   5995889.45634 2093373.1410400001 37.727768297568005 -122.456460143934 (37.727768297568, -122.456460143934)
168844 92401 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 1215 35th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/29/2009 12:00:00 AM 2 3x3 Permit Number 52801 5985169.7 2106911.6 37.764319978357896 -122.494515603708 (37.7643199783579, -122.494515603708)
168588 227137 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 180 Parnassus Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 3ft   5997464.66679 2106771.33887 37.7646467688489 -122.451980864539 (37.7646467688489, -122.451980864539)
167979 95712 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 642 Athens St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 09/07/2011 12:00:00 AM 5 3x3 Permit Number 767468 6003074.18539 2089625.7401 37.7178886288451 -122.431355025819 (37.7178886288451, -122.431355025819)
167579 191218 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 477 Vermont St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 4ft   6011234.32907 2106146.16371 37.763709265180395 -122.40431099816901 (37.7637092651804, -122.404310998169)
167479 176902 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 676 Silver Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 3ft   6005861.557080001 2093540.1941099998 37.728794447392396 -122.421998219354 (37.7287944473924, -122.421998219354)
167364 182307 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 1509 29th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 0ft   5987118.7965 2104973.5941 37.7591126281614 -122.487631931758 (37.7591126281614, -122.487631931758)
167111 92440 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 1352 45th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/30/2009 12:00:00 AM 1 3x3 Permit Number 52830 5982162.933999999 2105885.2573 37.7613255007309 -122.504838927947 (37.7613255007309, -122.504838927947)
167057 227121 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 791 27th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 4ft   6001433.87774 2099966.59062 37.746189124520896 -122.437765046244 (37.7461891245209, -122.437765046244)
166777 207015 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 409 Edna St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 1ft   5998751.39592 2094165.7682599998 37.7301085556677 -122.44662340974101 (37.7301085556677, -122.446623409741)
166649 50185 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 139 25th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   11/01/2007 12:00:00 AM 6 3x3 Permit Number 49870 5987999.15348 2115065.15007 37.7868725355783 -122.485327781661 (37.7868725355783, -122.485327781661)
166344 118587 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 140 Point Lobos Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 3ft   5982334.052630001 2112627.33977 37.7798473711823 -122.504746689196 (37.7798473711823, -122.504746689196)
166285 251003 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 250 Point Lobos Ave 2 : 4 Tree 1 Private 1     3 Width 3ft   5981957.64195 2112675.6435700003 37.7799578490271 -122.506052420011 (37.7799578490271, -122.506052420011)
166221 120804 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 689 20th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 3ft   5989715.19561 2110680.27165 37.774932704327 -122.47906987573299 (37.774932704327, -122.479069875733)
166011 83491 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 1966 48th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   01/24/2008 12:00:00 AM 4 3x3 Permit Number 50181 5981376.6636 2101684.6102 37.7497454310313 -122.507246608859 (37.7497454310313, -122.507246608859)

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