trees
1,985 rows where qSpecies_id = 83 sorted by Zip Codes
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 |
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) );