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

View and edit SQL

rowid TreeID qLegalStatus_id qSpecies_id qAddress SiteOrder qSiteInfo PlantType qCaretaker_id qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location Fire Prevention Districts Police Districts ▼ Supervisor Districts Zip Codes Neighborhoods (old)
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                        
4231 261663 Undocumented 4 Lagunaria patersonii :: Primrose Tree 6 1099x Broadway   Sidewalk: Curb side : Cutout Tree Private 2   10/28/2020 12:00:00 AM 3 3x3   6008393 2118190 37.7966195766837 -122.414990814528 (37.7966195766837, -122.414990814528) 5 1 10 308 21
4801 125249 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 1077 Broadway 1 Sidewalk: Curb side : Cutout Tree Private 2   10/28/2020 12:00:00 AM 3 Width 3ft   6008457.69643 2118247.71377 37.7967816796858 -122.414771036277 (37.7967816796858, -122.414771036277) 5 1 10 308 21
6798 125247 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 1085 Broadway 1 Sidewalk: Curb side : Cutout Tree Private 2   10/28/2020 12:00:00 AM 3 3x3 Permit Number 782055 6008420.1565 2118241.89629 37.796763597016 -122.414900521554 (37.796763597016, -122.414900521554) 5 1 10 308 21
42267 83686 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 1250-1262 Mason St 2 Sidewalk: Curb side : Cutout Tree Private 2   06/30/2009 12:00:00 AM 7 3x3 Permit Number 52242 6009408.29288 2117660.17543 37.7952218082983 -122.411440210903 (37.7952218082983, -122.411440210903) 3 1 10 28857 4
49974 73594 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 780 Post St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/12/2014 12:00:00 AM 3   Permit Number 772812 6008453.79298 2114896.74793 37.7875805296608 -122.414547298434 (37.7875805296608, -122.414547298434) 5 1 10 28858 21
74010 129386 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 929 Pine St 2 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   6009490.7484 2116033.66261 37.7907604245028 -122.411039958651 (37.7907604245028, -122.411039958651) 5 1 10 28857 21
80490 83685 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 1250-1262 Mason St 3 Sidewalk: Curb side : Cutout Tree Private 2   06/30/2009 12:00:00 AM 6 3x3 Permit Number 52242 6009407.14931 2117677.56911 37.7952695029448 -122.411445397284 (37.7952695029448, -122.411445397284) 3 1 10 28857 4
81222 83687 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 1250-1262 Mason St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/30/2009 12:00:00 AM 6 3x3 Permit Number 52242 6009414.65188 2117634.89994 37.7951527646548 -122.411416421158 (37.7951527646548, -122.411416421158) 3 1 10 28857 4
81750 129385 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 722 Mason St 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 4ft   6009662.68842 2115877.38276 37.7903409582254 -122.41043401253 (37.7903409582254, -122.41043401253) 5 1 10 28857 21
102379 84816 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 736 Leavenworth St 1 Sidewalk: Curb side : Cutout Tree Private 2   11/13/2009 12:00:00 AM 4 3x3 Permit Number 53031 6008319.93046 2115035.61847 37.7879543130824 -122.415020270782 (37.7879543130824, -122.415020270782) 5 1 10 28858 21
127633 52071 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 939 Jackson St 2 Sidewalk: Curb side : Cutout Tree Private 2   10/04/2005 12:00:00 AM 7   Permit Number 48265 6009677.58908 2117754.14875 37.7954949369081 -122.410515038747 (37.7954949369081, -122.410515038747) 3 1 10 28857 4
131191 71549 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 780 Post St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/18/2015 12:00:00 AM 3 3x3 Permit Number 772812 6008431.05429 2114892.38013 37.7875672592553 -122.414625660841 (37.7875672592553, -122.414625660841) 5 1 10 28858 21
142268 129380 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 730 Leavenworth St 1 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 4ft   6008321.92773 2115014.63424 37.7878968077251 -122.415011874722 (37.7878968077251, -122.415011874722) 5 1 10 28858 21
146089 52362 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 1438ASHINGTON Leavenworth St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/14/2005 12:00:00 AM 9   Permit Number 48498 6007994.93646 2117377.76116 37.7943669936906 -122.416310648633 (37.7943669936906, -122.416310648633) 5 1 10 28858 21
150091 129390 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 902 Vallejo St 1 Sidewalk: Curb side : Pot Tree Private 2     4 Width 4ft   6009192.86484 2118752.75452 37.798209676283 -122.412262888224 (37.798209676283, -122.412262888224) 3 1 10 308 21
154237 60223 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 1230 Mason St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/30/2009 12:00:00 AM 8 3x3 Permit Number 52240 6009426.59197 2117542.6242 37.7949000677337 -122.411368584404 (37.7949000677337, -122.411368584404) 3 1 10 28857 4
158967 79726 Permitted Site 7 Lagunaria patersonii :: Primrose Tree 6 780 Post St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/18/2008 12:00:00 AM   3x3 Permit Number 50955 6008416.19534554 2114892.53002417 37.7875668360064 -122.414677080613 (37.7875668360064, -122.414677080613) 5 1 10 28858 21
166093 88438 Permitted Site 7 Lagunaria patersonii :: Primrose Tree 6 1248 Mason St   Sidewalk: Curb side : Cutout Tree Private 2   06/30/2009 12:00:00 AM   3x3 Permit Number 52242 6009421 2117567 37.7949666840821 -122.411389656386 (37.7949666840821, -122.411389656386) 3 1 10 28857 4
188002 88645 Permitted Site 7 Lagunaria patersonii :: Primrose Tree 6 2500x Larkin St   Sidewalk: Curb side : Cutout Tree Private 2   08/05/2008 12:00:00 AM   3x3 Permit Number 51618 6006882.7 2119972.1 37.8014277902223 -122.420343352043 (37.8014277902223, -122.420343352043) 5 1 1 28858 32
194195 52070 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 939 Jackson St 1 Sidewalk: Curb side : Cutout Tree Private 2   10/04/2005 12:00:00 AM 7   Permit Number 48265 6009656.25559 2117750.51311 37.7954837583147 -122.410588599703 (37.7954837583147, -122.410588599703) 3 1 10 28857 4
15133 129382 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 91 McAllister St 1 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 4ft   6008704.56308 2112447.63135 37.7808699297471 -122.413506401504 (37.7808699297471, -122.413506401504) 7 10 9 28852 36
20503 129384 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 91 McAllister St 3 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 4ft   6008749.2926 2112454.62361 37.7808916402666 -122.413352154294 (37.7808916402666, -122.413352154294) 7 10 9 28852 36
107699 129383 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 91 McAllister St 2 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 4ft   6008721.10925 2112450.33412 37.7808782799549 -122.413449351208 (37.7808782799549, -122.413449351208) 7 10 9 28852 36
148373 129381 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 555 O'Farrell St 2 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 4ft   6008630.87446 2114175.52263 37.7856101663154 -122.413883591577 (37.7856101663154, -122.413883591577) 7 10 9 28852 36
9840 256599 Undocumented 4 Lagunaria patersonii :: Primrose Tree 6 2x Stillman St 26 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6014165 2112908 37.7824390851954 -122.394648183134 (37.7824390851954, -122.394648183134) 6 2 9 28856 6
18289 88190 Permitted Site 7 Lagunaria patersonii :: Primrose Tree 6 1118 Harrison St   Sidewalk: Curb side : Cutout Tree Private 2   07/08/2008 12:00:00 AM   3x3 Permit Number 51195 6010631 2110372 37.7752787109316 -122.406695562022 (37.7752787109316, -122.406695562022) 8 2 9 28853 34
29256 256605 Undocumented 4 Lagunaria patersonii :: Primrose Tree 6 2x Stillman St 32 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6014165 2112908 37.7824390851954 -122.394648183134 (37.7824390851954, -122.394648183134) 6 2 9 28856 6
32904 256600 Undocumented 4 Lagunaria patersonii :: Primrose Tree 6 2x Stillman St 27 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6014165 2112908 37.7824390851954 -122.394648183134 (37.7824390851954, -122.394648183134) 6 2 9 28856 6
48121 227587 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 77 Brady St 1 Sidewalk: Curb side : Cutout Tree Private 2     20 Width 3ft   6006751.41341 2109490.52204 37.7726405574578 -122.420053398542 (37.7726405574578, -122.420053398542) 8 2 9 28853 19
51877 256607 Undocumented 4 Lagunaria patersonii :: Primrose Tree 6 2x Stillman St 34 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6014165 2112908 37.7824390851954 -122.394648183134 (37.7824390851954, -122.394648183134) 6 2 9 28856 6
54965 191246 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 22 Rausch St 1 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 3ft   6009574.51886 2111002.08454 37.776949608681 -122.410394686976 (37.776949608681, -122.410394686976) 8 2 9 28853 34
61590 256576 Undocumented 4 Lagunaria patersonii :: Primrose Tree 6 2x Stillman St 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6014165 2112908 37.7824390851954 -122.394648183134 (37.7824390851954, -122.394648183134) 6 2 9 28856 6
70541 256574 Undocumented 4 Lagunaria patersonii :: Primrose Tree 6 2x Stillman St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6014165 2112908 37.7824390851954 -122.394648183134 (37.7824390851954, -122.394648183134) 6 2 9 28856 6
80264 105013 Permitted Site 7 Lagunaria patersonii :: Primrose Tree 6 330 Townsend St 2 Sidewalk: Curb side : Cutout Tree Private 2       3X3   6013709.8 2110877.9 37.7768395752266 -122.396080672132 (37.7768395752266, -122.396080672132) 6 2 9 28856 34
86891 41786 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 101 15th St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/20/2000 12:00:00 AM 11   Permit Number 42194 6011862.44614 2107450.91483 37.7673268978362 -122.402230262809 (37.7673268978362, -122.402230262809) 8 2 8 28853 20
92191 105012 Permitted Site 7 Lagunaria patersonii :: Primrose Tree 6 330 Townsend St 1 Sidewalk: Curb side : Cutout Tree Private 2       3X3   6013709.8 2110877.9 37.7768395752266 -122.396080672132 (37.7768395752266, -122.396080672132) 6 2 9 28856 34
92562 256604 Undocumented 4 Lagunaria patersonii :: Primrose Tree 6 2x Stillman St 31 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6014165 2112908 37.7824390851954 -122.394648183134 (37.7824390851954, -122.394648183134) 6 2 9 28856 6
97730 41784 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 101 15th St 4 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/20/2000 12:00:00 AM 13   Permit Number 42194 6011899.9957 2107451.97946 37.7673319169733 -122.40210045827 (37.7673319169733, -122.40210045827) 8 2 8 28853 20
107310 88186 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 43 Dore St 1 Sidewalk: Curb side : Cutout Tree Private 2   07/08/2008 12:00:00 AM 5 3x3 Permit Number 51193 6008751.52799 2109978.60624 37.7740932089612 -122.41316928526 (37.7740932089612, -122.41316928526) 8 2 9 28853 34
108082 41787 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 101 15th St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/20/2000 12:00:00 AM 11   Permit Number 42194 6011846.53611 2107450.83181 37.7673257817889 -122.402285287842 (37.7673257817889, -122.402285287842) 8 2 8 28853 20
121138 95828 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 174 Langton St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/29/2011 12:00:00 AM 6 3x3 Permit Number 767563 6010564.55165 2110346.83579 37.775205897855 -122.406923649213 (37.775205897855, -122.406923649213) 8 2 9 28853 34
134706 256601 Undocumented 4 Lagunaria patersonii :: Primrose Tree 6 2x Stillman St 28 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6014165 2112908 37.7824390851954 -122.394648183134 (37.7824390851954, -122.394648183134) 6 2 9 28856 6
136349 105014 Permitted Site 7 Lagunaria patersonii :: Primrose Tree 6 330 Townsend St 3 Sidewalk: Curb side : Cutout Tree Private 2       3X3   6013709.8 2110877.9 37.7768395752266 -122.396080672132 (37.7768395752266, -122.396080672132) 6 2 9 28856 34
140711 41785 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 101 15th St 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/20/2000 12:00:00 AM 13   Permit Number 42194 6011884.29769 2107452.29856 37.7673319169518 -122.402154778231 (37.7673319169518, -122.402154778231) 8 2 8 28853 20
149522 106431 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 747 Natoma St 1 Sidewalk: Curb side : Cutout Tree Private 2     2 3x3   6008848.75367 2110684.34026 37.7760364460542 -122.412882870049 (37.7760364460542, -122.412882870049) 8 2 9 28853 34
160238 256575 Undocumented 4 Lagunaria patersonii :: Primrose Tree 6 2x Stillman St 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6014165 2112908 37.7824390851954 -122.394648183134 (37.7824390851954, -122.394648183134) 6 2 9 28856 6
170364 88187 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 43 Dore St 2 Sidewalk: Curb side : Cutout Tree Private 2   07/08/2008 12:00:00 AM 6 3x3 Permit Number 51193 6008740.44285 2109989.37217 37.7741221473478 -122.413208392271 (37.7741221473478, -122.413208392271) 8 2 9 28853 34
183981 256606 Undocumented 4 Lagunaria patersonii :: Primrose Tree 6 2x Stillman St 33 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6014165 2112908 37.7824390851954 -122.394648183134 (37.7824390851954, -122.394648183134) 6 2 9 28856 6
190595 88188 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 43-25 Dore St 3 Sidewalk: Curb side : Cutout Tree Private 2   07/08/2008 12:00:00 AM 6 3x3 Permit Number 51193 6008699.51281 2110034.52168 37.7742438193359 -122.413353170509 (37.7742438193359, -122.413353170509) 8 2 9 28853 34
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
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
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
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
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
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
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
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
17049 112023 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 2101x 22nd Ave 3 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
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
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
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
24569 176914 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 1300 Silver Ave 4 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   6009346.09367 2094283.90387 37.7310324255937 -122.41000437762 (37.7310324255937, -122.41000437762) 9 3 7 309 28
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
25340 176908 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 1053 Silver Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 2ft   6007885.16277 2093698.95374 37.7293442892945 -122.415013692231 (37.7293442892945, -122.415013692231) 9 3 7 309 28
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
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
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

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