Data source: data.sfgov.org
This data as json, CSV (advanced)
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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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) |
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");