Street_Tree_List

Data source: data.sfgov.org

41 rows where PlotSize = "Width 3ft", SiteOrder = 1 and qSpecies = 45

View and edit SQL

Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, DBH

Link rowid ▼ TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
576 240412 DPW Maintained 3 Rhamnus alaternus :: Italian Buckthorn 45 3420 Market St 1 : 4 Tree 1 DPW 2   04/19/1996 12:00:00 AM 7 Width 3ft   6000095.059769999 2103920.2632400002 37.7569687331323 -122.442678332141 (37.7569687331323, -122.442678332141)
23461 240416 Undocumented 2 Rhamnus alaternus :: Italian Buckthorn 45 12 Harper St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 3ft   6003644.58951 2098299.35585 37.7417367402568 -122.43000177276899 (37.7417367402568, -122.430001772769)
26763 240404 Undocumented 2 Rhamnus alaternus :: Italian Buckthorn 45 4362 21st St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 3ft   6000898.63467 2103311.26449 37.7553423460847 -122.439855611169 (37.7553423460847, -122.439855611169)
27641 240391 Undocumented 2 Rhamnus alaternus :: Italian Buckthorn 45 346 Bocana St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 3ft   6006743.91028 2097051.2853599999 37.7384848564878 -122.41919681678199 (37.7384848564878, -122.419196816782)
32460 214016 Undocumented 2 Rhamnus alaternus :: Italian Buckthorn 45 1310 Funston Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 3ft   5992104.55451 2106488.0935299997 37.7635605748926 -122.47049926614099 (37.7635605748926, -122.470499266141)
38309 120769 Undocumented 2 Rhamnus alaternus :: Italian Buckthorn 45 4500 Fulton St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 3ft   5989405.82896 2109925.10593 37.7728412569544 -122.48008475013701 (37.7728412569544, -122.480084750137)
39197 136301 Undocumented 2 Rhamnus alaternus :: Italian Buckthorn 45 119 Locust St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 3ft   5997498.90653 2116025.43206 37.790058058469 -122.452530326034 (37.790058058469, -122.452530326034)
39998 122277 Undocumented 2 Rhamnus alaternus :: Italian Buckthorn 45 1750 Balboa St 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     1 Width 3ft   5990139.99053 2111321.69927 37.7767185479371 -122.477647330613 (37.7767185479371, -122.477647330613)
41992 118563 Undocumented 2 Rhamnus alaternus :: Italian Buckthorn 45 8000 Geary Blvd 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     11 Width 3ft   5982185.81739 2112405.54556 37.7792296683273 -122.50524304882099 (37.7792296683273, -122.505243048821)
42442 136326 Undocumented 2 Rhamnus alaternus :: Italian Buckthorn 45 463 Broadway 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 3ft   6011288.49181 2118628.67213 37.797986344959995 -122.405002616378 (37.79798634496, -122.405002616378)
44795 122290 Undocumented 2 Rhamnus alaternus :: Italian Buckthorn 45 1750 Balboa St 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     1 Width 3ft   5990062.61204 2111318.0216900003 37.7767039596239 -122.47791473389799 (37.7767039596239, -122.477914733898)
46883 214041 Undocumented 2 Rhamnus alaternus :: Italian Buckthorn 45 431 Staples Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 3ft   5997281.4748599995 2093791.4004 37.7289965565343 -122.451678093372 (37.7289965565343, -122.451678093372)
47021 179382 Undocumented 2 Rhamnus alaternus :: Italian Buckthorn 45 143 University St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     10 Width 3ft   6007980.64963 2093237.8287400003 37.728083504546596 -122.414650965095 (37.7280835045466, -122.414650965095)
48149 240393 Undocumented 2 Rhamnus alaternus :: Italian Buckthorn 45 35 Hill St 1 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     3 Width 3ft   6006109.51353 2103440.5803799997 37.7559926584484 -122.421843980221 (37.7559926584484, -122.421843980221)
56315 240406 Undocumented 2 Rhamnus alaternus :: Italian Buckthorn 45 101 Roanoke St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 3ft   6003419.55137 2096211.39701 37.7359909366181 -122.430630923178 (37.7359909366181, -122.430630923178)
56835 240403 Undocumented 2 Rhamnus alaternus :: Italian Buckthorn 45 557 Duncan St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 3ft   6002931.13898 2099759.29881 37.7457049727185 -122.43257290392799 (37.7457049727185, -122.432572903928)
59699 197345 Undocumented 2 Rhamnus alaternus :: Italian Buckthorn 45 1277 Howard St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 3ft   6008901.33871 2110395.02653 37.7752450102959 -122.41268050642599 (37.7752450102959, -122.412680506426)
66574 214018 Undocumented 2 Rhamnus alaternus :: Italian Buckthorn 45 2464 15th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 3ft   5991736.67899 2098669.28572 37.742070888761894 -122.47120193253001 (37.7420708887619, -122.47120193253)
70628 240402 Undocumented 2 Rhamnus alaternus :: Italian Buckthorn 45 4440 23rd St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 3ft   6000362.39575 2102290.8235 37.7525099241126 -122.441636854259 (37.7525099241126, -122.441636854259)
71181 240388 Undocumented 2 Rhamnus alaternus :: Italian Buckthorn 45 65 Gates St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 3ft   6008348.72479 2098315.88712 37.742047422761296 -122.413737549756 (37.7420474227613, -122.413737549756)
73887 214033 Undocumented 2 Rhamnus alaternus :: Italian Buckthorn 45 342 Staples Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 3ft   5997821.19553 2093821.6931599998 37.7291106283447 -122.449814429211 (37.7291106283447, -122.449814429211)
74323 240374 Undocumented 2 Rhamnus alaternus :: Italian Buckthorn 45 99 Ramona Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     10 Width 3ft   6005228.2825 2107285.15785 37.7664992238917 -122.425165122599 (37.7664992238917, -122.425165122599)
75966 197346 Undocumented 2 Rhamnus alaternus :: Italian Buckthorn 45 1245 Howard St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 3ft   6008998.58265 2110487.32292 37.7755038918289 -122.412350641372 (37.7755038918289, -122.412350641372)
125050 240396 Undocumented 2 Rhamnus alaternus :: Italian Buckthorn 45 122 Highland Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 3ft   6005552.307130001 2096648.4643 37.737311620735895 -122.42328818262301 (37.7373116207359, -122.423288182623)
129548 214017 Undocumented 2 Rhamnus alaternus :: Italian Buckthorn 45 1438 08th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 3ft   5993685.58433 2105688.82171 37.761457274651605 -122.464972976223 (37.7614572746516, -122.464972976223)
131206 179380 Undocumented 2 Rhamnus alaternus :: Italian Buckthorn 45 77 Santa Cruz Ave 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     9 Width 3ft   5993077.06779 2086425.7469099998 37.7085305695939 -122.46567800964199 (37.7085305695939, -122.465678009642)
135504 136328 DPW Maintained 3 Rhamnus alaternus :: Italian Buckthorn 45 447 Broadway 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     3 Width 3ft   6011327.03299 2118633.79421 37.7980025633245 -122.40486961294201 (37.7980025633245, -122.404869612942)
137156 118182 Undocumented 2 Rhamnus alaternus :: Italian Buckthorn 45 615 33rd Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 3ft   5985646.494109999 2111667.23632 37.7774055049593 -122.493216904169 (37.7774055049593, -122.493216904169)
137736 136324 Undocumented 2 Rhamnus alaternus :: Italian Buckthorn 45 448 Broadway 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 3ft   6011401.0 2118734.0 37.798281838344 -122.404620722239 (37.798281838344, -122.404620722239)
158872 197351 Undocumented 2 Rhamnus alaternus :: Italian Buckthorn 45 1240 Ingalls St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 3ft   6017537.11653 2093985.5056900003 37.7306687649511 -122.381665582497 (37.7306687649511, -122.381665582497)
164927 240387 Undocumented 2 Rhamnus alaternus :: Italian Buckthorn 45 310 Gates St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 3ft   6008249.57192 2097137.15027 37.7388053020181 -122.41399702216002 (37.7388053020181, -122.41399702216)
171047 214038 Undocumented 2 Rhamnus alaternus :: Italian Buckthorn 45 638 Head St 1 : 4 Tree 1 Private 1     5 Width 3ft   5993525.3619099995 2090091.0611400001 37.718620496206796 -122.46439460152901 (37.7186204962068, -122.464394601529)
172426 240394 Undocumented 2 Rhamnus alaternus :: Italian Buckthorn 45 27 Topaz Way 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 3ft   6001499.24152 2098615.40839 37.742482813337 -122.43744228675301 (37.742482813337, -122.437442286753)
172827 214015 Undocumented 2 Rhamnus alaternus :: Italian Buckthorn 45 1326 Funston Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     13 Width 3ft   5992108.78084 2106403.01661 37.763327220596 -122.470478452218 (37.763327220596, -122.470478452218)
174298 214014 Undocumented 2 Rhamnus alaternus :: Italian Buckthorn 45 1462 Funston Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 3ft   5992138.117459999 2105483.85764 37.7608051492715 -122.47031004699 (37.7608051492715, -122.47031004699)
175504 179381 Undocumented 2 Rhamnus alaternus :: Italian Buckthorn 45 211 Maynard St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     13 Width 3ft   6004791.2259599995 2093805.4606400002 37.7294623864734 -122.42571730003901 (37.7294623864734, -122.425717300039)
177305 240408 Undocumented 2 Rhamnus alaternus :: Italian Buckthorn 45 180 Sussex St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 3ft   6001780.1737 2096439.35558 37.7365238469964 -122.436315208675 (37.7365238469964, -122.436315208675)
177864 214036 Undocumented 2 Rhamnus alaternus :: Italian Buckthorn 45 262 Ralston St 1 : 4 Tree 1 Private 1     7 Width 3ft   5992219.26388 2089623.39625 37.7172610279406 -122.46887519663 (37.7172610279406, -122.46887519663)
179090 240400 Undocumented 2 Rhamnus alaternus :: Italian Buckthorn 45 499 Hoffman Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 3ft   6000695.68287 2101155.78818 37.74941237387971 -122.440402898093 (37.7494123738797, -122.440402898093)
180886 240377 Undocumented 2 Rhamnus alaternus :: Italian Buckthorn 45 87 14th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     9 Width 3ft   6008059.81094 2107952.1886400003 37.768490286015 -122.415418572409 (37.768490286015, -122.415418572409)
188261 240405 Undocumented 2 Rhamnus alaternus :: Italian Buckthorn 45 130 Roanoke St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 3ft   6003457.25772 2096114.18055 37.735726138447795 -122.43049362280199 (37.7357261384478, -122.430493622802)

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 377.825ms · Data source: data.sfgov.org