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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
19701 | 19701 | 102514 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1700X Ellis St | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/28/2013 12:00:00 AM | 4x3 | Permit Number 768629 | 6002473.3 | 2113331.2 | 37.782944132882 | -122.43512657661199 | (37.782944132882, -122.435126576612) | ||
43333 | 43333 | 6292 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1700X Ellis St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 01/28/2013 12:00:00 AM | 24 | 3X4 | Permit Number 768629 | 6002728.2699376 | 2113059.4201816004 | 37.7822123689276 | -122.43422505132601 | (37.7822123689276, -122.434225051326) | |
48375 | 48375 | 17720 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1300X Pierce St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 01/28/2013 12:00:00 AM | 35 | 3X3 | Permit Number 768629 | 6002290.5602400005 | 2112983.34935 | 37.7819786446445 | -122.435733884321 | (37.7819786446445, -122.435733884321) | |
77366 | 77366 | 17721 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1300X Pierce St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 01/28/2013 12:00:00 AM | 3 | 3X3 | Permit Number 768629 | 6002290.5602400005 | 2112983.34935 | 37.7819786446445 | -122.435733884321 | (37.7819786446445, -122.435733884321) | |
77843 | 77843 | 98421 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1501X Steiner St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 3x3 | Permit Number 768629 | 6002677.2 | 2113386.1 | 37.7831064505465 | -122.43442509431299 | (37.7831064505465, -122.434425094313) | |||
78006 | 78006 | 102511 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1700X Ellis St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/28/2013 12:00:00 AM | 4x3 | Permit Number 768629 | 6002473.3 | 2113331.2 | 37.782944132882 | -122.43512657661199 | (37.782944132882, -122.435126576612) | ||
82149 | 82149 | 98423 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 1501X Steiner St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 01/28/2013 12:00:00 AM | 3x3 | Permit Number 768629 | 6002677.2 | 2113386.1 | 37.7831064505465 | -122.43442509431299 | (37.7831064505465, -122.434425094313) | ||
84294 | 84294 | 102509 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1700X Ellis St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/28/2013 12:00:00 AM | 4x3 | Permit Number 768629 | 6002473.3 | 2113331.2 | 37.782944132882 | -122.43512657661199 | (37.782944132882, -122.435126576612) | ||
86532 | 86532 | 102513 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1700X Ellis St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/28/2013 12:00:00 AM | 4x3 | Permit Number 768629 | 6002473.3 | 2113331.2 | 37.782944132882 | -122.43512657661199 | (37.782944132882, -122.435126576612) | ||
92526 | 92526 | 98417 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1501X Steiner St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 3x3 | Permit Number 768629 | 6002677.2 | 2113386.1 | 37.7831064505465 | -122.43442509431299 | (37.7831064505465, -122.434425094313) | |||
95645 | 95645 | 17724 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1300X Pierce St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 01/28/2013 12:00:00 AM | 20 | 3X3 | Permit Number 768629 | 6002290.5602400005 | 2112983.34935 | 37.7819786446445 | -122.435733884321 | (37.7819786446445, -122.435733884321) | |
99261 | 99261 | 98426 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1501X Steiner St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 3x3 | Permit Number 768629 | 6002677.2 | 2113386.1 | 37.7831064505465 | -122.43442509431299 | (37.7831064505465, -122.434425094313) | |||
99429 | 99429 | 6293 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 1700X Ellis St | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/28/2013 12:00:00 AM | 24 | 5x7 | Permit Number 768629 | 6002728.2699376 | 2113059.4201816004 | 37.7822123689276 | -122.43422505132601 | (37.7822123689276, -122.434225051326) | |
99469 | 99469 | 102507 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 1700X Ellis St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/28/2013 12:00:00 AM | 4x3 | Permit Number 768629 | 6002473.3 | 2113331.2 | 37.782944132882 | -122.43512657661199 | (37.782944132882, -122.435126576612) | ||
99569 | 99569 | 98434 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 1401X Steiner St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 01/28/2013 12:00:00 AM | 3x3 | Permit Number 768629 | 6002724.9 | 2113044.1 | 37.782170112299795 | -122.434235614198 | (37.7821701122998, -122.434235614198) | ||
101074 | 101074 | 102516 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 1401X Steiner St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 01/28/2013 12:00:00 AM | 4x4 | Permit Number 768629 | 6002724.9 | 2113044.1 | 37.782170112299795 | -122.434235614198 | (37.7821701122998, -122.434235614198) | ||
104497 | 104497 | 102508 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 1700X Ellis St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/28/2013 12:00:00 AM | 4x3 | Permit Number 768629 | 6002473.3 | 2113331.2 | 37.782944132882 | -122.43512657661199 | (37.782944132882, -122.435126576612) | ||
117106 | 117106 | 98432 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 1401X Steiner St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 01/28/2013 12:00:00 AM | 3x3 | Permit Number 768629 | 6002724.9 | 2113044.1 | 37.782170112299795 | -122.434235614198 | (37.7821701122998, -122.434235614198) | ||
118532 | 118532 | 98422 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 1501X Steiner St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 01/28/2013 12:00:00 AM | 3x3 | Permit Number 768629 | 6002677.2 | 2113386.1 | 37.7831064505465 | -122.43442509431299 | (37.7831064505465, -122.434425094313) | ||
119159 | 119159 | 6290 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1700X Ellis St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 05/06/2015 12:00:00 AM | 4x4 | Permit Number 768629 | 6002728.2699376 | 2113059.4201816004 | 37.7822123689276 | -122.43422505132601 | (37.7822123689276, -122.434225051326) | ||
123156 | 123156 | 98435 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 1401X Steiner St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 01/28/2013 12:00:00 AM | 3x3 | Permit Number 768629 | 6002724.9 | 2113044.1 | 37.782170112299795 | -122.434235614198 | (37.7821701122998, -122.434235614198) | ||
123177 | 123177 | 6288 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 1700X Ellis St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 01/28/2013 12:00:00 AM | 4x3 | Permit Number 768629 | 6002728.2699376 | 2113059.4201816004 | 37.7822123689276 | -122.43422505132601 | (37.7822123689276, -122.434225051326) | ||
123574 | 123574 | 98418 | DPW Maintained 3 | Tree(s) :: 17 | 1501X Steiner St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 3x3 | Permit Number 768629 | 6002677.2 | 2113386.1 | 37.7831064505465 | -122.43442509431299 | (37.7831064505465, -122.434425094313) | |||
125042 | 125042 | 98427 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1401X Steiner St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 3x3 | Permit Number 768629 | 6002724.9 | 2113044.1 | 37.782170112299795 | -122.434235614198 | (37.7821701122998, -122.434235614198) | |||
139442 | 139442 | 98425 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1501X Steiner St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 3x3 | Permit Number 768629 | 6002677.2 | 2113386.1 | 37.7831064505465 | -122.43442509431299 | (37.7831064505465, -122.434425094313) | |||
141545 | 141545 | 98431 | DPW Maintained 3 | Tree(s) :: 17 | 1401X Steiner St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 3x3 | Permit Number 768629 | 6002724.9 | 2113044.1 | 37.782170112299795 | -122.434235614198 | (37.7821701122998, -122.434235614198) | |||
143782 | 143782 | 102515 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 1700X Ellis St | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/28/2013 12:00:00 AM | 4x4 | Permit Number 768629 | 6002473.3 | 2113331.2 | 37.782944132882 | -122.43512657661199 | (37.782944132882, -122.435126576612) | ||
143937 | 143937 | 17725 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1300X Pierce St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 01/28/2013 12:00:00 AM | 60 | 3X3 | Permit Number 768629 | 6002290.5602400005 | 2112983.34935 | 37.7819786446445 | -122.435733884321 | (37.7819786446445, -122.435733884321) | |
145940 | 145940 | 102510 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1700X Ellis St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/28/2013 12:00:00 AM | 4x3 | Permit Number 768629 | 6002473.3 | 2113331.2 | 37.782944132882 | -122.43512657661199 | (37.782944132882, -122.435126576612) |
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");