trees
2,694 rows where qSpecies_id = 84 sorted by Location
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 91597 | 26794 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 186 Leland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/09/1999 12:00:00 AM | 2 | 3x3 | 6010044.3489 | 2087538.0893 | 37.7125489295627 | -122.407115057358 | (37.7125489295627, -122.407115057358) | 9 | 7 | 8 | 309 | 39 | ||
| 30723 | 120885 | Undocumented 4 | Prunus serrulata :: Ornamental Cherry 84 | 201 Leland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 3x3 | 6009830 | 2087548 | 37.7125641444482 | -122.407856615551 | (37.7125641444482, -122.407856615551) | 9 | 7 | 8 | 309 | 39 | ||||
| 166674 | 120891 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 201 Leland Ave | 7 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 1 | 3x3 | 6009886.0438 | 2087551.2204 | 37.7125761244342 | -122.407663136759 | (37.7125761244342, -122.407663136759) | 9 | 7 | 8 | 309 | 39 | |||
| 61236 | 120890 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 201 Leland Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 1 | 3x3 | 6009870.8927 | 2087557.0134 | 37.71259118268 | -122.40771591214 | (37.71259118268, -122.40771591214) | 9 | 7 | 8 | 309 | 39 | |||
| 61182 | 120889 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 201 Leland Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 1 | 3x3 | 6009853.959 | 2087561.9153 | 37.7126036943297 | -122.407774785999 | (37.7126036943297, -122.407774785999) | 9 | 7 | 8 | 309 | 39 | |||
| 177982 | 120888 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 201 Leland Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 1 | 3x3 | 6009826.3305 | 2087573.9471 | 37.7126351844606 | -122.407871127091 | (37.7126351844606, -122.407871127091) | 9 | 7 | 8 | 309 | 39 | |||
| 1809 | 120887 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 201 Leland Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 1 | 3x3 | 6009811.6249 | 2087578.8489 | 37.7126478205015 | -122.407922299954 | (37.7126478205015, -122.407922299954) | 9 | 7 | 8 | 309 | 39 | |||
| 37714 | 120886 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 201 Leland Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 1 | 3x3 | 6009795.1369 | 2087583.7508 | 37.7126603570018 | -122.407979633406 | (37.7126603570018, -122.407979633406) | 9 | 7 | 8 | 309 | 39 | |||
| 175097 | 95005 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 201X Leland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 6009777.312 | 2087590.4351 | 37.7126777127282 | -122.408041713268 | (37.7126777127282, -122.408041713268) | 9 | 7 | 8 | 309 | 39 | ||||
| 59804 | 109182 | Undocumented 4 | Prunus serrulata :: Ornamental Cherry 84 | 634 HURON AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 5998040 | 2087925.4 | 37.7129332935716 | -122.448633512376 | (37.7129332935716, -122.448633512376) | 9 | 7 | 6 | 28861 | 25 | |||
| 60596 | 217554 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 258 Broad St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 5994397.0077 | 2088113.6647 | 37.7132412415717 | -122.461238438183 | (37.7132412415717, -122.461238438183) | 9 | 8 | 6 | 28861 | 24 | |||
| 159909 | 178874 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 190 Foote Ave | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 8ft | 5998666.63351 | 2088343.63451 | 37.7141174818994 | -122.446497740299 | (37.7141174818994, -122.446497740299) | 9 | 7 | 6 | 28861 | 25 | |||
| 75451 | 178875 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 190 Foote Ave | 12 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 8ft | 5998646.96752 | 2088361.56482 | 37.7141655911394 | -122.446567002474 | (37.7141655911394, -122.446567002474) | 9 | 7 | 6 | 28861 | 25 | |||
| 36933 | 18597 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 415 Randolph St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/05/1999 12:00:00 AM | 6 | 3X3 | 5992871.5273 | 2088492.4561 | 37.7141934014371 | -122.466538492306 | (37.7141934014371, -122.466538492306) | 9 | 8 | 6 | 64 | 24 | ||
| 12911 | 25471 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 237 Randolph St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/08/2005 12:00:00 AM | 3 | 3X3 | 5993297.6081 | 2088487.2193 | 37.7142036007288 | -122.465065423908 | (37.7142036007288, -122.465065423908) | 9 | 8 | 6 | 64 | 24 | ||
| 11410 | 25472 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 205X Randolph St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/18/2019 12:00:00 AM | 6 | 3X3 | 5993432.494 | 2088486.2672 | 37.7142087634879 | -122.464599140586 | (37.7142087634879, -122.464599140586) | 9 | 8 | 6 | 64 | 24 | ||
| 54356 | 178894 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 38 Curtis St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 6000524.98993 | 2088394.35729 | 37.714362726143 | -122.44007819877 | (37.714362726143, -122.44007819877) | 9 | 7 | 6 | 28861 | 5 | |||
| 180432 | 50873 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 183 Lobos St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/08/2004 12:00:00 AM | Permit Number 47383 | 5995201.42685987 | 2088679.26823835 | 37.714840517964 | -122.458499025396 | (37.714840517964, -122.458499025396) | 9 | 8 | 6 | 28861 | 24 | |||
| 93738 | 214418 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 183 Lobos St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5995206.37473 | 2088687.61791 | 37.7148637285506 | -122.458482527651 | (37.7148637285506, -122.458482527651) | 9 | 8 | 6 | 28861 | 24 | |||
| 70798 | 178871 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 276 Foote Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 5998313.51813 | 2088706.56781 | 37.7150938380738 | -122.447744349048 | (37.7150938380738, -122.447744349048) | 9 | 7 | 6 | 28861 | 25 | |||
| 36657 | 214421 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 447 Head St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 10ft | 5993467.53824 | 2088847.90842 | 37.7152037640188 | -122.464504257681 | (37.7152037640188, -122.464504257681) | 9 | 8 | 6 | 64 | 24 | |||
| 29335 | 91571 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 511 Campbell Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/14/2009 12:00:00 AM | 3 | 3x3 | Permit Number 52143 | 6010245.73036 | 2088527.63553 | 37.7152772898907 | -122.40648870199 | (37.7152772898907, -122.40648870199) | 9 | 7 | 8 | 309 | 39 | |
| 74508 | 84214 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 103 Tucker Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/02/2008 12:00:00 AM | 3x3 | Permit Number 50754 | 6010384.5804163 | 2088747.67100343 | 37.7158892293049 | -122.406024264993 | (37.7158892293049, -122.406024264993) | 9 | 7 | 8 | 309 | 39 | ||
| 133866 | 84224 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 103 Tucker Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/02/2008 12:00:00 AM | 3x3 | Permit Number 50754 | 6010384.5804163 | 2088747.67100343 | 37.7158892293049 | -122.406024264993 | (37.7158892293049, -122.406024264993) | 9 | 7 | 8 | 309 | 39 | ||
| 15294 | 178876 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 852 Paris St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/12/2005 12:00:00 AM | 1 | Width 2ft | Permit Number 48053 | 6000760.9108 | 2088982.59449 | 37.7159913219087 | -122.439304903221 | (37.7159913219087, -122.439304903221) | 9 | 7 | 6 | 28861 | 5 | |
| 118299 | 178877 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 812 Naples St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6002023.11476 | 2088969.20619 | 37.7160263082367 | -122.434941181287 | (37.7160263082367, -122.434941181287) | 9 | 7 | 6 | 28861 | 5 | |||
| 139887 | 95729 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 247 Dublin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/07/2011 12:00:00 AM | 5 | 3x3 | Permit Number 767475 | 6004014.48263 | 2088996.54653 | 37.7162142458739 | -122.428060019581 | (37.7162142458739, -122.428060019581) | 9 | 7 | 6 | 28861 | 5 |
| 13781 | 40472 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 43 Lakeview Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/15/1999 12:00:00 AM | Permit Number 41555 | 5997449.10168169 | 2089159.83978526 | 37.7162889747674 | -122.450764790718 | (37.7162889747674, -122.450764790718) | 9 | 8 | 6 | 28861 | 24 | |||
| 115993 | 40473 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 43 Lakeview Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/15/1999 12:00:00 AM | Permit Number 41555 | 5997449.10168169 | 2089159.83978526 | 37.7162889747674 | -122.450764790718 | (37.7162889747674, -122.450764790718) | 9 | 8 | 6 | 28861 | 24 | |||
| 129092 | 40474 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 43 Lakeview Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/15/1999 12:00:00 AM | Permit Number 41555 | 5997449.10168169 | 2089159.83978526 | 37.7162889747674 | -122.450764790718 | (37.7162889747674, -122.450764790718) | 9 | 8 | 6 | 28861 | 24 | |||
| 164622 | 40471 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 43 Lakeview Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/15/1999 12:00:00 AM | Permit Number 41555 | 5997449.10168169 | 2089159.83978526 | 37.7162889747674 | -122.450764790718 | (37.7162889747674, -122.450764790718) | 9 | 8 | 6 | 28861 | 24 | |||
| 101593 | 40468 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 111 Caine Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/15/1999 12:00:00 AM | Permit Number 41553 | 5997316.73360061 | 2089179.17157647 | 37.7163344773044 | -122.451223710036 | (37.7163344773044, -122.451223710036) | 9 | 8 | 6 | 28861 | 24 | ||
| 104927 | 34809 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 55 Rome St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/29/1997 12:00:00 AM | Permit Number 38444 | 5999172.71597008 | 2089296.17855447 | 37.7167618448058 | -122.444816960418 | (37.7167618448058, -122.444816960418) | 9 | 7 | 6 | 28861 | 25 | ||
| 7567 | 78659 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 238 Ottawa Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 5998369.99191 | 2089313.52564 | 37.7167636327026 | -122.447592817774 | (37.7167636327026, -122.447592817774) | 9 | 7 | 6 | 28861 | 25 | |||
| 147295 | 38915 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 147 Byxbee St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/02/1998 12:00:00 AM | Permit Number 40726 | 5991915.47880902 | 2089512.34448242 | 37.7169385510534 | -122.469917148086 | (37.7169385510534, -122.469917148086) | 9 | 8 | 6 | 64 | 24 | ||
| 36059 | 38916 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 151 Byxbee St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/02/1998 12:00:00 AM | Permit Number 40727 | 5991915.78904323 | 2089537.41535132 | 37.7170074074891 | -122.469917900123 | (37.7170074074891, -122.469917900123) | 9 | 8 | 6 | 64 | 24 | ||
| 191890 | 178878 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 754 Edinburgh St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 2ft | 6001997.79635 | 2089434.88388 | 37.7173035182202 | -122.435061980046 | (37.7173035182202, -122.435061980046) | 9 | 7 | 6 | 28861 | 5 | |||
| 48523 | 178872 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1029 Russia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6003905.75349 | 2089465.86318 | 37.7174967348674 | -122.428469272232 | (37.7174967348674, -122.428469272232) | 9 | 7 | 6 | 28861 | 5 | |||
| 189468 | 178873 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1029 Russia Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6003894.97731 | 2089471.28937 | 37.7175110241788 | -122.428506907095 | (37.7175110241788, -122.428506907095) | 9 | 7 | 6 | 28861 | 5 | |||
| 27605 | 178906 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 109 Delta St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6009976.78188 | 2089389.92306 | 37.7176299046612 | -122.407479066904 | (37.7176299046612, -122.407479066904) | 9 | 7 | 8 | 309 | 39 | |||
| 67480 | 50722 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 495 Wilde Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/26/2004 12:00:00 AM | Permit Number 47274 | 6010067.71310756 | 2089419.28604179 | 37.7177156186782 | -122.40716682602 | (37.7177156186782, -122.40716682602) | 9 | 7 | 8 | 309 | 39 | |||
| 73119 | 50723 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 495 Wilde Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/26/2004 12:00:00 AM | Permit Number 47274 | 6010067.71310756 | 2089419.28604179 | 37.7177156186782 | -122.40716682602 | (37.7177156186782, -122.40716682602) | 9 | 7 | 8 | 309 | 39 | |||
| 172306 | 95775 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 674 Vienna St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/07/2011 12:00:00 AM | 3 | 3x3 | Permit Number 767509 | 6002729.66432 | 2089587.30224 | 37.7177635556125 | -122.432543138167 | (37.7177635556125, -122.432543138167) | 9 | 7 | 6 | 28861 | 5 |
| 139702 | 51244 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 31 Majestic Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/17/2004 12:00:00 AM | Permit Number 47619 | 5997384.45837141 | 2089741.12682177 | 37.7178813535714 | -122.451030121405 | (37.7178813535714, -122.451030121405) | 9 | 8 | 6 | 28861 | 24 | ||
| 60398 | 214424 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 732 Shields St | 1 | : | Tree | Private 2 | 1 | Width 3ft | 5992045.19947 | 2089870.88734 | 37.7179305201634 | -122.469494855606 | (37.7179305201634, -122.469494855606) | 9 | 8 | 6 | 64 | 24 | |||
| 7234 | 43732 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 769 Lakeview Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/25/2000 12:00:00 AM | Permit Number 43369 | 5994354.80201989 | 2089904.78759744 | 37.718156810292 | -122.461514088361 | (37.718156810292, -122.461514088361) | 9 | 8 | 6 | 28861 | 24 | ||
| 156721 | 66236 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 727 Lakeview Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/24/1990 12:00:00 AM | Permit Number 29334 | 5994760.98118392 | 2089897.08979712 | 37.7181590447559 | -122.460109553503 | (37.7181590447559, -122.460109553503) | 9 | 8 | 6 | 28861 | 24 | ||
| 129817 | 65461 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 745 Lakeview Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/10/2007 12:00:00 AM | 3x3 | Permit Number 49756 | 5994584.49670969 | 2089901.01202032 | 37.7181596617168 | -122.460719864451 | (37.7181596617168, -122.460719864451) | 9 | 8 | 6 | 28861 | 24 | ||
| 151402 | 43722 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 663 Lakeview Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/25/2000 12:00:00 AM | Permit Number 43362 | 5995378.9819826 | 2089884.66693766 | 37.7181604610324 | -122.457972504918 | (37.7181604610324, -122.457972504918) | 9 | 8 | 6 | 28861 | 24 | ||
| 13647 | 43721 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 655 Lakeview Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/25/2000 12:00:00 AM | Permit Number 43361 | 5995440.43888004 | 2089883.51967293 | 37.7181608417184 | -122.457759993154 | (37.7181608417184, -122.457759993154) | 9 | 8 | 6 | 28861 | 24 | ||
| 192588 | 50427 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 575 Lakeview Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/06/2003 12:00:00 AM | Permit Number 47080 | 5996062.43497228 | 2089871.90840865 | 37.718164673097 | -122.455609193168 | (37.718164673097, -122.455609193168) | 9 | 8 | 6 | 28861 | 24 | ||
| 114124 | 40566 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 687 London St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Permit Number 41611 | 6000998.28566 | 2089807.27388 | 37.7182692120226 | -122.438543479598 | (37.7182692120226, -122.438543479598) | 9 | 7 | 6 | 28861 | 5 | |||
| 72044 | 50652 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 41 Josiah Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/30/2003 12:00:00 AM | Permit Number 47234 | 5996870.80130055 | 2089899.24303395 | 37.7182860829536 | -122.452817003739 | (37.7182860829536, -122.452817003739) | 9 | 8 | 6 | 28861 | 24 | |||
| 106680 | 38920 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 748 Lakeview Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/02/1998 12:00:00 AM | Permit Number 40730 | 5994545.96417904 | 2089953.8830186 | 37.7183026158118 | -122.460856883631 | (37.7183026158118, -122.460856883631) | 9 | 8 | 6 | 28861 | 24 | ||
| 114340 | 178879 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 683 Edinburgh St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 2ft | 6002292.14978 | 2089824.92661 | 37.718391198782 | -122.434072405644 | (37.718391198782, -122.434072405644) | 9 | 7 | 6 | 28861 | 5 | |||
| 33286 | 43735 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 14 Lee Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/25/2000 12:00:00 AM | Permit Number 43372 | 5996531.68905486 | 2089965.7239711 | 37.7184491858628 | -122.453993963558 | (37.7184491858628, -122.453993963558) | 9 | 8 | 6 | 28861 | 24 | ||
| 133677 | 178929 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 236 Niagara Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | 5999086.84032 | 2089914.7209 | 37.7184553195406 | -122.445158233389 | (37.7184553195406, -122.445158233389) | 9 | 7 | 6 | 28861 | 25 | ||||
| 126419 | 45358 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 434 Victoria St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/19/2002 12:00:00 AM | Permit Number 44766 | 5993275.26942875 | 2090069.89309509 | 37.7185479545501 | -122.465257525662 | (37.7185479545501, -122.465257525662) | 9 | 8 | 6 | 64 | 24 | ||
| 189902 | 45359 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 438 Victoria St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/19/2002 12:00:00 AM | Permit Number 44767 | 5993275.62106747 | 2090094.58069454 | 37.71861576102 | -122.465258102457 | (37.71861576102, -122.465258102457) | 9 | 8 | 6 | 64 | 24 | ||
| 93726 | 66254 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 930 Capitol Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/24/1990 12:00:00 AM | Permit Number 29355 | 5995057.5524776 | 2090124.39622258 | 37.7188002278135 | -122.459100890621 | (37.7188002278135, -122.459100890621) | 9 | 8 | 6 | 28861 | 24 | ||
| 129196 | 214423 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 447 Bright St | 1 | : | Tree | Private 2 | 3 | Width 3ft | 5993753.59221 | 2090152.37899 | 37.7188020135797 | -122.463610156194 | (37.7188020135797, -122.463610156194) | 9 | 8 | 6 | 64 | 24 | |||
| 49040 | 33821 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 56 Mill St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/03/1985 12:00:00 AM | Permit Number 37837 | 6010417.94927739 | 2089844.96936421 | 37.7189040522027 | -122.405986182119 | (37.7189040522027, -122.405986182119) | 10 | 7 | 8 | 309 | 39 | |||
| 100403 | 178880 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 641 Edinburgh St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6002434.09262 | 2090051.35285 | 37.7190209697198 | -122.433597942217 | (37.7190209697198, -122.433597942217) | 9 | 7 | 6 | 28861 | 5 | |||
| 143097 | 214420 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 466 Victoria St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 6ft | 5993273.26213 | 2090266.31835 | 37.7190871751261 | -122.465278724129 | (37.7190871751261, -122.465278724129) | 9 | 8 | 6 | 64 | 24 | |||
| 19566 | 178881 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 631 Edinburgh St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 6002458.40291 | 2090087.03952 | 37.7191203367176 | -122.433516460014 | (37.7191203367176, -122.433516460014) | 9 | 7 | 6 | 28861 | 5 | |||
| 24390 | 66242 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 283 Tara St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/24/1990 12:00:00 AM | Permit Number 29340 | 5997754.61642905 | 2090213.33999682 | 37.7191991265322 | -122.449784665644 | (37.7191991265322, -122.449784665644) | 9 | 8 | 6 | 28861 | 24 | ||
| 89877 | 47355 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 375 Ralston St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/13/2002 12:00:00 AM | Permit Number 45280 | 5992186.9428459 | 2090329.99196799 | 37.7191993003756 | -122.469038309031 | (37.7191993003756, -122.469038309031) | 9 | 8 | 6 | 64 | 24 | ||
| 162367 | 47354 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 375 Ralston St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/13/2002 12:00:00 AM | Permit Number 45280 | 5992186.9428459 | 2090329.99196799 | 37.7191993003756 | -122.469038309031 | (37.7191993003756, -122.469038309031) | 9 | 8 | 6 | 64 | 24 | ||
| 44234 | 50018 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 375 Vernon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/28/2003 12:00:00 AM | Permit Number 46752 | 5992447.36096557 | 2090326.79664317 | 37.7192055701762 | -122.468137918171 | (37.7192055701762, -122.468137918171) | 9 | 8 | 6 | 64 | 24 | ||
| 97892 | 214419 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 479 Ramsell St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 10ft | 5992969.97647 | 2090349.42697 | 37.7192978763685 | -122.466333093823 | (37.7192978763685, -122.466333093823) | 9 | 8 | 6 | 64 | 24 | |||
| 101608 | 43716 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 66 Jules Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/25/2000 12:00:00 AM | Permit Number 43357 | 5994471.63688238 | 2090356.83767318 | 37.7194047560126 | -122.461142992014 | (37.7194047560126, -122.461142992014) | 9 | 8 | 6 | 28861 | 24 | ||
| 48589 | 49775 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 996@ ORDWAY Somerset St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/09/2003 12:00:00 AM | Permit Number 46561 | 6010806.40404101 | 2090031.53281179 | 37.7194380356715 | -122.404656566431 | (37.7194380356715, -122.404656566431) | 10 | 7 | 8 | 309 | 28 | ||
| 78637 | 49774 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 996@ ORDWAY Somerset St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/09/2003 12:00:00 AM | Permit Number 46561 | 6010806.40404101 | 2090031.53281179 | 37.7194380356715 | -122.404656566431 | (37.7194380356715, -122.404656566431) | 10 | 7 | 8 | 309 | 28 | ||
| 162412 | 103482 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 560 Vienna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | 3x3 | 6003141.00472 | 2090240.25972 | 37.7195797508971 | -122.431167899382 | (37.7195797508971, -122.431167899382) | 9 | 7 | 6 | 28861 | 5 | |||
| 118310 | 71314 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 530 Athens St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/26/2012 12:00:00 AM | 2 | Permit Number 769252 | 6003477.6405 | 2090266.53643 | 37.7196709718096 | -122.430006145274 | (37.7196709718096, -122.430006145274) | 9 | 7 | 6 | 28861 | 5 | |
| 173484 | 52967 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 430 Garfield St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/03/2006 12:00:00 AM | Permit Number 48951 | 5992913.39477217 | 2090514.51004168 | 37.7197478895212 | -122.466540666402 | (37.7197478895212, -122.466540666402) | 9 | 8 | 6 | 64 | 24 | ||
| 172802 | 47334 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 142 Garfield St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/13/2002 12:00:00 AM | Permit Number 45265 | 5993656.96278859 | 2090531.97182441 | 37.7198387158131 | -122.463971702484 | (37.7198387158131, -122.463971702484) | 9 | 8 | 6 | 64 | 24 | ||
| 82288 | 66229 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 219 Tara St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/24/1990 12:00:00 AM | Permit Number 29326 | 5997887.19527776 | 2090462.5095335 | 37.7198908728412 | -122.449344335824 | (37.7198908728412, -122.449344335824) | 9 | 8 | 6 | 28861 | 24 | ||
| 30961 | 84824 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 845 Mount Vernon Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/27/2007 12:00:00 AM | Permit No. 49256 | 5996978.8 | 2090483.4 | 37.7198962296133 | -122.452485832408 | (37.7198962296133, -122.452485832408) | 9 | 8 | 6 | 28861 | 24 | |||
| 179133 | 84825 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 845 Mount Vernon Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/27/2007 12:00:00 AM | Permit No. 49256 | 5996978.8 | 2090483.4 | 37.7198962296133 | -122.452485832408 | (37.7198962296133, -122.452485832408) | 9 | 8 | 6 | 28861 | 24 | |||
| 61108 | 178901 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 811 University St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6008890.15805 | 2090268.5562 | 37.719981566168 | -122.411297082012 | (37.719981566168, -122.411297082012) | 9 | 3 | 7 | 309 | 28 | |||
| 60666 | 45788 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 524 Grafton Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/13/2002 12:00:00 AM | Permit Number 45272 | 5995257.5395659 | 2090592.77790767 | 37.7200977875118 | -122.458443505078 | (37.7200977875118, -122.458443505078) | 9 | 8 | 6 | 28861 | 24 | ||
| 163795 | 37830 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 451 Athens St | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 07/09/2007 12:00:00 AM | 3 | 6x6 | Permit Number 49480 | 6003635.85955 | 2090436.92041 | 37.7201477680848 | -122.429471383195 | (37.7201477680848, -122.429471383195) | 9 | 7 | 6 | 28861 | 5 |
| 11092 | 74333 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1118 Fitzgerald Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 6015132.5367 | 2090213.511 | 37.720178552846 | -122.389715298726 | (37.720178552846, -122.389715298726) | 10 | 3 | 8 | 58 | 1 | |||
| 98004 | 37838 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 451 Athens St | 2 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 07/07/1998 12:00:00 AM | 3 | 4x6 | Permit Number 40134 | 6003644.26117 | 2090451.27602 | 37.7201876611143 | -122.429443364835 | (37.7201876611143, -122.429443364835) | 9 | 7 | 6 | 28861 | 5 |
| 27765 | 37839 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 451 Athens St | 3 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 07/07/1998 12:00:00 AM | 3 | 4x6 | Permit Number 40134 | 6003658.01474 | 2090473.5929 | 37.7202497170415 | -122.42939741397 | (37.7202497170415, -122.42939741397) | 9 | 7 | 6 | 28861 | 5 |
| 170729 | 214422 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 529 Bright St | 1 | : | Tree | Private 2 | 4 | Width 3ft | 5993759.81051 | 2090686.52668 | 37.7202690128731 | -122.463627407878 | (37.7202690128731, -122.463627407878) | 9 | 8 | 6 | 64 | 24 | |||
| 181911 | 37840 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 451 Athens St | 4 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 07/09/2007 12:00:00 AM | 3 | 4x6 | Permit Number 49480 | 6003672.4294 | 2090496.54171 | 37.7203135455184 | -122.429349222898 | (37.7203135455184, -122.429349222898) | 9 | 7 | 6 | 28861 | 5 |
| 104136 | 45312 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 333 Byxbee St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/12/2002 12:00:00 AM | Permit Number 44759 | 5991931.79579935 | 2090744.40687829 | 37.7203224367541 | -122.469950404817 | (37.7203224367541, -122.469950404817) | 9 | 8 | 6 | 64 | 24 | ||
| 121512 | 43736 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 114 Lee Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/25/2000 12:00:00 AM | Permit Number 43373 | 5996541.98319278 | 2090652.82083499 | 37.720336382823 | -122.45400797708 | (37.720336382823, -122.45400797708) | 9 | 8 | 6 | 28861 | 24 | ||
| 4260 | 178882 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 451 Athens St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6003684.48265 | 2090515.01932 | 37.7203649633559 | -122.4293088757 | (37.7203649633559, -122.4293088757) | 9 | 7 | 6 | 28861 | 5 | |||
| 128924 | 178883 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 451 Athens St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6003694.22054 | 2090531.28472 | 37.7204101758585 | -122.42927637423 | (37.7204101758585, -122.42927637423) | 9 | 7 | 6 | 28861 | 5 | |||
| 121074 | 45309 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 238 Beverly St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/18/2001 12:00:00 AM | Permit Number 44147 | 5991464.05254061 | 2090792.05998046 | 37.7204262308827 | -122.471570695131 | (37.7204262308827, -122.471570695131) | 9 | 8 | 6 | 64 | 24 | ||
| 58603 | 178891 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 579 Madrid St | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 4ft | 6002452.87445 | 2090566.89512 | 37.7204375997904 | -122.43356984467 | (37.7204375997904, -122.43356984467) | 9 | 7 | 6 | 28861 | 5 | |||
| 116884 | 178884 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 451 Athens St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6003708.27118 | 2090552.30373 | 37.7204686848705 | -122.429229303716 | (37.7204686848705, -122.429229303716) | 9 | 7 | 6 | 28861 | 5 | |||
| 65104 | 45349 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 442 Vernon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/12/2002 12:00:00 AM | Permit Number 44764 | 5992505.35292147 | 2090807.04622062 | 37.7205275676125 | -122.467972377091 | (37.7205275676125, -122.467972377091) | 9 | 8 | 6 | 64 | 24 | ||
| 52577 | 178885 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 451 Athens St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6003721.71366 | 2090575.27261 | 37.7205325133491 | -122.429184474304 | (37.7205325133491, -122.429184474304) | 9 | 7 | 6 | 28861 | 5 | |||
| 132375 | 38910 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 542 Arch St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/02/1998 12:00:00 AM | Permit Number 40722 | 5992764.33916068 | 2090804.00808724 | 37.7205341782239 | -122.46707693099 | (37.7205341782239, -122.46707693099) | 9 | 8 | 6 | 64 | 24 | ||
| 19600 | 70126 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 518 Naples St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 3x3 | Permit Number 767414 | 6003049.75959 | 2090601.90902 | 37.7205675887031 | -122.431509104887 | (37.7205675887031, -122.431509104887) | 9 | 7 | 6 | 28861 | 5 | |
| 41956 | 178886 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 451 Athens St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 6003733.07859 | 2090591.8271 | 37.7205786116989 | -122.429146369125 | (37.7205786116989, -122.429146369125) | 9 | 7 | 6 | 28861 | 5 |
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) );