Data source: data.sfgov.org
This data as json, CSV (advanced)
| Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1369 | 1369 | 121635 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 506 11th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/11/2017 12:00:00 AM | 3 | 3x3 | 5992560.0 | 2111978.0 | 37.778660711296794 | -122.46932365779699 | (37.7786607112968, -122.469323657797) | ||
| 1766 | 1766 | 251688 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 925 Sutter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6008132.0 | 2115128.0 | 37.788197407905 | -122.415677021756 | (37.788197407905, -122.415677021756) | ||||
| 2824 | 2824 | 124729 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 198X Division St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6010680.0 | 2108566.0 | 37.7703225929477 | -122.406398777104 | (37.7703225929477, -122.406398777104) | ||||
| 2914 | 2914 | 225015 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 157 Hartford St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/11/2017 12:00:00 AM | 3 | Width 3ft | Permit Number 780170 | 6002699.8255900005 | 2104972.04176 | 37.7600048066089 | -122.433745251143 | (37.7600048066089, -122.433745251143) | |
| 3707 | 3707 | 253520 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 2626 Larkin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/19/2017 12:00:00 AM | 3 | 3x3 | 6006643.0 | 2120264.0 | 37.8022157634914 | -122.42119356191999 | (37.8022157634914, -122.42119356192) | ||
| 3713 | 3713 | 253521 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 2626 Larkin St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/19/2017 12:00:00 AM | 3 | 3x3 | 6006643.0 | 2120264.0 | 37.8022157634914 | -122.42119356191999 | (37.8022157634914, -122.42119356192) | ||
| 4854 | 4854 | 253694 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 536 Octavia St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6005450.0 | 2111168.0 | 37.7771730951376 | -122.42467448311199 | (37.7771730951376, -122.424674483112) | ||||
| 4859 | 4859 | 253693 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 536 Octavia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6005450.0 | 2111168.0 | 37.7771730951376 | -122.42467448311199 | (37.7771730951376, -122.424674483112) | ||||
| 5108 | 5108 | 124732 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 198X Division St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6010680.0 | 2108566.0 | 37.7703225929477 | -122.406398777104 | (37.7703225929477, -122.406398777104) | ||||
| 5755 | 5755 | 124730 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 198X Division St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6010680.0 | 2108566.0 | 37.7703225929477 | -122.406398777104 | (37.7703225929477, -122.406398777104) | ||||
| 6653 | 6653 | 124728 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 198X Division St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6010680.0 | 2108566.0 | 37.7703225929477 | -122.406398777104 | (37.7703225929477, -122.406398777104) | ||||
| 6680 | 6680 | 112268 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 1X Geary St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | ||||||||||
| 6704 | 6704 | 112269 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 1X Geary St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | ||||||||||
| 7811 | 7811 | 124731 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 198X Division St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6010680.0 | 2108566.0 | 37.7703225929477 | -122.406398777104 | (37.7703225929477, -122.406398777104) | ||||
| 7941 | 7941 | 124727 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 198X Division St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6010680.0 | 2108566.0 | 37.7703225929477 | -122.406398777104 | (37.7703225929477, -122.406398777104) | ||||
| 9701 | 9701 | 173642 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 657 Howard St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6012793.0 | 2114089.0 | 37.78560546361629 | -122.39947767317301 | (37.7856054636163, -122.399477673173) | ||||
| 9990 | 9990 | 173774 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 2239 15th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6002625.0 | 2107043.0 | 37.7656869095489 | -122.434152085943 | (37.7656869095489, -122.434152085943) | ||||
| 9993 | 9993 | 173772 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 2235 15th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6002649.0 | 2107045.0 | 37.7656937631635 | -122.434069218237 | (37.7656937631635, -122.434069218237) | ||||
| 10016 | 10016 | 173777 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 89 Eureka St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6001439.0 | 2105287.0 | 37.760797980712205 | -122.438128392537 | (37.7607979807122, -122.438128392537) | ||||
| 10023 | 10023 | 173776 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 89 Eureka St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6001439.0 | 2105287.0 | 37.760797980712205 | -122.438128392537 | (37.7607979807122, -122.438128392537) | ||||
| 10025 | 10025 | 173773 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 2235 15th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6002649.0 | 2107045.0 | 37.7656937631635 | -122.434069218237 | (37.7656937631635, -122.434069218237) | ||||
| 10044 | 10044 | 120656 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 160 Folsom St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 778623 | 6015082.0 | 2115536.0 | 37.7897059122539 | -122.3916595384 | (37.7897059122539, -122.3916595384) | |||
| 10045 | 10045 | 120661 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 299X Main St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 778623 | 6015082.0 | 2115536.0 | 37.7897059122539 | -122.3916595384 | (37.7897059122539, -122.3916595384) | |||
| 10058 | 10058 | 120660 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 126 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 778623 | 6015082.0 | 2115536.0 | 37.7897059122539 | -122.3916595384 | (37.7897059122539, -122.3916595384) | |||
| 10065 | 10065 | 120663 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 299X Main St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 778623 | 6015082.0 | 2115536.0 | 37.7897059122539 | -122.3916595384 | (37.7897059122539, -122.3916595384) | |||
| 10066 | 10066 | 120655 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 160 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 778623 | 6015082.0 | 2115536.0 | 37.7897059122539 | -122.3916595384 | (37.7897059122539, -122.3916595384) | |||
| 10073 | 10073 | 120662 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 299X Main St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 778623 | 6015082.0 | 2115536.0 | 37.7897059122539 | -122.3916595384 | (37.7897059122539, -122.3916595384) | |||
| 10130 | 10130 | 173876 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 250 Raymond Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6009764.0 | 2087931.0 | 37.7136120890563 | -122.408111727364 | (37.7136120890563, -122.408111727364) | ||||
| 10165 | 10165 | 173892 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 24 Prospect Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6007185.0 | 2099410.0 | 37.7449861923813 | -122.417838888286 | (37.7449861923813, -122.417838888286) | ||||
| 10172 | 10172 | 173891 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 24 Prospect Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6007185.0 | 2099410.0 | 37.7449861923813 | -122.417838888286 | (37.7449861923813, -122.417838888286) | ||||
| 10998 | 10998 | 112267 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 1X Geary St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | ||||||||||
| 11026 | 11026 | 173949 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 1306 Clayton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5999102.0 | 2105133.0 | 37.760241947595404 | -122.446199926833 | (37.7602419475954, -122.446199926833) | ||||
| 12922 | 12922 | 173948 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 1300 Clayton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5999106.0 | 2105162.0 | 37.7603218028196 | -122.446188178838 | (37.7603218028196, -122.446188178838) | ||||
| 13244 | 13244 | 113373 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 88 HOWARD ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/22/2015 12:00:00 AM | 3x3 | 6014757.0 | 2116474.0 | 37.7922633974731 | -122.39284966575 | (37.7922633974731, -122.39284966575) | |||
| 17885 | 17885 | 102456 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 3365 20th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 6007790.0 | 2104415.0 | 37.7587628183764 | -122.416101290754 | (37.7587628183764, -122.416101290754) | |||
| 18014 | 18014 | 113224 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 4244 23RD ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6001623.0 | 2102374.0 | 37.752810049427794 | -122.437283434624 | (37.7528100494278, -122.437283434624) | ||||
| 18683 | 18683 | 108105 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 2390X Green St | 7 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 6001806.63782 | 2118043.59498 | 37.7958452773357 | -122.437770563269 | (37.7958452773357, -122.437770563269) | |||||
| 19501 | 19501 | 117186 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 201x GREENWICH ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6x6 | 6011833.0 | 2120374.0 | 37.80280901508429 | -122.40324129087 | (37.8028090150843, -122.40324129087) | ||||
| 19675 | 19675 | 103628 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 1450X Stevenson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | Permit Number 777592 | 6006328.29748 | 2108087.53462 | 37.768764440650294 | -122.42141735000799 | (37.7687644406503, -122.421417350008) | ||
| 19843 | 19843 | 99594 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 1855X Evans Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | 6014349.8 | 2099426.2 | 37.7454312840379 | -122.393065244865 | (37.7454312840379, -122.393065244865) | |||
| 20082 | 20082 | 111807 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 50X COLUMBIA SQUARE ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 3x3 | 6010857.0 | 2110997.0 | 37.7770074580074 | -122.405957810357 | (37.7770074580074, -122.405957810357) | ||||
| 20384 | 20384 | 104821 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 2173 15TH ST | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 6003063.7 | 2107068.1 | 37.7657807169148 | -122.43263651234301 | (37.7657807169148, -122.432636512343) | |||||
| 20651 | 20651 | 115057 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 499X BRANNAN ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6013762.0 | 2111312.0 | 37.7780344196247 | -122.39593052209601 | (37.7780344196247, -122.395930522096) | ||||
| 20843 | 20843 | 111792 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 55X SHERMAN ST | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 3x3 | 6010857.0 | 2110997.0 | 37.7770074580074 | -122.405957810357 | (37.7770074580074, -122.405957810357) | ||||
| 22938 | 22938 | 110472 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 477 GROVE ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/13/2016 12:00:00 AM | 3 | 3x10 | 6005542.0 | 2111298.0 | 37.77753523894629 | -122.424365474196 | (37.7775352389463, -122.424365474196) | ||
| 22981 | 22981 | 116011 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 1448 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/09/2016 12:00:00 AM | 3 | 6000920.0 | 2110390.8 | 37.7747822166773 | -122.44028940195601 | (37.7747822166773, -122.440289401956) | |||
| 27184 | 27184 | 117402 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 75x BEACH ST | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6009846.0 | 2122112.0 | 37.80746995952921 | -122.410240137563 | (37.8074699595292, -122.410240137563) | ||||
| 28450 | 28450 | 104230 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 409 Walnut St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14x8 | 5998587.6 | 2115205.6 | 37.787869332154 | -122.44870447955601 | (37.787869332154, -122.448704479556) | ||||
| 41076 | 41076 | 117048 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 2183 SUTTER ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | 3x3 | 6002170.0 | 2114323.0 | 37.78565013631621 | -122.436246868292 | (37.7856501363162, -122.436246868292) | |||
| 42747 | 42747 | 115058 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 499X BRANNAN ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6013762.0 | 2111312.0 | 37.7780344196247 | -122.39593052209601 | (37.7780344196247, -122.395930522096) | ||||
| 43174 | 43174 | 117400 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 75x BEACH ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6009846.0 | 2122112.0 | 37.80746995952921 | -122.410240137563 | (37.8074699595292, -122.410240137563) | ||||
| 43364 | 43364 | 115743 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 1X POND ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Public Library 14 | Rec/Park 7 | 28 | 3x3 | 6003250.0 | 2106477.0 | 37.764168263011996 | -122.43194992880301 | (37.764168263012, -122.431949928803) | ||
| 44347 | 44347 | 224728 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 1110 York St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 3ft | Permit Number 771820 | 6009984.63313 | 2102660.33541 | 37.754068053508 | -122.40838743973801 | (37.754068053508, -122.408387439738) | ||
| 49589 | 49589 | 104825 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 45 Prosper St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6003350.0 | 2106266.0 | 37.763594576550496 | -122.431588992909 | (37.7635945765505, -122.431588992909) | |||
| 49591 | 49591 | 110708 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 2999X Turk St | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5996638.0 | 2111487.0 | 37.7775473668867 | -122.455180869531 | (37.7775473668867, -122.455180869531) | ||||
| 50412 | 50412 | 111774 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 215 CLAYTON ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | 3x3 | 5998260.0 | 2109886.0 | 37.773244358342296 | -122.449454468346 | (37.7732443583423, -122.449454468346) | |||
| 51254 | 51254 | 120965 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 1145x Noe St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6003243.0 | 2101623.0 | 37.7508399403415 | -122.43162756863 | (37.7508399403415, -122.43162756863) | ||||
| 62742 | 62742 | 100053 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 3233X Buchanan St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6003300.0 | 2119605.0 | 37.800217292537106 | -122.432714848025 | (37.8002172925371, -122.432714848025) | |||
| 65719 | 65719 | 99967 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 2270 Folsom St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6007986.9 | 2105322.2 | 37.761264849910205 | -122.415484545241 | (37.7612648499102, -122.415484545241) | |||||
| 65794 | 65794 | 115992 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 438 20th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/27/2016 12:00:00 AM | 3 | Permit Number 778644 | 5989723.9 | 2112354.3 | 37.7795296278249 | -122.47916224845301 | (37.7795296278249, -122.479162248453) | ||
| 66011 | 66011 | 108152 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 2232 Webster St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6003295.44003 | 2116396.66877 | 37.791407783491294 | -122.432501340527 | (37.7914077834913, -122.432501340527) | |||||
| 72158 | 72158 | 116028 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 1500 PACIFIC AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6006937.0 | 2117734.0 | 37.7952855901943 | -122.419996533467 | (37.7952855901943, -122.419996533467) | ||||
| 72207 | 72207 | 101715 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 560 Wisconsin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6012536.0 | 2104936.0 | 37.760459075101 | -122.399723915341 | (37.760459075101, -122.399723915341) | |||||
| 76139 | 76139 | 94058 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 1401X 08th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 5993648.0 | 2105942.0 | 37.7621502689837 | -122.465121353228 | (37.7621502689837, -122.465121353228) | |||
| 77420 | 77420 | 110696 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 2999X Turk St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5996638.0 | 2111487.0 | 37.7775473668867 | -122.455180869531 | (37.7775473668867, -122.455180869531) | ||||
| 77535 | 77535 | 111597 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 398X BRYANT ST | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6014483.0 | 2113360.0 | 37.7836978486164 | -122.393579678281 | (37.7836978486164, -122.393579678281) | ||||
| 77860 | 77860 | 102602 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 88 Spear St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | 3x3 | 6014255.3 | 2116583.4 | 37.7925359054466 | -122.394593235194 | (37.7925359054466, -122.394593235194) | |||
| 78196 | 78196 | 122714 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 855x Kearny St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6011188.0 | 2117923.0 | 37.7960431220576 | -122.40530062831999 | (37.7960431220576, -122.40530062832) | ||||
| 78296 | 78296 | 93145 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 1152 Clement St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5991985.0 | 2113459.0 | 37.7826938870859 | -122.47142072749399 | (37.7826938870859, -122.471420727494) | |||||
| 78427 | 78427 | 111811 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 50X COLUMBIA SQUARE ST | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 3x3 | 6010857.0 | 2110997.0 | 37.7770074580074 | -122.405957810357 | (37.7770074580074, -122.405957810357) | ||||
| 78463 | 78463 | 115215 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 3395x 21ST ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/24/2016 12:00:00 AM | 3 | 9x5 | Permit Number 779049 | 6005778.0 | 2103691.0 | 37.7566615513452 | -122.423008263345 | (37.7566615513452, -122.423008263345) | |
| 78813 | 78813 | 111595 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 398X BRYANT ST | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6014483.0 | 2113360.0 | 37.7836978486164 | -122.393579678281 | (37.7836978486164, -122.393579678281) | ||||
| 78842 | 78842 | 120144 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 1X Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6008026.0 | 2111839.0 | 37.77916064960021 | -122.41581078056299 | (37.7791606496002, -122.415810780563) | ||||
| 78954 | 78954 | 113001 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 700x STANYAN ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5997124.0 | 2108268.0 | 37.768736698354004 | -122.453267191941 | (37.768736698354, -122.453267191941) | ||||
| 79104 | 79104 | 116602 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 3260x 16TH ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 9x9 | 6005124.0 | 2106632.0 | 37.764699916645 | -122.425479329399 | (37.764699916645, -122.425479329399) | |||
| 79132 | 79132 | 109603 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 602 SHOTWELL ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6007851.6 | 2104381.9 | 37.758675396701 | -122.41588590510901 | (37.758675396701, -122.415885905109) | ||||
| 79426 | 79426 | 116125 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 2500X Keith St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6014198.52795 | 2092093.45262 | 37.7252886606488 | -122.39307534923799 | (37.7252886606488, -122.393075349238) | |||||
| 79496 | 79496 | 96947 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 900X Capp St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | 6x6 | 6007389.0 | 2101516.0 | 37.750780272338 | -122.41728270280899 | (37.750780272338, -122.417282702809) | |||
| 79596 | 79596 | 117399 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 75x BEACH ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6009846.0 | 2122112.0 | 37.80746995952921 | -122.410240137563 | (37.8074699595292, -122.410240137563) | ||||
| 79647 | 79647 | 107630 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 2164 CHESTNUT ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3x3 | 6001495.0 | 2119755.0 | 37.8005266206576 | -122.438971595662 | (37.8005266206576, -122.438971595662) | |||
| 79798 | 79798 | 115056 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 499X BRANNAN ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6013762.0 | 2111312.0 | 37.7780344196247 | -122.39593052209601 | (37.7780344196247, -122.395930522096) | ||||
| 79860 | 79860 | 101758 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 45X 11th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 6007389.6 | 2110351.2 | 37.7750397101602 | -122.41790686002899 | (37.7750397101602, -122.417906860029) | |||
| 79876 | 79876 | 120964 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 1145x Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6003243.0 | 2101623.0 | 37.7508399403415 | -122.43162756863 | (37.7508399403415, -122.43162756863) | ||||
| 79879 | 79879 | 110363 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 1899x MARIPOSA ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6011823.0 | 2106021.0 | 37.7633984709679 | -122.40226615501801 | (37.7633984709679, -122.402266155018) | ||||
| 79945 | 79945 | 113775 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 1712 BAKER ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | 3x3 | 6000121.0 | 2114885.0 | 37.7870766118482 | -122.443376178084 | (37.7870766118482, -122.443376178084) | |||
| 79990 | 79990 | 111430 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 500X PRESIDIO AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5999200.0 | 2114887.0 | 37.7870295394193 | -122.446562765799 | (37.7870295394193, -122.446562765799) | ||||
| 80162 | 80162 | 110730 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 3515 25TH ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6006381.0 | 2101411.0 | 37.7504352040325 | -122.42076100913799 | (37.7504352040325, -122.420761009138) | ||||
| 80453 | 80453 | 96734 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 520 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | 3x3.5 | 6007401.6 | 2106571.6 | 37.764662495901106 | -122.41759740995501 | (37.7646624959011, -122.417597409955) | |||
| 80499 | 80499 | 108103 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 2390X Green St | 5 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 6001806.63782 | 2118043.59498 | 37.7958452773357 | -122.437770563269 | (37.7958452773357, -122.437770563269) | |||||
| 80569 | 80569 | 113510 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 320 TURK ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6008411.0 | 2113171.0 | 37.7828396386737 | -122.41457318656299 | (37.7828396386737, -122.414573186563) | ||||
| 80581 | 80581 | 96337 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 1851 15th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6005204.9 | 2107156.8 | 37.766145462943605 | -122.42523686393 | (37.7661454629436, -122.42523686393) | |||
| 80661 | 80661 | 107839 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 1000x LEAVENWORTH ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6008256.0 | 2115925.0 | 37.790392745036 | -122.41530444395501 | (37.790392745036, -122.415304443955) | ||||
| 80711 | 80711 | 120139 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 10X Grove St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6007842.0 | 2111812.0 | 37.779076168386105 | -122.41644540073798 | (37.7790761683861, -122.416445400738) | ||||
| 80730 | 80730 | 117185 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 201x GREENWICH ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6011833.0 | 2120374.0 | 37.80280901508429 | -122.40324129087 | (37.8028090150843, -122.40324129087) | ||||
| 81089 | 81089 | 100262 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 40 Federal St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | 3x3 | 6014922.0 | 2113400.9 | 37.7838345339316 | -122.39206375347099 | (37.7838345339316, -122.392063753471) | |||
| 81245 | 81245 | 111817 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 80 ORD ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | 3x3 | 6000817.0 | 2105938.0 | 37.7625500726099 | -122.440326296311 | (37.7625500726099, -122.440326296311) | |||
| 81353 | 81353 | 112404 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 300x 15TH ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6011264.0 | 2107649.0 | 37.7678373720049 | -122.404314158491 | (37.7678373720049, -122.404314158491) | ||||
| 81359 | 81359 | 112751 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 135X TRENTON ST | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Housing Authority 20 | Private 3 | 3x3 | 6009947.0 | 2118097.0 | 37.796451422722605 | -122.409607037418 | (37.7964514227226, -122.409607037418) | |||
| 81573 | 81573 | 110967 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 2439 WASHINGTON ST | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6003043.0 | 2116458.0 | 37.7915618650441 | -122.43337916182101 | (37.7915618650441, -122.433379161821) | ||||
| 81832 | 81832 | 99266 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 1340 Leavenworth St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6008042.0 | 2117018.0 | 37.7933818247157 | -122.416122311937 | (37.7933818247157, -122.416122311937) |
JSON shape: default, array, newline-delimited
CREATE TABLE "Street_Tree_List" (
"TreeID" INTEGER,
"qLegalStatus" INTEGER,
"qSpecies" INTEGER,
"qAddress" TEXT,
"SiteOrder" INTEGER,
"qSiteInfo" INTEGER,
"PlantType" INTEGER,
"qCaretaker" INTEGER,
"qCareAssistant" INTEGER,
"PlantDate" TEXT,
"DBH" INTEGER,
"PlotSize" TEXT,
"PermitNotes" TEXT,
"XCoord" REAL,
"YCoord" REAL,
"Latitude" REAL,
"Longitude" REAL,
"Location" TEXT
,
FOREIGN KEY ("PlantType") REFERENCES [PlantType](id),
FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id),
FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id),
FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id),
FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id),
FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id));
CREATE INDEX ["Street_Tree_List_PlantType"] ON [Street_Tree_List]("PlantType");
CREATE INDEX ["Street_Tree_List_qCaretaker"] ON [Street_Tree_List]("qCaretaker");
CREATE INDEX ["Street_Tree_List_qSpecies"] ON [Street_Tree_List]("qSpecies");
CREATE INDEX ["Street_Tree_List_qSiteInfo"] ON [Street_Tree_List]("qSiteInfo");
CREATE INDEX ["Street_Tree_List_qCareAssistant"] ON [Street_Tree_List]("qCareAssistant");
CREATE INDEX ["Street_Tree_List_qLegalStatus"] ON [Street_Tree_List]("qLegalStatus");