Street_Tree_List

Data source: data.sfgov.org

29 rows where PlantDate = "01/27/2015 12:00:00 AM"

View and edit SQL

Link rowid ▼ TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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)

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

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");
Powered by Datasette · Query took 2809.614ms · Data source: data.sfgov.org