98 rows where Zip Codes = 309 and qSpecies_id = 6

View and edit SQL

Zip Codes

  • 309 · 98
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)
8 264824 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 1x Harkness Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   11/01/2020 12:00:00 AM 3     6012032 2089425 37.7178410421308 -122.400377527521 (37.7178410421308, -122.400377527521) 10 7 8 309 39
25 49783 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 130 Wilde Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/01/2020 12:00:00 AM 3   Permit Number 46568 6011944.29976 2088937.30454 37.7164970376796 -122.400646428989 (37.7164970376796, -122.400646428989) 10 7 8 309 39
334 162296 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 299 Olmstead St 2 Sidewalk: Curb side : Cutout Tree Private 2   10/23/2020 12:00:00 AM 3 Width 0ft   6010920.41592 2090984.45712 37.7220609417541 -122.40432950351 (37.7220609417541, -122.40432950351) 10 3 7 309 28
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
6290 259344 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 167 Somerset St 1 Sidewalk: Curb side : Cutout Tree DPW 1 FUF 04/27/2019 12:00:00 AM 3     6009725.84271 2093690.47402 37.7294242696948 -122.408649667073 (37.7294242696948, -122.408649667073) 10 3 7 309 28
9404 176900 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 167 Madison St 3 Sidewalk: Property side : Yard Tree Private 2     1 Width 4ft   6005606.72127 2092829.97134 37.7268299557374 -122.422828750447 (37.7268299557374, -122.422828750447) 9 7 7 309 5
9408 259103 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 625 Visitacion Ave   Sidewalk: Curb side : Cutout Tree DPW 1 FUF 03/30/2019 12:00:00 AM 3     6010501.76504 2086856.29359 37.7107024439005 -122.405486089504 (37.7107024439005, -122.405486089504) 9 7 8 309 39
9949 162295 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 299 Olmstead St 1 Sidewalk: Curb side : Cutout Tree Private 2   10/23/2020 12:00:00 AM 3 Width 0ft   6010903.85659 2090979.54911 37.7220465400048 -122.404386400036 (37.7220465400048, -122.404386400036) 10 3 7 309 28
12682 260425 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 508 Dwight St   Unaccepted Street : Yard Tree DPW 1 FUF 08/17/2019 12:00:00 AM 3     6010099.90949 2091269.80828 37.7227985719868 -122.407185909529 (37.7227985719868, -122.407185909529) 10 3 7 309 28
15168 259102 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 619 Visitacion Ave   Sidewalk: Curb side : Cutout Tree DPW 1 FUF 03/30/2019 12:00:00 AM 3     6010517.89431 2086850.21293 37.7106866494876 -122.405429914879 (37.7106866494876, -122.405429914879) 9 7 8 309 39
15493 259346 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 106 Burrows St 1 Sidewalk: Curb side : Cutout Tree DPW 1 FUF 04/27/2019 12:00:00 AM 3     6011005.88556 2093460.4594 37.728864306632 -122.404208230977 (37.728864306632, -122.404208230977) 10 3 7 309 28
16773 70408 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 266 Oxford St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   3     6006531.16259 2092699.03842 37.7265225593592 -122.419623688079 (37.7265225593592, -122.419623688079) 9 7 7 309 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
23429 176881 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 3303 San Bruno Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 3ft   6011991.79808 2090250.44255 37.7201052985 -122.400574440964 (37.7201052985, -122.400574440964) 10 7 8 309 28
23899 95684 Permitted Site 7 Lagunaria patersonii :: Primrose Tree 6 334 Oxford St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/08/2011 12:00:00 AM   3x3 Permit Number 767433 6006626.2 2092405.9 37.72572301772 -122.419274361386 (37.72572301772, -122.419274361386) 9 7 7 309 5
24569 176914 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 1300 Silver Ave 4 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   6009346.09367 2094283.90387 37.7310324255937 -122.41000437762 (37.7310324255937, -122.41000437762) 9 3 7 309 28
25340 176908 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 1053 Silver Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 2ft   6007885.16277 2093698.95374 37.7293442892945 -122.415013692231 (37.7293442892945, -122.415013692231) 9 3 7 309 28
25424 176901 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 167 Madison St 4 Sidewalk: Property side : Yard Tree Private 2     1 Width 4ft   6005600.43917 2092849.05844 37.7268820102711 -122.422851823466 (37.7268820102711, -122.422851823466) 9 7 7 309 5
29761 176907 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 769 Silver Ave 3 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   6006492.03782 2093629.408 37.7290749477448 -122.419824929392 (37.7290749477448, -122.419824929392) 9 7 7 309 5
31662 27080 Permitted Site 7 Lagunaria patersonii :: Primrose Tree 6 799X Silver Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   01/29/2009 12:00:00 AM 6 2X3   6006577.59669 2093640.72947 37.7291108536609 -122.419529947915 (37.7291108536609, -122.419529947915) 9 7 7 309 5
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
37255 108775 Permitted Site 7 Lagunaria patersonii :: Primrose Tree 6 500X Lathrop Ave 14 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/06/2015 12:00:00 AM 3   Permit Number 773822 6012750.2 2086624.6 37.7101917236901 -122.397698699654 (37.7101917236901, -122.397698699654) 10 3 8 309 1
49657 46433 Permitted Site 7 Lagunaria patersonii :: Primrose Tree 6 2St. Ankeny St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/05/2018 12:00:00 AM 3 3x3 Permit Number 777225 6011103.47209 2089684.58226 37.718501979072 -122.403605308234 (37.718501979072, -122.403605308234) 10 7 8 309 28
50859 114691 Permitted Site 7 Lagunaria patersonii :: Primrose Tree 6 391 Girard St 1 Sidewalk: Curb side : Cutout Tree Private 2   12/01/2015 12:00:00 AM     Permit Number 774511 6010909.5 2092975 37.7275259502006 -122.404507285761 (37.7275259502006, -122.404507285761) 10 3 7 309 28
51610 176885 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 191 Rey St 1 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 3ft   6008580.05361 2087004.56736 37.7110019335603 -122.412138452652 (37.7110019335603, -122.412138452652) 9 7 8 309 39
52628 176910 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 1390 Silver Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   6009561.38521 2094361.93193 37.7312587382014 -122.409265579153 (37.7312587382014, -122.409265579153) 10 3 7 309 28
54619 108768 Permitted Site 7 Lagunaria patersonii :: Primrose Tree 6 500X Lathrop Ave 7 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/06/2015 12:00:00 AM 3   Permit Number 773822 6012750.2 2086624.6 37.7101917236901 -122.397698699654 (37.7101917236901, -122.397698699654) 10 3 8 309 1
55754 176898 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 167 Madison St 1 Sidewalk: Property side : Yard Tree Private 2     1 Width 4ft   6005619.38027 2092788.13013 37.7267157831975 -122.422782016296 (37.7267157831975, -122.422782016296) 9 7 7 309 5
56826 176874 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 526 Lathrop Ave 3 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 3ft   6012843.86934 2086597.3532 37.7101221250005 -122.397373047849 (37.7101221250005, -122.397373047849) 10 3 8 309 1
57255 176878 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 526 Lathrop Ave 17 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 3ft   6013154.94381 2086496.55313 37.7098626625021 -122.396290845073 (37.7098626625021, -122.396290845073) 10 3 8 309 1
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
62270 176912 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 1390 Silver Ave 4 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   6009589.47798 2094371.19963 37.7312857592085 -122.409169110679 (37.7312857592085, -122.409169110679) 10 3 7 309 28
65352 176897 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 338 Oxford St 1 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 2ft   6006634.64196 2092369.41813 37.7256233218417 -122.419242591383 (37.7256233218417, -122.419242591383) 9 7 7 309 5
68285 27051 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 1008 Silver Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   12/10/2007 12:00:00 AM 6 3x3   6007619.46607 2093557.16905 37.7289400449304 -122.415922196353 (37.7289400449304, -122.415922196353) 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
75326 176909 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 1038 Silver Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 3ft   6007759.63809 2093605.48677 37.7290805945829 -122.415441029374 (37.7290805945829, -122.415441029374) 9 3 7 309 5
76984 176882 Permitted Site 7 Lagunaria patersonii :: Primrose Tree 6 371 Wilde Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/07/2018 12:00:00 AM 3 3x3 Permit Number 781358 6010924.50069 2089093.90072 37.7168700890604 -122.404182392406 (37.7168700890604, -122.404182392406) 9 7 8 309 39
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
82669 46431 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 2St. Ankeny St 3 Sidewalk: Curb side : Cutout Tree Private 2   03/15/2002 12:00:00 AM 1   Permit Number 44652 6011089.42189 2089718.35805 37.7185939356546 -122.403656249429 (37.7185939356546, -122.403656249429) 10 7 8 309 28
84471 27064 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 801 Silver Ave 6 Sidewalk: Curb side : Cutout Tree DPW 1   01/30/2009 12:00:00 AM 1 4   6007054.44286 2093598.36831 37.7290213868102 -122.417878446659 (37.7290213868102, -122.417878446659) 9 3 7 309 28
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
88331 176913 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 1390 Silver Ave 5 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   6009673.25426 2094402.87309 37.7313774208194 -122.40888171342 (37.7313774208194, -122.40888171342) 10 3 7 309 28
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
95475 46434 Planning Code 138.1 required 2 Lagunaria patersonii :: Primrose Tree 6 2St. Ankeny St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/30/2003 12:00:00 AM 1   Permit Number 47151 6011096.25435 2089701.2859 37.7185474406786 -122.40363143174 (37.7185474406786, -122.40363143174) 10 7 8 309 28
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
96851 82945 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 51 Princeton St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/08/2009 12:00:00 AM 6 3x3 Permit Number 52470 6007551.81764 2093700.90463 37.7293309082802 -122.416166238177 (37.7293309082802, -122.416166238177) 9 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
101851 176875 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 526 Lathrop Ave 7 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 3ft   6012929.76757 2086570.3757 37.7100528322548 -122.397074274178 (37.7100528322548, -122.397074274178) 10 3 8 309 1
102299 82807 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 130 Cambridge St 1 Sidewalk: Curb side : Cutout Tree Private 2   07/08/2009 12:00:00 AM 8 3x3 Permit Number 52471 6006613.17369 2094127.50126 37.7304494265868 -122.419441474643 (37.7304494265868, -122.419441474643) 9 7 7 309 5
103230 49761 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 366@ REY Leland Ave 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/04/2003 12:00:00 AM 4   Permit Number 46555 6008949.54261 2087928.88077 37.713560633393 -122.41092664676 (37.713560633393, -122.41092664676) 9 7 8 309 39
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
107198 50036 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 73 University St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/28/2003 12:00:00 AM 9   Permit Number 46766 6007832.62107 2093714.43935 37.7293838567558 -122.415196429982 (37.7293838567558, -122.415196429982) 9 3 7 309 28
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
108222 108764 Permitted Site 7 Lagunaria patersonii :: Primrose Tree 6 500X Lathrop Ave 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/06/2015 12:00:00 AM 3   Permit Number 773822 6012750.2 2086624.6 37.7101917236901 -122.397698699654 (37.7101917236901, -122.397698699654) 10 3 8 309 1
109581 27083 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 773 Silver Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   12/21/2007 12:00:00 AM 3 2X3   6006444.73415 2093622.02758 37.7290520177348 -122.419987938702 (37.7290520177348, -122.419987938702) 9 7 7 309 5
114989 50035 Permitted Site 7 Lagunaria patersonii :: Primrose Tree 6 73 University St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/28/2003 12:00:00 AM     Permit Number 46766 6007848.45417861 2093691.5625558 37.7293219318135 -122.415140074598 (37.7293219318135, -122.415140074598) 9 3 7 309 28
117917 108778 Permitted Site 7 Lagunaria patersonii :: Primrose Tree 6 500X Lathrop Ave 17 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/06/2015 12:00:00 AM 3   Permit Number 773822 6012750.2 2086624.6 37.7101917236901 -122.397698699654 (37.7101917236901, -122.397698699654) 10 3 8 309 1
118890 176879 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 140 Bacon St 2 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 3ft   6010956.3364 2092967.77816 37.7275087379234 -122.404344863032 (37.7275087379234, -122.404344863032) 10 3 7 309 28
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
127629 176876 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 526 Lathrop Ave 11 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 3ft   6013031.56753 2086536.06642 37.7099642921874 -122.396720027609 (37.7099642921874, -122.396720027609) 10 3 8 309 1
129402 82909 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 51 Princeton St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/08/2009 12:00:00 AM 6 3x3 Permit Number 52470 6007555.60486 2093720.99529 37.7293862858368 -122.416154567675 (37.7293862858368, -122.416154567675) 9 3 7 309 28
132281 254353 Permitted Site 7 Lagunaria patersonii :: Primrose Tree 6 2 Ankeny St   Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/05/2018 12:00:00 AM 3 3x3 Permit Number 777225 6011131.69741 2089639.6721 37.7183802415409 -122.403504586485 (37.7183802415409, -122.403504586485) 10 7 8 309 28
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
134524 108772 Permitted Site 7 Lagunaria patersonii :: Primrose Tree 6 500X Lathrop Ave 11 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/06/2015 12:00:00 AM 3   Permit Number 773822 6012750.2 2086624.6 37.7101917236901 -122.397698699654 (37.7101917236901, -122.397698699654) 10 3 8 309 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
136837 95677 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 231 Harvard St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/08/2011 12:00:00 AM 6 3x3 Permit Number 767429 6006245.60839 2092760.95718 37.7266764855102 -122.420615232913 (37.7266764855102, -122.420615232913) 9 7 7 309 5
137268 176906 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 769 Silver Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 3ft   6006512.6379 2093630.87617 37.7290801395131 -122.419753817278 (37.7290801395131, -122.419753817278) 9 7 7 309 5
138739 82870 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 110 Cambridge St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/08/2009 12:00:00 AM 8 3x3 Permit Number 53934 6006630.39976 2094273.0498 37.730850041274 -122.419392243064 (37.730850041274, -122.419392243064) 9 7 7 309 5
138944 114692 Permitted Site 7 Lagunaria patersonii :: Primrose Tree 6 391 Girard St 2 Sidewalk: Curb side : Cutout Tree Port 6 Private 12/01/2015 12:00:00 AM     Permit Number 774511 6010909.5 2092975 37.7275259502006 -122.404507285761 (37.7275259502006, -122.404507285761) 10 3 7 309 28
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
139841 176902 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 676 Silver Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 3ft   6005861.55708 2093540.19411 37.7287944473924 -122.421998219354 (37.7287944473924, -122.421998219354) 9 7 7 309 5
141360 176880 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 3333 San Bruno Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 3ft   6012013.01229 2090122.10429 37.7197540907522 -122.400492099948 (37.7197540907522, -122.400492099948) 10 7 8 309 28
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
151427 176883 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 96 Alpha St 4 Front Yard : Yard Tree Private 2     1     6011048.63475 2088252.82193 37.7145675926038 -122.403694172945 (37.7145675926038, -122.403694172945) 9 7 8 309 39
153956 176899 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 167 Madison St 2 Sidewalk: Property side : Yard Tree Private 2     1 Width 4ft   6005613.54422 2092807.28897 37.7267680598911 -122.422803552358 (37.7267680598911, -122.422803552358) 9 7 7 309 5
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
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
156893 27081 Permitted Site 7 Lagunaria patersonii :: Primrose Tree 6 799X Silver Ave 3 Sidewalk: Curb side : Cutout Tree Private 2   12/21/2007 12:00:00 AM 3 2X3   6006577.59669 2093640.72947 37.7291108536609 -122.419529947915 (37.7291108536609, -122.419529947915) 9 7 7 309 5
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
162239 94098 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 7 Colby St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/03/2010 12:00:00 AM 4   Permit Number 53474 6007925.01702 2094192.51392 37.7307017385741 -122.414910830466 (37.7307017385741, -122.414910830466) 9 3 7 309 28
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
167406 176915 Permitted Site 7 Lagunaria patersonii :: Primrose Tree 6 143 Somerset St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/06/2018 12:00:00 AM 3 3x3 Permit Number 778564 6009701.03874 2093769.75693 37.7296405745301 -122.408741008189 (37.7296405745301, -122.408741008189) 10 3 7 309 28
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
169305 176877 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 526 Lathrop Ave 14 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 3ft   6013098.43993 2086515.08302 37.7099103976217 -122.396487432357 (37.7099103976217, -122.396487432357) 10 3 8 309 1
169948 176911 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 1390 Silver Ave 3 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   6009574.07755 2094366.6897 37.7312725131133 -122.409222034865 (37.7312725131133, -122.409222034865) 10 3 7 309 28
172292 176884 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 96 Alpha St 2 Front Yard : Yard Tree Private 2     1     6011062.55449 2088258.87965 37.7145850034576 -122.403646486396 (37.7145850034576, -122.403646486396) 9 7 8 309 39
174505 108825 Permitted Site 7 Lagunaria patersonii :: Primrose Tree 6 146-150X Gillette Ave 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/06/2015 12:00:00 AM 3   Permit Number 773819 6013072.89275 2086799.91674 37.7106910734067 -122.39659568235 (37.7106910734067, -122.39659568235) 10 3 8 309 1
177940 50032 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 33 Tulane St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/28/2003 12:00:00 AM 5   Permit Number 46764 6007353.74197 2093754.84576 37.7294678795239 -122.416854825683 (37.7294678795239, -122.416854825683) 9 3 7 309 28
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
191490 60927 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 1506 Silver Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   06/13/1983 12:00:00 AM 5   Permit Number 20728 6010428.9415 2094674.96946 37.7321668403311 -122.406288313254 (37.7321668403311, -122.406288313254) 10 3 7 309 28
192015 108829 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 545 Lathrop Ave 3 Sidewalk: Curb side : Cutout Tree Private 2   01/06/2015 12:00:00 AM 3   Permit Number 773819 6012931.90275 2086607.74701 37.7101555653976 -122.397069513169 (37.7101555653976, -122.397069513169) 10 3 8 309 1

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)
);