1,121 rows where qSpecies_id = 6 sorted by Police Districts

View and edit SQL

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)
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
34639 93188 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 1675 Jerrold Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   02/18/2010 12:00:00 AM 10 3x3 Permit Number 53196 6014934.44131 2097265.12572 37.7395298812852 -122.39089262491 (37.7395298812852, -122.39089262491) 10 3 8 58 1
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
40165 191226 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 2350 20th St 3 Sidewalk: Property side : Yard Tree Private 2     4 Width 7ft   6011107.06002 2104648.42845 37.7595897074225 -122.404645742032 (37.7595897074225, -122.404645742032) 10 3 8 28856 29
44173 49818 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 1300 De Haro St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/11/2003 12:00:00 AM 7 3x3 Permit Number 46609 6012222.38132 2102319.17957 37.7532563730854 -122.400624753529 (37.7532563730854, -122.400624753529) 10 3 8 28856 29
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
46503 201810 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 101 Friedell St 1 : Tree Private 2     1 Width 6ft   6021035.70856 2093179.80399 37.7286490171175 -122.369514606714 (37.7286490171175, -122.369514606714) 10 3 8 58 1
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
52248 201838 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 350 Friedell St 8 Sidewalk: Curb side : Cutout Tree Private 2   07/12/2017 12:00:00 AM 3 Width 5ft Permit Number 770566 6020663.4716 2092744.71005 37.7274339035298 -122.370771395785 (37.7274339035298, -122.370771395785) 10 3 8 58 1
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
53926 201827 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 258 Friedell St 1 Sidewalk: Curb side : Cutout Tree Private 2   07/12/2017 12:00:00 AM 3 Width 5ft Permit Number 770566 6020879.65439 2093047.83852 37.7282781025329 -122.370044984594 (37.7282781025329, -122.370044984594) 10 3 8 58 1
54445 201812 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 101 Friedell St 3 : Tree Private 2     1 Width 6ft   6021065.67541 2093224.76894 37.7287741263267 -122.369414113788 (37.7287741263267, -122.369414113788) 10 3 8 58 1
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
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
57077 201825 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 232 Friedell St 1 Sidewalk: Curb side : Cutout Tree Private 2   07/12/2017 12:00:00 AM 3 Width 5ft Permit Number 770566 6020928.29141 2093111.19247 37.7284547293849 -122.369881218949 (37.7284547293849, -122.369881218949) 10 3 8 58 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
59083 88474 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 2350 Jerrold Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   07/18/2008 12:00:00 AM 3 3x3 Permit Number 51428 6011695.42869 2099760.86607 37.7462023967426 -122.402267215055 (37.7462023967426, -122.402267215055) 10 3 8 58 1
59846 201831 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 350 Friedell St 1 Sidewalk: Curb side : Cutout Tree Private 2   07/12/2017 12:00:00 AM 3 Width 5ft Permit Number 770566 6020768.36275 2092897.88429 37.7278602487283 -122.370419366967 (37.7278602487283, -122.370419366967) 10 3 8 58 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
63555 201813 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 101 Friedell St 4 Sidewalk: Curb side : Cutout Tree Private 2   07/12/2017 12:00:00 AM 3 Width 6ft   6021086.18405 2093254.37787 37.7288565518864 -122.369345258092 (37.7288565518864, -122.369345258092) 10 3 8 58 1
65951 191221 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 101 Mississippi St 3 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 3ft   6014015.89789 2106592.91783 37.7650909952748 -122.394721628821 (37.7650909952748, -122.394721628821) 14 3 8 28856 29
66747 27158 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 1700X Silver Ave 7 Sidewalk: Curb side : Cutout Tree DPW 1   07/28/2011 12:00:00 AM 3 3x3   6011192.58379 2095136.52795 37.7334768701528 -122.403680681311 (37.7334768701528, -122.403680681311) 10 3 8 58 1
67683 191232 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 2055 Silver Ave 1 : Tree Private 2     4 Width 3ft   6012617.37339 2096166.05375 37.7363832218132 -122.398826976382 (37.7363832218132, -122.398826976382) 10 3 8 58 1
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
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
72608 201817 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 100 Friedell St 1 : Tree Private 2   07/12/2017 12:00:00 AM 3 Width 5ft   6021101.98762 2093338.62944 37.7290887577236 -122.369296441991 (37.7290887577236, -122.369296441991) 10 3 8 58 1
73269 92664 Permitted Site 7 Lagunaria patersonii :: Primrose Tree 6 791 San Bruno Ave 2 Sidewalk: Property side : Cutout Tree Private 2   09/11/2009 12:00:00 AM     Permit Number 52939 6011029.3 2104669.9 37.7596443172001 -122.404916188138 (37.7596443172001, -122.404916188138) 10 3 8 28856 29
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
75496 191243 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 1620 Newhall St 4 : Tree Private 2     3 Width 2ft   6014061.56884 2095278.41625 37.7340263154591 -122.393771638049 (37.7340263154591, -122.393771638049) 10 3 8 58 1
76376 191242 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 1620 Newhall St 3 : Tree Private 2     3 Width 2ft   6014072.32553 2095292.84785 37.73406653943 -122.393735458343 (37.73406653943, -122.393735458343) 10 3 8 58 1
76682 201818 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 100 Friedell St 2 : Tree Private 2   07/12/2017 12:00:00 AM 3 Width 5ft   6021088.08179 2093322.41734 37.7290434795636 -122.369343396492 (37.7290434795636, -122.369343396492) 10 3 8 58 1
77318 191240 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 1620 Newhall St 1 : Tree Private 2     3 Width 2ft   6014102.75792 2095335.27393 37.734184723833 -122.393633211698 (37.734184723833, -122.393633211698) 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
80797 201815 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 101 Friedell St 6 Sidewalk: Curb side : Cutout Tree Private 2   07/12/2017 12:00:00 AM 3 Width 6ft   6021129.2467 2093308.19399 37.7290066829092 -122.369200102111 (37.7290066829092, -122.369200102111) 10 3 8 58 1
82173 201824 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 100 Friedell St 8 : Tree Private 2   07/12/2017 12:00:00 AM 3 Width 5ft   6021004.60368 2093212.58809 37.7287373296405 -122.369624404053 (37.7287373296405, -122.369624404053) 10 3 8 58 1
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
86466 191233 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 2055 Silver Ave 6 : Tree Private 2     3 Width 3ft   6012545.71972 2096123.80654 37.7362632270542 -122.399071750278 (37.7362632270542, -122.399071750278) 10 3 8 58 1
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
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
92176 191244 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 1620 Newhall St 5 : Tree Private 2     3 Width 2ft   6014050.66054 2095263.98772 37.7339860914812 -122.393808342098 (37.7339860914812, -122.393808342098) 10 3 8 58 1
94732 88465 Permitted Site 7 Lagunaria patersonii :: Primrose Tree 6 955X Newhall St 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/11/2008 12:00:00 AM 6 3x3 Permit Number 51410 6015306.946426 2096847.395831 37.7384035424873 -122.389575486471 (37.7384035424873, -122.389575486471) 10 3 8 58 1
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
97627 27156 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 1700X Silver Ave 5 Sidewalk: Curb side : Cutout Tree DPW 1   07/28/2011 12:00:00 AM 3 3x3   6011160.21022 2095112.55455 37.7334092357479 -122.403790920224 (37.7334092357479, -122.403790920224) 10 3 8 58 1
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
102075 201832 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 350 Friedell St 2 Sidewalk: Curb side : Cutout Tree Private 2   07/12/2017 12:00:00 AM 3 Width 5ft Permit Number 770566 6020752.62591 2092874.74971 37.7277958617862 -122.370472171548 (37.7277958617862, -122.370472171548) 10 3 8 58 1
102170 39552 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 1101 16th St 1 Sidewalk: Curb side : Cutout Tree Private 2   12/28/1998 12:00:00 AM 10   Permit Number 40979 6013009.1617 2107035.865 37.7662512051775 -122.398234785624 (37.7662512051775, -122.398234785624) 14 3 8 28856 20
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
106294 191227 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 201 Texas St 1 : Tree Private 2     3 Width 3ft   6013759.688 2106121.42545 37.7637821327587 -122.395574766182 (37.7637821327587, -122.395574766182) 14 3 8 28856 29
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
108420 201836 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 350 Friedell St 6 Sidewalk: Curb side : Cutout Tree Private 2   07/12/2017 12:00:00 AM 3 Width 5ft Permit Number 770566 6020688.4191 2092782.87071 37.7275400550072 -122.370687788509 (37.7275400550072, -122.370687788509) 10 3 8 58 1
111468 27168 Permitted Site 7 Lagunaria patersonii :: Primrose Tree 6 2070X Silver Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   12/21/2007 12:00:00 AM 6 2X3   6012351.75792 2095958.07131 37.735797342091 -122.399730727068 (37.735797342091, -122.399730727068) 10 3 8 58 1
112579 191230 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 1251 Newhall St 1 : Tree Private 2     6 Width 3ft   6014739.49892 2096121.87769 37.7363799383901 -122.391486752132 (37.7363799383901, -122.391486752132) 10 3 8 58 1
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
115205 191229 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 901 Newhall St 3 : Tree Private 2     6 Width 3ft   6015272.35005 2096832.51763 37.7383607716336 -122.389694066038 (37.7383607716336, -122.389694066038) 10 3 8 58 1
116827 191241 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 1620 Newhall St 2 : Tree Private 2     3 Width 2ft   6014082.94285 2095307.88657 37.7341084226719 -122.393699802926 (37.7341084226719, -122.393699802926) 10 3 8 58 1
117513 88483 Permitted Site 7 Lagunaria patersonii :: Primrose Tree 6 1221 Newhall St 4 Sidewalk: Curb side : Cutout Tree Private 2   07/18/2008 12:00:00 AM 5 3x3 Permit Number 51432 6014835.95113 2096251.52849 37.7367412859786 -122.391162333372 (37.7367412859786, -122.391162333372) 10 3 8 58 1
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
120653 200835 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 1101 16th St 3 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 0ft   6013058.6169 2107038.7182 37.7662617940431 -122.398063928568 (37.7662617940431, -122.398063928568) 14 3 8 28856 20
120971 95999 Permitted Site 7 Lagunaria patersonii :: Primrose Tree 6 1682 Newcomb Ave 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/16/2011 12:00:00 AM   3x3 Permit Number 767649 6014786.9 2096088.7 37.7362914700729 -122.39132054684 (37.7362914700729, -122.39132054684) 10 3 8 58 1
121234 201829 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 284 Friedell St 1 Sidewalk: Curb side : Cutout Tree Private 2   07/12/2017 12:00:00 AM 3 Width 5ft Permit Number 770566 6020846.41585 2093000.79454 37.7281471046068 -122.370156642634 (37.7281471046068, -122.370156642634) 10 3 8 58 1
121429 191228 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 901 Newhall St 1 : Tree Private 2     8 Width 3ft   6015254.00871 2096807.91476 37.7382922001146 -122.38975576401 (37.7382922001146, -122.38975576401) 10 3 8 58 1
122415 92665 Permitted Site 7 Lagunaria patersonii :: Primrose Tree 6 791 San Bruno Ave 3 Sidewalk: Property side : Cutout Tree Private 2   09/11/2009 12:00:00 AM     Permit Number 52939 6011029.3 2104669.9 37.7596443172001 -122.404916188138 (37.7596443172001, -122.404916188138) 10 3 8 28856 29
122458 87640 Permitted Site 7 Lagunaria patersonii :: Primrose Tree 6 2300X Silver Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   01/24/2008 12:00:00 AM   3x3   6012975.96285 2096322.27153 37.7368321371284 -122.397598127165 (37.7368321371284, -122.397598127165) 10 3 8 58 1
123991 65594 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 1221 Newhall St 1 Sidewalk: Curb side : Cutout Tree Private 2   02/05/1990 12:00:00 AM 7   Permit Number 28496 6014809.91986 2096215.04668 37.7366396697686 -122.391249786165 (37.7366396697686, -122.391249786165) 10 3 8 58 1
125237 201811 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 101 Friedell St 2 : Tree Private 2     1 Width 6ft   6021050.71889 2093203.62599 37.7287152512926 -122.369464359799 (37.7287152512926, -122.369464359799) 10 3 8 58 1
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
127080 112029 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 2101x 22nd Ave 9 Sidewalk: Curb side : Cutout Tree SFUSD 4   07/23/2015 12:00:00 AM 3 9x9   6011761 2103726 37.75709344993 -122.402319220858 (37.75709344993, -122.402319220858) 10 3 8 28856 29
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
129793 201837 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 350 Friedell St 7 Sidewalk: Curb side : Cutout Tree Private 2   07/12/2017 12:00:00 AM 3 Width 5ft Permit Number 770566 6020676.58787 2092764.09442 37.7274878493838 -122.370727391967 (37.7274878493838, -122.370727391967) 10 3 8 58 1
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
133595 88475 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 2350 Jerrold Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   07/18/2008 12:00:00 AM 3 3x3 Permit Number 51428 6011686.38123 2099767.14104 37.7462191214225 -122.402298941348 (37.7462191214225, -122.402298941348) 10 3 8 58 1
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
135455 201808 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 247 Friedell St 1 : Tree Private 2     1 Width 6ft   6020927.8472 2093035.08257 37.7282457215548 -122.369877496672 (37.7282457215548, -122.369877496672) 10 3 8 58 1
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
137235 88480 Permitted Site 7 Lagunaria patersonii :: Primrose Tree 6 1221 Newhall St 1 Sidewalk: Curb side : Cutout Tree Private 2   07/18/2008 12:00:00 AM   3x3 Permit Number 51432 6014837 2096254 37.7367481304458 -122.391158879645 (37.7367481304458, -122.391158879645) 10 3 8 58 1
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
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
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
143294 82700 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 1506-1508 Underwood Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   07/09/2009 12:00:00 AM 3 3x3 Permit Number 52505 6015020.9353 2093436.9104 37.7290231783131 -122.390326164865 (37.7290231783131, -122.390326164865) 10 3 8 58 1
145694 40073 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 102 Thornton Ave 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/19/1999 12:00:00 AM 10   Permit Number 41298 6014207.29735 2094114.30982 37.7308380137496 -122.393186376362 (37.7308380137496, -122.393186376362) 10 3 8 58 1
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
146566 201835 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 350 Friedell St 5 Sidewalk: Curb side : Cutout Tree Private 2   07/12/2017 12:00:00 AM 3 Width 5ft Permit Number 770566 6020706.7385 2092807.85492 37.7276096625463 -122.370626184075 (37.7276096625463, -122.370626184075) 10 3 8 58 1
146833 88482 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 1221 Newhall St 3 Sidewalk: Curb side : Cutout Tree Private 2   07/18/2008 12:00:00 AM 5 3x3 Permit Number 51432 6014826.89323 2096240.8429 37.7367114428676 -122.391192904038 (37.7367114428676, -122.391192904038) 10 3 8 58 1
147718 201819 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 100 Friedell St 3 Sidewalk: Curb side : Yard Tree Private 2   07/12/2017 12:00:00 AM 3 Width 4ft   6021071.50009 2093300.77069 37.7289831323462 -122.369399226393 (37.7289831323462, -122.369399226393) 10 3 8 58 1
148668 49802 Permitted Site 7 Lagunaria patersonii :: Primrose Tree 6 101 MISSISSIPPI ST 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/11/2003 12:00:00 AM     Permit Number 46598 6014071 2106574 37.765042114519 -122.394529717904 (37.765042114519, -122.394529717904) 14 3 8 28856 29
149415 201820 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 100 Friedell St 4 Sidewalk: Curb side : Yard Tree Private 2   07/12/2017 12:00:00 AM 3 Width 4ft   6021056.53291 2093279.09213 37.7289227860515 -122.369449472416 (37.7289227860515, -122.369449472416) 10 3 8 58 1

Next page

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