Street_Tree_List

Data source: data.sfgov.org

977 rows where qSpecies = 48 sorted by TreeID

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
141 832 DPW Maintained 3 Lagunaria patersonii :: Primrose Tree 48 1396 47th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   03/28/2017 12:18:00 PM 3 3X3   5981551.7086 2105613.8347 37.7605442750604 -122.50693272862101 (37.7605442750604, -122.506932728621)
13263 835 DPW Maintained 3 Lagunaria patersonii :: Primrose Tree 48 1396X 48th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   02/21/2017 10:55:00 AM 3 3X3   5981242.3727 2105595.8151 37.7604765764936 -122.5080012238 (37.7604765764936, -122.5080012238)
2004 836 DPW Maintained 3 Lagunaria patersonii :: Primrose Tree 48 1396X 48th Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   02/21/2017 10:52:00 AM 3 3X3   5981241.3128 2105622.3145 37.7605492737866 -122.50800685617901 (37.7605492737866, -122.508006856179)
84495 840 DPW Maintained 3 Lagunaria patersonii :: Primrose Tree 48 1412 48th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   04/06/2015 01:14:00 PM 3 3x3   5981250.420684201 2105445.3666042998 37.7600639622975 -122.507962224252 (37.7600639622975, -122.507962224252)
20021 858 DPW Maintained 3 Lagunaria patersonii :: Primrose Tree 48 400X Alemany Blvd 4 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   07/24/2015 09:41:00 AM 3 3x3   6008130.35725 2095075.26223 37.7331371107843 -122.414263368055 (37.7331371107843, -122.414263368055)
5034 3513 DPW Maintained 3 Lagunaria patersonii :: Primrose Tree 48 201X Cargo Way 23 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   04/10/2017 11:31:00 AM 3 3X3   6018063.30501 2098072.0296400003 37.7419185912736 -122.38013031748699 (37.7419185912736, -122.380130317487)
4963 3516 DPW Maintained 3 Lagunaria patersonii :: Primrose Tree 48 201X Cargo Way 26 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   06/07/1996 12:00:00 AM 6 3X3   6018109.71439 2098036.73671 37.7418242442879 -122.379967395395 (37.7418242442879, -122.379967395395)
4939 3523 DPW Maintained 3 Lagunaria patersonii :: Primrose Tree 48 201X Cargo Way 33 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   04/10/2017 11:28:00 AM 3 3X3   6018216.35215 2097958.4950099997 37.741615290427106 -122.379593238756 (37.7416152904271, -122.379593238756)
4929 3534 DPW Maintained 3 Lagunaria patersonii :: Primrose Tree 48 201X Cargo Way 44 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   04/10/2017 11:10:00 AM 3 3X3   6018402.129369999 2097818.41667 37.7412409080406 -122.378941151133 (37.7412409080406, -122.378941151133)
5006 3538 DPW Maintained 3 Lagunaria patersonii :: Primrose Tree 48 201X Cargo Way 48 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   04/10/2017 10:28:00 AM 3 3X3   6018470.22426 2097768.00954 37.741106254339705 -122.37870220126999 (37.7411062543397, -122.37870220127)
5022 3539 DPW Maintained 3 Lagunaria patersonii :: Primrose Tree 48 201X Cargo Way 49 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   05/03/2017 08:08:00 AM 3 3X3   6018487.88793 2097755.11327 37.741071817512704 -122.378640230766 (37.7410718175127, -122.378640230766)
4944 3666 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 100X Cargo Way 102 Sidewalk: Curb side : Cutout 1 Tree 1 Port 9   05/02/2017 03:06:00 PM 3 3X3   6017134.48475 2098914.37607 37.744180216238604 -122.383400533034 (37.7441802162386, -122.383400533034)
5053 3667 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 100X Cargo Way 103 Sidewalk: Curb side : Cutout 1 Tree 1 Port 9   05/02/2017 03:19:00 PM 3 3X3   6017116.62756 2098928.27448 37.744217391521396 -122.38346324724199 (37.7442173915214, -122.383463247242)
4976 3673 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 100X Cargo Way 109 Sidewalk: Curb side : Cutout 1 Tree 1 Port 9   04/10/2017 10:21:00 AM 3 3X3   6017015.17172 2099002.6203400004 37.7444159222737 -122.38381923847601 (37.7444159222737, -122.383819238476)
4971 3674 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 100X Cargo Way 110 Sidewalk: Curb side : Cutout 1 Tree 1 Port 9   04/10/2017 10:22:00 AM 3 3X3   6016998.30504 2099015.89853 37.7444514490906 -122.383878484902 (37.7444514490906, -122.383878484902)
4933 3676 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 100X Cargo Way 112 Sidewalk: Curb side : Cutout 1 Tree 1 Port 9   04/10/2017 10:24:00 AM 3 3X3   6016964.487509999 2099042.50937 37.74452264751721 -122.38399727276101 (37.7445226475172, -122.383997272761)
4959 3681 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 100X Cargo Way 117 Sidewalk: Curb side : Cutout 1 Tree 1 Port 9   05/02/2017 03:27:00 PM 3 3X3   6016866.9573099995 2099120.49255 37.7447313810499 -122.384339945926 (37.7447313810499, -122.384339945926)
87607 11573 DPW Maintained 3 Lagunaria patersonii :: Primrose Tree 48 3906 Judah St 3 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   07/10/2015 07:56:00 AM 3 3X3   5982438.0 2105598.0 37.7605529521075 -122.50386633030199 (37.7605529521075, -122.503866330302)
165 11582 DPW Maintained 3 Lagunaria patersonii :: Primrose Tree 48 4000 Judah St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   03/28/2017 11:49:00 AM 3 3X3   5982109.291 2105604.0369 37.760550193841404 -122.505003612665 (37.7605501938414, -122.505003612665)
85269 11589 DPW Maintained 3 Lagunaria patersonii :: Primrose Tree 48 4050X Judah St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   09/19/2016 11:29:00 AM 3 3X3   5981992.356728501 2105594.1635633 37.760516204039604 -122.50540729614599 (37.7605162040396, -122.505407296146)
144 11598 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 4134 Judah St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   03/28/2017 11:51:00 AM 3 3X3   5981663.7126 2105589.2786 37.760483446414796 -122.506543543521 (37.7604834464148, -122.506543543521)
11460 11602 DPW Maintained 3 Lagunaria patersonii :: Primrose Tree 48 4150 Judah St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   05/06/2011 12:00:00 AM 3 3X3   5981591.6344 2105586.8054 37.7604724115264 -122.506792641078 (37.7604724115264, -122.506792641078)
113212 11603 DPW Maintained 3 Lagunaria patersonii :: Primrose Tree 48 4245 Judah St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   03/23/2015 05:31:00 PM 3 3X3   5981392.296520599 2105523.6051476 37.7602871413722 -122.507477357537 (37.7602871413722, -122.507477357537)
150 11606 DPW Maintained 3 Lagunaria patersonii :: Primrose Tree 48 4200x Judah St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   03/28/2017 11:54:00 AM 3 3X3   5981492.2847 2105581.1189 37.76045094714279 -122.507135818078 (37.7604509471428, -122.507135818078)
4258 19062 DPW Maintained 3 Lagunaria patersonii :: Primrose Tree 48 174 Sagamore St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   10/10/2017 08:47:00 AM 3 3X3   5995225.08055 2087462.80286 37.7115017488702 -122.458329272374 (37.7115017488702, -122.458329272374)
21386 19350 DPW Maintained 3 Lagunaria patersonii :: Primrose Tree 48 618 Shields St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   10/06/2014 12:00:00 AM 3 3X3 Permit Number 774109 5992350.09465 2089866.75515 37.7179367902328 -122.468440675709 (37.7179367902328, -122.468440675709)
152 24532 DPW Maintained 3 Lagunaria patersonii :: Primrose Tree 48 1395 47th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   03/28/2017 12:21:00 PM 3 3X3   5981507.2257 2105680.0147 37.7607233666377 -122.50709148147499 (37.7607233666377, -122.507091481475)
119386 24739 DPW Maintained 3 Lagunaria patersonii :: Primrose Tree 48 2 Point Lobos Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   03/23/2004 12:00:00 AM 3 3X3   5982782.27657 2112574.64249 37.7797290371816 -122.503192207591 (37.7797290371816, -122.503192207591)
80627 24740 DPW Maintained 3 Lagunaria patersonii :: Primrose Tree 48 2 Point Lobos Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   09/07/2012 12:00:00 AM 3 3X3   5982774.3423 2112574.7084 37.779728751764104 -122.503219660118 (37.7797287517641, -122.503219660118)
119389 24747 DPW Maintained 3 Lagunaria patersonii :: Primrose Tree 48 200X Point Lobos Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   02/09/1999 12:00:00 AM 3 3X3   5982215.35166 2112638.47493 37.779870961567894 -122.505158146759 (37.7798709615679, -122.505158146759)
17806 25338 DPW Maintained 3 Lagunaria patersonii :: Primrose Tree 48 297x Sagamore St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   10/03/2015 02:44:00 PM 3 3X3   5994177.957230001 2087395.7640200001 37.7112574471386 -122.46194351998699 (37.7112574471386, -122.461943519987)
11504 25763 DPW Maintained 3 Lagunaria patersonii :: Primrose Tree 48 1682 Geneva Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   08/20/2015 06:02:00 PM 3 2X3   6004184.86566 2087196.3858299998 37.711281031873 -122.42734293164801 (37.711281031873, -122.427342931648)
11715 26976 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 504X Silver Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/21/2007 12:00:00 AM 3 3x3   6004631.3919400005 2093482.01374 37.7285652398765 -122.42624684333201 (37.7285652398765, -122.426246843332)
10655 26983 DPW Maintained 3 Lagunaria patersonii :: Primrose Tree 48 1395 Silver Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   01/30/2009 12:00:00 AM 3 3X3   6009622.935740001 2094432.5688200002 37.731456140283704 -122.409057769215 (37.7314561402837, -122.409057769215)
10726 26985 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 1353 Silver Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   01/29/2009 12:00:00 AM 3 3X3   6009441.55287 2094364.79553 37.731259886623896 -122.409680064978 (37.7312598866239, -122.409680064978)
12597 26986 DPW Maintained 3 Lagunaria patersonii :: Primrose Tree 48 1349 Silver Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 3X3   6009414.0618 2094354.93302 37.7312312656966 -122.409774411069 (37.7312312656966, -122.409774411069)
11736 26988 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 1339 Silver Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   01/29/2009 12:00:00 AM 6 3X3   6009367.01038 2094339.1416200001 37.731185268979395 -122.409935962601 (37.7311852689794, -122.409935962601)
10468 27000 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 1236 Silver Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/10/2007 12:00:00 AM 6 3X3   6008836.56983 2094066.26048 37.7304062528391 -122.411750521985 (37.7304062528391, -122.411750521985)
103181 27003 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 1380X Silver Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   01/29/2009 12:00:00 AM 3 3X3   6009629.1666 2094382.2025400002 37.7313181942464 -122.409032675373 (37.7313181942464, -122.409032675373)
10532 27006 DPW Maintained 3 Lagunaria patersonii :: Primrose Tree 48 1420 Silver Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   07/13/1999 12:00:00 AM 3 3X3   6009885.433069999 2094479.90043 37.73160080432 -122.408153598922 (37.73160080432, -122.408153598922)
12392 27007 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 1424 Silver Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   05/19/1999 12:00:00 AM 3 3X3   6009909.30958 2094487.23688 37.731622285542706 -122.408071569962 (37.7316222855427, -122.408071569962)
12324 27008 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 1430 Silver Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   05/19/1999 12:00:00 AM 3 3X3   6009940.18408 2094497.7501400001 37.731652881356396 -122.407965571349 (37.7316528813564, -122.407965571349)
11601 27009 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 1446 Silver Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/06/2007 12:00:00 AM 3 3X3   6010020.23018 2094527.09535 37.731737938333104 -122.40769090313299 (37.7317379383331, -122.407690903133)
12933 27010 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 1462 Silver Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   06/02/1999 12:00:00 AM 6 3X3   6010153.37045 2094576.2882400001 37.7318804638018 -122.407234074496 (37.7318804638018, -122.407234074496)
120336 27014 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 1518 Silver Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   01/30/2009 12:00:00 AM 6 3X3   6010461.99919 2094665.45469 37.732142563919794 -122.40617335478001 (37.7321425639198, -122.40617335478)
117965 27025 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 1380X Silver Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   01/29/2009 12:00:00 AM 12 3X3   6009629.1666 2094382.2025400002 37.7313181942464 -122.409032675373 (37.7313181942464, -122.409032675373)
128401 27026 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 1380X Silver Ave 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   03/21/2005 12:00:00 AM 3 3X3   6009629.1666 2094382.2025400002 37.7313181942464 -122.409032675373 (37.7313181942464, -122.409032675373)
13204 27035 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 1300X Silver Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   05/27/1999 12:00:00 AM 6 3X3   6009326.50967 2094276.52484 37.731011066700894 -122.410071562372 (37.7310110667009, -122.410071562372)
12859 27036 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 1328 Silver Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   03/21/2005 12:00:00 AM 3 3X3   6009383.50137 2094296.42093 37.7310688913025 -122.409875935553 (37.7310688913025, -122.409875935553)
10740 27042 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 730 Silver Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/10/2007 12:00:00 AM 6 3X3   6006159.1890199995 2093550.7367900002 37.7288401770086 -122.420970032554 (37.7288401770086, -122.420970032554)
11394 27044 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 750 Silver Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   05/26/1999 12:00:00 AM 3 3X3   6006334.59281 2093563.7909400002 37.7288859066417 -122.42036457476001 (37.7288859066417, -122.42036457476)
13061 27046 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 790 Silver Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   01/29/2009 12:00:00 AM 6 3X3   6006496.082169999 2093583.10222 37.728948030017904 -122.419807663316 (37.7289480300179, -122.419807663316)
12688 27048 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 896 Silver Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   01/29/2009 12:00:00 AM 3 3X3   6007189.55023 2093517.44233 37.7288067843062 -122.417405636178 (37.7288067843062, -122.417405636178)
12940 27051 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 1008 Silver Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/10/2007 12:00:00 AM 6 3x3   6007619.46607 2093557.16905 37.7289400449304 -122.415922196353 (37.7289400449304, -122.415922196353)
13072 27052 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 1016 Silver Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   05/27/1999 12:00:00 AM 6 3X3   6007658.95865 2093571.8872599998 37.7289826781912 -122.415786708996 (37.7289826781912, -122.415786708996)
11575 27064 DPW Maintained 3 Lagunaria patersonii :: Primrose Tree 48 801 Silver Ave 6 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   01/30/2009 12:00:00 AM 1 4   6007054.44286 2093598.3683099998 37.7290213868102 -122.41787844665899 (37.7290213868102, -122.417878446659)
126643 27080 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 799X Silver Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   01/29/2009 12:00:00 AM 6 2X3   6006577.59669 2093640.7294700001 37.7291108536609 -122.419529947915 (37.7291108536609, -122.419529947915)
121418 27081 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 799X Silver Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/21/2007 12:00:00 AM 3 2X3   6006577.59669 2093640.7294700001 37.7291108536609 -122.419529947915 (37.7291108536609, -122.419529947915)
11808 27083 DPW Maintained 3 Lagunaria patersonii :: Primrose Tree 48 773 Silver Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   12/21/2007 12:00:00 AM 3 2X3   6006444.73415 2093622.02758 37.729052017734794 -122.419987938702 (37.7290520177348, -122.419987938702)
12093 27089 DPW Maintained 3 Lagunaria patersonii :: Primrose Tree 48 725 Silver Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   01/30/2009 12:00:00 AM 3 2X3   6006167.96193 2093597.45552 37.728968950933 -122.420943019604 (37.728968950933, -122.420943019604)
11161 27102 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 669 Silver Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   01/05/2009 12:00:00 AM 3 3X3   6005822.11431 2093583.57584 37.7289113394767 -122.422137656546 (37.7289113394767, -122.422137656546)
12790 27106 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 559 Silver Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   09/03/2009 12:00:00 AM 3 3X3   6005090.492430001 2093546.0118 37.7287669038667 -122.42466425684299 (37.7287669038667, -122.424664256843)
108236 27114 DPW Maintained 3 Lagunaria patersonii :: Primrose Tree 48 451 Silver Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   09/03/2009 12:00:00 AM 3 3x3   6004400.62614 2093530.84049 37.728686260787796 -122.427048090034 (37.7286862607878, -122.427048090034)
13205 27117 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 415 Silver Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   09/03/2009 12:00:00 AM 3 3X3   6004172.1589 2093507.5126900002 37.7286092859714 -122.42783625385701 (37.7286092859714, -122.427836253857)
115374 27123 DPW Maintained 3 Lagunaria patersonii :: Primrose Tree 48 2095X Silver Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   02/22/2011 12:00:00 AM 3 3X3   6012407.8106259005 2096047.4553772 37.736045896585495 -122.399543203223 (37.7360458965855, -122.399543203223)
93450 27125 DPW Maintained 3 Lagunaria patersonii :: Primrose Tree 48 2095X Silver Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   02/22/2011 12:00:00 AM 6 3X3   6012407.8106259005 2096047.4553772 37.736045896585495 -122.399543203223 (37.7360458965855, -122.399543203223)
15148 27156 DPW Maintained 3 Lagunaria patersonii :: Primrose Tree 48 1700X Silver Ave 5 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   07/28/2011 12:00:00 AM 3 3x3   6011160.21022 2095112.55455 37.7334092357479 -122.403790920224 (37.7334092357479, -122.403790920224)
14407 27158 DPW Maintained 3 Lagunaria patersonii :: Primrose Tree 48 1700X Silver Ave 7 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   07/28/2011 12:00:00 AM 3 3x3   6011192.5837900005 2095136.52795 37.7334768701528 -122.403680681311 (37.7334768701528, -122.403680681311)
145023 27161 DPW Maintained 3 Lagunaria patersonii :: Primrose Tree 48 1700X Silver Ave 10 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   07/28/2011 12:00:00 AM 3 3x3   6011020.5092245005 2095004.7366116 37.733105385033795 -122.40426632243 (37.7331053850338, -122.40426632243)
13510 27162 DPW Maintained 3 Lagunaria patersonii :: Primrose Tree 48 1700X Silver Ave 11 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   07/28/2011 12:00:00 AM 3 3x3   6011270.310880001 2095195.56425 37.733643313074204 -122.40341610708 (37.7336433130742, -122.40341610708)
99745 27168 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 2070X Silver Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/21/2007 12:00:00 AM 6 2X3   6012351.75792 2095958.0713099998 37.735797342091 -122.399730727068 (37.735797342091, -122.399730727068)
14988 27169 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 2080 Silver Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   06/16/1999 12:00:00 AM 6 2x3   6012550.77406 2096074.9927599998 37.73612947627829 -122.39905085001999 (37.7361294762783, -122.39905085002)
12018 27177 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 241 Silver Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   02/23/2005 12:00:00 AM 3 2X3   6002847.37275 2093824.8510200002 37.729405592491496 -122.432438768257 (37.7294055924915, -122.432438768257)
12272 27179 DPW Maintained 3 Lagunaria patersonii :: Primrose Tree 48 231 Silver Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   01/27/2009 12:00:00 AM 3 2X3   6002801.57598 2093850.9514400002 37.729474661304295 -122.432598955494 (37.7294746613043, -122.432598955494)
11229 27181 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 225 Silver Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   01/30/2009 12:00:00 AM 3 2X3   6002702.00816 2093915.39197 37.7296459533895 -122.432947772843 (37.7296459533895, -122.432947772843)
11019 27182 DPW Maintained 3 Lagunaria patersonii :: Primrose Tree 48 214 Silver Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   07/03/2015 07:50:00 AM 3 2X3   6002674.64617 2093876.5721099998 37.72953781082239 -122.433039593603 (37.7295378108224, -122.433039593603)
12199 27193 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 284 Silver Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   01/27/2009 12:00:00 AM 6 3X3   6003096.09594 2093601.65823 37.7288068562446 -122.431562981455 (37.7288068562446, -122.431562981455)
112426 27201 DPW Maintained 3 Lagunaria patersonii :: Primrose Tree 48 300 Silver Ave 8 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   09/28/2012 12:00:00 AM 3 3X3   6003188.8907382 2093541.6739542 37.728647412080996 -122.431237903911 (37.728647412081, -122.431237903911)
10843 27202 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 302 Silver Ave 9 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   06/08/1999 12:00:00 AM 6 3X3   6003502.33889 2093475.71167 37.7284840526724 -122.43014959163601 (37.7284840526724, -122.430149591636)
13218 27205 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 302 Silver Ave 12 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   06/08/1999 12:00:00 AM 6 3X3   6003575.96193 2093472.3389700002 37.7284789616109 -122.429894832577 (37.7284789616109, -122.429894832577)
12126 27207 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 302 Silver Ave 14 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   06/08/1999 12:00:00 AM 6 3X3   6003623.95003 2093470.2864400002 37.7284760433174 -122.429728788952 (37.7284760433174, -122.429728788952)
11827 27212 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 302 Silver Ave 19 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   06/08/1999 12:00:00 AM 6 3X3   6003753.294 2093466.8220900001 37.7284738543786 -122.429281393342 (37.7284738543786, -122.429281393342)
12241 27220 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 387 Silver Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   09/03/2009 12:00:00 AM 6 3X3   6003946.676519999 2093508.2167200001 37.728598460843294 -122.42861580957899 (37.7285984608433, -122.428615809579)
12497 27237 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 279 Silver Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   11/30/2007 12:00:00 AM 3 3X3   6003060.07524 2093688.7909799998 37.7290440614247 -122.43169372578501 (37.7290440614247, -122.431693725785)
12620 27251 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 547 Silver Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 2X3   6005015.49022 2093543.0573099998 37.7287545552706 -122.424923334442 (37.7287545552706, -122.424923334442)
115973 27273 DPW Maintained 3 Lagunaria patersonii :: Primrose Tree 48 2095X Silver Ave 8 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   02/22/2011 12:00:00 AM 8 3X3   6012407.8106259005 2096047.4553772 37.736045896585495 -122.399543203223 (37.7360458965855, -122.399543203223)
11210 27282 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 710 Silver Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/10/2007 12:00:00 AM 6 3X3   6006026.1077 2093547.18457 37.7288229208214 -122.421429852322 (37.7288229208214, -122.421429852322)
10352 27283 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 630 Silver Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   11/11/2008 12:00:00 AM 6 3X3   6005560.769069999 2093525.90712 37.7287382496569 -122.423037049614 (37.7287382496569, -122.423037049614)
12863 27284 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 636 Silver Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   09/04/2009 12:00:00 AM 3 3X3   6005588.17954 2093528.26307 37.7287462653044 -122.422942457136 (37.7287462653044, -122.422942457136)
120335 27286 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 682 Silver Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   01/30/2009 12:00:00 AM 3 3X3   6005885.56477 2093523.1174 37.7287489124796 -122.421914010506 (37.7287489124796, -122.421914010506)
12306 27287 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 1036 Silver Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/06/2008 12:00:00 AM 6 3X3   6007731.14975 2093596.42391 37.729054108643 -122.415538874723 (37.729054108643, -122.415538874723)
11119 27314 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 884 Silver Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/05/2007 12:00:00 AM 3 3X3   6007123.27309 2093533.58449 37.728847377904394 -122.41763590486799 (37.7288473779044, -122.417635904868)
102581 27315 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 1330X Silver Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   05/27/1999 12:00:00 AM 6 3X3   6009430.10492 2094285.00827 37.7310401662886 -122.409714013149 (37.7310401662886, -122.409714013149)
12102 27527 DPW Maintained 3 Lagunaria patersonii :: Primrose Tree 48 1114 Silver Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   07/03/2015 07:52:00 AM 3 3X3   6008222.66754 2093785.3034 37.729600346979794 -122.41385300921101 (37.7296003469798, -122.413853009211)
104761 28817 DPW Maintained 3 Lagunaria patersonii :: Primrose Tree 48 1075 Silver Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     6 3X3   6008023.971390001 2093752.9516900002 37.7295003553203 -122.414537636128 (37.7295003553203, -122.414537636128)
36288 31158 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 600 Head St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/28/2001 12:00:00 AM 1   Permit Number 34860 5993522.80361 2089878.90243 37.71803781197371 -122.464388049089 (37.7180378119737, -122.464388049089)
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)
73444 34680 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 1904 Greenwich St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/10/2009 12:00:00 AM 5 3x3 Permit Number 52535 6003705.30059 2119372.14104 37.7996008996227 -122.43129571912701 (37.7996008996227, -122.431295719127)
1367 36152 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 51 Commonwealth Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 05/01/1998 12:00:00 AM 4   Permit Number 39237 5996489.9045 2114249.7041 37.7851245233187 -122.455892946486 (37.7851245233187, -122.455892946486)
97094 37052 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 156 Duncan St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   10/25/2007 12:00:00 AM   3x3 Permit Number 49822 6005524.96145532 2099948.44891125 37.746371088402704 -122.423617283508 (37.7463710884027, -122.423617283508)

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