Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: SiteOrder, qCaretaker, PlotSize
qLegalStatus ✖
| Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3013 | 3013 | 39333 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 0 21st St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/21/1998 12:00:00 AM | Permit Number 40897 | ||||||||
| 5518 | 5518 | 39334 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 0 21st St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/21/1998 12:00:00 AM | Permit Number 40897 | ||||||||
| 6740 | 6740 | 39332 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 0 21st St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/21/1998 12:00:00 AM | Permit Number 40897 | ||||||||
| 14197 | 14197 | 39331 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 0 21st St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/21/1998 12:00:00 AM | Permit Number 40897 | ||||||||
| 18193 | 18193 | 39379 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1354 Natoma St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/21/1998 12:00:00 AM | Permit Number 40920 | 6007143.93712268 | 2107602.08417603 | 37.7674774616365 | -122.41856167807501 | (37.7674774616365, -122.418561678075) | |||
| 19673 | 19673 | 39412 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 401Bldg #8 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/21/1998 12:00:00 AM | Permit Number 40928 | 6004636.26366245 | 2109802.84186708 | 37.773378713416 | -122.427392181999 | (37.773378713416, -122.427392181999) | |||
| 19848 | 19848 | 39350 | Permitted Site 1 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 106 | 378 Capp St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/21/1998 12:00:00 AM | Permit Number 40911 | 6007185.43468518 | 2105114.94243818 | 37.7606506875228 | -122.418241786158 | (37.7606506875228, -122.418241786158) | ||
| 25406 | 25406 | 39287 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2030 Harrison St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/21/1998 12:00:00 AM | 10 | 3x3 | Permit Number 40887 | 6008691.77200643 | 2106524.44270682 | 37.7646055260983 | -122.413131696747 | (37.7646055260983, -122.413131696747) |
| 36450 | 36450 | 39386 | Permitted Site 1 | Liriodendron tulipifera :: Tulip Tree 85 | 2710 Broadway | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/21/1998 12:00:00 AM | 9 | Permit Number 40925 | 6000600.16704 | 2117204.05937 | 37.7934714577907 | -122.441884880082 | (37.7934714577907, -122.441884880082) | ||
| 40240 | 40240 | 39382 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 442 Tehama St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/21/1998 12:00:00 AM | 15 | Permit Number 40924 | 6011028.8433300005 | 2112194.85786 | 37.7803061060932 | -122.40544772953699 | (37.7803061060932, -122.405447729537) | ||
| 44810 | 44810 | 53918 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 3 21st St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/21/1998 12:00:00 AM | Permit Number 40897 | ||||||||
| 49631 | 49631 | 39426 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 395Bldg #9 Buchanan St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/21/1998 12:00:00 AM | Permit Number 40929 | 6004623.83107143 | 2109808.7893301 | 37.773394340542104 | -122.42743561187001 | (37.7733943405421, -122.42743561187) | |||
| 55722 | 55722 | 39388 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 414 28th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/21/1998 12:00:00 AM | Permit Number 40926 | 6003200.97263054 | 2099519.74958744 | 37.745062524724204 | -122.43162276019501 | (37.7450625247242, -122.431622760195) | ||
| 56659 | 56659 | 39383 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 442 Tehama St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/21/1998 12:00:00 AM | 11 | Permit Number 40924 | 6011035.938999999 | 2112201.64162 | 37.7803251294514 | -122.405423660089 | (37.7803251294514, -122.405423660089) | |
| 62368 | 62368 | 39387 | Permitted Site 1 | Liriodendron tulipifera :: Tulip Tree 85 | 2710 Broadway | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/21/1998 12:00:00 AM | 7 | Permit Number 40925 | 6000579.41048 | 2117201.67826 | 37.7934637371134 | -122.44195652817899 | (37.7934637371134, -122.441956528179) | ||
| 77776 | 77776 | 39397 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 1690 Church St | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/21/1998 12:00:00 AM | Permit Number 40927 | 6004593.43741133 | 2099046.93821221 | 37.74384312179429 | -122.42677419677099 | (37.7438431217943, -122.426774196771) | |||
| 77995 | 77995 | 39425 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 395Bldg #9 Buchanan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/21/1998 12:00:00 AM | Permit Number 40929 | 6004623.83107143 | 2109808.7893301 | 37.773394340542104 | -122.42743561187001 | (37.7733943405421, -122.42743561187) | |||
| 78286 | 78286 | 39355 | Permitted Site 1 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 106 | 395 Capp St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/21/1998 12:00:00 AM | Permit Number 40913 | 6007242.31720481 | 2105028.26051266 | 37.7604158807224 | -122.41803890956699 | (37.7604158807224, -122.418038909567) | ||
| 78520 | 78520 | 39295 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 399X Treat Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/21/1998 12:00:00 AM | 8 | 3x3 | Permit Number 40887 | 6008691.77200643 | 2106524.44270682 | 37.7646055260983 | -122.413131696747 | (37.7646055260983, -122.413131696747) |
| 78898 | 78898 | 39438 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 350Bldg #15 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/21/1998 12:00:00 AM | Permit Number 40931 | 6004450.98112316 | 2109482.57981657 | 37.772488871091 | -122.428010274079 | (37.772488871091, -122.428010274079) | |||
| 79546 | 79546 | 39440 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 350Bldg #15 Haight St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/21/1998 12:00:00 AM | Permit Number 40931 | 6004450.98112316 | 2109482.57981657 | 37.772488871091 | -122.428010274079 | (37.772488871091, -122.428010274079) | |||
| 80592 | 80592 | 39276 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2030 Harrison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/21/1998 12:00:00 AM | 10 | 3x3 | Permit Number 40887 | 6008691.77200643 | 2106524.44270682 | 37.7646055260983 | -122.413131696747 | (37.7646055260983, -122.413131696747) |
| 80777 | 80777 | 39319 | Permitted Site 1 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 106 | 3349 18th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/21/1998 12:00:00 AM | Permit Number 40894 | 6007178.22711975 | 2105544.00184257 | 37.7618283793101 | -122.41829713555201 | (37.7618283793101, -122.418297135552) | ||
| 81138 | 81138 | 39434 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 350Bldg #15 Haight St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/21/1998 12:00:00 AM | Permit Number 40931 | 6004450.98112316 | 2109482.57981657 | 37.772488871091 | -122.428010274079 | (37.772488871091, -122.428010274079) | |||
| 81563 | 81563 | 39343 | Permitted Site 1 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 106 | 326 Capp St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/21/1998 12:00:00 AM | Permit Number 40906 | 6007169.30768554 | 2105406.00808539 | 37.7614489784433 | -122.418318199964 | (37.7614489784433, -122.418318199964) | ||
| 83126 | 83126 | 39349 | Permitted Site 1 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 106 | 367 Capp St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/21/1998 12:00:00 AM | Permit Number 40910 | 6007233.63343604 | 2105184.98816402 | 37.7608457297745 | -122.41808005395399 | (37.7608457297745, -122.418080053954) | ||
| 83487 | 83487 | 35780 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 3590X 17th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/21/1998 12:00:00 AM | 10 | 3x3 | Permit Number 40916 | 6004935.16103629 | 2106049.50977672 | 37.763089865827 | -122.426091003679 | (37.763089865827, -122.426091003679) |
| 83740 | 83740 | 39338 | Permitted Site 1 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 106 | 315 Capp St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/21/1998 12:00:00 AM | Permit Number 40903 | 6007217.50643554 | 2105476.05382693 | 37.761644020816 | -122.418156466227 | (37.761644020816, -122.418156466227) | ||
| 83948 | 83948 | 39357 | Permitted Site 1 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 106 | 396 Capp St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/21/1998 12:00:00 AM | Permit Number 40914 | 6007191.01710862 | 2105014.18893606 | 37.7603743559888 | -122.418215335605 | (37.7603743559888, -122.418215335605) | |||
| 83998 | 83998 | 39430 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 350Bldg #15 Haight St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/21/1998 12:00:00 AM | Permit Number 40931 | 6004450.98112316 | 2109482.57981657 | 37.772488871091 | -122.428010274079 | (37.772488871091, -122.428010274079) | |||
| 85043 | 85043 | 39414 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 401Bldg #8 Page St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/21/1998 12:00:00 AM | Permit Number 40928 | 6004636.26366245 | 2109802.84186708 | 37.773378713416 | -122.427392181999 | (37.773378713416, -122.427392181999) | |||
| 85593 | 85593 | 39431 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 350Bldg #15 Haight St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/21/1998 12:00:00 AM | Permit Number 40931 | 6004450.98112316 | 2109482.57981657 | 37.772488871091 | -122.428010274079 | (37.772488871091, -122.428010274079) | |||
| 86325 | 86325 | 39342 | Permitted Site 1 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 106 | 325 Capp St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/21/1998 12:00:00 AM | Permit Number 40905 | 6007220.60778173 | 2105420.07966199 | 37.7614905033232 | -122.418141771432 | (37.7614905033232, -122.418141771432) | ||
| 86338 | 86338 | 39411 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 401Bldg #8 Page St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/21/1998 12:00:00 AM | Permit Number 40928 | 6004636.26366245 | 2109802.84186708 | 37.773378713416 | -122.427392181999 | (37.773378713416, -122.427392181999) | |||
| 86560 | 86560 | 39325 | Permitted Site 1 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 0 20th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/21/1998 12:00:00 AM | Permit Number 40896 | 6017074.59942826 | 2104815.9109509 | 37.7603812969624 | -122.38401847505399 | (37.7603812969624, -122.384018475054) | |||
| 87565 | 87565 | 39367 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 2477 Folsom St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/21/1998 12:00:00 AM | Permit Number 40918 | 6008248.39653418 | 2104014.21566983 | 37.757688119307204 | -122.414487579835 | (37.7576881193072, -122.414487579835) | |||
| 88073 | 88073 | 39300 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 399X Treat Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/21/1998 12:00:00 AM | 8 | 3x3 | Permit Number 40887 | 6008691.77200643 | 2106524.44270682 | 37.7646055260983 | -122.413131696747 | (37.7646055260983, -122.413131696747) |
| 88410 | 88410 | 39375 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 2477 Folsom St | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/21/1998 12:00:00 AM | Permit Number 40918 | 6008248.39653418 | 2104014.21566983 | 37.757688119307204 | -122.414487579835 | (37.7576881193072, -122.414487579835) | |||
| 89431 | 89431 | 39354 | Permitted Site 1 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 106 | 395 Capp St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/21/1998 12:00:00 AM | Permit Number 40913 | 6007242.31720481 | 2105028.26051266 | 37.7604158807224 | -122.41803890956699 | (37.7604158807224, -122.418038909567) | ||
| 90027 | 90027 | 39370 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 2477 Folsom St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/21/1998 12:00:00 AM | Permit Number 40918 | 6008248.39653418 | 2104014.21566983 | 37.757688119307204 | -122.414487579835 | (37.7576881193072, -122.414487579835) | |||
| 90548 | 90548 | 39302 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 399X Treat Ave | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/21/1998 12:00:00 AM | 8 | 3x3 | Permit Number 40887 | 6008691.77200643 | 2106524.44270682 | 37.7646055260983 | -122.413131696747 | (37.7646055260983, -122.413131696747) |
| 90944 | 90944 | 39285 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2030 Harrison St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/21/1998 12:00:00 AM | 10 | 3x3 | Permit Number 40887 | 6008691.77200643 | 2106524.44270682 | 37.7646055260983 | -122.413131696747 | (37.7646055260983, -122.413131696747) |
| 91698 | 91698 | 39407 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 401Bldg #8 Page St | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/21/1998 12:00:00 AM | Permit Number 40928 | 6004636.26366245 | 2109802.84186708 | 37.773378713416 | -122.427392181999 | (37.773378713416, -122.427392181999) | |||
| 92743 | 92743 | 39435 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 350Bldg #15 Haight St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/21/1998 12:00:00 AM | Permit Number 40931 | 6004450.98112316 | 2109482.57981657 | 37.772488871091 | -122.428010274079 | (37.772488871091, -122.428010274079) | |||
| 93235 | 93235 | 39279 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2030 Harrison St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/21/1998 12:00:00 AM | 10 | 3x3 | Permit Number 40887 | 6008691.77200643 | 2106524.44270682 | 37.7646055260983 | -122.413131696747 | (37.7646055260983, -122.413131696747) |
| 93560 | 93560 | 39422 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 395Bldg #9 Buchanan St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/21/1998 12:00:00 AM | Permit Number 40929 | 6004623.83107143 | 2109808.7893301 | 37.773394340542104 | -122.42743561187001 | (37.7733943405421, -122.42743561187) | |||
| 93648 | 93648 | 39305 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 399X Treat Ave | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/21/1998 12:00:00 AM | 8 | 3x3 | Permit Number 40887 | 6008691.77200643 | 2106524.44270682 | 37.7646055260983 | -122.413131696747 | (37.7646055260983, -122.413131696747) |
| 93650 | 93650 | 39320 | Permitted Site 1 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 106 | 3349 18th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/21/1998 12:00:00 AM | Permit Number 40894 | 6007178.22711975 | 2105544.00184257 | 37.7618283793101 | -122.41829713555201 | (37.7618283793101, -122.418297135552) | |||
| 93897 | 93897 | 39347 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 342 Capp St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/21/1998 12:00:00 AM | Permit Number 40909 | 6007174.26983946 | 2105316.44942149 | 37.761203350475995 | -122.41829468784799 | (37.761203350476, -122.418294687848) | ||
| 94694 | 94694 | 39293 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 399X Treat Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/21/1998 12:00:00 AM | 8 | 3x3 | Permit Number 40887 | 6008691.77200643 | 2106524.44270682 | 37.7646055260983 | -122.413131696747 | (37.7646055260983, -122.413131696747) |
| 94945 | 94945 | 39297 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 399X Treat Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/21/1998 12:00:00 AM | 9 | 3x3 | Permit Number 40887 | 6008691.77200643 | 2106524.44270682 | 37.7646055260983 | -122.413131696747 | (37.7646055260983, -122.413131696747) |
| 95319 | 95319 | 39406 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 401Bldg #8 Page St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/21/1998 12:00:00 AM | Permit Number 40928 | 6004636.26366245 | 2109802.84186708 | 37.773378713416 | -122.427392181999 | (37.773378713416, -122.427392181999) | |||
| 95401 | 95401 | 39442 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 345Bldg #14 Buchanan St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/21/1998 12:00:00 AM | Permit Number 40932 | 6004648.604089499 | 2109642.10979232 | 37.7729380801911 | -122.427338042649 | (37.7729380801911, -122.427338042649) | |||
| 96349 | 96349 | 39303 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 399X Treat Ave | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/21/1998 12:00:00 AM | 8 | 3x3 | Permit Number 40887 | 6008691.77200643 | 2106524.44270682 | 37.7646055260983 | -122.413131696747 | (37.7646055260983, -122.413131696747) |
| 96606 | 96606 | 39362 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 2433 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/21/1998 12:00:00 AM | Permit Number 40917 | 6008235.29946712 | 2104260.15851816 | 37.7583626864034 | -122.41455027836001 | (37.7583626864034, -122.41455027836) | ||
| 96803 | 96803 | 39306 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 399X Treat Ave | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/21/1998 12:00:00 AM | 8 | 3x3 | Permit Number 40887 | 6008691.77200643 | 2106524.44270682 | 37.7646055260983 | -122.413131696747 | (37.7646055260983, -122.413131696747) |
| 97402 | 97402 | 39419 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 401Bldg #8 Page St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/21/1998 12:00:00 AM | Permit Number 40928 | 6004636.26366245 | 2109802.84186708 | 37.773378713416 | -122.427392181999 | (37.773378713416, -122.427392181999) | |||
| 98306 | 98306 | 38287 | Permitted Site 1 | Magnolia doltsopa :: Himalayan Magnolia 187 | 32 Adair St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/21/1998 12:00:00 AM | Permit Number 40900 | 6007321.94599403 | 2106988.23094143 | 37.765801984592 | -122.417902448639 | (37.765801984592, -122.417902448639) | ||
| 99324 | 99324 | 4269 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 4199X Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/21/1998 12:00:00 AM | 3 | 3X3 | 6002633.0419403 | 2100321.340364 | 37.74723129761279 | -122.43364383962499 | (37.7472312976128, -122.433643839625) | ||
| 99645 | 99645 | 39416 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 401Bldg #8 Page St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/21/1998 12:00:00 AM | Permit Number 40928 | 6004636.26366245 | 2109802.84186708 | 37.773378713416 | -122.427392181999 | (37.773378713416, -122.427392181999) | |||
| 101127 | 101127 | 39321 | Permitted Site 1 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 106 | 3349 18th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/21/1998 12:00:00 AM | Permit Number 40894 | 6007178.22711975 | 2105544.00184257 | 37.7618283793101 | -122.41829713555201 | (37.7618283793101, -122.418297135552) | ||
| 101250 | 101250 | 39393 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 1690 Church St | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/21/1998 12:00:00 AM | Permit Number 40927 | 6004593.43741133 | 2099046.93821221 | 37.74384312179429 | -122.42677419677099 | (37.7438431217943, -122.426774196771) | |||
| 102096 | 102096 | 39292 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 399X Treat Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/21/1998 12:00:00 AM | 8 | 3x3 | Permit Number 40887 | 6008691.77200643 | 2106524.44270682 | 37.7646055260983 | -122.413131696747 | (37.7646055260983, -122.413131696747) |
| 102254 | 102254 | 39415 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 401Bldg #8 Page St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/21/1998 12:00:00 AM | Permit Number 40928 | 6004636.26366245 | 2109802.84186708 | 37.773378713416 | -122.427392181999 | (37.773378713416, -122.427392181999) | |||
| 102401 | 102401 | 39314 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 3248 17th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/21/1998 12:00:00 AM | Permit Number 40892 | 6007145.08024569 | 2106178.91659474 | 37.7635698413851 | -122.418456799551 | (37.7635698413851, -122.418456799551) | ||
| 102418 | 102418 | 39405 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 1690 Church St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/21/1998 12:00:00 AM | Permit Number 40927 | 6004593.43741133 | 2099046.93821221 | 37.74384312179429 | -122.42677419677099 | (37.7438431217943, -122.426774196771) | |||
| 102682 | 102682 | 39318 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 3344 18th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/21/1998 12:00:00 AM | Permit Number 40893 | 6007219.04940289 | 2105598.34676892 | 37.7619798956613 | -122.418159800155 | (37.7619798956613, -122.418159800155) | ||
| 103088 | 103088 | 39281 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2030 Harrison St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/21/1998 12:00:00 AM | 10 | 3x3 | Permit Number 40887 | 6008691.77200643 | 2106524.44270682 | 37.7646055260983 | -122.413131696747 | (37.7646055260983, -122.413131696747) |
| 103166 | 103166 | 39364 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 2477 Folsom St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/21/1998 12:00:00 AM | Permit Number 40918 | 6008248.39653418 | 2104014.21566983 | 37.757688119307204 | -122.414487579835 | (37.7576881193072, -122.414487579835) | |||
| 103260 | 103260 | 39309 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 399X Treat Ave | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/21/1998 12:00:00 AM | 10 | 3x3 | Permit Number 40887 | 6008691.77200643 | 2106524.44270682 | 37.7646055260983 | -122.413131696747 | (37.7646055260983, -122.413131696747) |
| 103269 | 103269 | 39283 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2030 Harrison St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/21/1998 12:00:00 AM | 10 | 3x3 | Permit Number 40887 | 6008691.77200643 | 2106524.44270682 | 37.7646055260983 | -122.413131696747 | (37.7646055260983, -122.413131696747) |
| 104016 | 104016 | 39369 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 2477 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/21/1998 12:00:00 AM | Permit Number 40918 | 6008248.39653418 | 2104014.21566983 | 37.757688119307204 | -122.414487579835 | (37.7576881193072, -122.414487579835) | ||
| 104181 | 104181 | 39348 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 342 Capp St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/21/1998 12:00:00 AM | Permit Number 40909 | 6007174.26983946 | 2105316.44942149 | 37.761203350475995 | -122.41829468784799 | (37.761203350476, -122.418294687848) | |||
| 104423 | 104423 | 39360 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 411 Capp St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/21/1998 12:00:00 AM | Permit Number 40915 | 6007248.60489953 | 2104914.77803867 | 37.760104638015896 | -122.41800911826799 | (37.7601046380159, -122.418009118268) | ||
| 104851 | 104851 | 39376 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 2477 Folsom St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/21/1998 12:00:00 AM | Permit Number 40918 | 6008248.39653418 | 2104014.21566983 | 37.757688119307204 | -122.414487579835 | (37.7576881193072, -122.414487579835) | |||
| 104861 | 104861 | 39443 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 345Bldg #14 Buchanan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/21/1998 12:00:00 AM | Permit Number 40932 | 6004648.604089499 | 2109642.10979232 | 37.7729380801911 | -122.427338042649 | (37.7729380801911, -122.427338042649) | |||
| 104913 | 104913 | 39282 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2030 Harrison St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/21/1998 12:00:00 AM | 10 | 3x3 | Permit Number 40887 | 6008691.77200643 | 2106524.44270682 | 37.7646055260983 | -122.413131696747 | (37.7646055260983, -122.413131696747) |
| 105130 | 105130 | 39444 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 345Bldg #14 Buchanan St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/21/1998 12:00:00 AM | Permit Number 40932 | 6004648.604089499 | 2109642.10979232 | 37.7729380801911 | -122.427338042649 | (37.7729380801911, -122.427338042649) | |||
| 105774 | 105774 | 39286 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 399X Treat Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/21/1998 12:00:00 AM | 8 | 3x3 | Permit Number 40887 | 6008691.77200643 | 2106524.44270682 | 37.7646055260983 | -122.413131696747 | (37.7646055260983, -122.413131696747) |
| 105898 | 105898 | 39363 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 2477 Folsom St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/21/1998 12:00:00 AM | Permit Number 40918 | 6008248.39653418 | 2104014.21566983 | 37.757688119307204 | -122.414487579835 | (37.7576881193072, -122.414487579835) | |||
| 106038 | 106038 | 39328 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 0 20th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/21/1998 12:00:00 AM | Permit Number 40896 | 6017074.59942826 | 2104815.9109509 | 37.7603812969624 | -122.38401847505399 | (37.7603812969624, -122.384018475054) | |||
| 107349 | 107349 | 34197 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 15 Woodward St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/21/1998 12:00:00 AM | Permit Number 40888 | 6006506.82888523 | 2108404.56366519 | 37.76964499140821 | -122.42082233238001 | (37.7696449914082, -122.42082233238) | ||
| 107423 | 107423 | 39436 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 350Bldg #15 Haight St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/21/1998 12:00:00 AM | Permit Number 40931 | 6004450.98112316 | 2109482.57981657 | 37.772488871091 | -122.428010274079 | (37.772488871091, -122.428010274079) | |||
| 107879 | 107879 | 39417 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 401Bldg #8 Page St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/21/1998 12:00:00 AM | Permit Number 40928 | 6004636.26366245 | 2109802.84186708 | 37.773378713416 | -122.427392181999 | (37.773378713416, -122.427392181999) | |||
| 108002 | 108002 | 39398 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 1690 Church St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/21/1998 12:00:00 AM | Permit Number 40927 | 6004593.43741133 | 2099046.93821221 | 37.74384312179429 | -122.42677419677099 | (37.7438431217943, -122.426774196771) | |||
| 108214 | 108214 | 39353 | Permitted Site 1 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 106 | 395 Capp St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/21/1998 12:00:00 AM | Permit Number 40913 | 6007242.31720481 | 2105028.26051266 | 37.7604158807224 | -122.41803890956699 | (37.7604158807224, -122.418038909567) | ||
| 108254 | 108254 | 39395 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 1690 Church St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/21/1998 12:00:00 AM | Permit Number 40927 | 6004593.43741133 | 2099046.93821221 | 37.74384312179429 | -122.42677419677099 | (37.7438431217943, -122.426774196771) | |||
| 109158 | 109158 | 39368 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 2477 Folsom St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/21/1998 12:00:00 AM | Permit Number 40918 | 6008248.39653418 | 2104014.21566983 | 37.757688119307204 | -122.414487579835 | (37.7576881193072, -122.414487579835) | |||
| 110043 | 110043 | 39345 | Permitted Site 1 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 106 | 331 Capp St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/21/1998 12:00:00 AM | Permit Number 40907 | 6007222.46858974 | 2105386.4951577997 | 37.7613983928103 | -122.418132954582 | (37.7613983928103, -122.418132954582) | ||
| 110131 | 110131 | 39344 | Permitted Site 1 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 106 | 331 Capp St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/21/1998 12:00:00 AM | Permit Number 40907 | 6007222.46858974 | 2105386.4951577997 | 37.7613983928103 | -122.418132954582 | (37.7613983928103, -122.418132954582) | ||
| 110232 | 110232 | 39298 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 399X Treat Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/21/1998 12:00:00 AM | 8 | 3x3 | Permit Number 40887 | 6008691.77200643 | 2106524.44270682 | 37.7646055260983 | -122.413131696747 | (37.7646055260983, -122.413131696747) |
| 110542 | 110542 | 39433 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 350Bldg #15 Haight St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/21/1998 12:00:00 AM | Permit Number 40931 | 6004450.98112316 | 2109482.57981657 | 37.772488871091 | -122.428010274079 | (37.772488871091, -122.428010274079) | |||
| 111023 | 111023 | 39352 | Permitted Site 1 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 106 | 395 Capp St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/21/1998 12:00:00 AM | Permit Number 40913 | 6007242.31720481 | 2105028.26051266 | 37.7604158807224 | -122.41803890956699 | (37.7604158807224, -122.418038909567) | ||
| 111139 | 111139 | 39421 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 395Bldg #9 Buchanan St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/21/1998 12:00:00 AM | Permit Number 40929 | 6004623.83107143 | 2109808.7893301 | 37.773394340542104 | -122.42743561187001 | (37.7733943405421, -122.42743561187) | |||
| 111708 | 111708 | 39371 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 2477 Folsom St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/21/1998 12:00:00 AM | Permit Number 40918 | 6008248.39653418 | 2104014.21566983 | 37.757688119307204 | -122.414487579835 | (37.7576881193072, -122.414487579835) | |||
| 111712 | 111712 | 39291 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2030 Harrison St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/21/1998 12:00:00 AM | 10 | 3x3 | Permit Number 40887 | 6008691.77200643 | 2106524.44270682 | 37.7646055260983 | -122.413131696747 | (37.7646055260983, -122.413131696747) |
| 111895 | 111895 | 39294 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 399X Treat Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/21/1998 12:00:00 AM | 8 | 3x3 | Permit Number 40887 | 6008691.77200643 | 2106524.44270682 | 37.7646055260983 | -122.413131696747 | (37.7646055260983, -122.413131696747) |
| 112217 | 112217 | 39308 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 399X Treat Ave | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/21/1998 12:00:00 AM | 8 | 3x3 | Permit Number 40887 | 6008691.77200643 | 2106524.44270682 | 37.7646055260983 | -122.413131696747 | (37.7646055260983, -122.413131696747) |
| 113300 | 113300 | 39340 | Permitted Site 1 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 106 | 319 Capp St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/21/1998 12:00:00 AM | Permit Number 40904 | 6007218.7469743 | 2105453.66415572 | 37.7615826138052 | -122.4181505883 | (37.7615826138052, -122.4181505883) | ||
| 113395 | 113395 | 39373 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 2477 Folsom St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/21/1998 12:00:00 AM | Permit Number 40918 | 6008248.39653418 | 2104014.21566983 | 37.757688119307204 | -122.414487579835 | (37.7576881193072, -122.414487579835) |
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");