81 rows where PlotSize = "3X3" and qSpecies_id = 6

View and edit SQL

PlotSize

  • 3X3 · 81
rowid ▼ TreeID qLegalStatus_id qSpecies_id qAddress SiteOrder qSiteInfo PlantType qCaretaker_id qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location Fire Prevention Districts Police Districts Supervisor Districts Zip Codes Neighborhoods (old)
639 261347 Planning Code 138.1 required 2 Lagunaria patersonii :: Primrose Tree 6 3300x Alemany Blvd 2 Sidewalk: Curb side : Cutout Tree DPW 1   01/13/2020 12:00:00 AM 3 3X3 Permit Number 780859 5994476 2087151 37.7106025369579 -122.460895688785 (37.7106025369579, -122.460895688785) 9 8 6 28861 24
2299 27284 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 636 Silver Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   09/04/2009 12:00:00 AM 3 3X3   6005588.17954 2093528.26307 37.7287462653044 -122.422942457136 (37.7287462653044, -122.422942457136) 9 7 7 309 5
10393 3666 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 100X Cargo Way 102 Sidewalk: Curb side : Cutout Tree Port 6   05/02/2017 03:06:00 PM 3 3X3   6017134.48475 2098914.37607 37.7441802162386 -122.383400533034 (37.7441802162386, -122.383400533034) 10 3 8 58 1
11481 3673 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 100X Cargo Way 109 Sidewalk: Curb side : Cutout Tree Port 6   04/10/2017 10:21:00 AM 3 3X3   6017015.17172 2099002.62034 37.7444159222737 -122.383819238476 (37.7444159222737, -122.383819238476) 10 3 8 58 1
11900 3534 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 201X Cargo Way 44 Sidewalk: Curb side : Cutout Tree DPW 1   04/10/2017 11:10:00 AM 3 3X3   6018402.12937 2097818.41667 37.7412409080406 -122.378941151133 (37.7412409080406, -122.378941151133) 10 3 8 58 1
12906 27193 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 284 Silver Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   01/27/2009 12:00:00 AM 6 3X3   6003096.09594 2093601.65823 37.7288068562446 -122.431562981455 (37.7288068562446, -122.431562981455) 9 7 6 28861 25
13199 261348 Planning Code 138.1 required 2 Lagunaria patersonii :: Primrose Tree 6 3300x Alemany Blvd 3 Sidewalk: Curb side : Cutout Tree DPW 1   01/13/2020 12:00:00 AM 3 3X3 Permit Number 784323 5994476 2087151 37.7106025369579 -122.460895688785 (37.7106025369579, -122.460895688785) 9 8 6 28861 24
15290 25338 Planning Code 138.1 required 2 Lagunaria patersonii :: Primrose Tree 6 3300X Alemany Blvd 1 Sidewalk: Curb side : Cutout Tree DPW 1   01/13/2020 12:00:00 AM 3 3X3 Permit Number 780859 5994476 2087151 37.7106025369579 -122.460895688785 (37.7106025369579, -122.460895688785) 9 8 6 28861 24
16027 261349 Planning Code 138.1 required 2 Lagunaria patersonii :: Primrose Tree 6 3300x Alemany Blvd 4 Sidewalk: Curb side : Cutout Tree DPW 1   01/13/2020 12:00:00 AM 3 3X3 Permit Number 784323 5994476 2087151 37.7106025369579 -122.460895688785 (37.7106025369579, -122.460895688785) 9 8 6 28861 24
18371 27202 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 302 Silver Ave 9 Sidewalk: Curb side : Cutout Tree Private 2   06/08/1999 12:00:00 AM 6 3X3   6003502.33889 2093475.71167 37.7284840526724 -122.430149591636 (37.7284840526724, -122.430149591636) 9 7 6 28861 5
21651 27207 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 302 Silver Ave 14 Sidewalk: Curb side : Cutout Tree Private 2   06/08/1999 12:00:00 AM 6 3X3   6003623.95003 2093470.28644 37.7284760433174 -122.429728788952 (37.7284760433174, -122.429728788952) 9 7 6 28861 5
21976 26983 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 1395 Silver Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   01/30/2009 12:00:00 AM 3 3X3   6009622.93574 2094432.56882 37.7314561402837 -122.409057769215 (37.7314561402837, -122.409057769215) 9 3 7 309 28
22775 27008 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 1430 Silver Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   05/19/1999 12:00:00 AM 3 3X3   6009940.18408 2094497.75014 37.7316528813564 -122.407965571349 (37.7316528813564, -122.407965571349) 10 3 7 309 28
25283 3523 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 201X Cargo Way 33 Sidewalk: Curb side : Cutout Tree DPW 1   04/10/2017 11:28:00 AM 3 3X3   6018216.35215 2097958.49501 37.7416152904271 -122.379593238756 (37.7416152904271, -122.379593238756) 10 3 8 58 1
28445 3667 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 100X Cargo Way 103 Sidewalk: Curb side : Cutout Tree Port 6   05/02/2017 03:19:00 PM 3 3X3   6017116.62756 2098928.27448 37.7442173915214 -122.383463247242 (37.7442173915214, -122.383463247242) 10 3 8 58 1
31538 113355 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 2 Point Lobos Ave 3 Sidewalk: Curb side : Cutout Tree DPW 1     1 3X3   5982766.03998 2112575.4615 37.7797303315274 -122.503248436763 (37.7797303315274, -122.503248436763) 11 6 2 55 26
33310 27006 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 1420 Silver Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   07/13/1999 12:00:00 AM 3 3X3   6009885.43307 2094479.90043 37.73160080432 -122.408153598922 (37.73160080432, -122.408153598922) 10 3 7 309 28
33564 27026 Permitted Site 7 Lagunaria patersonii :: Primrose Tree 6 1380X Silver Ave 4 Sidewalk: Curb side : Cutout Tree Private 2   03/21/2005 12:00:00 AM 3 3X3   6009629.1666 2094382.20254 37.7313181942464 -122.409032675373 (37.7313181942464, -122.409032675373) 10 3 7 309 28
33674 27102 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 669 Silver Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   01/05/2009 12:00:00 AM 3 3X3   6005822.11431 2093583.57584 37.7289113394767 -122.422137656546 (37.7289113394767, -122.422137656546) 9 7 6 28861 5
42322 24532 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 1395 47th Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   03/28/2017 12:21:00 PM 3 3X3   5981507.2257 2105680.0147 37.7607233666377 -122.507091481475 (37.7607233666377, -122.507091481475) 1 8 3 56 35
42520 27117 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 415 Silver Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   09/03/2009 12:00:00 AM 3 3X3   6004172.1589 2093507.51269 37.7286092859714 -122.427836253857 (37.7286092859714, -122.427836253857) 9 7 6 28861 5
46442 3681 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 100X Cargo Way 117 Sidewalk: Curb side : Cutout Tree Port 6   05/02/2017 03:27:00 PM 3 3X3   6016866.95731 2099120.49255 37.7447313810499 -122.384339945926 (37.7447313810499, -122.384339945926) 10 3 8 58 1
52327 835 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 1396X 48th Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   02/21/2017 10:55:00 AM 3 3X3   5981242.3727 2105595.8151 37.7604765764936 -122.5080012238 (37.7604765764936, -122.5080012238) 1 8 3 56 35
55470 11606 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 4200x Judah St 1 Sidewalk: Curb side : Cutout Tree DPW 1   03/28/2017 11:54:00 AM 3 3X3   5981492.2847 2105581.1189 37.7604509471428 -122.507135818078 (37.7604509471428, -122.507135818078) 1 8 3 56 35
55868 24740 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 2 Point Lobos Ave 2 Sidewalk: Curb side : Cutout Tree DPW 1   09/07/2012 12:00:00 AM 3 3X3   5982774.3423 2112574.7084 37.7797287517641 -122.503219660118 (37.7797287517641, -122.503219660118) 11 6 2 55 26
58640 11589 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 4050X Judah St 1 Sidewalk: Curb side : Cutout Tree DPW 1   09/19/2016 11:29:00 AM 3 3X3   5981992.3567285 2105594.1635633 37.7605162040396 -122.505407296146 (37.7605162040396, -122.505407296146) 1 8 3 56 35
59994 11598 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 4134 Judah St 1 Sidewalk: Curb side : Cutout Tree Private 2   03/28/2017 11:51:00 AM 3 3X3   5981663.7126 2105589.2786 37.7604834464148 -122.506543543521 (37.7604834464148, -122.506543543521) 1 8 3 56 35
60494 27052 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 1016 Silver Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   05/27/1999 12:00:00 AM 6 3X3   6007658.95865 2093571.88726 37.7289826781912 -122.415786708996 (37.7289826781912, -122.415786708996) 9 3 7 309 5
68376 27287 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 1036 Silver Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   12/06/2008 12:00:00 AM 6 3X3   6007731.14975 2093596.42391 37.729054108643 -122.415538874723 (37.729054108643, -122.415538874723) 9 3 7 309 5
68993 27000 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 1236 Silver Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   12/10/2007 12:00:00 AM 6 3X3   6008836.56983 2094066.26048 37.7304062528391 -122.411750521985 (37.7304062528391, -122.411750521985) 9 3 7 309 28
70295 11573 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 3906 Judah St 3 Sidewalk: Curb side : Cutout Tree DPW 1   07/10/2015 07:56:00 AM 3 3X3   5982438 2105598 37.7605529521075 -122.503866330302 (37.7605529521075, -122.503866330302) 1 8 3 56 35
70811 3516 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 201X Cargo Way 26 Sidewalk: Curb side : Cutout Tree DPW 1   06/07/1996 12:00:00 AM 6 3X3   6018109.71439 2098036.73671 37.7418242442879 -122.379967395395 (37.7418242442879, -122.379967395395) 10 3 8 58 1
77325 26988 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 1339 Silver Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   01/29/2009 12:00:00 AM 6 3X3   6009367.01038 2094339.14162 37.7311852689794 -122.409935962601 (37.7311852689794, -122.409935962601) 9 3 7 309 28
80049 3674 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 100X Cargo Way 110 Sidewalk: Curb side : Cutout Tree Port 6   04/10/2017 10:22:00 AM 3 3X3   6016998.30504 2099015.89853 37.7444514490906 -122.383878484902 (37.7444514490906, -122.383878484902) 10 3 8 58 1
80264 105013 Permitted Site 7 Lagunaria patersonii :: Primrose Tree 6 330 Townsend St 2 Sidewalk: Curb side : Cutout Tree Private 2       3X3   6013709.8 2110877.9 37.7768395752266 -122.396080672132 (37.7768395752266, -122.396080672132) 6 2 9 28856 34
87197 27205 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 302 Silver Ave 12 Sidewalk: Curb side : Cutout Tree Private 2   06/08/1999 12:00:00 AM 6 3X3   6003575.96193 2093472.33897 37.7284789616109 -122.429894832577 (37.7284789616109, -122.429894832577) 9 7 6 28861 5
87299 27282 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 710 Silver Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   12/10/2007 12:00:00 AM 6 3X3   6006026.1077 2093547.18457 37.7288229208214 -122.421429852322 (37.7288229208214, -122.421429852322) 9 7 7 309 5
87554 27125 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 2095X Silver Ave 3 Sidewalk: Curb side : Cutout Tree DPW 1   02/22/2011 12:00:00 AM 6 3X3   6012407.8106259 2096047.4553772 37.7360458965855 -122.399543203223 (37.7360458965855, -122.399543203223) 10 3 8 58 1
89153 27009 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 1446 Silver Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   12/06/2007 12:00:00 AM 3 3X3   6010020.23018 2094527.09535 37.7317379383331 -122.407690903133 (37.7317379383331, -122.407690903133) 10 3 7 309 28
91908 27212 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 302 Silver Ave 19 Sidewalk: Curb side : Cutout Tree Private 2   06/08/1999 12:00:00 AM 6 3X3   6003753.294 2093466.82209 37.7284738543786 -122.429281393342 (37.7284738543786, -122.429281393342) 9 7 6 28861 5
92191 105012 Permitted Site 7 Lagunaria patersonii :: Primrose Tree 6 330 Townsend St 1 Sidewalk: Curb side : Cutout Tree Private 2       3X3   6013709.8 2110877.9 37.7768395752266 -122.396080672132 (37.7768395752266, -122.396080672132) 6 2 9 28856 34
93431 11602 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 4150 Judah St 1 Sidewalk: Curb side : Cutout Tree DPW 1   05/06/2011 12:00:00 AM 3 3X3   5981591.6344 2105586.8054 37.7604724115264 -122.506792641078 (37.7604724115264, -122.506792641078) 1 8 3 56 35
96120 27315 Permitted Site 7 Lagunaria patersonii :: Primrose Tree 6 1330X Silver Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   05/27/1999 12:00:00 AM 6 3X3   6009430.10492 2094285.00827 37.7310401662886 -122.409714013149 (37.7310401662886, -122.409714013149) 9 3 7 309 28
96434 27007 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 1424 Silver Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   05/19/1999 12:00:00 AM 3 3X3   6009909.30958 2094487.23688 37.7316222855427 -122.408071569962 (37.7316222855427, -122.408071569962) 10 3 7 309 28
100533 27048 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 896 Silver Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   01/29/2009 12:00:00 AM 3 3X3   6007189.55023 2093517.44233 37.7288067843062 -122.417405636178 (37.7288067843062, -122.417405636178) 9 3 7 309 5
103320 27036 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 1328 Silver Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   03/21/2005 12:00:00 AM 3 3X3   6009383.50137 2094296.42093 37.7310688913025 -122.409875935553 (37.7310688913025, -122.409875935553) 9 3 7 309 28
106113 27044 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 750 Silver Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   05/26/1999 12:00:00 AM 3 3X3   6006334.59281 2093563.79094 37.7288859066417 -122.42036457476 (37.7288859066417, -122.42036457476) 9 7 7 309 5
106660 27046 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 790 Silver Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   01/29/2009 12:00:00 AM 6 3X3   6006496.08217 2093583.10222 37.7289480300179 -122.419807663316 (37.7289480300179, -122.419807663316) 9 7 7 309 5
108067 27003 Permitted Site 7 Lagunaria patersonii :: Primrose Tree 6 1380X Silver Ave 3 Sidewalk: Curb side : Cutout Tree Private 2   01/29/2009 12:00:00 AM 3 3X3   6009629.1666 2094382.20254 37.7313181942464 -122.409032675373 (37.7313181942464, -122.409032675373) 10 3 7 309 28
112076 27237 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 279 Silver Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   11/30/2007 12:00:00 AM 3 3X3   6003060.07524 2093688.79098 37.7290440614247 -122.431693725785 (37.7290440614247, -122.431693725785) 9 7 6 28861 25
115054 11582 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 4000 Judah St 2 Sidewalk: Curb side : Cutout Tree DPW 1   03/28/2017 11:49:00 AM 3 3X3   5982109.291 2105604.0369 37.7605501938414 -122.505003612665 (37.7605501938414, -122.505003612665) 1 8 3 56 35
125720 27527 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 1114 Silver Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   07/03/2015 07:52:00 AM 3 3X3   6008222.66754 2093785.3034 37.7296003469798 -122.413853009211 (37.7296003469798, -122.413853009211) 9 3 7 309 28
129314 113356 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 2 Point Lobos Ave 4 Sidewalk: Curb side : Cutout Tree DPW 1     1 3X3   5982735.90689 2112577.00884 37.7797328087219 -122.503352793138 (37.7797328087219, -122.503352793138) 11 6 2 55 26
132697 28817 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 1075 Silver Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1     6 3X3   6008023.97139 2093752.95169 37.7295003553203 -122.414537636128 (37.7295003553203, -122.414537636128) 9 3 7 309 28
134756 19062 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 174 Sagamore St 1 Sidewalk: Curb side : Cutout Tree DPW 1   10/10/2017 08:47:00 AM 3 3X3   5995225.08055 2087462.80286 37.7115017488702 -122.458329272374 (37.7115017488702, -122.458329272374) 9 8 6 28861 24
135912 3538 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 201X Cargo Way 48 Sidewalk: Curb side : Cutout Tree DPW 1   04/10/2017 10:28:00 AM 3 3X3   6018470.22426 2097768.00954 37.7411062543397 -122.37870220127 (37.7411062543397, -122.37870220127) 10 3 8 58 1
136110 27042 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 730 Silver Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   12/10/2007 12:00:00 AM 6 3X3   6006159.18902 2093550.73679 37.7288401770086 -122.420970032554 (37.7288401770086, -122.420970032554) 9 7 7 309 5
136349 105014 Permitted Site 7 Lagunaria patersonii :: Primrose Tree 6 330 Townsend St 3 Sidewalk: Curb side : Cutout Tree Private 2       3X3   6013709.8 2110877.9 37.7768395752266 -122.396080672132 (37.7768395752266, -122.396080672132) 6 2 9 28856 34
137916 27123 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 2095X Silver Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   02/22/2011 12:00:00 AM 3 3X3   6012407.8106259 2096047.4553772 37.7360458965855 -122.399543203223 (37.7360458965855, -122.399543203223) 10 3 8 58 1
138661 27273 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 2095X Silver Ave 8 Sidewalk: Curb side : Cutout Tree DPW 1   02/22/2011 12:00:00 AM 8 3X3   6012407.8106259 2096047.4553772 37.7360458965855 -122.399543203223 (37.7360458965855, -122.399543203223) 10 3 8 58 1
139170 27314 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 884 Silver Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   12/05/2007 12:00:00 AM 3 3X3   6007123.27309 2093533.58449 37.7288473779044 -122.417635904868 (37.7288473779044, -122.417635904868) 9 3 7 309 5
140777 27106 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 559 Silver Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   09/03/2009 12:00:00 AM 3 3X3   6005090.49243 2093546.0118 37.7287669038667 -122.424664256843 (37.7287669038667, -122.424664256843) 9 7 6 28861 5
141397 3676 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 100X Cargo Way 112 Sidewalk: Curb side : Cutout Tree Port 6   04/10/2017 10:24:00 AM 3 3X3   6016964.48751 2099042.50937 37.7445226475172 -122.383997272761 (37.7445226475172, -122.383997272761) 10 3 8 58 1
145389 11603 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 4245 Judah St 1 Sidewalk: Curb side : Cutout Tree DPW 1   03/23/2015 05:31:00 PM 3 3X3   5981392.2965206 2105523.6051476 37.7602871413722 -122.507477357537 (37.7602871413722, -122.507477357537) 1 8 3 56 35
145844 26986 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 1349 Silver Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1     12 3X3   6009414.0618 2094354.93302 37.7312312656966 -122.409774411069 (37.7312312656966, -122.409774411069) 9 3 7 309 28
145882 27201 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 300 Silver Ave 8 Sidewalk: Curb side : Cutout Tree DPW 1   09/28/2012 12:00:00 AM 3 3X3   6003188.8907382 2093541.6739542 37.728647412081 -122.431237903911 (37.728647412081, -122.431237903911) 9 7 6 28861 5
151770 27220 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 387 Silver Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   09/03/2009 12:00:00 AM 6 3X3   6003946.67652 2093508.21672 37.7285984608433 -122.428615809579 (37.7285984608433, -122.428615809579) 9 7 6 28861 5
153523 113357 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 2 POINT LOBOS AVE 5 Sidewalk: Curb side : Cutout Tree DPW 1       3X3   5982777 2112621 37.7798560111402 -122.503213894495 (37.7798560111402, -122.503213894495) 11 6 2 55 26
154862 26985 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 1353 Silver Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   01/29/2009 12:00:00 AM 3 3X3   6009441.55287 2094364.79553 37.7312598866239 -122.409680064978 (37.7312598866239, -122.409680064978) 9 3 7 309 28
155786 3539 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 201X Cargo Way 49 Sidewalk: Curb side : Cutout Tree DPW 1   05/03/2017 08:08:00 AM 3 3X3   6018487.88793 2097755.11327 37.7410718175127 -122.378640230766 (37.7410718175127, -122.378640230766) 10 3 8 58 1
156212 27014 Permitted Site 7 Lagunaria patersonii :: Primrose Tree 6 1518 Silver Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   01/30/2009 12:00:00 AM 6 3X3   6010461.99919 2094665.45469 37.7321425639198 -122.40617335478 (37.7321425639198, -122.40617335478) 10 3 7 309 28
158730 27025 Permitted Site 7 Lagunaria patersonii :: Primrose Tree 6 1380X Silver Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   01/29/2009 12:00:00 AM 12 3X3   6009629.1666 2094382.20254 37.7313181942464 -122.409032675373 (37.7313181942464, -122.409032675373) 10 3 7 309 28
160467 27283 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 630 Silver Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   11/11/2008 12:00:00 AM 6 3X3   6005560.76907 2093525.90712 37.7287382496569 -122.423037049614 (37.7287382496569, -122.423037049614) 9 7 7 309 5
161397 24739 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 2 Point Lobos Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   03/23/2004 12:00:00 AM 3 3X3   5982782.27657 2112574.64249 37.7797290371816 -122.503192207591 (37.7797290371816, -122.503192207591) 11 6 2 55 26
162045 24747 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 200X Point Lobos Ave 2 Sidewalk: Curb side : Cutout Tree DPW 1   02/09/1999 12:00:00 AM 3 3X3   5982215.35166 2112638.47493 37.7798709615679 -122.505158146759 (37.7798709615679, -122.505158146759) 11 6 2 55 26
165833 27035 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 1300X Silver Ave 3 Sidewalk: Curb side : Cutout Tree Private 2   05/27/1999 12:00:00 AM 6 3X3   6009326.50967 2094276.52484 37.7310110667009 -122.410071562372 (37.7310110667009, -122.410071562372) 9 3 7 309 28
168187 836 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 1396X 48th Ave 2 Sidewalk: Curb side : Cutout Tree DPW 1   02/21/2017 10:52:00 AM 3 3X3   5981241.3128 2105622.3145 37.7605492737866 -122.508006856179 (37.7605492737866, -122.508006856179) 1 8 3 56 35
169270 27286 Permitted Site 7 Lagunaria patersonii :: Primrose Tree 6 682 Silver Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   01/30/2009 12:00:00 AM 3 3X3   6005885.56477 2093523.1174 37.7287489124796 -122.421914010506 (37.7287489124796, -122.421914010506) 9 7 7 309 5
179045 19350 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 618 Shields St 1 Sidewalk: Curb side : Cutout Tree DPW 1   03/27/2018 12:00:00 AM 3 3X3 Permit Number 781612 5992350.09465 2089866.75515 37.7179367902328 -122.468440675709 (37.7179367902328, -122.468440675709) 9 8 6 64 24
185303 3513 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 201X Cargo Way 23 Sidewalk: Curb side : Cutout Tree DPW 1   04/10/2017 11:31:00 AM 3 3X3   6018063.30501 2098072.02964 37.7419185912736 -122.380130317487 (37.7419185912736, -122.380130317487) 10 3 8 58 1
187299 27010 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 1462 Silver Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   06/02/1999 12:00:00 AM 6 3X3   6010153.37045 2094576.28824 37.7318804638018 -122.407234074496 (37.7318804638018, -122.407234074496) 10 3 7 309 28

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

CREATE TABLE "trees" (
   [rowid] INTEGER PRIMARY KEY,
   [TreeID] TEXT,
   [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]),
   [qSpecies_id] INTEGER,
   [qAddress] TEXT,
   [SiteOrder] TEXT,
   [qSiteInfo] TEXT,
   [PlantType] TEXT,
   [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]),
   [qCareAssistant] TEXT,
   [PlantDate] TEXT,
   [DBH] TEXT,
   [PlotSize] TEXT,
   [PermitNotes] TEXT,
   [XCoord] TEXT,
   [YCoord] TEXT,
   [Latitude] TEXT,
   [Longitude] TEXT,
   [Location] TEXT,
   [Fire Prevention Districts] TEXT,
   [Police Districts] TEXT,
   [Supervisor Districts] TEXT,
   [Zip Codes] TEXT,
   [Neighborhoods (old)] TEXT,
   FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id)
);