Street_Tree_List

Data source: data.sfgov.org

32 rows where PlotSize = "4x4" and qLegalStatus = 4

View and edit SQL

Suggested facets: qSpecies, qAddress, SiteOrder, qSiteInfo, PlantDate, DBH, 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
138 72565 Planning Code 138.1 required 4 Ginkgo biloba :: Maidenhair Tree 44 270 Brannan St 1 Sidewalk: Property side : Cutout 5 Tree 1 Private 1   11/16/1996 12:00:00 AM 3 4x4 Permit Number 770847 6015158.0 2112983.0 37.782700175280794 -122.39121805332199 (37.7827001752808, -122.391218053322)
139 116640 Planning Code 138.1 required 4 Ginkgo biloba :: Maidenhair Tree 44 270 Brannan St 2 Sidewalk: Property side : Cutout 5 Tree 1 Private 1     1 4x4   6015158.0 2112983.0 37.782700175280794 -122.39121805332199 (37.7827001752808, -122.391218053322)
1601 102430 Planning Code 138.1 required 4 Washingtonia robusta :: Mexican Fan Palm 75 200 06th St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   05/25/2017 12:00:00 AM 3 4x4 Permit Number 770993 6010566.09371 2111909.33227 37.779496235110706 -122.407028471514 (37.7794962351107, -122.407028471514)
1602 102429 Planning Code 138.1 required 4 Washingtonia robusta :: Mexican Fan Palm 75 200 06th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   05/25/2017 12:00:00 AM 3 4x4 Permit Number 770993 6010552.49087 2111923.99595 37.7795357369219 -122.40707656363399 (37.7795357369219, -122.407076563634)
2687 253164 Planning Code 138.1 required 4 Tree(s) :: 17 146 Cambridge St 1 Front Yard : Cutout 8 Tree 1 Private 1   07/27/2017 12:00:00 AM 3 4x4   6006598.94029 2094006.4119099998 37.7301161400075 -122.419482094225 (37.7301161400075, -122.419482094225)
3174 253344 Planning Code 138.1 required 4 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 2586 30th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   08/23/2017 12:00:00 AM 3 4x4 Permit Number 780063 5987098.36417 2097677.28593 37.7390777358027 -122.487166705945 (37.7390777358027, -122.487166705945)
3890 161753 Planning Code 138.1 required 4 Eriobotrya deflexa :: Bronze Loquat 49 175x Newton St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   08/09/2017 12:00:00 AM 3 4x4 Permit Number 780462 6001022.0 2087749.0 37.7126190008501 -122.43831413288 (37.7126190008501, -122.43831413288)
3901 253246 Planning Code 138.1 required 4 Eriobotrya deflexa :: Bronze Loquat 49 1192 Naples St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   08/09/2017 12:00:00 AM 3 4x4 Permit Number 780462 6001173.0 2087586.0 37.7121800264355 -122.437780563503 (37.7121800264355, -122.437780563503)
7556 115529 Planning Code 138.1 required 4 Platanus x hispanica :: Sycamore: London Plane 15 101 Polk St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   02/08/2016 12:00:00 AM 3 4x4 Permit Number 770842 6007327.31765 2111347.52577 37.777771876795 -122.418192961161 (37.777771876795, -122.418192961161)
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)
8658 115528 Planning Code 138.1 required 4 Platanus x hispanica :: Sycamore: London Plane 15 101 Polk St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   02/08/2016 12:00:00 AM 3 4x4 Permit Number 770842 6007325.8351 2111377.63368 37.77785446243671 -122.418200224953 (37.7778544624367, -122.418200224953)
8908 33111 Planning Code 138.1 required 4 Ginkgo biloba :: Maidenhair Tree 44 2626 Filbert St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   11/05/1996 12:00:00 AM 3 4x4 Permit Number 769981 6000363.34088 2118561.77591 37.797185891667105 -122.442801853125 (37.7971858916671, -122.442801853125)
9788 115347 Planning Code 138.1 required 4 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 398X HARRISON ST 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/28/2016 12:00:00 AM 3 4x4 Permit Number 773314 6014854.0 2114630.0 37.7872055860551 -122.392385006805 (37.7872055860551, -122.392385006805)
9806 115346 Planning Code 138.1 required 4 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 398X HARRISON ST 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/28/2016 12:00:00 AM 3 4x4 Permit Number 773314 6014854.0 2114630.0 37.7872055860551 -122.392385006805 (37.7872055860551, -122.392385006805)
12678 108261 Planning Code 138.1 required 4 Melaleuca quinquenervia :: Cajeput 50 379 Lisbon St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/16/2015 12:00:00 AM 3 4x4 Permit Number 774479 6002548.02456 2091247.69967 37.7223123355393 -122.43328956378201 (37.7223123355393, -122.433289563782)
22901 183545 Planning Code 138.1 required 4 Agonis flexuosa :: Peppermint Willow 7 2580 26th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   03/13/2017 12:00:00 AM 3 4x4 Permit Number 777874 5988340.9772 2097760.0505 37.73937736557679 -122.482876432223 (37.7393773655768, -122.482876432223)
22935 109466 Planning Code 138.1 required 4 Koelreuteria bipinnata :: Chinese Flame Tree 283 360 Berry St 11 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   03/15/2017 12:00:00 AM 3 4x4 Permit Number 773752 6013302.89282 2109368.02055 37.7726711397891 -122.39738238550699 (37.7726711397891, -122.397382385507)
22937 109463 Planning Code 138.1 required 4 Koelreuteria bipinnata :: Chinese Flame Tree 283 360 Berry St 8 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   03/15/2017 12:00:00 AM 3 4x4 Permit Number 773752 6013357.96458 2109418.68041 37.7728133064148 -122.39719543803899 (37.7728133064148, -122.397195438039)
27515 109465 Planning Code 138.1 required 4 Koelreuteria bipinnata :: Chinese Flame Tree 283 360 Berry St 10 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 4x4 Permit Number 773752 6013321.87847 2109385.26551 37.772719547604495 -122.397317921189 (37.7727195476045, -122.397317921189)
46526 109467 Planning Code 138.1 required 4 Koelreuteria bipinnata :: Chinese Flame Tree 283 360 Berry St 12 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 4x4 Permit Number 773752 6013285.76594 2109350.55221 37.7726222220803 -122.39744040434601 (37.7726222220803, -122.397440404346)
65429 109468 Planning Code 138.1 required 4 Koelreuteria bipinnata :: Chinese Flame Tree 283 360 Berry St 13 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 4x4 Permit Number 773752 6013267.70036 2109332.73182 37.7725722854256 -122.397501645497 (37.7725722854256, -122.397501645497)
98533 119286 Planning Code 138.1 required 4 Platanus x hispanica :: Sycamore: London Plane 15 400 Grove St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/28/2016 12:00:00 AM 3 4x4   6005873.0 2111410.0 37.777861449140204 -122.423228396467 (37.7778614491402, -122.423228396467)
125829 119287 Planning Code 138.1 required 4 Platanus x hispanica :: Sycamore: London Plane 15 400 Grove St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/28/2016 12:00:00 AM 3 4x4   6005873.0 2111410.0 37.777861449140204 -122.423228396467 (37.7778614491402, -122.423228396467)
127953 119285 Planning Code 138.1 required 4 Platanus x hispanica :: Sycamore: London Plane 15 400 Grove St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/28/2016 12:00:00 AM 3 4x4   6005873.0 2111410.0 37.777861449140204 -122.423228396467 (37.7778614491402, -122.423228396467)
147831 109460 Planning Code 138.1 required 4 Koelreuteria bipinnata :: Chinese Flame Tree 283 360 Berry St 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 4x4 Permit Number 773752 6013412.32492 2109471.0252 37.7729600595772 -122.39701106892099 (37.7729600595772, -122.397011068921)
151818 109462 Planning Code 138.1 required 4 Koelreuteria bipinnata :: Chinese Flame Tree 283 360 Berry St 7 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     10 4x4 Permit Number 773752 6013376.015 2109435.75899 37.7728612052211 -122.39713419690001 (37.7728612052211, -122.3971341969)
152424 109459 Planning Code 138.1 required 4 Koelreuteria bipinnata :: Chinese Flame Tree 283 360 Berry St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     10 4x4 Permit Number 773752 6013430.92674 2109487.72122 37.7730069385559 -122.39694789334101 (37.7730069385559, -122.396947893341)
159239 109461 Planning Code 138.1 required 4 Koelreuteria bipinnata :: Chinese Flame Tree 283 360 Berry St 6 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     10 4x4 Permit Number 773752 6013397.072509999 2109454.07559 37.7729126707161 -122.397062640549 (37.7729126707161, -122.397062640549)
166306 109458 Planning Code 138.1 required 4 Koelreuteria bipinnata :: Chinese Flame Tree 283 360 Berry St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     9 4x4 Permit Number 773752 6013450.121119999 2109506.07563 37.7730584040491 -122.396882784219 (37.7730584040491, -122.396882784219)
171614 109469 Planning Code 138.1 required 4 Koelreuteria bipinnata :: Chinese Flame Tree 283 360 Berry St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 4x4 Permit Number 773752 6013484.3589 2109540.27035 37.7731542007368 -122.3967667483 (37.7731542007368, -122.3967667483)
175630 109464 Planning Code 138.1 required 4 Koelreuteria bipinnata :: Chinese Flame Tree 283 360 Berry St 9 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 4x4 Permit Number 773752 6013338.99753 2109402.3629400004 37.772767446381394 -122.39725990323 (37.7727674463814, -122.39725990323)
187427 109470 Planning Code 138.1 required 4 Koelreuteria bipinnata :: Chinese Flame Tree 283 360 Berry St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 4x4 Permit Number 773752 6013467.61268 2109523.16527 37.77310630195289 -122.39682347663299 (37.7731063019529, -122.396823476633)

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