1,985 rows where qSpecies_id = 83 sorted by Zip Codes

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)
449 252970 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 101X Whipple Ave 2 Sidewalk: Curb side : Yard Tree Private 2   04/26/2019 12:00:00 AM 3                        
2762 46200 Permitted Site 7 Pyrus kawakamii :: Evergreen Pear 83   2 Sidewalk: Curb side : Cutout Tree Private 2   12/31/2001 12:00:00 AM     Permit Number 44518                    
3450 52146 Permitted Site 7 Pyrus kawakamii :: Evergreen Pear 83 145 Hawes St 1 Sidewalk: Curb side : Cutout Tree Private 2   10/31/2005 12:00:00 AM     Permit Number 48337                    
3492 30592 Permitted Site 7 Pyrus kawakamii :: Evergreen Pear 83 269 Walter St 2 Sidewalk: Curb side : Cutout Tree Private 2   01/26/1995 12:00:00 AM     Permit Number 34561                    
7715 260428 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 745 Silliman St 1 Sidewalk: Curb side : Cutout Tree DPW 1 FUF 08/17/2019 12:00:00 AM 3                        
9907 30593 Permitted Site 7 Pyrus kawakamii :: Evergreen Pear 83 269 Walter St 1 Sidewalk: Curb side : Cutout Tree Private 2   01/26/1995 12:00:00 AM     Permit Number 34561                    
13512 259080 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 1001 Visitacion Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   06/01/2019 12:00:00 AM 3                        
15478 252965 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 115X Whipple Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   10/05/2017 02:04:00 PM 3                        
15527 19972 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 100 STAIRWAY44 3 Sidewalk: Curb side : Cutout Tree DPW 1     3 36                      
19620 46201 Permitted Site 7 Pyrus kawakamii :: Evergreen Pear 83   1 Sidewalk: Curb side : Cutout Tree Private 2   12/31/2001 12:00:00 AM     Permit Number 44518                    
1044 139272 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 765 FULTON ST 2 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 0ft   6004185.2644 2111476.3212 37.7779481591061 -122.429071593475 (37.7779481591061, -122.429071593475) 7 9 11 28852 10
2769 81793 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 435 Hayes St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF   5 3x3   6005759.2342 2111006.7416 37.7767477786156 -122.423593274768 (37.7767477786156, -122.423593274768) 7 9 11 28852 10
7946 74150 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 740 Buchanan St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   8     6004499.396 2111088.6935 37.7769016055642 -122.427957272174 (37.7769016055642, -122.427957272174) 7 9 11 28852 10
10522 31312 Permitted Site 7 Pyrus kawakamii :: Evergreen Pear 83 709 Buchanan St 2 Sidewalk: Curb side : Cutout Tree Private 2   04/12/1995 12:00:00 AM     Permit Number 34949 6004473.77987727 2110903.29372292 37.7763910940647 -122.428032671161 (37.7763910940647, -122.428032671161) 7 9 11 28852 10
19624 31313 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 709 Buchanan St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/12/1995 12:00:00 AM 7   Permit Number 34949 6004462.32974 2110985.15865 37.7766152272516 -122.428078115713 (37.7766152272516, -122.428078115713) 7 9 11 28852 10
20523 139996 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 450 FULTON ST 2 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 0ft   6005498.173 2111711.6583 37.77866856873 -122.424546518451 (37.77866856873, -122.424546518451) 7 9 11 28852 41
23938 237023 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 8 Octavia St 4 : Tree DPW 1   04/15/2017 01:44:00 PM 3 Width 6ft   6005765.01716 2109438.39176 37.7724417955802 -122.423461745458 (37.7724417955802, -122.423461745458) 7 9 11 28852 10
27515 139278 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 725 FULTON ST 5 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 0ft   6004349.2802 2111499.4808 37.7780210326226 -122.428505855992 (37.7780210326226, -122.428505855992) 7 9 11 28852 10
27967 30728 Permitted Site 7 Pyrus kawakamii :: Evergreen Pear 83 45 Rose St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/31/1995 12:00:00 AM     Permit Number 34624 6006303.86733164 2109861.47838862 37.7736338888904 -122.421627862373 (37.7736338888904, -122.421627862373) 7 9 11 28852 10
28771 8049 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 600 Fulton St 1 Sidewalk: Curb side : Cutout Tree DPW 1   03/08/2001 12:00:00 AM 12 3X3   6004627.99576 2111737.28964 37.7786897656705 -122.427558625827 (37.7786897656705, -122.427558625827) 7 9 11 28852 41
29084 95303 Permitted Site 7 Pyrus kawakamii :: Evergreen Pear 83 701 Golden Gate Ave 3 Sidewalk: Curb side : Cutout Tree Private 2   02/08/2011 12:00:00 AM   3x3 Permit Number 767203 6006127.5 2112421.2 37.780652317617 -122.422419858646 (37.780652317617, -122.422419858646) 7 9 11 28852 41
29821 138936 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 611 Ivy St 1 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 0ft   6004391.0086 2110998.5233 37.7766478878909 -122.428325789109 (37.7766478878909, -122.428325789109) 7 9 11 28852 10
36615 138937 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 609 Ivy St 2 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 0ft   6004415.7448 2111001.1974 37.7766566299655 -122.428240409959 (37.7766566299655, -122.428240409959) 7 9 11 28852 10
37445 118287 Undocumented 4 Pyrus kawakamii :: Evergreen Pear 83 240 IVY ST 1 Sidewalk: Curb side : Cutout Tree Private 2       3x2.5   6006177 2111293 37.7775573470216 -122.422168438332 (37.7775573470216, -122.422168438332) 7 9 11 28852 10
39609 8107 Permitted Site 7 Pyrus kawakamii :: Evergreen Pear 83 785 Fulton St 2 Sidewalk: Curb side : Cutout Tree Private 2   04/14/1998 12:00:00 AM 3 4X4   6004040.71712 2111448.77193 37.7778643322695 -122.429569668288 (37.7778643322695, -122.429569668288) 7 9 11 28852 10
46792 95302 Permitted Site 7 Pyrus kawakamii :: Evergreen Pear 83 701 Golden Gate Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   02/08/2011 12:00:00 AM   3x3 Permit Number 767203 6006127.5 2112421.2 37.780652317617 -122.422419858646 (37.780652317617, -122.422419858646) 7 9 11 28852 41
46951 138951 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 713 BUCHANAN ST 1 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 0ft   6004468.8943 2110977.1298 37.7765935534027 -122.428054834694 (37.7765935534027, -122.428054834694) 7 9 11 28852 10
54267 139271 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 765 FULTON ST 1 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 0ft   6004149.5758 2111471.3855 37.7779325866279 -122.429194700927 (37.7779325866279, -122.429194700927) 7 9 11 28852 10
59153 100410 Permitted Site 7 Pyrus kawakamii :: Evergreen Pear 83 201x Linden St 1 Sidewalk: Curb side : Cutout Tree Private 2   08/16/2012 12:00:00 AM     Permit Number 767727 6006435 2110776 37.7761523386864 -122.421239206856 (37.7761523386864, -122.421239206856) 7 9 11 28852 10
60223 97605 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 445 Hayes St 2 Sidewalk: Curb side : Cutout Tree Private 2   10/27/2011 12:00:00 AM 2 3x3 Permit Number 768351 6005728.0342 2111001.8882 37.7767326912067 -122.423700859813 (37.7767326912067, -122.423700859813) 7 9 11 28852 10
67141 29137 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 90x Jones St 2 Sidewalk: Curb side : Cutout Tree DPW 1   11/19/2005 12:00:00 AM 3 3x3   6009115.3969879 2112842.7343052 37.7819778479132 -122.412113051935 (37.7819778479132, -122.412113051935) 14 10 9 28852 36
67502 57721 Permitted Site 7 Pyrus kawakamii :: Evergreen Pear 83 231 Waller St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/19/2010 12:00:00 AM     Permit Number 53634 6004597.07146519 2109103.26366214 37.7714556250816 -122.427477905237 (37.7714556250816, -122.427477905237) 7 9 11 28852 10
70975 31336 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 745 Buchanan St 2 Sidewalk: Curb side : Cutout Tree Private 2   04/12/1995 12:00:00 AM 9   Permit Number 34951 6004456.33645 2111073.11505 37.776856394839 -122.42810511786 (37.776856394839, -122.42810511786) 7 9 11 28852 10
78779 8084 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 755X Fulton St 3 Sidewalk: Curb side : Cutout Tree DPW 1   12/14/2007 12:00:00 AM 3 3X3   6004115.11785 2111289.80956 37.7774320731857 -122.429300951982 (37.7774320731857, -122.429300951982) 7 9 11 28852 10
88172 31311 Permitted Site 7 Pyrus kawakamii :: Evergreen Pear 83 709 Buchanan St 3 Sidewalk: Curb side : Cutout Tree Private 2   04/12/1995 12:00:00 AM     Permit Number 34949 6004473.77987727 2110903.29372292 37.7763910940647 -122.428032671161 (37.7763910940647, -122.428032671161) 7 9 11 28852 10
88388 139267 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 785 FULTON ST 1 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 0ft   6004042.8897 2111456.1989 37.7778848479076 -122.429562682385 (37.7778848479076, -122.429562682385) 7 9 11 28852 10
90800 8083 Permitted Site 7 Pyrus kawakamii :: Evergreen Pear 83 755X Fulton St 2 Sidewalk: Curb side : Cutout Tree Private 2   04/14/1998 12:00:00 AM 6 3X3   6004278.93609 2111494.41804 37.7780031505288 -122.428748840382 (37.7780031505288, -122.428748840382) 7 9 11 28852 10
92180 138832 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 745 BUCHANAN ST 4 Sidewalk: Curb side : Yard Tree Private 2     9 Width 0ft   6004455.5234 2111072.8991 37.7768557558926 -122.428107915053 (37.7768557558926, -122.428107915053) 7 9 11 28852 10
94091 244319 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 331 Octavia St 2 Sidewalk: Curb side : Cutout Tree DPW 1   05/02/2017 04:00:00 PM 3 Width 0ft   6005497.6412 2110517.1934 37.7753888290162 -122.424463374134 (37.7753888290162, -122.424463374134) 7 9 11 28852 10
96679 142043 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 401 HAYES ST 1 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 0ft   6005850.7541 2111017.8349 37.776783403594 -122.423277468562 (37.776783403594, -122.423277468562) 7 9 11 28852 10
98292 139277 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 725 FULTON ST 4 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 0ft   6004315.8695 2111494.5451 37.778005589649 -122.428621083615 (37.778005589649, -122.428621083615) 7 9 11 28852 10
100200 237022 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 8 Octavia St 3 : Tree DPW 1   04/15/2017 01:40:00 PM 3 Width 6ft   6005770.13323 2109412.50366 37.772371001847 -122.423442207693 (37.772371001847, -122.423442207693) 7 9 11 28852 10
100640 8079 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 676 Fulton St 1 Sidewalk: Curb side : Cutout Tree DPW 1   04/14/1998 12:00:00 AM 18 3X3   6004627.99576 2111737.28964 37.7786897656705 -122.427558625827 (37.7786897656705, -122.427558625827) 7 9 11 28852 41
102196 95304 Permitted Site 7 Pyrus kawakamii :: Evergreen Pear 83 701 Golden Gate Ave 4 Sidewalk: Curb side : Cutout Tree Private 2   02/08/2011 12:00:00 AM   3x3 Permit Number 767203 6006127.5 2112421.2 37.780652317617 -122.422419858646 (37.780652317617, -122.422419858646) 7 9 11 28852 41
102932 237024 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 8 Octavia St 5 : Tree DPW 1   04/15/2017 01:48:00 PM 3 Width 6ft   6005763.84021 2109451.72322 37.772478334131 -122.423466764586 (37.772478334131, -122.423466764586) 7 9 11 28852 10
103131 249400 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 230 Hyde St 1 : Tree Private 2     3 Width 3ft   6008085.57169 2113256.87585 37.7830571448252 -122.415705117997 (37.7830571448252, -122.415705117997) 7 10 9 28852 36
104496 10234 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 47 Haight St 2 Sidewalk: Curb side : Cutout Tree DPW 1   04/29/2011 12:00:00 AM 3 4x4   6005872.37024 2109570.63288 37.7728109564944 -122.423099801515 (37.7728109564944, -122.423099801515) 7 9 11 28852 10
115665 100415 Permitted Site 7 Pyrus kawakamii :: Evergreen Pear 83 201x Linden St 6 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 767727 6006435 2110776 37.7761523386864 -122.421239206856 (37.7761523386864, -122.421239206856) 7 9 11 28852 10
121737 33691 Permitted Site 7 Pyrus kawakamii :: Evergreen Pear 83 625 Ivy St 2 Sidewalk: Curb side : Cutout Tree Private 2   12/03/1996 12:00:00 AM     Permit Number 37764 6004364.86581498 2110979.96495009 37.776595451913 -122.428414901604 (37.776595451913, -122.428414901604) 7 9 11 28852 10
123347 8086 Permitted Site 7 Pyrus kawakamii :: Evergreen Pear 83 755X Fulton St 5 Sidewalk: Curb side : Cutout Tree Private 2   01/01/2001 12:00:00 AM 6 3X3   6004351.32927 2111504.25977 37.7780342704524 -122.428499108252 (37.7780342704524, -122.428499108252) 7 9 11 28852 10
124327 8099 Permitted Site 7 Pyrus kawakamii :: Evergreen Pear 83 765 Fulton St 2 Sidewalk: Curb side : Cutout Tree Private 2   04/14/1998 12:00:00 AM 8 3X3   6004167.34812 2111468.4499 37.7779255322683 -122.429133010837 (37.7779255322683, -122.429133010837) 7 9 11 28852 10
124854 97604 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 445 Hayes St 1 Sidewalk: Curb side : Cutout Tree Private 2   10/27/2011 12:00:00 AM 2 3x5 Permit Number 768351 6005714.1676 2110999.8082 37.7767261972703 -122.423748680625 (37.7767261972703, -122.423748680625) 7 9 11 28852 10
127187 249399 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 222 Hyde St 1 : Tree Private 2     3 Width 3ft   6008090.57738 2113215.48771 37.7829437843643 -122.41568486887 (37.7829437843643, -122.41568486887) 7 10 9 28852 36
129469 52112 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 435 Hayes St 1 Sidewalk: Curb side : Cutout Tree Private 2   10/26/2005 12:00:00 AM 3 3x3 Permit Number 48303 6005739.8209 2111002.5816 37.776735260452 -122.423660135383 (37.776735260452, -122.423660135383) 7 9 11 28852 10
130051 100414 Permitted Site 7 Pyrus kawakamii :: Evergreen Pear 83 201x Linden St 5 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 767727 6006435 2110776 37.7761523386864 -122.421239206856 (37.7761523386864, -122.421239206856) 7 9 11 28852 10
131665 2436 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 740 Buchanan St 2 Sidewalk: Curb side : Cutout Tree DPW 1   01/22/1999 12:00:00 AM 3 3X3   6004500.11127 2111079.27008 37.7768757716325 -122.427954126177 (37.7768757716325, -122.427954126177) 7 9 11 28852 10
136183 95301 Permitted Site 7 Pyrus kawakamii :: Evergreen Pear 83 701 Golden Gate Ave   Sidewalk: Curb side : Cutout Tree Private 2   02/08/2011 12:00:00 AM   3x3 Permit Number 767203 6006127.5 2112421.2 37.780652317617 -122.422419858646 (37.780652317617, -122.422419858646) 7 9 11 28852 41
136697 239151 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 100 Octavia St 2 : Tree DPW 1   04/15/2017 01:58:00 PM 3 Width 4ft   6005731.03459 2109700.90805 37.7731606839629 -122.423597962203 (37.7731606839629, -122.423597962203) 7 9 11 28852 10
137024 33690 Permitted Site 7 Pyrus kawakamii :: Evergreen Pear 83 625 Ivy St 1 Sidewalk: Curb side : Cutout Tree Private 2   12/03/1996 12:00:00 AM     Permit Number 37764 6004364.86581498 2110979.96495009 37.776595451913 -122.428414901604 (37.776595451913, -122.428414901604) 7 9 11 28852 10
137622 100413 Permitted Site 7 Pyrus kawakamii :: Evergreen Pear 83 201x Linden St 4 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 767727 6006435 2110776 37.7761523386864 -122.421239206856 (37.7761523386864, -122.421239206856) 7 9 11 28852 10
138955 31338 Permitted Site 7 Pyrus kawakamii :: Evergreen Pear 83 745 Buchanan St 4 Sidewalk: Curb side : Cutout Tree Private 2   04/12/1995 12:00:00 AM   6x18 Permit Number 34951 6004451.86142632 2111060.17267694 37.7768206050732 -122.428119675771 (37.7768206050732, -122.428119675771) 7 9 11 28852 10
139840 8101 Permitted Site 7 Pyrus kawakamii :: Evergreen Pear 83 765 Fulton St 4 Sidewalk: Curb side : Cutout Tree Private 2   04/14/1998 12:00:00 AM 7 3X3   6004218.15362 2111478.37785 37.7779556678418 -122.428957964704 (37.7779556678418, -122.428957964704) 7 9 11 28852 10
140003 30525 Undocumented 4 Pyrus kawakamii :: Evergreen Pear 83 96 McAllister St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/19/2005 12:00:00 AM 10 3x3   6008672.39963745 2112539.12321188 37.7811193385199 -122.413624143987 (37.7811193385199, -122.413624143987) 7 10 9 28852 36
142553 8096 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 762 Fulton St 7 Sidewalk: Curb side : Cutout Tree Arts Commission 19   04/14/1998 12:00:00 AM 18 3X3   6004110.3708 2111520.4613 37.7780651171853 -122.429333825297 (37.7780651171853, -122.429333825297) 7 9 11 28852 41
146755 139268 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 785 FULTON ST 2 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 0ft   6004071.3646 2111459.6159 37.7778958423736 -122.429464421477 (37.7778958423736, -122.429464421477) 7 9 11 28852 10
147451 8108 Permitted Site 7 Pyrus kawakamii :: Evergreen Pear 83 785 Fulton St 3 Sidewalk: Curb side : Cutout Tree Private 2   04/14/1998 12:00:00 AM 4 3X3   6004054.06089 2111452.34079 37.777874887005 -122.429523762111 (37.777874887005, -122.429523762111) 7 9 11 28852 10
149337 8095 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 762 Fulton St 6 Sidewalk: Curb side : Cutout Tree Arts Commission 19   04/14/1998 12:00:00 AM 24 3X3   6004129.5547 2111522.3059 37.77807126806 -122.429267592872 (37.77807126806, -122.429267592872) 7 9 11 28852 41
149657 100412 Permitted Site 7 Pyrus kawakamii :: Evergreen Pear 83 201x Linden St 3 Sidewalk: Curb side : Cutout Tree Private 2   08/16/2012 12:00:00 AM     Permit Number 767727 6006435 2110776 37.7761523386864 -122.421239206856 (37.7761523386864, -122.421239206856) 7 9 11 28852 10
150121 142044 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 401 HAYES ST 2 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 0ft   6005880.5674 2111021.3015 37.7767946045442 -122.423174581774 (37.7767946045442, -122.423174581774) 7 9 11 28852 10
150151 8098 Permitted Site 7 Pyrus kawakamii :: Evergreen Pear 83 765 Fulton St 1 Sidewalk: Curb side : Cutout Tree Private 2   04/14/1998 12:00:00 AM 6 3X3   6004145.13907 2111463.64591 37.7779110844604 -122.42920949713 (37.7779110844604, -122.42920949713) 7 9 11 28852 10
154474 237028 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 8 Octavia St 9 : Tree DPW 1   04/15/2017 01:55:00 PM 3 Width 6ft   6005756.39315 2109517.28856 37.7726579404383 -122.423497186858 (37.7726579404383, -122.423497186858) 7 9 11 28852 10
155281 141980 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 676 FULTON ST 1 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 0ft   6004463.6367 2111570.2882 37.778221923041 -122.428115303303 (37.778221923041, -122.428115303303) 7 9 11 28852 41
158249 33638 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 434 Linden St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/03/1996 12:00:00 AM 7   Permit Number 37733 6005306.206 2110803.5701 37.7761643373284 -122.425145975417 (37.7761643373284, -122.425145975417) 7 9 11 28852 10
164717 49987 Permitted Site 7 Pyrus kawakamii :: Evergreen Pear 83 300@ GOUGH Linden St 5 Sidewalk: Curb side : Cutout Tree Private 2   07/23/2003 12:00:00 AM     Permit Number 46733 6005944.16269933 2110905.42089734 37.7764800131905 -122.422946348288 (37.7764800131905, -122.422946348288) 7 9 11 28852 10
167945 118288 Undocumented 4 Pyrus kawakamii :: Evergreen Pear 83 240 IVY ST 3 Sidewalk: Curb side : Cutout Tree Private 2       3x2.5   6006177 2111293 37.7775573470216 -122.422168438332 (37.7775573470216, -122.422168438332) 7 9 11 28852 10
170712 49992 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 300 Linden St 4 Sidewalk: Curb side : Cutout Tree Private 2   07/23/2003 12:00:00 AM 6   Permit Number 46733 6005873.634 2110881.2484 37.7764096614269 -122.42318860884 (37.7764096614269, -122.42318860884) 7 9 11 28852 10
174776 141968 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 600 FULTON ST 1 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 0ft   6004837.9618 2111622.5068 37.7783864740372 -122.426824094864 (37.7783864740372, -122.426824094864) 7 9 11 28852 41
176720 69224 Permitted Site 7 Pyrus kawakamii :: Evergreen Pear 83 345 Gough St 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/31/1994 12:00:00 AM 3 3x3 Permit Number 33276 6005935.60239934 2110883.16438759 37.7764184191765 -122.422974378607 (37.7764184191765, -122.422974378607) 7 9 11 28852 10
180331 244414 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 261 Octavia St 3 Sidewalk: Curb side : Cutout Tree DPW 1   05/02/2017 04:17:00 PM 3 Width 0ft   6005541.7456 2110219.4552 37.7745738026307 -122.424289625835 (37.7745738026307, -122.424289625835) 7 9 11 28852 10
180849 139276 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 725 FULTON ST 3 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 0ft   6004285.6861 2111490.9383 37.7779939780477 -122.428725241569 (37.7779939780477, -122.428725241569) 7 9 11 28852 10
186835 8082 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 755X Fulton St 1 Sidewalk: Curb side : Cutout Tree DPW 1   01/22/1992 12:00:00 AM 6 3X3   6004115.11785 2111289.80956 37.7774320731857 -122.429300951982 (37.7774320731857, -122.429300951982) 7 9 11 28852 10
191489 100411 Permitted Site 7 Pyrus kawakamii :: Evergreen Pear 83 201x Linden St 2 Sidewalk: Curb side : Cutout Tree Private 2   08/16/2012 12:00:00 AM     Permit Number 767727 6006435 2110776 37.7761523386864 -122.421239206856 (37.7761523386864, -122.421239206856) 7 9 11 28852 10
191565 244318 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 331 Octavia St 1 Sidewalk: Curb side : Cutout Tree DPW 1   05/02/2017 04:08:00 PM 3 Width 0ft   6005494.8083 2110541.2729 37.7754547855001 -122.424474886956 (37.7754547855001, -122.424474886956) 7 9 11 28852 10
193928 139274 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 725 FULTON ST 1 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 0ft   6004227.9769 2111481.8263 37.7779656924567 -122.428924228419 (37.7779656924567, -122.428924228419) 7 9 11 28852 10
810 75303 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 376 Utah St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF   1     6010591.15079 2106579.14528 37.7648621726769 -122.406566076957 (37.7648621726769, -122.406566076957) 8 4 8 28853 19
2151 258135 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 988 Howard St 1 Sidewalk: Curb side : Cutout Tree DPW 1 FUF   3     6010589.4479 2112082.95565 37.7799742710855 -122.40695991983 (37.7799742710855, -122.40695991983) 14 2 9 28853 34
2453 49617 Permitted Site 7 Pyrus kawakamii :: Evergreen Pear 83 1626 Folsom St 7 Sidewalk: Curb side : Cutout Tree Private 2   05/13/2003 12:00:00 AM     Permit Number 46477 6008114.57908688 2108709.83276472 37.7705736773564 -122.415282774124 (37.7705736773564, -122.415282774124) 8 2 9 28853 19
2819 70680 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 330 Utah St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF   10     6010584.43859 2106698.38492 37.7651892021367 -122.406597696229 (37.7651892021367, -122.406597696229) 8 4 8 28853 19
8128 90393 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 98 12th St 2 Sidewalk: Curb side : Cutout Tree DPW 1   10/31/2016 12:00:00 AM 3 3x3   6007146.175112 2109626.370927 37.7730357998282 -122.418697508419 (37.7730357998282, -122.418697508419) 8 2 9 28853 19
8277 75145 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 376 Utah St 4 Sidewalk: Curb side : Cutout Tree Private 2 FUF   1     6010592.19708 2106537.02068 37.7647465666182 -122.406559489431 (37.7647465666182, -122.406559489431) 8 4 8 28853 19
9559 90383 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 20 12th St 3 Sidewalk: Curb side : Cutout Tree DPW 1   02/21/2008 12:00:00 AM 3 3x3   6006777.292282 2110019.638696 37.7740948433326 -122.420001435971 (37.7740948433326, -122.420001435971) 8 2 9 28853 19
12199 30624 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 1655 Folsom St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/26/1995 12:00:00 AM 7   Permit Number 35324 6008124.7709 2108587.5084 37.7702383761626 -122.41523885993 (37.7702383761626, -122.41523885993) 8 2 9 28853 19
17469 239268 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 43 Woodward St 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   6006498.06002 2108217.35728 37.769130472909 -122.420839370946 (37.769130472909, -122.420839370946) 8 4 7 28853 19
19096 73459 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 330 Utah St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   15     6010582.51713 2106716.25151 37.7652381522352 -122.406605601283 (37.7652381522352, -122.406605601283) 8 4 8 28853 19
19522 75060 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 390x Utah St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   7     6010594.46043 2106517.2504 37.7646924085388 -122.406550267789 (37.7646924085388, -122.406550267789) 8 4 8 28853 19
25420 30655 Permitted Site 7 Pyrus kawakamii :: Evergreen Pear 83 35 Lafayette St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/30/1995 12:00:00 AM 10 3x3 Permit Number 34590 6007536.63957853 2109665.02696878 37.7731639163293 -122.417349579607 (37.7731639163293, -122.417349579607) 8 2 9 28853 19
26265 120516 Undocumented 4 Pyrus kawakamii :: Evergreen Pear 83 888 Brannan St 11 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6011018 2109170 37.7719999408521 -122.405272169822 (37.7719999408521, -122.405272169822) 14 2 9 28853 34
32162 107809 Permitted Site 7 Pyrus kawakamii :: Evergreen Pear 83 174 14TH ST   Sidewalk: Curb side : Cutout Tree Private 2   12/22/2014 12:00:00 AM 3 3x3 Permit Number 773719 6007550.6 2107982.4 37.7685446055333 -122.417182034417 (37.7685446055333, -122.417182034417) 8 4 7 28853 19
39932 49616 Permitted Site 7 Pyrus kawakamii :: Evergreen Pear 83 1626 Folsom St 6 Sidewalk: Curb side : Cutout Tree Private 2   05/13/2003 12:00:00 AM     Permit Number 46477 6008114.57908688 2108709.83276472 37.7705736773564 -122.415282774124 (37.7705736773564, -122.415282774124) 8 2 9 28853 19
40700 30616 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 1621 Folsom St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/30/1995 12:00:00 AM 7   Permit Number 34577 6008176.3922 2108702.7792 37.7705577837388 -122.415068461945 (37.7705577837388, -122.415068461945) 8 2 9 28853 19

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