Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, DBH, PlotSize
Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1797 | 1797 | 251710 | DPW Maintained 3 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 124 | 902 Market St | 2 | Front Yard : Cutout 8 | Tree 1 | DPW 2 | 3x3 | 6010270.0 | 2113565.0 | 37.7840257341798 | -122.4081695922 | (37.7840257341798, -122.4081695922) | ||||
26063 | 26063 | 197421 | Undocumented 2 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 124 | 1200 04th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 5ft | 6015000.4324199995 | 2109495.8046 | 37.7731163734468 | -122.391519300385 | (37.7731163734468, -122.391519300385) | |||
27443 | 27443 | 136362 | Undocumented 2 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 124 | 1715 Taylor St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 3ft | 6008714.5466 | 2118843.19382 | 37.7984311487376 | -122.413924418086 | (37.7984311487376, -122.413924418086) | |||
29651 | 29651 | 240512 | Undocumented 2 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 124 | 301 Florida St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6009219.21952 | 2106751.79124 | 37.7652593690624 | -122.41132345193998 | (37.7652593690624, -122.41132345194) | |||
33768 | 33768 | 46508 | Permitted Site 1 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 124 | 675 Minna St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/27/2002 12:00:00 AM | 5 | Permit Number 44677 | 6009091.30835 | 2111167.9463 | 37.777377926079 | -122.412077991228 | (37.777377926079, -122.412077991228) | ||
36656 | 36656 | 136354 | Undocumented 2 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 124 | 1508 Green St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6005758.24578 | 2118617.72057 | 37.79764558194071 | -122.42413809590401 | (37.7976455819407, -122.424138095904) | |||
37840 | 37840 | 197380 | Undocumented 2 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 124 | 2251 Silver Ave | 2 | : 4 | Tree 1 | Private 1 | 11 | Width 3ft | 6012873.308019999 | 2096314.08493 | 37.7368039417418 | -122.39795247834299 | (37.7368039417418, -122.397952478343) | |||
38124 | 38124 | 197384 | Undocumented 2 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 124 | 1350 04th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 5ft | 6015096.00206 | 2108800.56286 | 37.7712126975445 | -122.391140104833 | (37.7712126975445, -122.391140104833) | |||
41777 | 41777 | 240887 | Undocumented 2 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 124 | 3009 26th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 5ft | 6009470.6055 | 2100993.60175 | 37.7494627754843 | -122.41004742097601 | (37.7494627754843, -122.410047420976) | |||
45643 | 45643 | 197407 | Undocumented 2 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 124 | 1101 04th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 5ft | 6015042.44961 | 2109744.00575 | 37.7738002107574 | -122.39139131066999 | (37.7738002107574, -122.39139131067) | |||
50197 | 50197 | 240889 | Undocumented 2 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 124 | 1201 Treat Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 4ft | 6008721.46882 | 2101044.16868 | 37.7495596045891 | -122.41264153966999 | (37.7495596045891, -122.41264153967) | |||
53894 | 53894 | 36877 | Permitted Site 1 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 124 | 2400 Divisadero St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/26/1998 12:00:00 AM | 7 | Permit Number 39539 | 6000814.63294 | 2116594.68212 | 37.7918104855159 | -122.441099074089 | (37.7918104855159, -122.441099074089) | |
59323 | 59323 | 240918 | Undocumented 2 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 124 | 4158 26th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 4ft | 6002863.78754 | 2100671.92533 | 37.748207011640794 | -122.43287098151 | (37.7482070116408, -122.43287098151) | |||
61264 | 61264 | 248011 | Undocumented 2 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 124 | 525 Franconia St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 6ft | 6009911.76805 | 2098028.06886 | 37.7413447878202 | -122.408312722264 | (37.7413447878202, -122.408312722264) | |||
63669 | 63669 | 96392 | Permitted Site 1 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 124 | 800 Tennessee St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/17/2011 12:00:00 AM | 6 | 3x3 | Permit Number 767136 | 6015444.53946 | 2105235.26093 | 37.761442489801105 | -122.389685433429 | (37.7614424898011, -122.389685433429) | |
67125 | 67125 | 197449 | Undocumented 2 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 124 | 668 Natoma St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 2ft | 6009262.53236 | 2111115.69015 | 37.777244048518206 | -122.41148197633301 | (37.7772440485182, -122.411481976333) | |||
67184 | 67184 | 197435 | Undocumented 2 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 124 | 1300 04th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 5ft | 6015029.61492 | 2108966.93535 | 37.7716658353527 | -122.391381374959 | (37.7716658353527, -122.391381374959) | |||
67808 | 67808 | 38390 | Permitted Site 1 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 124 | 2435 Polk St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/17/1998 12:00:00 AM | 5 | 3x5 | Permit Number 40447 | 6006235.29717 | 2119188.7184099997 | 37.799240320944904 | -122.42252796141399 | (37.7992403209449, -122.422527961414) | |
73517 | 73517 | 240909 | Undocumented 2 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 124 | 725 Florida St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 4ft | 6009321.39191 | 2104824.59162 | 37.759973449022105 | -122.41083393923999 | (37.7599734490221, -122.41083393924) | |||
105747 | 105747 | 113638 | Significant Tree 6 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 124 | 1X Russ St | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 6009949.394180001 | 2111947.85897 | 37.7795674908256 | -122.40916462626801 | (37.7795674908256, -122.409164626268) | |||||
142453 | 142453 | 113641 | Significant Tree 6 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 124 | 545X Minna St | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 6010081.18772 | 2112137.85468 | 37.7800965567953 | -122.40872210131901 | (37.7800965567953, -122.408722101319) | |||||
154860 | 154860 | 179419 | Undocumented 2 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 124 | 416 Peninsula Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 6012202.51453 | 2086708.25139 | 37.7103908999794 | -122.399597492152 | (37.7103908999794, -122.399597492152) | |||
160639 | 160639 | 197413 | Undocumented 2 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 124 | 1110 04th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 5ft | 6014976.00474 | 2109834.88715 | 37.7740460629032 | -122.391627511322 | (37.7740460629032, -122.391627511322) | |||
161536 | 161536 | 197443 | Undocumented 2 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 124 | 577 Nelson Rising Ln | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 5ft | 6013632.067840001 | 2108039.85381 | 37.7690426127674 | -122.396150626374 | (37.7690426127674, -122.396150626374) | |||
162826 | 162826 | 240517 | Undocumented 2 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 124 | 3012 26th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 4ft | 6009425.7418 | 2101039.02648 | 37.7495849870744 | -122.41020576820401 | (37.7495849870744, -122.410205768204) | |||
164610 | 164610 | 240913 | Undocumented 2 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 124 | 85 Sycamore St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6006349.99918 | 2105832.52537 | 37.7625739412505 | -122.421182140339 | (37.7625739412505, -122.421182140339) | |||
174531 | 174531 | 240925 | Undocumented 2 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 124 | 1200 Florida St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6009473.40771 | 2102070.45596 | 37.752419734682604 | -122.41011374595699 | (37.7524197346826, -122.410113745957) | |||
179937 | 179937 | 240936 | Undocumented 2 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 124 | 2500 Market St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 7 | Width 3ft | 6001978.22314 | 2105823.15955 | 37.76230079647421 | -122.436301834857 | (37.7623007964742, -122.436301834857) | |||
182157 | 182157 | 197393 | Undocumented 2 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 124 | 1255 04th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 5ft | 6015077.381569999 | 2109137.2639099997 | 37.7721361708673 | -122.391228054034 | (37.7721361708673, -122.391228054034) | |||
184571 | 184571 | 240515 | Undocumented 2 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 124 | 457 14th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6005735.72646 | 2107821.05877 | 37.767999333531996 | -122.42344806497499 | (37.767999333532, -122.423448064975) |
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");