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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 186933 | 61372 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 3240 Lyon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/04/1994 12:00:00 AM | 8 | Permit Number 32977 | 5999005.45241 | 2119937.78509 | 37.800886538036 | -122.447599568972 | (37.800886538036, -122.447599568972) | 13 | 9 | 1 | 57 | 17 | |
| 187407 | 52637 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 2@ PACIFIC Laurel St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/08/2006 12:00:00 AM | 8 | Permit Number 48719 | 5997984.07214 | 2116339.17658 | 37.7909473027338 | -122.450874333286 | (37.7909473027338, -122.450874333286) | 13 | 6 | 1 | 54 | 31 | ||
| 187966 | 7328 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 2042 Fillmore St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6002935.65629 | 2115353.59376 | 37.7885233572924 | -122.433671603208 | (37.7885233572924, -122.433671603208) | 13 | 9 | 1 | 29490 | 27 | |||
| 188580 | 136218 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 2901 Steiner St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6002000.86832 | 2118219.41961 | 37.7963390882297 | -122.437111085304 | (37.7963390882297, -122.437111085304) | 13 | 9 | 1 | 57 | 17 | |||
| 189045 | 115209 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 115 Spruce St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 3x3 | Permit Number 777466 | 5997030.13095 | 2115907.11493 | 37.7897063219407 | -122.454143692681 | (37.7897063219407, -122.454143692681) | 11 | 6 | 1 | 54 | 31 | ||
| 190087 | 69353 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1337 Francisco St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/18/1994 12:00:00 AM | 7 | Permit Number 33444 | 6004896.60555 | 2120531.01209 | 37.8028503021536 | -122.427255965393 | (37.8028503021536, -122.427255965393) | 13 | 9 | 1 | 57 | 17 | |
| 190545 | 69359 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 3130 Gough St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/18/1994 12:00:00 AM | 6 | Permit Number 33453 | 6004667.12401 | 2120354.39385 | 37.8023523736266 | -122.428037496051 | (37.8023523736266, -122.428037496051) | 13 | 9 | 1 | 57 | 17 | |
| 192729 | 136204 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 3898 Clay St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 4ft | 5996215.93738 | 2115261.69586 | 37.7878874538988 | -122.456914002974 | (37.7878874538988, -122.456914002974) | 11 | 6 | 1 | 54 | 31 | |||
| 193247 | 85088 | Significant Tree 6 | Pyrus kawakamii :: Evergreen Pear 83 | 1600 Chestnut St | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 6004108.1 | 2120157.9 | 37.8017812094321 | -122.429957968303 | (37.8017812094321, -122.429957968303) | 13 | 9 | 1 | 57 | 17 | |||||
| 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 | |||
| 3781 | 46872 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 2006 Larkin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/26/2002 12:00:00 AM | 6 | Permit Number 44935 | 6006916.93752 | 2118140.46696 | 37.7964005164122 | -122.420094813224 | (37.7964005164122, -122.420094813224) | 5 | 9 | 10 | 28858 | 32 | |
| 5972 | 136242 | Undocumented 4 | Pyrus kawakamii :: Evergreen Pear 83 | 1679 Washington St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6006678.63942 | 2116999.88567 | 37.7932553363267 | -122.420838360099 | (37.7932553363267, -122.420838360099) | 13 | 9 | 10 | 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 | |||
| 8502 | 73401 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1733 Polk St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 6006559.8799 | 2116866.9427 | 37.7928836135597 | -122.421239831973 | (37.7928836135597, -122.421239831973) | 13 | 9 | 10 | 28858 | 32 | |||
| 8876 | 136239 | Undocumented 4 | Pyrus kawakamii :: Evergreen Pear 83 | 1679 Washington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6006621.33402 | 2116991.57937 | 37.7932292991375 | -122.4210360509 | (37.7932292991375, -122.4210360509) | 13 | 9 | 10 | 28858 | 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 | ||
| 11751 | 142826 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1731 POLK ST | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 2 | Width 0ft | 6006566.9559 | 2116825.8136 | 37.7927710822258 | -122.421212426745 | (37.7927710822258, -122.421212426745) | 13 | 9 | 10 | 28858 | 32 | |||
| 12071 | 81939 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 1567 Pacific Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/04/2008 12:00:00 AM | 3x3 | Permit Number 50642 | 6006641.29456006 | 2117646.14573466 | 37.7950276999422 | -122.421013482861 | (37.7950276999422, -122.421013482861) | 13 | 9 | 10 | 28858 | 32 | ||
| 13336 | 136240 | Undocumented 4 | Pyrus kawakamii :: Evergreen Pear 83 | 1679 Washington St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6006640.65595 | 2116994.76492 | 37.7932391350289 | -122.420969421921 | (37.7932391350289, -122.420969421921) | 13 | 9 | 10 | 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 | |||
| 15988 | 136243 | Undocumented 4 | Pyrus kawakamii :: Evergreen Pear 83 | 1679 Washington St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6006695.60451 | 2117001.64443 | 37.7932611216587 | -122.42077978457 | (37.7932611216587, -122.42077978457) | 13 | 9 | 10 | 28858 | 32 | |||
| 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 | ||||
| 16514 | 136241 | Undocumented 4 | Pyrus kawakamii :: Evergreen Pear 83 | 1679 Washington St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6006661.22108 | 2116996.66069 | 37.7932454995431 | -122.42089839975 | (37.7932454995431, -122.42089839975) | 13 | 9 | 10 | 28858 | 32 | |||
| 21589 | 136245 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1723 Clay St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 6006515.15933 | 2116648.60219 | 37.7922815836866 | -122.421379054996 | (37.7922815836866, -122.421379054996) | 13 | 9 | 10 | 28858 | 21 | |||
| 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 | ||
| 25154 | 52631 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1725@ POLK Washington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/01/2006 12:00:00 AM | 3 | Permit Number 48716 | 6006396.26388 | 2116959.24979 | 37.7931278403295 | -122.421812512039 | (37.7931278403295, -122.421812512039) | 13 | 9 | 10 | 28858 | 32 | ||
| 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 | |||
| 28482 | 142842 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1343 POLK ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 6006739.5174 | 2115575.1482 | 37.7893467921177 | -122.420526537815 | (37.7893467921177, -122.420526537815) | 13 | 9 | 10 | 28858 | 21 | |||
| 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 | |||
| 38150 | 143127 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 2044 POLK ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 6006472.0934 | 2117865.3206 | 37.7956199598585 | -122.421614519298 | (37.7956199598585, -122.421614519298) | 13 | 9 | 10 | 28858 | 32 | |||
| 38907 | 58091 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1750 Polk St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/08/2010 12:00:00 AM | 2 | Permit Number 53771 | 6006613.15875288 | 2116850.06123449 | 37.7928402647887 | -122.421054285011 | (37.7928402647887, -122.421054285011) | 13 | 9 | 10 | 28858 | 32 | ||
| 44032 | 58781 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 2064 Polk St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/12/1995 12:00:00 AM | Permit Number 18024 | 6006472.52256241 | 2117868.87652577 | 37.7956297477373 | -122.421613286998 | (37.7956297477373, -122.421613286998) | 13 | 9 | 10 | 28858 | 32 | ||
| 49348 | 136256 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1422 Vallejo St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6006727.18618 | 2118403.84078 | 37.7971129818473 | -122.420770101557 | (37.7971129818473, -122.420770101557) | 13 | 9 | 10 | 28858 | 32 | |||
| 49788 | 136247 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1723 Clay St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 6006549.57992 | 2116650.11937 | 37.7922876900734 | -122.421260066609 | (37.7922876900734, -122.421260066609) | 13 | 9 | 10 | 28858 | 21 | |||
| 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 | |||
| 52503 | 52633 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1725@ POLK Washington St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/01/2006 12:00:00 AM | 3 | Permit Number 48716 | 6006431.88211 | 2116964.74466 | 37.79314493643 | -122.42168966107 | (37.79314493643, -122.42168966107) | 13 | 9 | 10 | 28858 | 32 | ||
| 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 | ||
| 59486 | 111906 | Undocumented 4 | Pyrus kawakamii :: Evergreen Pear 83 | 1699x WASHINGTON ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006657 | 2116952 | 37.7931226344993 | -122.420909832708 | (37.7931226344993, -122.420909832708) | 13 | 9 | 10 | 28858 | 32 | ||||
| 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 | ||
| 61839 | 136246 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1723 Clay St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 6006533.72276 | 2116650.00017 | 37.7922864687885 | -122.421314924346 | (37.7922864687885, -122.421314924346) | 13 | 9 | 10 | 28858 | 21 | |||
| 62922 | 52632 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1725@ POLK Washington St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/01/2006 12:00:00 AM | 6 | Permit Number 48716 | 6006419.56903 | 2116963.21871 | 37.7931400522157 | -122.421732156715 | (37.7931400522157, -122.421732156715) | 13 | 9 | 10 | 28858 | 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 | |
| 75777 | 70620 | Undocumented 4 | Pyrus kawakamii :: Evergreen Pear 83 | 1644 Washington St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/13/1994 12:00:00 AM | 12 | 3x3 | 6006824.13924708 | 2117065.21920464 | 37.7934429258981 | -122.420339559376 | (37.7934429258981, -122.420339559376) | 13 | 9 | 10 | 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 | |||
| 83591 | 142824 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1731 POLK ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 6006563.8602 | 2116843.0613 | 37.7928182655861 | -122.421224363331 | (37.7928182655861, -122.421224363331) | 13 | 9 | 10 | 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 | |||
| 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 | |||
| 94019 | 59283 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 1940 Polk St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/07/1994 12:00:00 AM | Permit Number 18619 | 6006528.93574422 | 2117463.80018293 | 37.7945206904601 | -122.421389306077 | (37.7945206904601, -122.421389306077) | 13 | 9 | 10 | 28858 | 32 | ||
| 94928 | 73448 | Undocumented 4 | Pyrus kawakamii :: Evergreen Pear 83 | 1644 Washington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/13/1994 12:00:00 AM | 12 | 3x3 | 6006824.13924708 | 2117065.21920464 | 37.7934429258981 | -122.420339559376 | (37.7934429258981, -122.420339559376) | 13 | 9 | 10 | 28858 | 32 | ||
| 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 | ||
| 96175 | 136255 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1422 Vallejo St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 2ft | 6006750.35587 | 2118407.27559 | 37.797123718848 | -122.42069017254 | (37.797123718848, -122.42069017254) | 13 | 9 | 10 | 28858 | 32 | |||
| 96849 | 81979 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 1567 Pacific Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/04/2008 12:00:00 AM | 3x3 | Permit Number 50642 | 6006641.29456006 | 2117646.14573466 | 37.7950276999422 | -122.421013482861 | (37.7950276999422, -122.421013482861) | 13 | 9 | 10 | 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 | |||
| 108819 | 142841 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1347 POLK ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 6006737.9132 | 2115595.2008 | 37.7894017611933 | -122.42053351217 | (37.7894017611933, -122.42053351217) | 13 | 9 | 10 | 28858 | 21 | |||
| 108936 | 68778 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 2020 Larkin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/16/1993 12:00:00 AM | 14 | 3x3 | Permit Number 32708 | 6006907.41923 | 2118207.98167 | 37.7965853585953 | -122.420132542485 | (37.7965853585953, -122.420132542485) | 5 | 9 | 10 | 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 | |||
| 118803 | 111908 | Undocumented 4 | Pyrus kawakamii :: Evergreen Pear 83 | 1699x WASHINGTON ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006657 | 2116952 | 37.7931226344993 | -122.420909832708 | (37.7931226344993, -122.420909832708) | 13 | 9 | 10 | 28858 | 32 | ||||
| 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 |
| 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 | |||
| 135107 | 35263 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 2314 Polk St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/30/2009 12:00:00 AM | 6 | 3x3 | Permit Number 52291 | 6006344.46456 | 2118787.78744 | 37.7981456238821 | -122.422121705266 | (37.7981456238821, -122.422121705266) | 13 | 9 | 10 | 28858 | 32 | |
| 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 | ||||
| 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 | |||
| 138778 | 69343 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 1720 Polk St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/07/1994 12:00:00 AM | Permit Number 53930 | 6006626.00049448 | 2116758.13786967 | 37.7925885900314 | -122.421003322231 | (37.7925885900314, -122.421003322231) | 13 | 9 | 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 | |
| 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 | |||
| 151327 | 111910 | Undocumented 4 | Pyrus kawakamii :: Evergreen Pear 83 | 1699x WASHINGTON ST | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006657 | 2116952 | 37.7931226344993 | -122.420909832708 | (37.7931226344993, -122.420909832708) | 13 | 9 | 10 | 28858 | 32 | ||||
| 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 | |||
| 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 | |||
| 156747 | 142821 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1760 POLK ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 6006596.1444 | 2116951.8546 | 37.7931188048508 | -122.421120386791 | (37.7931188048508, -122.421120386791) | 13 | 9 | 10 | 28858 | 32 | |||
| 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 | |||
| 169200 | 136244 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1747 Clay St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 6006363.52762 | 2116626.58822 | 37.7922125885856 | -122.421902140281 | (37.7922125885856, -122.421902140281) | 13 | 9 | 10 | 28858 | 21 | |||
| 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 | |||
| 176557 | 35264 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 2316 Polk St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/30/2009 12:00:00 AM | 3x3 | Permit Number 52291 | 6006351.5463232 | 2118737.5484062 | 37.7980080796095 | -122.422093629292 | (37.7980080796095, -122.422093629292) | 13 | 9 | 10 | 28858 | 32 | ||
| 183996 | 111907 | Undocumented 4 | Pyrus kawakamii :: Evergreen Pear 83 | 1699x WASHINGTON ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006657 | 2116952 | 37.7931226344993 | -122.420909832708 | (37.7931226344993, -122.420909832708) | 13 | 9 | 10 | 28858 | 32 | ||||
| 191471 | 111909 | Undocumented 4 | Pyrus kawakamii :: Evergreen Pear 83 | 1699x WASHINGTON ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006657 | 2116952 | 37.7931226344993 | -122.420909832708 | (37.7931226344993, -122.420909832708) | 13 | 9 | 10 | 28858 | 32 | ||||
| 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 | |||
| 1241 | 140612 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 880 Fillmore St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 6003492.8085 | 2111354.3072 | 37.777573917235 | -122.431458329369 | (37.777573917235, -122.431458329369) | 7 | 9 | 11 | 29492 | 10 | |||
| 1699 | 5933 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1355 Eddy St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/28/1990 12:00:00 AM | 3 | 4X4 | 6004029.33456 | 2112693.29822 | 37.781280848415 | -122.429697830179 | (37.781280848415, -122.429697830179) | 7 | 9 | 11 | 29490 | 41 |
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) );