Street_Tree_List

Data source: data.sfgov.org

79 rows where PlotSize = "3X3", qSiteInfo = 1 and qSpecies = 48

View and edit SQL

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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
38258 113355 DPW Maintained 3 Lagunaria patersonii :: Primrose Tree 48 2 Point Lobos Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     1 3X3   5982766.03998 2112575.4615 37.779730331527404 -122.503248436763 (37.7797303315274, -122.503248436763)
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)
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)
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)
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)
95133 105013 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 330 Townsend St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3X3   6013709.8 2110877.9 37.7768395752266 -122.396080672132 (37.7768395752266, -122.396080672132)
96133 105012 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 330 Townsend St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3X3   6013709.8 2110877.9 37.7768395752266 -122.396080672132 (37.7768395752266, -122.396080672132)
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)
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)
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)
111186 105014 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 330 Townsend St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3X3   6013709.8 2110877.9 37.7768395752266 -122.396080672132 (37.7768395752266, -122.396080672132)
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)
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)
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)
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)
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)
118920 113357 DPW Maintained 3 Lagunaria patersonii :: Primrose Tree 48 2 POINT LOBOS AVE 5 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2       3X3   5982777.0 2112621.0 37.779856011140204 -122.50321389449499 (37.7798560111402, -122.503213894495)
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)
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)
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)
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)
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)
152469 113356 DPW Maintained 3 Lagunaria patersonii :: Primrose Tree 48 2 Point Lobos Ave 4 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     1 3X3   5982735.90689 2112577.0088400003 37.7797328087219 -122.503352793138 (37.7797328087219, -122.503352793138)

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