Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, PlantDate, DBH, PlotSize
Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
22574 | 22574 | 7125 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 300X Fern St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/02/1990 12:00:00 AM | 6 | 3X3 | 6005738.176580001 | 2115026.96294 | 37.7877851299198 | -122.42395206753099 | (37.7877851299198, -122.423952067531) | ||
22588 | 22588 | 7129 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 399X Fern St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/02/1990 12:00:00 AM | 4 | 3X3 | 6005508.68317 | 2114972.6560299997 | 37.787623057713496 | -122.424742207381 | (37.7876230577135, -122.424742207381) | ||
34506 | 34506 | 125457 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 2807 Steiner St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 4ft | 6002053.50035 | 2117793.13608 | 37.795171616221104 | -122.43689843522101 | (37.7951716162211, -122.436898435221) | |||
38916 | 38916 | 125482 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 1 Nob Hill Pl | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 1ft | 6009469.59091 | 2116291.78471 | 37.7914679787239 | -122.41113140348499 | (37.7914679787239, -122.411131403485) | |||
52304 | 52304 | 220625 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 665 Elizabeth St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 3ft | 6002079.843669999 | 2102040.673 | 37.751920772823794 | -122.43567974235 | (37.7519207728238, -122.43567974235) | |||
54200 | 54200 | 125490 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 1322 Pine St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6007597.86895 | 2115819.15526 | 37.7900651109764 | -122.417574034214 | (37.7900651109764, -122.417574034214) | |||
58417 | 58417 | 125477 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 150 Sproule Ln | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 4ft | 6009239.02025 | 2116870.71678 | 37.793044652131 | -122.41197010674802 | (37.793044652131, -122.411970106748) | |||
61458 | 61458 | 249988 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 228 Filbert St | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3 | Width 0ft | 6011583.89861 | 2120104.21147 | 37.802054326596206 | -122.404084315938 | (37.8020543265962, -122.404084315938) | |||
65811 | 65811 | 175157 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 229 Delano Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 4ft | 6000084.80379 | 2092303.48045 | 37.7250712199557 | -122.44188005254 | (37.7250712199557, -122.44188005254) | |||
66904 | 66904 | 203470 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 100 Staples Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 17 | 5999333.68862 | 2093807.8865599998 | 37.72915914047 | -122.444584644873 | (37.72915914047, -122.444584644873) | ||||
76457 | 76457 | 125449 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 3101 Clay St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 4ft | 5999876.27718 | 2115725.0378099997 | 37.789369177790206 | -122.444283251471 | (37.7893691777902, -122.444283251471) | |||
90795 | 90795 | 32709 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 1005 Hyde St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/29/1996 12:00:00 AM | Permit Number 37107 | 6007675.42771265 | 2115829.29953352 | 37.7900973284958 | -122.41730640574801 | (37.7900973284958, -122.417306405748) | ||
92011 | 92011 | 99403 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 2200X Keith St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/09/2012 12:00:00 AM | 3x3 | Permit Number 768917 | 6014766.6 | 2092880.6 | 37.7274815503989 | -122.391166558925 | (37.7274815503989, -122.391166558925) | ||
102011 | 102011 | 38318 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 1810 Harrison St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/29/2011 12:00:00 AM | 3x3 | Permit Number 767577 | 6008623.68390919 | 2107918.42733823 | 37.7684292621485 | -122.41346579017299 | (37.7684292621485, -122.413465790173) | |
102103 | 102103 | 34189 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 2701 Lake St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/04/2010 12:00:00 AM | Permit Number 38079 | 5987120.3446635 | 2114449.05125045 | 37.785129669395104 | -122.488322923297 | (37.7851296693951, -122.488322923297) | ||
105612 | 105612 | 49036 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 1190 Sanchez St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/07/2003 12:00:00 AM | Permit Number 46211 | 6003822.41781324 | 2101344.45239948 | 37.75010793907921 | -122.429604025448 | (37.7501079390792, -122.429604025448) | ||
110335 | 110335 | 24520 | DPW Maintained 3 | Afrocarpus gracilior :: Fern Pine 70 | 365 Austin St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6005518.5465766 | 2115307.531712 | 37.788543099973396 | -122.424731913891 | (37.7885430999734, -122.424731913891) | |||
112518 | 112518 | 33292 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 160 Sproule Ln | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/14/1996 12:00:00 AM | Permit Number 37451 | 6009246.88754349 | 2116916.88448981 | 37.7931718587847 | -122.411946149383 | (37.7931718587847, -122.411946149383) | ||
114838 | 114838 | 97942 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 491 Greenwich St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6010516.0 | 2120277.0 | 37.802469036850205 | -122.407791962119 | (37.8024690368502, -122.407791962119) | |||||
118715 | 118715 | 27671 | DPW Maintained 3 | Afrocarpus gracilior :: Fern Pine 70 | 310 Austin St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6005758.15165 | 2115391.49838 | 37.7887871812497 | -122.423908889223 | (37.7887871812497, -122.423908889223) | |||
121106 | 121106 | 102478 | Significant Tree 6 | Afrocarpus gracilior :: Fern Pine 70 | 760 Victoria St | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5993664.7 | 2092172.3 | 37.7243431058269 | -122.464063971167 | (37.7243431058269, -122.464063971167) | |||||
130236 | 130236 | 189156 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 2 Shipley St | 4 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 6012246.95244 | 2112466.10025 | 37.7811189079475 | -122.401252766302 | (37.7811189079475, -122.401252766302) | |||
132055 | 132055 | 189161 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 109 Kissling St | 4 | : 4 | Tree 1 | Private 1 | 2 | Width 3ft | 6008149.50016 | 2109391.65635 | 37.7724477670719 | -122.41521025345699 | (37.7724477670719, -122.415210253457) | |||
133444 | 133444 | 221774 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 5587 Diamond Heights Blvd | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 2ft | 6001628.85719 | 2097123.02869 | 37.7383924556487 | -122.43688730163 | (37.7383924556487, -122.43688730163) | |||
136912 | 136912 | 250078 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 399 Austin St | 4 | : 4 | Tree 1 | Private 1 | 8 | Width 3ft | 6005435.52045 | 2115308.45101 | 37.78854093456471 | -122.425019237271 | (37.7885409345647, -122.425019237271) | |||
137536 | 137536 | 249818 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 285 Kearny St | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | 24 | Width 0ft | 6010887.46579 | 2120660.30432 | 37.803542284601996 | -122.40653352599399 | (37.803542284602, -122.406533525994) | |||
148879 | 148879 | 249535 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 201 Myrtle St | 4 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 6006279.61488 | 2114039.5342599996 | 37.7851044469537 | -122.422008617322 | (37.7851044469537, -122.422008617322) | |||
149835 | 149835 | 125493 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 1207 Chestnut St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 3ft | 6006021.473809999 | 2120333.6545700002 | 37.8023719590496 | -122.42334930055401 | (37.8023719590496, -122.423349300554) | |||
151503 | 151503 | 248095 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 8 Brewster St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 6010444.10359 | 2099844.52048 | 37.746362164885 | -122.406600056945 | (37.746362164885, -122.406600056945) | |||
152559 | 152559 | 189178 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 1 Anthony St | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 5ft | 6012651.667780001 | 2115316.04533 | 37.7889667644596 | -122.400052847677 | (37.7889667644596, -122.400052847677) | |||
154983 | 154983 | 125471 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 655 Powell St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 2ft | 6010076.95545 | 2116019.41648 | 37.7907541634305 | -122.409010696908 | (37.7907541634305, -122.409010696908) | |||
157854 | 157854 | 203451 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 1515 16th Ave | 4 | Side Yard : Yard 17 | Tree 1 | Private 1 | 8 | Width 8ft | 5991183.11857 | 2105012.94014 | 37.7594568739424 | -122.473578579008 | (37.7594568739424, -122.473578579008) | |||
166425 | 166425 | 189184 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 40 Bluxome St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 2ft | 6013459.66135 | 2110901.5969 | 37.776890721054 | -122.396947645136 | (37.776890721054, -122.396947645136) | |||
168173 | 168173 | 125468 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 1177 California St | 4 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 5 | Width 4ft | 6008726.14199 | 2116272.16952 | 37.7913723996763 | -122.413702344902 | (37.7913723996763, -122.413702344902) | |||
174163 | 174163 | 125486 | DPW Maintained 3 | Afrocarpus gracilior :: Fern Pine 70 | 1237x Robert C Levy Tunl | 4 | Median : Yard 3 | Tree 1 | DPW 2 | 6 | 6007645.270330001 | 2118136.8198 | 37.7964315115565 | -122.417574361577 | (37.7964315115565, -122.417574361577) | ||||
177273 | 177273 | 125532 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 11 Miller Pl | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 6010078.47215 | 2116887.6611 | 37.793138238302205 | -122.409066739034 | (37.7931382383022, -122.409066739034) | |||
178536 | 178536 | 189195 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 30 15th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 4ft | 6012037.52857 | 2107512.72185 | 37.767506377346294 | -122.401629018386 | (37.7675063773463, -122.401629018386) | |||
185192 | 185192 | 189165 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 1000 Pennsylvania Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 3ft | 6014460.44489 | 2102480.94268 | 37.753825107047 | -122.392896328823 | (37.753825107047, -122.392896328823) | |||
187869 | 187869 | 203446 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 1 Marne Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 2ft | 5995218.706569999 | 2097826.55093 | 37.739957742754704 | -122.459101255842 | (37.7399577427547, -122.459101255842) |
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");