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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3299 | 3299 | 192595 | Planning Code 138.1 required 4 | Lophostemon confertus :: Brisbane Box 11 | 1321 Mission St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/27/2015 12:00:00 AM | 3 | Width 4ft | Permit Number 770747 | 6008285.14461 | 2110684.68439 | 37.776005738696604 | -122.414832573262 | (37.7760057386966, -122.414832573262) | |
3302 | 3302 | 192594 | Planning Code 138.1 required 4 | Lophostemon confertus :: Brisbane Box 11 | 1321 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/27/2015 12:00:00 AM | 2 | Width 4ft | Permit Number 770747 | 6008274.3646 | 2110675.08431 | 37.775978773435504 | -122.414869184668 | (37.7759787734355, -122.414869184668) | |
3307 | 3307 | 192596 | Planning Code 138.1 required 4 | Lophostemon confertus :: Brisbane Box 11 | 1335 Mission St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/27/2015 12:00:00 AM | 3 | Width 4ft | Permit Number 770747 | 6008295.90964 | 2110693.56586 | 37.776030729971794 | -122.41479596277901 | (37.7760307299718, -122.414795962779) | |
13916 | 13916 | 51328 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 333 01st St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/27/2015 12:00:00 AM | 3 | Permit Number 769035 | 6014381.59156 | 2114580.64848 | 37.787043834057 | -122.394015994643 | (37.787043834057, -122.394015994643) | ||
14051 | 14051 | 51330 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 333 01st St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/27/2015 12:00:00 AM | 3 | Permit Number 769035 | 6014367.75684 | 2114595.25107 | 37.787083160494795 | -122.39406488271099 | (37.7870831604948, -122.394064882711) | ||
14325 | 14325 | 51335 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 333 01st St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/27/2015 12:00:00 AM | 3 | Permit Number 769035 | 6014469.07486 | 2114489.67669 | 37.786798908177296 | -122.393706949821 | (37.7867989081773, -122.393706949821) | ||
14468 | 14468 | 51333 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 333 01st St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/27/2015 12:00:00 AM | 3 | Permit Number 769035 | 6014483.95418 | 2114476.81185 | 37.7867644110965 | -122.393654569705 | (37.7867644110965, -122.393654569705) | ||
15216 | 15216 | 51332 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 333 01st St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/27/2015 12:00:00 AM | 3 | Permit Number 769035 | 6014455.003 | 2114505.03769 | 37.7868403039865 | -122.393756711124 | (37.7868403039865, -122.393756711124) | ||
15415 | 15415 | 51334 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 333 01st St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/27/2015 12:00:00 AM | 3 | 3x3 | Permit Number 769035 | 6014513.697869999 | 2114450.32884 | 37.786693347562704 | -122.3935498086 | (37.7866933475627, -122.3935498086) | |
15910 | 15910 | 51329 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 333 01st St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/27/2015 12:00:00 AM | 3 | Permit Number 769035 | 6014352.4442300005 | 2114611.6421 | 37.787127315414295 | -122.39411900929701 | (37.7871273154143, -122.394119009297) | ||
16055 | 16055 | 51331 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 333 01st St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/27/2015 12:00:00 AM | 3 | Permit Number 769035 | 6014339.098619999 | 2114625.4808400003 | 37.7871645716384 | -122.394166151749 | (37.7871645716384, -122.394166151749) | ||
16116 | 16116 | 51327 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 333 01st St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/27/2015 12:00:00 AM | 3 | Permit Number 769035 | 6014502.81835 | 2114461.3538900004 | 37.786723015300296 | -122.393588221341 | (37.7867230153003, -122.393588221341) | ||
16329 | 16329 | 51336 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 333 01st St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/27/2015 12:00:00 AM | 3 | Permit Number 769035 | 6014396.4352 | 2114566.02547 | 37.7870045076019 | -122.39396361453501 | (37.7870045076019, -122.393963614535) | ||
81246 | 81246 | 109097 | Property Tree 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 601 29th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/27/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774331 | 6002630.6 | 2098839.9 | 37.743163470374895 | -122.43354642924999 | (37.7431634703749, -122.43354642925) |
82099 | 82099 | 109103 | Permitted Site 1 | Tree(s) :: 17 | 3660 21st St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/27/2015 12:00:00 AM | 3 | Permit Number 770773 | 6003991.2 | 2103675.5 | 37.756518003383896 | -122.429186559891 | (37.7565180033839, -122.429186559891) | ||
84243 | 84243 | 109102 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 1665 08th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/27/2015 12:00:00 AM | 3 | 3x3 | Permit Number 771042 | 5993673.5 | 2104163.7 | 37.7572689897716 | -122.46490400670099 | (37.7572689897716, -122.464904006701) |
84996 | 84996 | 15236 | Planning Code 138.1 required 4 | Lophostemon confertus :: Brisbane Box 11 | 1321 Mission St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/27/2015 12:00:00 AM | 3 | 3X3 | Permit Number 770747 | 6008261.49106 | 2110663.4843099997 | 37.7759461992201 | -122.41491289655599 | (37.7759461992201, -122.414912896556) | |
86819 | 86819 | 15237 | Planning Code 138.1 required 4 | Lophostemon confertus :: Brisbane Box 11 | 1321 Mission St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/27/2015 12:00:00 AM | 3 | 3X3 | Permit Number 770747 | 6008256.52807 | 2110680.03106 | 37.7759913537931 | -122.414931236282 | (37.7759913537931, -122.414931236282) | |
87614 | 87614 | 109098 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 442 Alvarado St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/27/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774790 | 6003487.8 | 2102768.8 | 37.753999909780795 | -122.430862790198 | (37.7539999097808, -122.430862790198) |
94827 | 94827 | 28967 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 112X 09th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/27/2015 12:00:00 AM | 3 | 3x3 | Permit Number 770747 | 6008365.644790701 | 2110683.719894 | 37.776007613279 | -122.41455403281401 | (37.776007613279, -122.414554032814) | |
95068 | 95068 | 109091 | Property Tree 7 | Ginkgo biloba 'Fairmont' :: Fairmont Ginkgo 316 | 4235 23rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/27/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773805 | 6001611.4 | 2102294.1 | 37.7525900037408 | -122.43731782876002 | (37.7525900037408, -122.43731782876) |
97430 | 97430 | 109101 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 1665 08th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/27/2015 12:00:00 AM | 3 | 3x3 | Permit Number 771042 | 5993673.5 | 2104163.7 | 37.7572689897716 | -122.46490400670099 | (37.7572689897716, -122.464904006701) |
98259 | 98259 | 28966 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 112X 09th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/27/2015 12:00:00 AM | 3 | 3x3 | Permit Number 770747 | 6008365.644790701 | 2110683.719894 | 37.776007613279 | -122.41455403281401 | (37.776007613279, -122.414554032814) | |
102061 | 102061 | 109092 | Property Tree 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 237 28th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/27/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773766 | 6004335.1 | 2099509.2 | 37.7450977767532 | -122.427700396282 | (37.7450977767532, -122.427700396282) |
106708 | 106708 | 109099 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 605 Arguello Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/27/2015 12:00:00 AM | 3 | 3x3 | Permit Number 772813 | 5995572.0 | 2112087.6 | 37.7791352386671 | -122.458911991714 | (37.7791352386671, -122.458911991714) |
116090 | 116090 | 99946 | Permitted Site 1 | Tree(s) :: 17 | 499X FOLSOM ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/27/2015 12:00:00 AM | 3 | 3x3 | Permit Number 769035 | 6014477.0 | 2114572.0 | 37.787025389439 | -122.393685294607 | (37.787025389439, -122.393685294607) | |
140546 | 140546 | 99945 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 499X FOLSOM ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/27/2015 12:00:00 AM | 3 | 3x3 | Permit Number 769035 | 6014477.0 | 2114572.0 | 37.787025389439 | -122.393685294607 | (37.787025389439, -122.393685294607) | |
142895 | 142895 | 109104 | Permitted Site 1 | Tree(s) :: 17 | 3660 21st St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/27/2015 12:00:00 AM | 3 | Permit Number 770773 | 6003991.2 | 2103675.5 | 37.756518003383896 | -122.429186559891 | (37.7565180033839, -122.429186559891) | ||
145330 | 145330 | 15235 | Planning Code 138.1 required 4 | Lophostemon confertus :: Brisbane Box 11 | 1321 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/27/2015 12:00:00 AM | 3 | 3X3 | Permit Number 770747 | 6008256.52807 | 2110680.03106 | 37.7759913537931 | -122.414931236282 | (37.7759913537931, -122.414931236282) |
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");