Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qAddress, SiteOrder, qSiteInfo, PlantDate, DBH, PlotSize, PermitNotes, XCoord, YCoord, Latitude, Longitude, Location
Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
948 | 948 | 251406 | Planning Code 138.1 required 4 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 445 Amazon Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/25/2017 12:00:00 AM | 3 | 3x3 | 6001636.0 | 2088904.0 | 37.7158252789105 | -122.43627456666799 | (37.7158252789105, -122.436274566668) | ||
976 | 976 | 160371 | Planning Code 138.1 required 4 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 868 Edinburgh St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/26/2017 12:00:00 AM | 3 | 3x3 | Permit Number 779314 | 6001686.38396 | 2088939.3945099998 | 37.7159253269669 | -122.43610294800199 | (37.7159253269669, -122.436102948002) | |
991 | 991 | 160369 | Planning Code 138.1 required 4 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 868 Edinburgh St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/26/2017 12:00:00 AM | 3 | 3x3 | Permit Number 779314 | 6001700.06015 | 2088961.7176 | 37.715987398188894 | -122.436057273237 | (37.7159873981889, -122.436057273237) | |
994 | 994 | 160370 | Planning Code 138.1 required 4 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 868 Edinburgh St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/26/2017 12:00:00 AM | 3 | 3x3 | Permit Number 779314 | 6001693.73373 | 2088950.71414 | 37.715956825716 | -122.436078353349 | (37.715956825716, -122.436078353349) | |
2025 | 2025 | 243143 | Planning Code 138.1 required 4 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 98x Eugenia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/16/2017 12:00:00 AM | 3 | 3x3 | 6006195.0 | 2098242.0 | 37.7417233638646 | -122.42117921336501 | (37.7417233638646, -122.421179213365) | ||
2032 | 2032 | 243144 | Planning Code 138.1 required 4 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 98x Eugenia Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/16/2017 12:00:00 AM | 3 | 3x3 | 6006195.0 | 2098242.0 | 37.7417233638646 | -122.42117921336501 | (37.7417233638646, -122.421179213365) | ||
2639 | 2639 | 253101 | Planning Code 138.1 required 4 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 3000x Irving St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/25/2017 12:00:00 AM | 3 | 3x3 | Permit Number 778939 | 5986427.0 | 2106455.0 | 37.7631397866436 | -122.490133427734 | (37.7631397866436, -122.490133427734) | |
2642 | 2642 | 253105 | Planning Code 138.1 required 4 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1295 31st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/25/2017 12:00:00 AM | 3 | 3x3 | Permit Number 778939 | 5986427.0 | 2106455.0 | 37.7631397866436 | -122.490133427734 | (37.7631397866436, -122.490133427734) | |
2663 | 2663 | 253102 | Planning Code 138.1 required 4 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 3000x Irving St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/25/2017 12:00:00 AM | 3 | 3x3 | Permit Number 778939 | 5986427.0 | 2106455.0 | 37.7631397866436 | -122.490133427734 | (37.7631397866436, -122.490133427734) | |
2666 | 2666 | 253103 | Planning Code 138.1 required 4 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 3000x Irving St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/25/2017 12:00:00 AM | 3 | 3x3 | Permit Number 778939 | 5986427.0 | 2106455.0 | 37.7631397866436 | -122.490133427734 | (37.7631397866436, -122.490133427734) | |
2669 | 2669 | 253104 | Planning Code 138.1 required 4 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 3000x Irving St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/25/2017 12:00:00 AM | 3 | 3x3 | Permit Number 778939 | 5986427.0 | 2106455.0 | 37.7631397866436 | -122.490133427734 | (37.7631397866436, -122.490133427734) | |
7909 | 7909 | 115530 | Planning Code 138.1 required 4 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 101 Polk St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/08/2016 12:00:00 AM | 3 | 4x4 | Permit Number 770842 | 6007332.44961 | 2111311.79762 | 37.7776740647351 | -122.418172674243 | (37.7776740647351, -122.418172674243) | |
9723 | 9723 | 173650 | Planning Code 138.1 required 4 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 80 Entrada Ct | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12/21/2016 12:00:00 AM | 3 | 4x10 | 5992424.456569999 | 2092194.59394 | 37.7243327619491 | -122.46835290122299 | (37.7243327619491, -122.468352901223) | ||
9959 | 9959 | 57959 | Planning Code 138.1 required 4 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 336 Hanover St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/13/2017 12:00:00 AM | 3 | 3x3 | Permit Number 774423 | 5999490.29697456 | 2086502.70799744 | 37.7091097236101 | -122.443518692288 | (37.7091097236101, -122.443518692288) | |
10564 | 10564 | 116803 | Planning Code 138.1 required 4 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 931 Silver Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/27/2016 12:00:00 AM | 3 | 3x3 | 6007342.71844 | 2093540.3953900002 | 37.728878425184796 | -122.416877747635 | (37.7288784251848, -122.416877747635) | ||
11604 | 11604 | 116262 | Planning Code 138.1 required 4 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 35 La Grande Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/22/2016 12:00:00 AM | 3 | 3x4 | 6005278.18089 | 2092026.4994299999 | 37.724605255111896 | -122.42390739821998 | (37.7246052551119, -122.42390739822) | ||
13329 | 13329 | 60277 | Planning Code 138.1 required 4 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2690 Harrison St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/03/2008 12:00:00 AM | 3x3 | Permit Number 51145 | 6008898.65774693 | 2102801.94608421 | 37.7543960104367 | -122.41215302657 | (37.7543960104367, -122.41215302657) | ||
22979 | 22979 | 112863 | Planning Code 138.1 required 4 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2451 19TH AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/25/2015 12:00:00 AM | 3 | 3x3 | 5990427.0 | 2098705.0 | 37.7420931085193 | -122.475732948104 | (37.7420931085193, -122.475732948104) | ||
46754 | 46754 | 115098 | Planning Code 138.1 required 4 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 537 Natoma St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/12/2016 12:00:00 AM | 2 | 2x4 | Permit Number 769476 | 6010148.06204 | 2111925.42664 | 37.7795170247346 | -122.408475763058 | (37.7795170247346, -122.408475763058) | |
81719 | 81719 | 112974 | Planning Code 138.1 required 4 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 4099x ULLOA ST | 3 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 10/20/2015 12:00:00 AM | 3x3 | Permit Number 773327 | 5983385.0 | 2098079.0 | 37.7399635032694 | -122.500035309652 | (37.7399635032694, -122.500035309652) | ||
90957 | 90957 | 112973 | Planning Code 138.1 required 4 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 4099x ULLOA ST | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 10/20/2015 12:00:00 AM | 3x3 | Permit Number 773327 | 5983385.0 | 2098079.0 | 37.7399635032694 | -122.500035309652 | (37.7399635032694, -122.500035309652) | ||
105015 | 105015 | 112975 | Planning Code 138.1 required 4 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 4099x ULLOA ST | 4 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 10/20/2015 12:00:00 AM | 3x3 | Permit Number 773327 | 5983385.0 | 2098079.0 | 37.7399635032694 | -122.500035309652 | (37.7399635032694, -122.500035309652) | ||
109588 | 109588 | 113335 | Planning Code 138.1 required 4 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2X STANFORD ST | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 11/10/2015 12:00:00 AM | 3x9 | Permit Number 770912 | 6014727.0 | 2112481.0 | 37.781297869167396 | -122.392674013487 | (37.7812978691674, -122.392674013487) | ||
119781 | 119781 | 113337 | Planning Code 138.1 required 4 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2X STANFORD ST | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 11/10/2015 12:00:00 AM | 3x9 | Permit Number 770912 | 6014727.0 | 2112481.0 | 37.781297869167396 | -122.392674013487 | (37.7812978691674, -122.392674013487) | ||
127734 | 127734 | 113338 | Planning Code 138.1 required 4 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2X STANFORD ST | 3 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 11/10/2015 12:00:00 AM | 3x9 | Permit Number 770912 | 6014727.0 | 2112481.0 | 37.781297869167396 | -122.392674013487 | (37.7812978691674, -122.392674013487) | ||
127737 | 127737 | 112972 | Planning Code 138.1 required 4 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 4099x ULLOA ST | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 10/20/2015 12:00:00 AM | 1 | 3x3 | Permit Number 773327 | 5983385.0 | 2098079.0 | 37.7399635032694 | -122.500035309652 | (37.7399635032694, -122.500035309652) | |
133773 | 133773 | 101942 | Planning Code 138.1 required 4 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 537 Natoma St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/12/2016 12:00:00 AM | 2 | 2x4 | Permit Number 769476 | 6010108.2937199995 | 2111885.47528 | 37.7794051005107 | -122.408610520167 | (37.7794051005107, -122.408610520167) | |
141647 | 141647 | 122627 | Planning Code 138.1 required 4 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 34 Country Club Dr | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 11/15/2016 12:00:00 AM | 3 | 3x4 | Permit Number 775279 | 5984731.0 | 2094410.0 | 37.729968312905505 | -122.49511098534401 | (37.7299683129055, -122.495110985344) | |
145677 | 145677 | 108030 | Planning Code 138.1 required 4 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 601 29th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/17/2014 12:00:00 AM | 3 | 3x3 | 6002630.6 | 2098839.9 | 37.743163470374895 | -122.43354642924999 | (37.7431634703749, -122.43354642925) | ||
149675 | 149675 | 115096 | Planning Code 138.1 required 4 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 537 Natoma St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/12/2016 12:00:00 AM | 2 | 2x4 | Permit Number 769476 | 6010119.08101 | 2111896.4319 | 37.7794357889593 | -122.408573975335 | (37.7794357889593, -122.408573975335) | |
151101 | 151101 | 39246 | Planning Code 138.1 required 4 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 3524 Jackson St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/22/2002 12:00:00 AM | 1 | Permit Number 772836 | 5997390.1418 | 2116079.3582900004 | 37.7901998932662 | -122.452910535096 | (37.7901998932662, -122.452910535096) | ||
179588 | 179588 | 115097 | Planning Code 138.1 required 4 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 537 Natoma St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/12/2016 12:00:00 AM | 2 | 2x4 | Permit Number 769476 | 6010133.894719999 | 2111910.59383 | 37.779475503918 | -122.408523727481 | (37.779475503918, -122.408523727481) |
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");