trees
185 rows where Police Districts = 3 and qSpecies_id = 6 sorted by SiteOrder
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |||
31876 | 88495 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 27 Reddy St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/18/2008 12:00:00 AM | 3x3 | Permit Number 51437 | 6013659 | 2094063 | 37.7306666521666 | -122.395078350002 | (37.7306666521666, -122.395078350002) | 10 | 3 | 8 | 58 | 1 | |||
1126 | 262542 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1260 Egbert Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 08/18/2020 12:00:00 AM | 6015016 | 2090665 | 37.7214117898675 | -122.390149655616 | (37.7214117898675, -122.390149655616) | 10 | 3 | 8 | 58 | 1 | |||
1417 | 88463 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 955X Newhall St | 1 | 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 |
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 | ||
9738 | 79640 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 168 Orsi Cir | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 9 | 6012982.50067 | 2092948.34875 | 37.727568405236 | -122.397338990501 | (37.727568405236, -122.397338990501) | 10 | 3 | 8 | 58 | 1 | |||
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 | ||
12096 | 83834 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 2300X Silver Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 6013045.53048 | 2096356.5558 | 37.7369301480983 | -122.397360003177 | (37.7369301480983, -122.397360003177) | 10 | 3 | 8 | 58 | 1 | |||
12282 | 83440 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 2230 18th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 8 | 6011076.92464 | 2105580.38381 | 37.7621469638337 | -122.404815578978 | (37.7621469638337, -122.404815578978) | 8 | 3 | 8 | 28856 | 29 | |||
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 | ||
16248 | 264659 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 971 Hollister Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 09/10/2020 12:00:00 AM | 3x3 | 6014920.44131 | 2089617.70445 | 37.7185308216427 | -122.390406839913 | (37.7185308216427, -122.390406839913) | 10 | 3 | 8 | 58 | 1 | |||
17413 | 112021 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 2101x 22nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 07/23/2015 12:00:00 AM | 3 | 5x5 | 6011761 | 2103726 | 37.75709344993 | -122.402319220858 | (37.75709344993, -122.402319220858) | 10 | 3 | 8 | 28856 | 29 | ||
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 | ||
22726 | 191234 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1600 Newhall St | 1 | : | Tree | Private 2 | 4 | Width 2ft | 6014153.11677 | 2095403.12134 | 37.7343738170818 | -122.393463850493 | (37.7343738170818, -122.393463850493) | 10 | 3 | 8 | 58 | 1 | |||
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 | ||
23895 | 92663 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 791 San Bruno Ave | 1 | 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 | |||
29816 | 95998 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 1682 Newcomb Ave | 1 | 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 | |
31921 | 191247 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1453 Hudson Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 6ft | 6016461.47366 | 2096825.22247 | 37.7384066073881 | -122.385582111127 | (37.7384066073881, -122.385582111127) | 10 | 3 | 8 | 58 | 1 | |||
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 | ||
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 | |
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 |
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 | |||
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 | |
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 | |
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 | ||
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 | ||
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 | ||
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 | |||
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 | ||
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 | ||
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 | ||
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 | |
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 | |||
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 | |||
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 | ||
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 | ||
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 | |||
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 | |||
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 | ||
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 | ||
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 | |
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 | |||
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 | ||
150802 | 61555 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1175- 1175 De Haro St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/18/2018 12:00:00 AM | 3 | 3x3 | Permit Number 781207 | 6012252.19835 | 2102963.49184 | 37.7550271768774 | -122.400566896541 | (37.7550271768774, -122.400566896541) | 10 | 3 | 8 | 28856 | 29 |
152733 | 40072 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 102 Thornton Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/19/1999 12:00:00 AM | 10 | Permit Number 41298 | 6014219.27435 | 2094112.15212 | 37.7308327545053 | -122.393144818701 | (37.7308327545053, -122.393144818701) | 10 | 3 | 8 | 58 | 1 | |
152989 | 47678 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 536 Pennsylvania Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/21/2002 12:00:00 AM | 9 | Permit Number 45462 | 6014348.84456 | 2104603.39752 | 37.7596467118443 | -122.393430795897 | (37.7596467118443, -122.393430795897) | 10 | 3 | 8 | 28856 | 29 | |
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 | ||
156156 | 201828 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 268 Friedell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/12/2017 12:00:00 AM | 3 | Width 5ft | Permit Number 770566 | 6020862.97624 | 2093021.36948 | 37.728204508308 | -122.3701008136 | (37.728204508308, -122.3701008136) | 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 | ||
157196 | 27169 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 2080 Silver Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/16/1999 12:00:00 AM | 6 | 2x3 | 6012550.77406 | 2096074.99276 | 37.7361294762783 | -122.39905085002 | (37.7361294762783, -122.39905085002) | 10 | 3 | 8 | 58 | 1 | ||
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 | ||
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 |
169734 | 201826 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 250 Friedell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/12/2017 12:00:00 AM | 3 | Width 5ft | Permit Number 770566 | 6020898.42083 | 2093071.04954 | 37.7283428654122 | -122.369981710984 | (37.7283428654122, -122.369981710984) | 10 | 3 | 8 | 58 | 1 | |
169785 | 201830 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 292 Friedell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/12/2017 12:00:00 AM | 3 | Width 5ft | Permit Number 770566 | 6020827.60649 | 2092975.44043 | 37.7280764547545 | -122.370219916224 | (37.7280764547545, -122.370219916224) | 10 | 3 | 8 | 58 | 1 | |
170413 | 191224 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 2350 20th St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | 6011129.67031 | 2104650.44992 | 37.7595965215873 | -122.404567686256 | (37.7595965215873, -122.404567686256) | 10 | 3 | 8 | 28856 | 29 | ||||
174884 | 191222 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1143 Mariposa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6013778.51486 | 2106149.81223 | 37.7638611238173 | -122.39551163825 | (37.7638611238173, -122.39551163825) | 14 | 3 | 8 | 28856 | 29 | |||
175350 | 191223 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1112 De Haro St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6012178.19052 | 2103217.19746 | 37.7557196692435 | -122.400840661869 | (37.7557196692435, -122.400840661869) | 10 | 3 | 8 | 28856 | 29 | |||
175919 | 201807 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 273 Friedell St | 1 | : | Tree | Private 2 | 2 | Width 6ft | 6020893.11722 | 2092989.08595 | 37.7281175177998 | -122.369994383343 | (37.7281175177998, -122.369994383343) | 10 | 3 | 8 | 58 | 1 | |||
176365 | 68842 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 602 Pennsylvania Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/27/2004 12:00:00 AM | 5 | 3x3 | Permit Number 767166 | 6014359.28345 | 2104329.14494 | 37.7588942535933 | -122.393375500204 | (37.7588942535933, -122.393375500204) | 10 | 3 | 8 | 28856 | 29 |
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 | ||
189147 | 191218 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 477 Vermont St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 6011234.32907 | 2106146.16371 | 37.7637092651804 | -122.404310998169 | (37.7637092651804, -122.404310998169) | 8 | 3 | 8 | 28856 | 29 | |||
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 | ||
192453 | 191245 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1675 Jerrold Ave | 1 | : | Tree | Private 2 | 12 | Width 3ft | 6014937.21218 | 2097262.06336 | 37.7395216264201 | -122.3908828304 | (37.7395216264201, -122.3908828304) | 10 | 3 | 8 | 58 | 1 | |||
193987 | 201809 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 237 Friedell St | 1 | : | Tree | Private 2 | 1 | Width 6ft | 6020945.51773 | 2093059.30039 | 37.7283131886973 | -122.369818081152 | (37.7283131886973, -122.369818081152) | 10 | 3 | 8 | 58 | 1 | |||
191983 | 27161 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1700X Silver Ave | 10 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 07/28/2011 12:00:00 AM | 3 | 3x3 | 6011020.5092245 | 2095004.7366116 | 37.7331053850338 | -122.40426632243 | (37.7331053850338, -122.40426632243) | 10 | 3 | 8 | 58 | 1 | ||
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 | ||
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 | ||
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 | ||
13960 | 27162 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1700X Silver Ave | 11 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 07/28/2011 12:00:00 AM | 3 | 3x3 | 6011270.31088 | 2095195.56425 | 37.7336433130742 | -122.40341610708 | (37.7336433130742, -122.40341610708) | 10 | 3 | 8 | 58 | 1 | ||
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 | |||
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 | |
162447 | 88066 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 2055 Silver Ave | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/24/2008 12:00:00 AM | 4 | 3x3 | Permit Number 51066 | 6012463.39117 | 2096075.79817 | 37.736126817888 | -122.399353026719 | (37.736126817888, -122.399353026719) | 10 | 3 | 8 | 58 | 1 | |
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 | ||
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 | ||
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 | ||
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 | |
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 | |||
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 | |||
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 | |
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 | ||
887 | 60297 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1101 16th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/27/1982 12:00:00 AM | 7 | Permit Number 19862 | 6013032.9382 | 2107035.865 | 37.7662525295396 | -122.398152546702 | (37.7662525295396, -122.398152546702) | 14 | 3 | 8 | 28856 | 20 | |
12065 | 88481 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1221 Newhall St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/18/2008 12:00:00 AM | 5 | 3x3 | Permit Number 51432 | 6014818.59944 | 2096228.0421 | 37.7366758342199 | -122.391220684988 | (37.7366758342199, -122.391220684988) | 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) );