Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qAddress, SiteOrder, qSiteInfo, PlotSize
Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
22660 | 22660 | 28058 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 399X Fern St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/28/2003 12:00:00 AM | 7 | 3X3 | 6005467.0390099995 | 2114965.36006 | 37.7876006726807 | -122.424885768876 | (37.7876006726807, -122.424885768876) | ||
24295 | 24295 | 249534 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 201 Myrtle St | 3 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 6006252.357009999 | 2114034.72493 | 37.785089704362704 | -122.422102579373 | (37.7850897043627, -122.422102579373) | |||
24633 | 24633 | 220637 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 79 Bemis St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6003700.73164 | 2096802.6587900002 | 37.7376303323698 | -122.429700927958 | (37.7376303323698, -122.429700927958) | |||
25088 | 25088 | 189157 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 2 Shipley St | 5 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 6012230.29612 | 2112453.73281 | 37.78108402055079 | -122.40130951984501 | (37.7810840205508, -122.401309519845) | |||
26400 | 26400 | 203471 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 410 Faxon Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 1ft | 5994790.95036 | 2091337.27547 | 37.7221151744519 | -122.460110243003 | (37.7221151744519, -122.460110243003) | |||
31581 | 31581 | 70151 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 846 Geary St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/08/1993 12:00:00 AM | 7 | 6007647.41454 | 2114440.4952 | 37.786282435643 | -122.41730487074699 | (37.786282435643, -122.417304870747) | ||
31786 | 31786 | 221763 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 3816 21st St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6002948.3546400005 | 2103602.92928 | 37.7562596509731 | -122.432787903054 | (37.7562596509731, -122.432787903054) | |||
36428 | 36428 | 203476 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 2357 16th Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 3ft | 5991292.10233 | 2099373.67062 | 37.743979223173106 | -122.472790471621 | (37.7439792231731, -122.472790471621) | |||
37791 | 37791 | 220646 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 816 Crescent Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6008205.0189 | 2095636.66757 | 37.7346828016745 | -122.41404494431801 | (37.7346828016745, -122.414044944318) | |||
39883 | 39883 | 203492 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 23 Melrose Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 10ft | 5999946.35958 | 2095464.23555 | 37.7337420298607 | -122.442585473564 | (37.7337420298607, -122.442585473564) | |||
40602 | 40602 | 203478 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 2453 Funston Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5992323.79318 | 2098755.04508 | 37.74234030496479 | -122.469178135975 | (37.7423403049648, -122.469178135975) | |||
40929 | 40929 | 249550 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 380 Fern St | 2 | : 4 | Tree 1 | Private 1 | 7 | Width 2ft | 6005507.2276099995 | 2114996.10092 | 37.7876873493358 | -122.424748911848 | (37.7876873493358, -122.424748911848) | |||
41677 | 41677 | 249947 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 305 Filbert St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 7 | Width 0ft | 6011342.9125 | 2120054.18632 | 37.8019035022036 | -122.40491472295 | (37.8019035022036, -122.40491472295) | |||
46074 | 46074 | 221767 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 287 Hermann St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 3ft | 6003902.82897 | 2108654.79623 | 37.770184952298 | -122.429847331292 | (37.770184952298, -122.429847331292) | |||
47152 | 47152 | 125475 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 150 Sproule Ln | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 4ft | 6009249.92549 | 2116801.2629400003 | 37.7928545606515 | -122.41192746357599 | (37.7928545606515, -122.411927463576) | |||
51580 | 51580 | 189194 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 30 15th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 4ft | 6012053.23647 | 2107512.8913 | 37.7675077191257 | -122.40157469843001 | (37.7675077191257, -122.40157469843) | |||
51714 | 51714 | 125450 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 44 Normandie Ter | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 3ft | 6000949.24806 | 2117425.20451 | 37.79409854965171 | -122.44069290604999 | (37.7940985496517, -122.44069290605) | |||
53096 | 53096 | 125439 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 99 Collins St | 0 | Side Yard : Yard 17 | Tree 1 | Private 1 | 7 | 5998117.25486 | 2114050.06951 | 37.7846696436241 | -122.450248453727 | (37.7846696436241, -122.450248453727) | ||||
56962 | 56962 | 220618 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 237 Murray St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 10ft | 6005720.296519999 | 2095375.55283 | 37.7338259689755 | -122.422616936749 | (37.7338259689755, -122.422616936749) | |||
57484 | 57484 | 221751 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 4000 25th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6003801.92979 | 2101310.951 | 37.750014791971104 | -122.429672485102 | (37.7500147919711, -122.429672485102) | |||
63040 | 63040 | 249939 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 331 Filbert St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 7 | Width 0ft | 6011281.55151 | 2120038.154 | 37.801856051265204 | -122.40512593233 | (37.8018560512652, -122.40512593233) | |||
76565 | 76565 | 220629 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 907 Elizabeth St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 4ft | 6000561.393680001 | 2101957.84527 | 37.7516069822761 | -122.440924802556 | (37.7516069822761, -122.440924802556) | |||
151339 | 151339 | 189154 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 2 Shipley St | 2 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 6012314.00092 | 2112536.43535 | 37.781315772258104 | -122.401025754031 | (37.7813157722581, -122.401025754031) | |||
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) | |||
156178 | 156178 | 33132 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 2927 Pierce St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/05/1996 12:00:00 AM | 7 | 4x5 | Permit Number 37362 | 6001472.71004 | 2118540.58919 | 37.7971908999849 | -122.438961648188 | (37.7971908999849, -122.438961648188) |
160003 | 160003 | 99402 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 2200X Keith St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/09/2012 12:00:00 AM | 7 | 3x3 | Permit Number 768917 | 6014766.6 | 2092880.6 | 37.7274815503989 | -122.391166558925 | (37.7274815503989, -122.391166558925) | |
164426 | 164426 | 125476 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 150 Sproule Ln | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 4ft | 6009246.74599 | 2116823.51326 | 37.792915476223705 | -122.41194003791 | (37.7929154762237, -122.41194003791) | |||
167284 | 167284 | 125445 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 3615 Buchanan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6003103.29494 | 2120784.42 | 37.8034445139256 | -122.433479854917 | (37.8034445139256, -122.433479854917) | |||
171692 | 171692 | 189197 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 453 Bryant St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6014136.4691 | 2112772.98188 | 37.78206677001071 | -122.39473742989401 | (37.7820667700107, -122.394737429894) | |||
172051 | 172051 | 249551 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 380 Fern St | 3 | : 4 | Tree 1 | Private 1 | 7 | Width 2ft | 6005490.31575 | 2114993.82461 | 37.787680143969496 | -122.424807261672 | (37.7876801439695, -122.424807261672) | |||
185094 | 185094 | 52182 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 626 Natoma St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/01/2005 12:00:00 AM | 7 | Permit Number 48372 | 6009510.44618 | 2111352.3864700003 | 37.777907863296704 | -122.410641078729 | (37.7779078632967, -122.410641078729) | |
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) | |||
185700 | 185700 | 203483 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 459 Colon Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 3ft | 5995499.06215 | 2095368.93495 | 37.733225844180105 | -122.457954104018 | (37.7332258441801, -122.457954104018) |
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");