Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qAddress, SiteOrder, qSiteInfo, qCaretaker, PlotSize
Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
25528 | 25528 | 33293 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 166 Sproule Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/14/1996 12:00:00 AM | 10 | Permit Number 37451 | 6009221.08576 | 2116982.79677 | 37.7933513902069 | -122.412040085683 | (37.7933513902069, -122.412040085683) | |
27160 | 27160 | 203449 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 1474 Funston Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 5992141.42239 | 2105406.9692 | 37.7605942249661 | -122.47029301742901 | (37.7605942249661, -122.470293017429) | |||
27258 | 27258 | 220664 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 1192 Sanchez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6003819.11819 | 2101351.9934400003 | 37.7501284581809 | -122.429615973494 | (37.7501284581809, -122.429615973494) | |||
38814 | 38814 | 221775 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 21 Addison St | 14 | Back Yard : Yard 13 | Tree 1 | Private 1 | 10 | Width 3ft | 6003667.46569 | 2096848.61536 | 37.737754634878 | -122.429819221204 | (37.737754634878, -122.429819221204) | |||
44032 | 44032 | 220657 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 505 Tompkins Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6008343.07833 | 2096482.99595 | 37.737014388512996 | -122.41362746465799 | (37.737014388513, -122.413627464658) | |||
44709 | 44709 | 125485 | DPW Maintained 3 | Afrocarpus gracilior :: Fern Pine 70 | 1237x Robert C Levy Tunl | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 10 | 6007640.9414 | 2118138.07584 | 37.796434716745 | -122.417589429708 | (37.796434716745, -122.417589429708) | ||||
50704 | 50704 | 35721 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 556 Bowdoin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/13/1998 12:00:00 AM | 10 | Permit Number 39004 | 6008810.28905 | 2093458.06001 | 37.728734789961706 | -122.411798418969 | (37.7287347899617, -122.411798418969) | |
55795 | 55795 | 189170 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 360 Texas St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 10 | Width 3ft | 6013732.7365 | 2105419.1930299997 | 37.761852457439495 | -122.395618779897 | (37.7618524574395, -122.395618779897) | |||
60321 | 60321 | 203473 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 128 Howth St | 1 | : 4 | Tree 1 | Private 1 | 10 | Width 3ft | 5997584.72507 | 2091125.26044 | 37.7216933258806 | -122.450437617121 | (37.7216933258806, -122.450437617121) | |||
64810 | 64810 | 220647 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 157 Bonview St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6007230.99534 | 2098247.75396 | 37.7417975128515 | -122.41759748493999 | (37.7417975128515, -122.41759748494) | |||
66877 | 66877 | 220656 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 505 Tompkins Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6008322.74158 | 2096484.8015599998 | 37.737018204322 | -122.41369790583 | (37.737018204322, -122.41369790583) | |||
68669 | 68669 | 203481 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 90 Manor Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 5993650.092119999 | 2093481.6421299998 | 37.7279373979817 | -122.464209479697 | (37.7279373979817, -122.464209479697) | |||
70754 | 70754 | 249984 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 226 Filbert St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 10 | Width 0ft | 6011604.5053 | 2120111.99388 | 37.8020768465317 | -122.404013554575 | (37.8020768465317, -122.404013554575) | |||
90780 | 90780 | 51468 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 450X Tompkins Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/20/2004 12:00:00 AM | 10 | 3x3 | Permit Number 47780 | 6008359.74436357 | 2096491.87705801 | 37.7370397099418 | -122.41357047046199 | (37.7370397099418, -122.413570470462) |
94567 | 94567 | 16912 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 474 Oak St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 10 | 3X3 | 6004730.16481 | 2110223.37403 | 37.774538702608396 | -122.42709732349701 | (37.7745387026084, -122.427097323497) | |||
126745 | 126745 | 220651 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 45 Stoneman St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 3ft | 6008064.96703 | 2099392.46104 | 37.74498751697679 | -122.41479487098101 | (37.7449875169768, -122.414794870981) | |||
142093 | 142093 | 49037 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 1190 Sanchez St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/07/2003 12:00:00 AM | 10 | Permit Number 46211 | 6003822.41781324 | 2101344.45239948 | 37.75010793907921 | -122.429604025448 | (37.7501079390792, -122.429604025448) | |
148423 | 148423 | 189174 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 14 Waterville St | 1 | : 4 | Tree 1 | Private 1 | 10 | Width 1ft | 6011435.762019999 | 2096086.73565 | 37.7360995216629 | -122.40290674814301 | (37.7360995216629, -122.402906748143) | |||
152920 | 152920 | 203479 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 90 Manor Dr | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 5993668.24229 | 2093512.36945 | 37.7280228137991 | -122.464148964325 | (37.7280228137991, -122.464148964325) | |||
153900 | 153900 | 203467 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 480 Hearst Ave | 9 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 2ft | 5998177.872280001 | 2094421.44457 | 37.730777805043104 | -122.448624552388 | (37.7307778050431, -122.448624552388) | |||
163606 | 163606 | 220643 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 10 Bronte St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6009355.21688 | 2097375.10372 | 37.739520706418396 | -122.410190999519 | (37.7395207064184, -122.410190999519) | |||
165596 | 165596 | 125497 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 1154 Chestnut St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 2ft | 6006282.866880001 | 2120431.59702 | 37.8026556331117 | -122.422451714169 | (37.8026556331117, -122.422451714169) | |||
167943 | 167943 | 31087 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 61 Pearl St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/21/1995 12:00:00 AM | 10 | Permit Number 34823 | 6005643.9795699995 | 2108712.30745 | 37.7704413103375 | -122.42382878848 | (37.7704413103375, -122.42382878848) | |
173419 | 173419 | 203452 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 1515 16th Ave | 5 | Side Yard : Yard 17 | Tree 1 | Private 1 | 10 | Width 8ft | 5991186.2272 | 2105007.12865 | 37.7594410971589 | -122.473567404026 | (37.7594410971589, -122.473567404026) | |||
175507 | 175507 | 220607 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 512 Andover St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6007434.64615 | 2096337.1519400002 | 37.7365628793641 | -122.416758001093 | (37.7365628793641, -122.416758001093) | |||
182457 | 182457 | 246824 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 402 Franconia St | 1 | : 4 | Tree 1 | Private 1 | 10 | Width 4ft | 6009972.67277 | 2098701.6792900003 | 37.7431977860534 | -122.408149630203 | (37.7431977860534, -122.408149630203) | |||
183131 | 183131 | 220648 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 35 Stoneman St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6008125.23959 | 2099402.94475 | 37.74501968930829 | -122.414587200443 | (37.7450196893083, -122.414587200443) | |||
183937 | 183937 | 249822 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 285 Kearny St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 10 | Width 0ft | 6010893.58143 | 2120633.6568400003 | 37.8034694593133 | -122.406510483572 | (37.8034694593133, -122.406510483572) | |||
184898 | 184898 | 221752 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 4000 25th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6003785.28495 | 2101310.15216 | 37.75001165602829 | -122.42972998686301 | (37.7500116560283, -122.429729986863) |
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");