trees
1,985 rows where qSpecies_id = 83 sorted by Police Districts
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 | ||||||||||||||
1294 | 136237 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1340 Clay St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6008274 | 2116946 | 37.7931971721852 | -122.415314473397 | (37.7931971721852, -122.415314473397) | 5 | 1 | 10 | 28858 | 21 | |||
3017 | 136252 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 802 North Point St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6006854.74284 | 2121556.78092 | 37.8057773454026 | -122.420552649091 | (37.8057773454026, -122.420552649091) | 5 | 1 | 1 | 28858 | 32 | |||
7527 | 136248 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 2023 Taylor St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6008588.60584 | 2119742.27726 | 37.8008927343603 | -122.414423864695 | (37.8008927343603, -122.414423864695) | 5 | 1 | 10 | 308 | 32 | |||
10982 | 96718 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1340 Clay St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/05/2011 12:00:00 AM | 8 | Permit Number 767223 | 6008274 | 2116946 | 37.7931971721852 | -122.415314473397 | (37.7931971721852, -122.415314473397) | 5 | 1 | 10 | 28858 | 21 | ||
13315 | 34250 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 945 Bay St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/17/1998 12:00:00 AM | 5 | Permit Number 38731 | 6006204.75677 | 2121056.43709 | 37.8043668775019 | -122.422766446326 | (37.8043668775019, -122.422766446326) | 5 | 1 | 1 | 28858 | 32 | |
15634 | 136235 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 928 Leavenworth St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6008235.61174 | 2115647.76794 | 37.7896303876902 | -122.415355351862 | (37.7896303876902, -122.415355351862) | 5 | 1 | 10 | 28858 | 21 | |||
16204 | 114507 | Undocumented 4 | Pyrus kawakamii :: Evergreen Pear 83 | 10 LOMBARD ST | 2 | Back Yard : Cutout | Tree | Port 6 | 4x4 | 6011932 | 2120995 | 37.8045196580749 | -122.402942401468 | (37.8045196580749, -122.402942401468) | 3 | 1 | 10 | 28860 | 6 | ||||
21703 | 95365 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 661 Broadway | 2 | Sidewalk: Property side : Cutout | Tree | Private 2 | 8 | 3x3 | Permit Number 778058 | 6010478.0762 | 2118518.1883 | 37.797637647797 | -122.407799105269 | (37.797637647797, -122.407799105269) | 3 | 1 | 10 | 308 | 4 | ||
26378 | 96719 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 1340 Clay St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6008320 | 2116937 | 37.7931750456071 | -122.415154672616 | (37.7931750456071, -122.415154672616) | 5 | 1 | 10 | 28858 | 21 | |||||
28102 | 4618 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 354 Columbus Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 9 | 3x3 | 6010598.00994 | 2118821.58602 | 37.7984774173787 | -122.407405500457 | (37.7984774173787, -122.407405500457) | 3 | 1 | 10 | 308 | 23 | |||
28692 | 48873 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 150 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/20/1993 12:00:00 AM | 12 | 3x3 | Permit Number 46081 | 6011769.28798 | 2120850.10657 | 37.8041127290715 | -122.40349528428 | (37.8041127290715, -122.40349528428) | 3 | 1 | 10 | 28860 | 6 | |
29594 | 96720 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 1340 Clay St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6008320 | 2116937 | 37.7931750456071 | -122.415154672616 | (37.7931750456071, -122.415154672616) | 5 | 1 | 10 | 28858 | 21 | |||||
32452 | 4617 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 348 Columbus Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/24/1995 12:00:00 AM | 10 | 3x3 | 6010597.9091 | 2118822.5443 | 37.7984800429378 | -122.40740591699 | (37.7984800429378, -122.40740591699) | 3 | 1 | 10 | 308 | 23 | ||
33350 | 136264 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1600 Montgomery St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 3ft | 6011327.59811 | 2121029.05024 | 37.8045793836809 | -122.405036399426 | (37.8045793836809, -122.405036399426) | 3 | 1 | 10 | 28860 | 6 | |||
33527 | 136257 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 2106 Leavenworth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6007681.63018 | 2119639.37861 | 37.8005592082118 | -122.417555094503 | (37.8005592082118, -122.417555094503) | 5 | 1 | 1 | 308 | 32 | |||
35410 | 87680 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 2998 Larkin St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/23/2008 12:00:00 AM | 3x3 | Permit Number 50399 | 6006514.3 | 2121415.1 | 37.8053691339868 | -122.421720734847 | (37.8053691339868, -122.421720734847) | 5 | 1 | 1 | 28858 | 32 | ||
35557 | 34252 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 945 Bay St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/17/1998 12:00:00 AM | 8 | Permit Number 38731 | 6006224.9654 | 2121058.41971 | 37.8043734614398 | -122.42269665354 | (37.8043734614398, -122.42269665354) | 5 | 1 | 1 | 28858 | 32 | |
41167 | 87679 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 2998 Larkin St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/23/2008 12:00:00 AM | 3x3 | Permit Number 50399 | 6006514.3 | 2121415.1 | 37.8053691339868 | -122.421720734847 | (37.8053691339868, -122.421720734847) | 5 | 1 | 1 | 28858 | 32 | ||
48947 | 136254 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 804 North Point St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6006813.5477 | 2121550.30022 | 37.8057572293748 | -122.420694750958 | (37.8057572293748, -122.420694750958) | 5 | 1 | 1 | 28858 | 32 | |||
49392 | 87678 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 2998 Larkin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/23/2008 12:00:00 AM | 3x3 | Permit Number 50399 | 6006514.3 | 2121415.1 | 37.8053691339868 | -122.421720734847 | (37.8053691339868, -122.421720734847) | 5 | 1 | 1 | 28858 | 32 | ||
51906 | 136271 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 240 Joice St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6010208.66727 | 2117064.18713 | 37.7936302286056 | -122.408628712567 | (37.7936302286056, -122.408628712567) | 3 | 1 | 10 | 28857 | 4 | |||
57088 | 101338 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 600 Chestnut St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/01/1993 12:00:00 AM | 3 | Permit Number 32655 | 6008893.4466 | 2120790.6495 | 37.8037884230366 | -122.413443168222 | (37.8037884230366, -122.413443168222) | 3 | 1 | 10 | 308 | 23 | ||
60118 | 95364 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 661 Broadway | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 7 | 3x3 | Permit Number 778058 | 6010448.4751 | 2118513.479 | 37.797623060035 | -122.407901201302 | (37.797623060035, -122.407901201302) | 3 | 1 | 10 | 308 | 4 | ||
60277 | 101046 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1050 Sansome St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | 3x3 | Permit Number 774347 | 6012049.48691 | 2119300.00717 | 37.7998721792109 | -122.402416569092 | (37.7998721792109, -122.402416569092) | 3 | 1 | 10 | 28860 | 6 | ||
63186 | 136258 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 2110 Leavenworth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6007680.05725 | 2119655.03643 | 37.8006021121473 | -122.417561647852 | (37.8006021121473, -122.417561647852) | 5 | 1 | 1 | 308 | 32 | |||
65230 | 49397 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1451@ PACIFIC Taylor St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/21/2003 12:00:00 AM | 4 | Permit Number 46412 | 6008850.17473 | 2117891.03277 | 37.7958243657476 | -122.413387728783 | (37.7958243657476, -122.413387728783) | 5 | 1 | 10 | 308 | 21 | ||
65266 | 82025 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 900-904 Filbert St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/04/2008 12:00:00 AM | 7 | 3x3 | Permit Number 50637 | 6008560.7244 | 2119705.22703 | 37.8007894373545 | -122.41451772334 | (37.8007894373545, -122.41451772334) | 5 | 1 | 10 | 308 | 32 | |
68810 | 101047 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 1050 Sansome St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/18/2014 12:00:00 AM | 3 | 3x3 | Permit Number 774347 | 6012043 | 2119296 | 37.799860814363 | -122.402438734441 | (37.799860814363, -122.402438734441) | 3 | 1 | 10 | 28860 | 6 | |
69076 | 136270 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 232 Joice St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6010211.84194 | 2117041.25544 | 37.7935674415409 | -122.408616109453 | (37.7935674415409, -122.408616109453) | 3 | 1 | 10 | 28857 | 4 | |||
70768 | 58814 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 821 Pine St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/05/2008 12:00:00 AM | 4 | 3x3 | Permit Number 51604 | 6009972.67936 | 2116102.82719 | 37.7909773472645 | -122.409377377481 | (37.7909773472645, -122.409377377481) | 5 | 1 | 10 | 28857 | 21 | |
79823 | 52196 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1205 Filbert St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/19/2013 12:00:00 AM | 2 | Permit Number 770878 | 6007126.92706 | 2119460.55943 | 37.8000369880733 | -122.419461903656 | (37.8000369880733, -122.419461903656) | 5 | 1 | 1 | 28858 | 32 | ||
80870 | 88423 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 1451 Taylor St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51387 | 6008861 | 2117824 | 37.7956409180501 | -122.413345528397 | (37.7956409180501, -122.413345528397) | 5 | 1 | 10 | 308 | 21 | |||
81997 | 34253 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 945 Bay St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/17/1998 12:00:00 AM | 7 | Permit Number 38731 | 6006242.74242 | 2121059.25353 | 37.8043767538414 | -122.422635193862 | (37.8043767538414, -122.422635193862) | 5 | 1 | 1 | 28858 | 32 | |
87471 | 136268 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 220 Joice St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6010216.49831 | 2116997.79235 | 37.7934483632051 | -122.408596930519 | (37.7934483632051, -122.408596930519) | 3 | 1 | 10 | 28857 | 4 | |||
91797 | 136266 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 220 Joice St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6010225.4664 | 2116932.79358 | 37.7932703945753 | -122.408561312861 | (37.7932703945753, -122.408561312861) | 3 | 1 | 10 | 28857 | 4 | |||
91874 | 91042 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 2998 Larkin St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/10/2008 12:00:00 AM | 5 | 3x3 | Permit Number 50399 | 6006462.58838 | 2121409.81945 | 37.8053517187772 | -122.421899314626 | (37.8053517187772, -122.421899314626) | 5 | 1 | 1 | 28858 | 32 | |
92639 | 136236 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1451 Taylor St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6008853.84836 | 2117876.73982 | 37.7957853270845 | -122.413374006003 | (37.7957853270845, -122.413374006003) | 5 | 1 | 10 | 308 | 21 | |||
95171 | 255309 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 2127 Taylor St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/08/2018 12:00:00 AM | 3 | 3x3 | 6008541.64537 | 2120124.79782 | 37.8019404020961 | -122.414613452743 | (37.8019404020961, -122.414613452743) | 5 | 1 | 10 | 308 | 32 | ||
96374 | 136251 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 2711 Hyde St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6006870.92139 | 2121576.32062 | 37.8058319081714 | -122.420498048543 | (37.8058319081714, -122.420498048543) | 5 | 1 | 1 | 28858 | 32 | |||
98774 | 100361 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1135 Green St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 3x3 | 6007562.69285 | 2118825.76087 | 37.7983185248271 | -122.417908959744 | (37.7983185248271, -122.417908959744) | 5 | 1 | 10 | 28858 | 32 | |||
101667 | 62995 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 828 Taylor St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/17/1986 12:00:00 AM | 11 | Permit Number 23397 | 6009184.70363 | 2115820.64878 | 37.7901583733657 | -122.412083801744 | (37.7901583733657, -122.412083801744) | 5 | 1 | 10 | 28857 | 21 | ||
102607 | 136234 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 928 Leavenworth St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6008238.09244 | 2115632.75649 | 37.7895893093397 | -122.415345705733 | (37.7895893093397, -122.415345705733) | 5 | 1 | 10 | 28858 | 21 | |||
109327 | 11173 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 2717 Hyde St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 3X3 | 6006873.7712695 | 2121594.1615237 | 37.8058810553361 | -122.420489453273 | (37.8058810553361, -122.420489453273) | 5 | 1 | 1 | 28858 | 32 | |||
109593 | 136249 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1717 Jones St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6008299.50959 | 2118376.18019 | 37.7971255273819 | -122.415327499887 | (37.7971255273819, -122.415327499887) | 5 | 1 | 10 | 28858 | 21 | |||
115566 | 48872 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 150 Lombard St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/18/2002 12:00:00 AM | 6 | 3x3 | Permit Number 46081 | 6011751.8076 | 2120847.07255 | 37.8041034220013 | -122.403555563145 | (37.8041034220013, -122.403555563145) | 3 | 1 | 10 | 28860 | 6 | |
116259 | 136231 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 828 Taylor St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6009179.06421 | 2115849.56877 | 37.7902374642249 | -122.412105358482 | (37.7902374642249, -122.412105358482) | 5 | 1 | 10 | 28857 | 21 | |||
118970 | 44270 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1101 Clay St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/13/2001 12:00:00 AM | 6 | 3x3 | Permit Number 43698 | 6009401.24992 | 2117056.5968 | 37.7935641338168 | -122.411421918689 | (37.7935641338168, -122.411421918689) | 3 | 1 | 10 | 28857 | 21 | |
120563 | 136261 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 15 MacOndray Ln | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | 6008598.0245 | 2119155.01738 | 37.7992807940363 | -122.414349696679 | (37.7992807940363, -122.414349696679) | 5 | 1 | 10 | 308 | 32 | ||||
122316 | 110361 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1155 Pine St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 6008381.52689 | 2115877.48528 | 37.790269335319 | -122.414866763697 | (37.790269335319, -122.414866763697) | 5 | 1 | 10 | 28858 | 21 | ||||
132157 | 88422 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 1451 Taylor St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51387 | 6008861 | 2117824 | 37.7956409180501 | -122.413345528397 | (37.7956409180501, -122.413345528397) | 5 | 1 | 10 | 308 | 21 | |||
132384 | 136232 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 928 Leavenworth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6008243.34435 | 2115601.80206 | 37.789504611209 | -122.415325342399 | (37.789504611209, -122.415325342399) | 5 | 1 | 10 | 28858 | 21 | |||
132439 | 95867 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 733 Chestnut St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/29/2011 12:00:00 AM | 7 | 3x3 | Permit Number 767588 | 6008296.37826 | 2120666.6947 | 37.8034145323264 | -122.415500582505 | (37.8034145323264, -122.415500582505) | 5 | 1 | 10 | 308 | 32 |
132522 | 136259 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 2110 Leavenworth St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6007679.18524 | 2119665.29199 | 37.8006302222728 | -122.417565392635 | (37.8006302222728, -122.417565392635) | 5 | 1 | 1 | 308 | 32 | |||
134709 | 136233 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 928 Leavenworth St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6008241.15126 | 2115615.72807 | 37.7895427253733 | -122.415333916531 | (37.7895427253733, -122.415333916531) | 5 | 1 | 10 | 28858 | 21 | |||
136855 | 136262 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 11 Filbert St | 7 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | 6012539.85481 | 2120210.2855 | 37.8023989459081 | -122.400783688018 | (37.8023989459081, -122.400783688018) | 3 | 1 | 10 | 28860 | 6 | ||||
137653 | 136253 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 802 North Point St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6006835.20454 | 2121555.13749 | 37.8057717318427 | -122.420620147698 | (37.8057717318427, -122.420620147698) | 5 | 1 | 1 | 28858 | 32 | |||
137904 | 136238 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1378 Pacific Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6007522.032 | 2117818.37086 | 37.7955501948379 | -122.417978207539 | (37.7955501948379, -122.417978207539) | 5 | 1 | 10 | 28858 | 32 | |||
139061 | 118322 | Significant Tree 6 | Pyrus kawakamii :: Evergreen Pear 83 | 720 BATTERY ST | 1 | unknown : Yard | Tree | Private 2 | 6012486 | 2118560 | 37.7978646555778 | -122.400854041686 | (37.7978646555778, -122.400854041686) | 3 | 1 | 10 | 28860 | 6 | |||||
140115 | 94205 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 225 Bush St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/25/2010 12:00:00 AM | 3 | 4 diameter | Permit Number 53606 | 6012323.95366 | 2116081.4267 | 37.7910500439823 | -122.401240507665 | (37.7910500439823, -122.401240507665) | 4 | 1 | 10 | 28854 | 6 | |
142312 | 91041 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 2998 Larkin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/10/2008 12:00:00 AM | 5 | 3x3 | Permit Number 50399 | 6006464.74623 | 2121395.99646 | 37.8053138860806 | -122.421890864574 | (37.8053138860806, -122.421890864574) | 5 | 1 | 1 | 28858 | 32 | |
146253 | 91043 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 2998 Larkin St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/10/2008 12:00:00 AM | 4 | 3x3 | Permit Number 50399 | 6006460.43386 | 2121423.80416 | 37.8053899957025 | -122.421907764657 | (37.8053899957025, -122.421907764657) | 5 | 1 | 1 | 28858 | 32 | |
150741 | 136265 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 220 Joice St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6010230.84505 | 2116901.45866 | 37.7931846576946 | -122.408540490873 | (37.7931846576946, -122.408540490873) | 3 | 1 | 10 | 28857 | 4 | |||
151874 | 249824 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1690 Kearny St | 6 | Front Yard : Yard | Tree | Private 2 | 5 | Width 0ft | 6010866.76079 | 2120642.67591 | 37.8034927229673 | -122.40660393394 | (37.8034927229673, -122.40660393394) | 3 | 1 | 10 | 308 | 23 | |||
152827 | 136250 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 2711 Hyde St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6006868.56519 | 2121594.39083 | 37.8058813915667 | -122.420507486038 | (37.8058813915667, -122.420507486038) | 5 | 1 | 1 | 28858 | 32 | |||
153472 | 136260 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 740 Francisco St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 3ft | 6007759.94756 | 2120993.00482 | 37.8042803312301 | -122.417380065732 | (37.8042803312301, -122.417380065732) | 5 | 1 | 1 | 308 | 32 | |||
156720 | 34975 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 220 Jackson St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/18/1997 12:00:00 AM | Permit Number 38557 | 6012788.97638306 | 2118225.73375032 | 37.7969637351298 | -122.399782167941 | (37.7969637351298, -122.399782167941) | 3 | 1 | 10 | 28860 | 6 | |||
159395 | 136269 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 220 Joice St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6010214.18023 | 2117016.13292 | 37.7934985921435 | -122.408606245692 | (37.7934985921435, -122.408606245692) | 3 | 1 | 10 | 28857 | 4 | |||
164114 | 136267 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 220 Joice St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6010219.36017 | 2116967.29713 | 37.7933647909937 | -122.408584876014 | (37.7933647909937, -122.408584876014) | 3 | 1 | 10 | 28857 | 4 | |||
170347 | 59713 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1155 Pine St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/18/1981 12:00:00 AM | 7 | 3x3 | Permit Number 19144 | 6008363.54406 | 2115876.33125 | 37.7902651561735 | -122.414928901463 | (37.7902651561735, -122.414928901463) | 5 | 1 | 10 | 28858 | 21 | |
174230 | 136263 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1600 Montgomery St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 3ft | 6011331.32037 | 2121003.20622 | 37.804508630427 | -122.40502169731 | (37.804508630427, -122.40502169731) | 3 | 1 | 10 | 28860 | 6 | |||
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 | ||
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 | |||
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 | |||
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 | |
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 | |||
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 | ||
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 | |
23362 | 93821 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 178 Bluxome St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/05/2010 12:00:00 AM | 3x3 | Permit Number 53343 | 6012557.4 | 2110038.2 | 37.7744697656056 | -122.40000821426 | (37.7744697656056, -122.40000821426) | 14 | 2 | 9 | 28856 | 20 | ||
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 | ||||
34547 | 93825 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 178 Bluxome St | 14 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/05/2010 12:00:00 AM | 3x3 | Permit Number 53343 | 6012557.4 | 2110038.2 | 37.7744697656056 | -122.40000821426 | (37.7744697656056, -122.40000821426) | 14 | 2 | 9 | 28856 | 20 | ||
35420 | 93812 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 178 Bluxome St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/05/2010 12:00:00 AM | 3x3 | Permit Number 53343 | 6012557.4 | 2110038.2 | 37.7744697656056 | -122.40000821426 | (37.7744697656056, -122.40000821426) | 14 | 2 | 9 | 28856 | 20 | ||
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 | |
41531 | 30628 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1690 Folsom St | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/30/1995 12:00:00 AM | 3 | 3x3 | Permit Number 34583 | 6008014.7624 | 2108466.4739 | 37.7698998606983 | -122.415610809035 | (37.7698998606983, -122.415610809035) | 8 | 2 | 9 | 28853 | 19 | |
43433 | 120515 | Undocumented 4 | Pyrus kawakamii :: Evergreen Pear 83 | 888 Brannan St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6011018 | 2109170 | 37.7719999408521 | -122.405272169822 | (37.7719999408521, -122.405272169822) | 14 | 2 | 9 | 28853 | 34 | ||||
44419 | 42167 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 525 05th St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/21/2000 12:00:00 AM | 14 | Permit Number 42460 | 6012577.4664 | 2111216.9324 | 37.7777074143023 | -122.400021595319 | (37.7777074143023, -122.400021595319) | 6 | 2 | 9 | 28856 | 34 | ||
44864 | 90394 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 314 12th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/21/2008 12:00:00 AM | 3 | 3x3 | 6008277.004378 | 2108757.643904 | 37.770714082787 | -122.41472432574 | (37.770714082787, -122.41472432574) | 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) );