trees
1,121 rows where qSpecies_id = 6 sorted by Police Districts
This data as json, CSV (advanced)
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 |
Advanced export
JSON shape: default, array, newline-delimited, object
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) );