trees
1,985 rows where qSpecies_id = 83 sorted by Supervisor 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 | ||||||||||||||
281 | 136194 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 2914 Fillmore St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 6002528.73575 | 2118269.03723 | 37.7965053162169 | -122.435288106477 | (37.7965053162169, -122.435288106477) | 13 | 9 | 1 | 57 | 17 | |||
381 | 136202 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1337 Francisco St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6004913.0684 | 2120534.02336 | 37.8028595013299 | -122.427199210075 | (37.8028595013299, -122.427199210075) | 13 | 9 | 1 | 57 | 17 | |||
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 | |||
3730 | 120250 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 164 24th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | Width 6ft | 5988365.5517 | 2114845.05893 | 37.7862895663335 | -122.484043998391 | (37.7862895663335, -122.484043998391) | 11 | 6 | 1 | 55 | 33 | |||
5677 | 123020 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 152 06th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5993993.9147 | 2114546.78107 | 37.78579664693 | -122.464549802121 | (37.78579664693, -122.464549802121) | 11 | 6 | 1 | 54 | 11 | |||
5790 | 136106 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 2362 Vallejo St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 4ft | 6002236.43409 | 2117779.37436 | 37.7951442255914 | -122.436264471651 | (37.7951442255914, -122.436264471651) | 13 | 9 | 1 | 57 | 17 | |||
8202 | 46512 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 2188 Green St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/27/2002 12:00:00 AM | 8 | Permit Number 44678 | 6002606.94356 | 2118178.75715 | 37.7962618715428 | -122.435011030753 | (37.7962618715428, -122.435011030753) | 13 | 9 | 1 | 57 | 17 | |
10812 | 58694 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 3633 Jackson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/02/1979 12:00:00 AM | 4 | Permit Number 17970 | 5996855.26576 | 2115960.61486 | 37.7898431897625 | -122.454752572401 | (37.7898431897625, -122.454752572401) | 11 | 6 | 1 | 54 | 31 | ||
11012 | 7356 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 2309 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/01/2007 12:00:00 AM | 4 | 3X3 | 6002769.01195 | 2116184.22684 | 37.7907946063198 | -122.434307574482 | (37.7907946063198, -122.434307574482) | 13 | 9 | 1 | 29490 | 27 | ||
12316 | 124412 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 3900 Clay St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 5996120.28006 | 2115251.26489 | 37.7878533198568 | -122.45724420279 | (37.7878533198568, -122.45724420279) | 11 | 6 | 1 | 54 | 31 | |||
13059 | 58732 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 2385 California St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/29/2005 12:00:00 AM | Permit Number 17967 | 6002968.76813263 | 2115478.70521399 | 37.7888687602145 | -122.433565986183 | (37.7888687602145, -122.433565986183) | 13 | 9 | 1 | 29490 | 27 | ||
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 | |
13618 | 143549 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 2245 UNION ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 6002240.1517 | 2118427.2493 | 37.7969233328664 | -122.436297997013 | (37.7969233328664, -122.436297997013) | 13 | 9 | 1 | 57 | 17 | |||
16463 | 106806 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 167 Commonwealth Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | 5996526.1156 | 2113255.0824 | 37.7823956347772 | -122.455695748043 | (37.7823956347772, -122.455695748043) | 11 | 6 | 1 | 54 | 31 | ||||
18843 | 65788 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 201 Laurel St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/26/1990 12:00:00 AM | 7 | Permit Number 28756 | 5998021.12629 | 2115778.19726 | 37.7894091238674 | -122.450705664532 | (37.7894091238674, -122.450705664532) | 11 | 6 | 1 | 54 | 31 | ||
22517 | 41240 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 270 Masonic Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/02/1999 12:00:00 AM | Permit Number 41940 | 5999013.40299918 | 2112000.64122659 | 37.7790936893244 | -122.447000559943 | (37.7790936893244, -122.447000559943) | 15 | 5 | 1 | 54 | 16 | |||
23046 | 136230 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 3100 Gough St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6004683.10116 | 2120231.33167 | 37.8020153805639 | -122.427973432847 | (37.8020153805639, -122.427973432847) | 13 | 9 | 1 | 57 | 17 | |||
23216 | 136209 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 3501 Washington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 5997993.27095 | 2115789.6423 | 37.7894389544021 | -122.450802865961 | (37.7894389544021, -122.450802865961) | 11 | 6 | 1 | 54 | 31 | |||
23910 | 69318 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1466 Chestnut St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/23/1994 12:00:00 AM | 12 | Permit Number 33399 | 6004829.35126 | 2120222.0032 | 37.8019980398336 | -122.427466672957 | (37.8019980398336, -122.427466672957) | 13 | 9 | 1 | 57 | 17 | |
24907 | 136189 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 2914 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 2ft | 6002539.896 | 2118184.5507 | 37.7962739719132 | -122.435243443451 | (37.7962739719132, -122.435243443451) | 13 | 9 | 1 | 57 | 17 | |||
27479 | 136226 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1570 Chestnut St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6004327.39771 | 2120155.21272 | 37.8017862476969 | -122.429198904827 | (37.8017862476969, -122.429198904827) | 13 | 9 | 1 | 57 | 17 | |||
28070 | 120249 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 164 24th Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10 | Width 6ft | 5988365.91336 | 2114852.64965 | 37.7863104293457 | -122.484043303996 | (37.7863104293457, -122.484043303996) | 11 | 6 | 1 | 55 | 33 | |||
28462 | 7316 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 2000 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3X3 | 6002972.25432 | 2115230.97031 | 37.7881887410682 | -122.433536213059 | (37.7881887410682, -122.433536213059) | 13 | 9 | 1 | 29490 | 27 | |||
29411 | 124324 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 109 Jordan Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 3ft | 5996182.48161 | 2113700.35533 | 37.7835985094544 | -122.45691677945 | (37.7835985094544, -122.45691677945) | 11 | 6 | 1 | 54 | 31 | |||
30443 | 136227 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 3630 Webster St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6002616.6752 | 2121115.11425 | 37.804324892641 | -122.435187487615 | (37.804324892641, -122.435187487615) | 13 | 9 | 1 | 57 | 17 | |||
30941 | 136212 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 101 Spruce St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 3ft | 5997026.47763 | 2115953.79939 | 37.7898342954728 | -122.454159706 | (37.7898342954728, -122.454159706) | 11 | 6 | 1 | 54 | 31 | |||
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 | |||
33924 | 67694 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 3330 Clay St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/13/1992 12:00:00 AM | 6 | 3x3 | Permit Number 31302 | 5998887.34453115 | 2115637.9553757 | 37.7890736016783 | -122.447698559552 | (37.7890736016783, -122.447698559552) | 13 | 6 | 1 | 54 | 31 | |
33994 | 12670 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1128 Lake St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/07/1998 12:00:00 AM | 6 | 3X3 | 5991921.00031 | 2114824.39199 | 37.786439173997 | -122.471741673868 | (37.786439173997, -122.471741673868) | 11 | 6 | 1 | 54 | 11 | ||
34865 | 40635 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 2577 Post St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/10/1999 12:00:00 AM | 1 | Permit Number 41635 | 5999855.0848 | 2113645.9018 | 37.7836592022764 | -122.444207108714 | (37.7836592022764, -122.444207108714) | 15 | 6 | 1 | 29490 | 31 | ||
35133 | 36194 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 107 Spruce St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Permit Number 39260 | 5997029.24357 | 2115938.23155 | 37.7897917089598 | -122.454149011282 | (37.7897917089598, -122.454149011282) | 11 | 6 | 1 | 54 | 31 | |||
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 | |
35912 | 24578 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 2301 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 07/12/1996 12:00:00 AM | 6 | 3x3 | 6002768.23016 | 2116232.67907 | 37.7909275993488 | -122.434313744932 | (37.7909275993488, -122.434313744932) | 13 | 9 | 1 | 29490 | 27 | ||
37483 | 85089 | Significant Tree 6 | Pyrus kawakamii :: Evergreen Pear 83 | 1600 Chestnut St | 2 | Sidewalk: Property side : Cutout | Tree | Private 2 | 6004108.1 | 2120157.9 | 37.8017812094321 | -122.429957968303 | (37.8017812094321, -122.429957968303) | 13 | 9 | 1 | 57 | 17 | |||||
37783 | 67598 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 3320 Clay St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/06/1992 12:00:00 AM | 5 | Permit Number 31166 | 5998906.2009 | 2115636.68755 | 37.7890711982373 | -122.447633227902 | (37.7890711982373, -122.447633227902) | 13 | 6 | 1 | 54 | 31 | ||
38148 | 136224 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 3699 Divisadero St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6000162.1216 | 2120884.12041 | 37.8035509567753 | -122.443665040422 | (37.8035509567753, -122.443665040422) | 13 | 9 | 1 | 57 | 17 | |||
38222 | 7333 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 2066 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6002924.90365 | 2115430.77271 | 37.7887346608959 | -122.433714323915 | (37.7887346608959, -122.433714323915) | 13 | 9 | 1 | 29490 | 27 | |||
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 | ||
42954 | 7334 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 2095X Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10 | 3X3 | 6002864.90775 | 2115441.94118 | 37.7887619221715 | -122.433922699489 | (37.7887619221715, -122.433922699489) | 13 | 9 | 1 | 29490 | 27 | |||
44763 | 90488 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 125 25th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/27/2008 12:00:00 AM | 6 | 3x3 | 5987997.51268 | 2115126.89685 | 37.7870419790043 | -122.485337990995 | (37.7870419790043, -122.485337990995) | 11 | 6 | 1 | 55 | 33 | ||
46070 | 136222 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 3159 Baker St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5999346.78651 | 2119715.31037 | 37.8002951834309 | -122.446402399571 | (37.8002951834309, -122.446402399571) | 13 | 9 | 1 | 57 | 17 | |||
46495 | 85086 | Significant Tree 6 | Pyrus kawakamii :: Evergreen Pear 83 | 1600 Chestnut St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 49476 | 6004108.1 | 2120157.9 | 37.8017812094321 | -122.429957968303 | (37.8017812094321, -122.429957968303) | 13 | 9 | 1 | 57 | 17 | ||||
48787 | 138699 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1600 BAKER ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 6000123.7356 | 2114472.3378 | 37.785943704602 | -122.443337062115 | (37.785943704602, -122.443337062115) | 15 | 6 | 1 | 29490 | 27 | |||
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 | ||
49749 | 104043 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1405 Greenwich St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/19/2018 12:00:00 AM | 3 | 3x3 | Permit Number 782596 | 6006090.81059 | 2119657.40346 | 37.8005190588724 | -122.423061266572 | (37.8005190588724, -122.423061266572) | 13 | 9 | 1 | 28858 | 32 | |
49819 | 7319 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 2011 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6002893.06 | 2115234.5275 | 37.7881940146245 | -122.433810466039 | (37.7881940146245, -122.433810466039) | 13 | 9 | 1 | 29490 | 27 | |||
50414 | 136190 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 2914 Fillmore St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 2ft | 6002538.23525 | 2118203.76672 | 37.7963266398053 | -122.435250565155 | (37.7963266398053, -122.435250565155) | 13 | 9 | 1 | 57 | 17 | |||
53938 | 7989 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 2148 Franklin St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 07/26/2012 12:00:00 AM | 3 | 3x3 | 6005571.0767989 | 2117355.4773403 | 37.7941692118946 | -122.4246959118 | (37.7941692118946, -122.4246959118) | 13 | 9 | 1 | 28858 | 27 | ||
54028 | 7329 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 2043 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 6002875.62738 | 2115359.09835 | 37.7885350652007 | -122.433879687382 | (37.7885350652007, -122.433879687382) | 13 | 9 | 1 | 29490 | 27 | ||||
58092 | 41239 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 270 Masonic Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/02/1999 12:00:00 AM | Permit Number 41940 | 5999013.40299918 | 2112000.64122659 | 37.7790936893244 | -122.447000559943 | (37.7790936893244, -122.447000559943) | 15 | 5 | 1 | 54 | 16 | |||
58138 | 137619 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 2270 Turk Blvd | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 5999129.6791 | 2111886.0816 | 37.7787857805731 | -122.446590070713 | (37.7787857805731, -122.446590070713) | 15 | 5 | 1 | 54 | 16 | |||
58587 | 120181 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 142 26th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 5987742.58723 | 2115005.98358 | 37.7866951312776 | -122.486211085191 | (37.7866951312776, -122.486211085191) | 11 | 6 | 1 | 55 | 33 | |||
61599 | 62003 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1446 Francisco St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/18/1994 12:00:00 AM | 11 | Permit Number 33451 | 6004382.28893 | 2120508.49846 | 37.8027593860996 | -122.429034158913 | (37.8027593860996, -122.429034158913) | 13 | 9 | 1 | 57 | 17 | |
62118 | 41238 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 270 Masonic Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/02/1999 12:00:00 AM | Permit Number 41940 | 5999013.40299918 | 2112000.64122659 | 37.7790936893244 | -122.447000559943 | (37.7790936893244, -122.447000559943) | 15 | 5 | 1 | 54 | 16 | |||
62203 | 138286 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 2027 FILLMORE ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 6002884.377 | 2115289.0168 | 37.7883431356378 | -122.433844403927 | (37.7883431356378, -122.433844403927) | 13 | 9 | 1 | 29490 | 27 | |||
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 | |||
64925 | 24570 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 2306 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/12/1996 12:00:00 AM | 6 | 3X3 | 6002830.77987 | 2116250.98173 | 37.7909814038841 | -122.434098634738 | (37.7909814038841, -122.434098634738) | 13 | 9 | 1 | 29490 | 27 | ||
67739 | 7327 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 2042 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6002940.62895 | 2115331.17345 | 37.7884620789862 | -122.433652795594 | (37.7884620789862, -122.433652795594) | 13 | 9 | 1 | 29490 | 27 | |||
68326 | 7325 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 2027 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6002881.7283 | 2115306.8957 | 37.7883920762372 | -122.433854846414 | (37.7883920762372, -122.433854846414) | 13 | 9 | 1 | 29490 | 27 | |||
68649 | 136200 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 2101 Beach St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6000132.37327 | 2120911.69707 | 37.8036249781613 | -122.443769967932 | (37.8036249781613, -122.443769967932) | 13 | 9 | 1 | 57 | 17 | |||
69520 | 136201 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 20 Retiro Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6001803.6012 | 2121217.14439 | 37.8045588359743 | -122.438008504412 | (37.8045588359743, -122.438008504412) | 13 | 9 | 1 | 57 | 17 | |||
72535 | 41236 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 270 Masonic Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/02/1999 12:00:00 AM | Permit Number 41940 | 5999013.40299918 | 2112000.64122659 | 37.7790936893244 | -122.447000559943 | (37.7790936893244, -122.447000559943) | 15 | 5 | 1 | 54 | 16 | |||
73327 | 123628 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 142 02nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 5995232.14872 | 2114600.88341 | 37.7860165001902 | -122.460269811318 | (37.7860165001902, -122.460269811318) | 11 | 6 | 1 | 54 | 11 | |||
73731 | 141309 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 74 PARKER AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 5996869.9521 | 2114088.2769 | 37.7847030919253 | -122.454566442022 | (37.7847030919253, -122.454566442022) | 11 | 6 | 1 | 54 | 31 | |||
76645 | 32025 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 2431 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/24/1995 12:00:00 AM | 7 | 4x4 | Permit Number 35414 | 6002714.02785707 | 2116573.3755444 | 37.7918599877301 | -122.434525653083 | (37.7918599877301, -122.434525653083) | 13 | 9 | 1 | 29490 | 27 | |
79252 | 136192 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 2914 Fillmore St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 2ft | 6002533.36728 | 2118236.78125 | 37.7964170126905 | -122.435269772002 | (37.7964170126905, -122.435269772002) | 13 | 9 | 1 | 57 | 17 | |||
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 | ||
81316 | 136197 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 2101 Beach St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6000062.25305 | 2120901.6465 | 37.8035933822804 | -122.444011899049 | (37.8035933822804, -122.444011899049) | 13 | 9 | 1 | 57 | 17 | |||
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 | |
82779 | 136199 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 2101 Beach St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6000108.92159 | 2120908.29838 | 37.8036143086235 | -122.443850879042 | (37.8036143086235, -122.443850879042) | 13 | 9 | 1 | 57 | 17 | |||
83246 | 120256 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 140 24th Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 4ft | 5988368.86327 | 2114963.36268 | 37.7866145875471 | -122.484041219882 | (37.7866145875471, -122.484041219882) | 11 | 6 | 1 | 55 | 33 | |||
85156 | 136195 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 2848 Scott St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6001082.7933 | 2118171.75388 | 37.7961559826614 | -122.44028438991 | (37.7961559826614, -122.44028438991) | 13 | 9 | 1 | 57 | 17 | |||
85718 | 137620 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 2280 Turk Blvd | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 5999093.1296 | 2111881.6822 | 37.7787716131699 | -122.446716192654 | (37.7787716131699, -122.446716192654) | 15 | 5 | 1 | 54 | 16 | |||
85796 | 137830 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 2000 FILLMORE ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6002959.8323 | 2115200.8411 | 37.7881053091283 | -122.433577037034 | (37.7881053091283, -122.433577037034) | 13 | 9 | 1 | 29490 | 27 | |||
86325 | 69319 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1490 Chestnut St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/23/1994 12:00:00 AM | 8 | Permit Number 33400 | 6004756.29564 | 2120212.83745 | 37.8019687408272 | -122.427718826659 | (37.8019687408272, -122.427718826659) | 13 | 9 | 1 | 57 | 17 | ||
89745 | 85085 | Significant Tree 6 | Pyrus kawakamii :: Evergreen Pear 83 | 1600 Chestnut St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 49476 | 6004108.1 | 2120157.9 | 37.8017812094321 | -122.429957968303 | (37.8017812094321, -122.429957968303) | 13 | 9 | 1 | 57 | 17 | ||||
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 | |
91925 | 115210 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 115 Spruce St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x3 | 5997031.37665 | 2115893.5791 | 37.7896692276076 | -122.454138404663 | (37.7896692276076, -122.454138404663) | 11 | 6 | 1 | 54 | 31 | |||
92002 | 24565 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 2117 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 07/11/1996 12:00:00 AM | 3 | 3X3 | 6002846.69927 | 2115626.75122 | 37.7892683300519 | -122.433998913998 | (37.7892683300519, -122.433998913998) | 13 | 9 | 1 | 29490 | 27 | ||
92865 | 3228 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 3864 California St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/21/2013 12:00:00 AM | 3 | 3x3 | 5995802.3054 | 2114541.58405 | 37.785886459875 | -122.458292942759 | (37.785886459875, -122.458292942759) | 11 | 6 | 1 | 54 | 31 | ||
92920 | 120248 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 164 24th Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | Width 6ft | 5988365.09621 | 2114861.46484 | 37.7863345857746 | -122.484046777757 | (37.7863345857746, -122.484046777757) | 11 | 6 | 1 | 55 | 33 | |||
93559 | 7320 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 2016 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/19/1992 12:00:00 AM | 7 | 3X3 | 6003001.73917 | 2115232.48409 | 37.7881945703662 | -122.433434308795 | (37.7881945703662, -122.433434308795) | 13 | 9 | 1 | 29490 | 27 | ||
93930 | 136206 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 201 Laurel St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 5998023.60869 | 2115735.83366 | 37.7892929467667 | -122.450694020137 | (37.7892929467667, -122.450694020137) | 11 | 6 | 1 | 54 | 31 | |||
94074 | 136220 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 2901 Steiner St | 14 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6002011.27576 | 2118147.89877 | 37.7961433022242 | -122.437069950312 | (37.7961433022242, -122.437069950312) | 13 | 9 | 1 | 57 | 17 | |||
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 | |||
96665 | 24572 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 2122 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/16/2013 12:00:00 AM | 3 | 3x3 | 6002889.00041 | 2115679.48805 | 37.7894155324538 | -122.433856328234 | (37.7894155324538, -122.433856328234) | 13 | 9 | 1 | 29490 | 27 | ||
96801 | 69357 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1355 Francisco St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/18/1994 12:00:00 AM | 7 | Permit Number 33448 | 6004836.73382 | 2120523.45104 | 37.8028261553684 | -122.427462613431 | (37.8028261553684, -122.427462613431) | 13 | 9 | 1 | 57 | 17 | |
98632 | 137889 | Undocumented 4 | Pyrus kawakamii :: Evergreen Pear 83 | 2034 FILLMORE ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Width 0ft | 6002935.6901 | 2115351.8703 | 37.7885186270288 | -122.433671363006 | (37.7885186270288, -122.433671363006) | 13 | 9 | 1 | 29490 | 27 |
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) );