Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, qCareAssistant, DBH, PlotSize
| Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2585 | 2585 | 6246 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 1280 Ellis St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6004721.4422 | 2113335.3655 | 37.7830829720913 | -122.427349228935 | (37.7830829720913, -122.427349228935) | |||
| 4536 | 4536 | 253202 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 800 Oak St | 4 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | Private 3 | 6x6 | 6003064.0 | 2109976.0 | 37.77376511482 | -122.43284323125299 | (37.77376511482, -122.432843231253) | |||
| 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) | ||||
| 6433 | 6433 | 13039 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 515-519 Lombard St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6009909.1781 | 2120541.7464 | 37.8031619752733 | -122.409910575369 | (37.8031619752733, -122.409910575369) | |||
| 8669 | 8669 | 21630 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 1615 Sutter St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/23/1990 12:00:00 AM | 6 | 4X4 | 6004701.1521 | 2114671.0024 | 37.786749150584996 | -122.427514608894 | (37.786749150585, -122.427514608894) | ||
| 9040 | 9040 | 173594 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 75 Howard St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6015060.0 | 2116254.0 | 37.7916761533754 | -122.391785881413 | (37.7916761533754, -122.391785881413) | ||||
| 10252 | 10252 | 173934 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 614 Alabama St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9x9 | 6008960.61704517 | 2105361.82717089 | 37.7614283394777 | -122.41211965835899 | (37.7614283394777, -122.412119658359) | ||||
| 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) | |||
| 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) | ||||
| 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) | ||||
| 44837 | 44837 | 95043 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 3224 Pierce St | 4 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW for City Agency 10 | 9 | 3x3 | 6001388.0 | 2119447.0 | 37.79967484547421 | -122.43931976889999 | (37.7996748454742, -122.4393197689) | |||
| 51311 | 51311 | 110985 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 245x North Point St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6009556.06624176 | 2121873.83782792 | 37.806799769840296 | -122.41122668881 | (37.8067997698403, -122.41122668881) | |||||
| 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) | |||||
| 77387 | 77387 | 109858 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 2455 03RD ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 15 | 5x8 | 6015836.2 | 2104173.0 | 37.7585474584562 | -122.388256691115 | (37.7585474584562, -122.388256691115) | |||
| 78224 | 78224 | 7218 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 1000X Fillmore St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6003426.09434 | 2111753.60864 | 37.778666518442 | -122.43171763216101 | (37.778666518442, -122.431717632161) | |||
| 78415 | 78415 | 116510 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 1500x Waller St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5998488.0 | 2108327.0 | 37.7689767823615 | -122.448553488995 | (37.7689767823615, -122.448553488995) | ||||
| 78462 | 78462 | 108945 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 105 Richland Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6005294.9 | 2096235.5 | 37.7361631827636 | -122.424148798432 | (37.7361631827636, -122.424148798432) | |||||
| 80196 | 80196 | 120531 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 1390 Waller St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5999052.33988667 | 2108383.59508746 | 37.7691644298026 | -122.446605553634 | (37.7691644298026, -122.446605553634) | ||||
| 80256 | 80256 | 668 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 3297X 24th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4x4 | 6007079.62061 | 2102029.84762 | 37.752173770171794 | -122.418388996947 | (37.7521737701718, -122.418388996947) | |||
| 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) | ||||
| 81530 | 81530 | 25702 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 550 06th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 20 | 3X3 | 6012081.78675 | 2110335.7627 | 37.7752602760543 | -122.40167438060301 | (37.7752602760543, -122.401674380603) | |||
| 82448 | 82448 | 20124 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 924X Fell St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6002999.41967 | 2110319.2516799998 | 37.7747039360019 | -122.433091154251 | (37.7747039360019, -122.433091154251) | |||
| 83244 | 83244 | 110731 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 3515 25TH ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6006381.0 | 2101411.0 | 37.7504352040325 | -122.42076100913799 | (37.7504352040325, -122.420761009138) | ||||
| 83454 | 83454 | 112162 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 1324 18th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6013680.97327942 | 2105726.70860795 | 37.7626939483281 | -122.39581935837 | (37.7626939483281, -122.39581935837) | ||||
| 83892 | 83892 | 9617 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 1050X Steiner St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 4X4 | 6002921.99888 | 2111973.13636 | 37.7792406996886 | -122.433477183837 | (37.7792406996886, -122.433477183837) | |||
| 84598 | 84598 | 95554 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 1333@ Larkin Bush St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6007121.0 | 2115358.0 | 37.7887720478953 | -122.419191239667 | (37.7887720478953, -122.419191239667) | |||||
| 84916 | 84916 | 44061 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 2700 Pierce St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/19/2000 12:00:00 AM | Permit Number 43588 | 6001640.58397077 | 2117683.20689336 | 37.7948463022786 | -122.43831930796699 | (37.7948463022786, -122.438319307967) | |||
| 86101 | 86101 | 13193 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 2095 Lombard St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6002451.4681 | 2119463.3271 | 37.7997801365268 | -122.43564095454701 | (37.7997801365268, -122.435640954547) | |||
| 86403 | 86403 | 99615 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 3233X Buchanan St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6003300.0 | 2119605.0 | 37.800217292537106 | -122.432714848025 | (37.8002172925371, -122.432714848025) | |||
| 86419 | 86419 | 102457 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 3365 20th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 6007790.0 | 2104415.0 | 37.7587628183764 | -122.416101290754 | (37.7587628183764, -122.416101290754) | |||
| 86513 | 86513 | 50374 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 2727 Pierce St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 47038 | 6001577.22511674 | 2117761.13132823 | 37.795056658547395 | -122.43854412401001 | (37.7950566585474, -122.43854412401) | ||||
| 86610 | 86610 | 20161 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 1150X Steiner St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Police Dept 18 | 18 | 4X4 | 6002889.1141449995 | 2112192.1807580004 | 37.779840274990796 | -122.433606604391 | (37.7798402749908, -122.433606604391) | |||
| 87402 | 87402 | 32646 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 379 TEHAMA ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/23/1996 12:00:00 AM | 8 | Permit Number 37086 | 6011447.0 | 2112547.0 | 37.7812963779039 | -122.404025912764 | (37.7812963779039, -122.404025912764) | |
| 88292 | 88292 | 111391 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 298x CLINTON PARK | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6004911.0 | 2108307.0 | 37.7692870280045 | -122.42633530742799 | (37.7692870280045, -122.426335307428) | ||||
| 88637 | 88637 | 5386 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 325X Dolores St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 90 | 3X3 | 6004919.4864142 | 2106495.5645768 | 37.7643137401636 | -122.426176974515 | (37.7643137401636, -122.426176974515) | |||
| 89957 | 89957 | 113573 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 901 LOMBARD ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 3x3 | 6007813.0 | 2120272.0 | 37.802303618634795 | -122.417145352251 | (37.8023036186348, -122.417145352251) | |||
| 90591 | 90591 | 24452 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 1384 Valencia St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3X3 | 6006362.58284 | 2101545.07315 | 37.750802300176396 | -122.42083421458901 | (37.7508023001764, -122.420834214589) | |||
| 90806 | 90806 | 4728 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 1075 Columbus Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 30 | 3X3 | 6008196.257 | 2120907.2939400002 | 37.8040695291651 | -122.41586410452 | (37.8040695291651, -122.41586410452) | |||
| 91756 | 91756 | 20116 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 800X OAK ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6002934.0 | 2109937.0 | 37.773650656395205 | -122.43329013413602 | (37.7736506563952, -122.433290134136) | |||
| 91787 | 91787 | 112109 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 699x COLUMBUS AVE | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6009471.0 | 2119722.0 | 37.8008865881446 | -122.411368963081 | (37.8008865881446, -122.411368963081) | |||
| 92051 | 92051 | 9576 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 1290X Golden Gate Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6003446.27659 | 2112118.33325 | 37.7796691054144 | -122.43167386069901 | (37.7796691054144, -122.431673860699) | |||
| 92983 | 92983 | 116128 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 2500X Keith St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6014198.52795 | 2092093.45262 | 37.7252886606488 | -122.39307534923799 | (37.7252886606488, -122.393075349238) | |||||
| 93406 | 93406 | 7211 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 1225X McAllister St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6003292.0475526 | 2111699.2584619997 | 37.7785096871743 | -122.43217746912701 | (37.7785096871743, -122.432177469127) | |||
| 93675 | 93675 | 103631 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 1450X Stevenson St | 4 | 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) | ||
| 94374 | 94374 | 49264 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 2X Spear St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/07/2003 12:00:00 AM | Permit Number 46305 | 6014371.0 | 2116872.0 | 37.7933347653256 | -122.394213120763 | (37.7933347653256, -122.394213120763) | |||
| 94766 | 94766 | 4593 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 100 Columbus Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 90 | 3X3 | 6011460.12974 | 2118136.30046 | 37.7966440043551 | -122.40437402195299 | (37.7966440043551, -122.404374021953) | |||
| 96878 | 96878 | 114284 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 200X STEUART ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6015060.0 | 2116254.0 | 37.7916761533754 | -122.391785881413 | (37.7916761533754, -122.391785881413) | ||||
| 98818 | 98818 | 115746 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 1X POND ST | 4 | 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) | ||
| 99494 | 99494 | 102601 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 88 Spear St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | 3x3 | 6014255.3 | 2116583.4 | 37.7925359054466 | -122.394593235194 | (37.7925359054466, -122.394593235194) | |||
| 99557 | 99557 | 111210 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 601X 09TH ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6010680.0 | 2108566.0 | 37.7703225929477 | -122.406398777104 | (37.7703225929477, -122.406398777104) | ||||
| 100176 | 100176 | 17014 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 1001 Oak St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6002208.6674 | 2109818.8585900003 | 37.773285094559895 | -122.43579071263001 | (37.7732850945599, -122.43579071263) | |||
| 100818 | 100818 | 87145 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 2405 Folsom St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/18/2008 12:00:00 AM | 3x3 | Permit Number 50131 | 6008226.0 | 2104427.0 | 37.7588202724984 | -122.414594246502 | (37.7588202724984, -122.414594246502) | ||
| 100865 | 100865 | 94300 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 1150X Fillmore St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Rec/Park 7 | 6x6 | 6003451.3 | 2112195.3 | 37.7798807216656 | -122.431661979156 | (37.7798807216656, -122.431661979156) | |||
| 101186 | 101186 | 9077 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 5618 Geary Blvd | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 5989554.31102 | 2112758.21214 | 37.7806288074212 | -122.479778486374 | (37.7806288074212, -122.479778486374) | |||
| 101284 | 101284 | 110726 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 3514 25TH ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6006378.0 | 2101471.0 | 37.7505997812246 | -122.42077564246901 | (37.7505997812246, -122.420775642469) | ||||
| 101340 | 101340 | 101761 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 45X 11th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 6007389.6 | 2110351.2 | 37.7750397101602 | -122.41790686002899 | (37.7750397101602, -122.417906860029) | |||
| 101441 | 101441 | 112750 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 135X TRENTON ST | 4 | 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) | |||
| 102449 | 102449 | 120147 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 1X Hyde St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6008026.0 | 2111839.0 | 37.77916064960021 | -122.41581078056299 | (37.7791606496002, -122.415810780563) | ||||
| 102677 | 102677 | 109882 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 1520 PAGE ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6x8 | 5999172.7 | 2109108.7 | 37.7711622584795 | -122.44624140323401 | (37.7711622584795, -122.446241403234) | ||||
| 102869 | 102869 | 9944 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 601X Green St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 80 | 3X3 | 6010102.57699 | 2119179.9289599997 | 37.79943359716321 | -122.40914515871701 | (37.7994335971632, -122.409145158717) | |||
| 103375 | 103375 | 10713 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 17X Hollis St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 4X4 | 6003918.21533 | 2113256.44585 | 37.7828208186367 | -122.430122434181 | (37.7828208186367, -122.430122434181) | |||
| 105308 | 105308 | 25271 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 1800 Ocean Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 2X2 | 5994503.82801 | 2092400.8361900002 | 37.725018937185 | -122.461179802839 | (37.725018937185, -122.461179802839) | |||
| 105378 | 105378 | 112406 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 300x 15TH ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6011264.0 | 2107649.0 | 37.7678373720049 | -122.404314158491 | (37.7678373720049, -122.404314158491) | ||||
| 105428 | 105428 | 17307 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 51X Otis St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3x3 | 6006961.49044 | 2109420.44821 | 37.772459985288 | -122.419321746309 | (37.772459985288, -122.419321746309) | |||
| 106107 | 106107 | 15108 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 110 Mission St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 4X4 | 6014309.51773 | 2116539.1619 | 37.7924174520023 | -122.394402539761 | (37.7924174520023, -122.394402539761) | |||
| 106594 | 106594 | 100483 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 1849 Harrison St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3x3 | 6008683.0 | 2107773.0 | 37.7680332828269 | -122.413250335235 | (37.7680332828269, -122.413250335235) | |||
| 106697 | 106697 | 18412 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 799X Potrero Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 4x4 | 6010481.346466599 | 2104567.7087473 | 37.759333078347105 | -122.406804093165 | (37.7593330783471, -122.406804093165) | |||
| 108234 | 108234 | 648 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 3244X 24th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6007408.30918 | 2102098.45375 | 37.752380644434204 | -122.41725719966401 | (37.7523806444342, -122.417257199664) | |||
| 108840 | 108840 | 108327 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 86 11TH ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6007396.0 | 2110315.0 | 37.77494067377889 | -122.417882154347 | (37.7749406737789, -122.417882154347) | ||||
| 109293 | 109293 | 121120 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 2701X 24th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6010429.0 | 2102109.0 | 37.752579083030895 | -122.406811850318 | (37.7525790830309, -122.406811850318) | ||||
| 109346 | 109346 | 100106 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 461 Jefferson St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6007004.8 | 2122229.7 | 37.807633464576796 | -122.420081138169 | (37.8076334645768, -122.420081138169) | |||||
| 109453 | 109453 | 120140 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 10X Grove St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6007842.0 | 2111812.0 | 37.779076168386105 | -122.41644540073798 | (37.7790761683861, -122.416445400738) | ||||
| 109491 | 109491 | 99267 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 1340 Leavenworth St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6008042.0 | 2117018.0 | 37.7933818247157 | -122.416122311937 | (37.7933818247157, -122.416122311937) | ||||
| 110421 | 110421 | 15252 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 1450X Mission St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6007671.660569999 | 2110183.15551 | 37.7745941699553 | -122.416919239811 | (37.7745941699553, -122.416919239811) | |||
| 110742 | 110742 | 111378 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 2999X Turk St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5996638.0 | 2111487.0 | 37.7775473668867 | -122.455180869531 | (37.7775473668867, -122.455180869531) | ||||
| 110877 | 110877 | 7231 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 1040 Fillmore St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6003407.8759699995 | 2111884.23201 | 37.7790241450036 | -122.431789985507 | (37.7790241450036, -122.431789985507) | |||
| 112372 | 112372 | 15150 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 895X Mission St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Dept of Real Estate 5 | 18 | 3x3 | 6010810.7123748 | 2113108.5528643 | 37.7828026992214 | -122.406266743907 | (37.7828026992214, -122.406266743907) | |||
| 112794 | 112794 | 109003 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 525x BURNETT AVE | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1x1 | 5999530.0 | 2102478.0 | 37.7529764040195 | -122.44452886107901 | (37.7529764040195, -122.444528861079) | ||||
| 112840 | 112840 | 93146 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 1152 Clement St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5991985.0 | 2113459.0 | 37.7826938870859 | -122.47142072749399 | (37.7826938870859, -122.471420727494) | |||||
| 113081 | 113081 | 102620 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 190X Pfeiffer St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | Permit Number 18461 | 6009953.9 | 2121114.8 | 37.8047379445266 | -122.409796287705 | (37.8047379445266, -122.409796287705) | ||
| 113142 | 113142 | 112828 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 101X COLUMBUS AVE | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 8 | 3x3 | 6011274.0 | 2118052.0 | 37.796402132688605 | -122.405012137355 | (37.7964021326886, -122.405012137355) | |||
| 113310 | 113310 | 16999 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 903 Oak St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | 3X3 | 6002647.07822 | 2109875.66562 | 37.77346596610221 | -122.434278253633 | (37.7734659661022, -122.434278253633) | |||
| 113479 | 113479 | 6808 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 1395 Fairfax Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3x3 | 6016583.3780675 | 2097443.6071151 | 37.7401113108781 | -122.385203697211 | (37.7401113108781, -122.385203697211) | |||
| 114282 | 114282 | 26945 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 2040 Sutter St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6002804.14495 | 2114458.42232 | 37.786057981290895 | -122.434062595727 | (37.7860579812909, -122.434062595727) | |||
| 114527 | 114527 | 111593 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 398X BRYANT ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6014483.0 | 2113360.0 | 37.7836978486164 | -122.393579678281 | (37.7836978486164, -122.393579678281) | ||||
| 114695 | 114695 | 21984 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 2585 03rd St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4x9 | 6015885.54141 | 2103557.92781 | 37.7568613347581 | -122.38804312319799 | (37.7568613347581, -122.388043123198) | |||
| 115241 | 115241 | 19373 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 390X 06th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 35 | 4X4 | 6011348.292859999 | 2111104.97037 | 37.7773313845055 | -122.404265868127 | (37.7773313845055, -122.404265868127) | |||
| 116068 | 116068 | 121369 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 11x Seymour St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6001614.0 | 2112138.0 | 37.7796190766925 | -122.438013896478 | (37.7796190766925, -122.438013896478) | ||||
| 117229 | 117229 | 94219 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 246 01st St | 4 | Sidewalk: Property side : Pot 6 | Tree 1 | Private 1 | 06/25/2010 12:00:00 AM | Permit Number 53568 | 6014001.8 | 2114912.7 | 37.7879344554838 | -122.395353268636 | (37.7879344554838, -122.395353268636) | |||
| 117643 | 117643 | 9696 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 414 Gough St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 22 | 3X3 | 6005964.80411 | 2111186.62637 | 37.7772532999259 | -122.42289493403601 | (37.7772532999259, -122.422894934036) | |||
| 120612 | 120612 | 100264 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 40 Federal St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | 3x3 | 6014922.0 | 2113400.9 | 37.7838345339316 | -122.39206375347099 | (37.7838345339316, -122.392063753471) | |||
| 124438 | 124438 | 20242 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 1801X Steiner St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6002529.5506914 | 2114404.1561918 | 37.7858933925245 | -122.435008734319 | (37.7858933925245, -122.435008734319) | |||
| 126681 | 126681 | 10586 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 1050X Harrison St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 75 | 3X3 | 6011036.2882597 | 2110765.2479161 | 37.7763811461579 | -122.40532126913901 | (37.7763811461579, -122.405321269139) | |||
| 127036 | 127036 | 85059 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 2435 03rd St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 4x9 | 6015831.18626 | 2104262.21936 | 37.7587921580004 | -122.388280257816 | (37.7587921580004, -122.388280257816) | |||
| 127284 | 127284 | 111116 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 2085 Hayes St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 5997903.58032533 | 2109906.22418863 | 37.773279493542795 | -122.45068882440701 | (37.7732794935428, -122.450688824407) | ||||
| 127525 | 127525 | 22720 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 1401X Turk St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Police Dept 18 | 18 | 4x4 | 6003306.8488585 | 2112395.4775226 | 37.7804221702729 | -122.43217599894 | (37.7804221702729, -122.43217599894) | |||
| 127627 | 127627 | 23704 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 2119X Gough St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 3X3 | 6005103.6033 | 2116867.2333400003 | 37.7928022043515 | -122.426278644375 | (37.7928022043515, -122.426278644375) | |||
| 128062 | 128062 | 17122 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 1931 Oak St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 5997743.8504099995 | 2109170.01524 | 37.7712489089965 | -122.45118824582701 | (37.7712489089965, -122.451188245827) | |||
| 128221 | 128221 | 115907 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 500x WALLER ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/13/2016 12:00:00 AM | 3 | 4x4 | 6003255.0 | 2109006.0 | 37.7711125644946 | -122.43211324892799 | (37.7711125644946, -122.432113248928) | ||
| 138615 | 138615 | 105657 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 901X Lombard St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | SFUSD 6 | 6007813.035080001 | 2120272.8882299997 | 37.8023060594642 | -122.417145293832 | (37.8023060594642, -122.417145293832) |
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");