Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qAddress, SiteOrder, DBH, PlotSize
Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
5171 | 5171 | 247184 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1 Buena Vista Ave East | 1 | : 4 | Tree 1 | Private 1 | 11/09/2017 12:00:00 AM | 3 | Width 4ft | Permit Number 780753 | 6001013.06071 | 2108893.70983 | 37.7706768805726 | -122.439860124855 | (37.7706768805726, -122.439860124855) | |
5187 | 5187 | 247186 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1 Buena Vista Ave East | 3 | : 4 | Tree 1 | Private 1 | 10 | Width 4ft | Permit Number 780753 | 6000985.28448 | 2108903.00262 | 37.770700815109294 | -122.439956869431 | (37.7707008151093, -122.439956869431) | ||
23825 | 23825 | 247187 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1 Buena Vista Ave East | 4 | : 4 | Tree 1 | Private 1 | 10 | Width 4ft | 6000970.93564 | 2108908.88323 | 37.770716144966 | -122.440006923906 | (37.770716144966, -122.440006923906) | |||
26119 | 26119 | 247188 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1 Buena Vista Ave East | 5 | : 4 | Tree 1 | Private 1 | 15 | Width 4ft | 6000957.547669999 | 2108914.20808 | 37.7707300035244 | -122.440053614886 | (37.7707300035244, -122.440053614886) | |||
29127 | 29127 | 250321 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 247 27th Ave | 1 | : 4 | Tree 1 | Private 1 | 8 | Width 3ft | 5987414.73446 | 2114306.1636799998 | 37.7847545126541 | -122.487293940769 | (37.7847545126541, -122.487293940769) | |||
39125 | 39125 | 197507 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1275 Harrison St | 2 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 6009714.36956 | 2109423.2134700003 | 37.772622236462205 | -122.409799423029 | (37.7726222364622, -122.409799423029) | |||
40326 | 40326 | 246423 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 406 Duncan St | 1 | : 4 | Tree 1 | Private 1 | 9 | Width 3ft | 6003794.9997 | 2099851.1264400003 | 37.746006061224605 | -122.429592349221 | (37.7460060612246, -122.429592349221) | |||
46348 | 46348 | 197519 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1055 Natoma St | 2 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 6007591.229180001 | 2109427.92338 | 37.772515957284206 | -122.417143942455 | (37.7725159572842, -122.417143942455) | |||
65713 | 65713 | 246598 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 52 Waller St | 4 | : 4 | Tree 1 | Private 1 | 20 | Width 3ft | 6005467.40356 | 2109274.31341 | 37.7719744736758 | -122.424479547814 | (37.7719744736758, -122.424479547814) | |||
75261 | 75261 | 246592 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 22 Waller St | 3 | : 4 | Tree 1 | Private 1 | 20 | Width 3ft | 6005574.158530001 | 2109287.40717 | 37.7720164540359 | -122.42411120528 | (37.7720164540359, -122.42411120528) | |||
130577 | 130577 | 246583 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 98 Waller St | 1 | : 4 | Tree 1 | Private 1 | 14 | Width 3ft | 6005277.33485 | 2109248.26095 | 37.7718922045878 | -122.425135156289 | (37.7718922045878, -122.425135156289) | |||
135186 | 135186 | 197518 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 407 09th St | 11 | : 4 | Tree 1 | Private 1 | 12 | Width 3ft | 6009751.84387 | 2109320.3302700003 | 37.772341843132 | -122.409662531815 | (37.772341843132, -122.409662531815) | |||
137146 | 137146 | 246591 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 22 Waller St | 2 | : 4 | Tree 1 | Private 1 | 20 | Width 3ft | 6005592.7822199995 | 2109289.94448 | 37.772024472369296 | -122.424046964897 | (37.7720244723693, -122.424046964897) | |||
137903 | 137903 | 250320 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 255 27th Ave | 1 | : 4 | Tree 1 | Private 1 | 11 | Width 3ft | 5987417.56987 | 2114243.0271099997 | 37.78458132302389 | -122.487279492276 | (37.7845813230239, -122.487279492276) | |||
148701 | 148701 | 197517 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 407 09th St | 10 | : 4 | Tree 1 | Private 1 | 9 | Width 3ft | 6009758.68055 | 2109312.44793 | 37.7723205831618 | -122.40963832656 | (37.7723205831618, -122.40963832656) | |||
153666 | 153666 | 197537 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 266 Bridgeview Dr | 1 | : 4 | Tree 1 | Private 1 | 10 | Width 2ft | 6012934.68235 | 2095259.36475 | 37.7339113173389 | -122.39766632393601 | (37.7339113173389, -122.397666323936) | |||
154089 | 154089 | 179456 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 39 Melra Ct | 1 | : 4 | Tree 1 | Private 1 | 18 | Width 4ft | 6008986.48136 | 2086460.78308 | 37.7095316094729 | -122.41069535821501 | (37.7095316094729, -122.410695358215) | |||
162638 | 162638 | 246599 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 52 Waller St | 5 | : 4 | Tree 1 | Private 1 | 18 | Width 3ft | 6005448.395330001 | 2109271.63735 | 37.771966052416204 | -122.42454510838999 | (37.7719660524162, -122.42454510839) | |||
163467 | 163467 | 247185 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1 Buena Vista Ave East | 2 | : 4 | Tree 1 | Private 1 | 13 | Width 4ft | 6000997.16935 | 2108899.56704 | 37.7706920584128 | -122.43991551320299 | (37.7706920584128, -122.439915513203) | |||
166887 | 166887 | 246597 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 52 Waller St | 3 | : 4 | Tree 1 | Private 1 | 16 | Width 3ft | 6005485.469380001 | 2109277.24468 | 37.7719835424264 | -122.42441726525 | (37.7719835424264, -122.42441726525) | |||
188040 | 188040 | 197520 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 98 Lafayette St | 5 | : 4 | Tree 1 | Private 1 | 22 | Width 3ft | 6007717.2402800005 | 2109472.44967 | 37.7726453040621 | -122.416711211162 | (37.7726453040621, -122.416711211162) |
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");