1,121 rows where qSpecies_id = 6 sorted by Neighborhoods (old)

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) ▼
1967 259348 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 450x Burrows St 2 Sidewalk: Curb side : Cutout Tree DPW 1 FUF 04/27/2019 12:00:00 AM 3                        
3117 260221 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 2201x 22nd Ave 13 Sidewalk: Curb side : Cutout Tree DPW 1 FUF 10/20/2018 12:00:00 AM 3                        
3183 260224 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 2201x 22nd Ave 20 Sidewalk: Curb side : Cutout Tree DPW 1 FUF 10/20/2018 12:00:00 AM 3                        
5614 259341 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 102 Bacon St 2 Sidewalk: Curb side : Cutout Tree DPW 1 FUF 04/27/2019 12:00:00 AM 3                        
5784 260220 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 2201x 22nd Ave 12 Sidewalk: Curb side : Cutout Tree DPW 1 FUF 10/20/2018 12:00:00 AM 3                        
8715 260222 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 2201x 22nd Ave 15 Sidewalk: Curb side : Cutout Tree DPW 1 FUF 10/20/2018 12:00:00 AM 3                        
11368 259340 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 102 Bacon St 1 Sidewalk: Curb side : Cutout Tree DPW 1 FUF 04/27/2019 12:00:00 AM 3                        
12542 262149 Private 9 Lagunaria patersonii :: Primrose Tree 6 4600 Irving St 1 Sidewalk: Curb side : Cutout Tree Private 2   05/11/2020 12:00:00 AM 3                        
15370 50774 Permitted Site 7 Lagunaria patersonii :: Primrose Tree 6   1 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 47304                    
16718 262177 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 620 Rutland St 2 Sidewalk: Curb side : Cutout Tree DPW 1 FUF 09/07/2019 12:00:00 AM 3                        
17639 260223 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 2201x 22nd Ave 19 Sidewalk: Curb side : Cutout Tree DPW 1 FUF 10/20/2018 12:00:00 AM 3                        
17693 259347 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 450x Burrows St 1 Sidewalk: Curb side : Cutout Tree DPW 1 FUF 04/27/2019 12:00:00 AM 3                        
18773 255529 Permitted Site 7 Lagunaria patersonii :: Primrose Tree 6 1555 O'Farrell St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/12/2018 12:00:00 AM 3 3x3 Permit Number 782018                    
19156 259400 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 1649 Newcomb Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1 FUF 10/13/2018 12:00:00 AM 3                        
19327 262176 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 620 Rutland St 1 Sidewalk: Curb side : Cutout Tree DPW 1 FUF 09/07/2019 12:00:00 AM 3                        
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
3177 191238 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 1600 Newhall St 8 : Tree Private 2     2 Width 2ft   6014118.19632 2095356.58877 37.7342441078693 -122.393581327137 (37.7342441078693, -122.393581327137) 10 3 8 58 1
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
10393 3666 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 100X Cargo Way 102 Sidewalk: Curb side : Cutout Tree Port 6   05/02/2017 03:06:00 PM 3 3X3   6017134.48475 2098914.37607 37.7441802162386 -122.383400533034 (37.7441802162386, -122.383400533034) 10 3 8 58 1
11481 3673 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 100X Cargo Way 109 Sidewalk: Curb side : Cutout Tree Port 6   04/10/2017 10:21:00 AM 3 3X3   6017015.17172 2099002.62034 37.7444159222737 -122.383819238476 (37.7444159222737, -122.383819238476) 10 3 8 58 1
11900 3534 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 201X Cargo Way 44 Sidewalk: Curb side : Cutout Tree DPW 1   04/10/2017 11:10:00 AM 3 3X3   6018402.12937 2097818.41667 37.7412409080406 -122.378941151133 (37.7412409080406, -122.378941151133) 10 3 8 58 1
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
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
13676 262543 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 1260 Egbert Ave 2 Sidewalk: Curb side : Cutout Tree DPW 1 FUF 08/18/2020 12:00:00 AM       6015062.6163 2090599.75011 37.7212352119804 -122.389983958896 (37.7212352119804, -122.389983958896) 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
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
21462 201816 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 101 Friedell St 7 Sidewalk: Curb side : Cutout Tree Private 2   07/12/2017 12:00:00 AM 3 Width 6ft   6021143.08428 2093327.21502 37.7290596700622 -122.369153577473 (37.7290596700622, -122.369153577473) 10 3 8 58 1
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
25283 3523 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 201X Cargo Way 33 Sidewalk: Curb side : Cutout Tree DPW 1   04/10/2017 11:28:00 AM 3 3X3   6018216.35215 2097958.49501 37.7416152904271 -122.379593238756 (37.7416152904271, -122.379593238756) 10 3 8 58 1
28445 3667 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 100X Cargo Way 103 Sidewalk: Curb side : Cutout Tree Port 6   05/02/2017 03:19:00 PM 3 3X3   6017116.62756 2098928.27448 37.7442173915214 -122.383463247242 (37.7442173915214, -122.383463247242) 10 3 8 58 1
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
31518 201833 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 350 Friedell St 3 Sidewalk: Curb side : Cutout Tree Private 2   07/12/2017 12:00:00 AM 3 Width 5ft Permit Number 770566 6020733.63229 2092847.87799 37.7277210345753 -122.370535976659 (37.7277210345753, -122.370535976659) 10 3 8 58 1
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
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
33446 191235 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 1600 Newhall St 2 : Tree Private 2     3 Width 2ft   6014141.54444 2095385.83675 37.7343257141509 -122.393502650848 (37.7343257141509, -122.393502650848) 10 3 8 58 1
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
149658 189150 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 351 Cargo Way 8 Sidewalk: Curb side : Cutout Tree DPW 1   04/10/2017 11:46:00 AM 3 Width 3ft   6017356.8528 2098625.87133 37.7434003277556 -122.382611554189 (37.7434003277556, -122.382611554189) 10 3 8 58 1
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

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