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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
30321 | 30321 | 132368 | Undocumented 2 | Pittosporum eugenioides :: Tarata 110 | 3100 Lyon St | 9 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 10ft | 5999060.82328 | 2119520.3698400003 | 37.7997435923452 | -122.44737790226999 | (37.7997435923452, -122.44737790227) | |||
31583 | 31583 | 132369 | Undocumented 2 | Pittosporum eugenioides :: Tarata 110 | 3100 Lyon St | 10 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 14 | Width 10ft | 5999059.80174 | 2119527.5303700003 | 37.7997631948618 | -122.44738195283199 | (37.7997631948618, -122.447381952832) | |||
32833 | 32833 | 132402 | Undocumented 2 | Pittosporum eugenioides :: Tarata 110 | 93 MacOndray Ln | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 15 | 6008127.0764 | 2119094.13477 | 37.7990871592098 | -122.41597503153 | (37.7990871592098, -122.41597503153) | ||||
33137 | 33137 | 132366 | Undocumented 2 | Pittosporum eugenioides :: Tarata 110 | 3100 Lyon St | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Width 10ft | 5999060.873319999 | 2119508.71315 | 37.7997115890667 | -122.44737688965 | (37.7997115890667, -122.44737688965) | |||
36060 | 36060 | 132385 | Undocumented 2 | Pittosporum eugenioides :: Tarata 110 | 1468 Greenwich St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 2ft | 6005829.912880001 | 2119675.1182 | 37.8005529731893 | -122.423965339721 | (37.8005529731893, -122.423965339721) | |||
37209 | 37209 | 178397 | Undocumented 2 | Pittosporum eugenioides :: Tarata 110 | 127 Athens St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | 6004928.6124599995 | 2092474.3613599997 | 37.7258152443728 | -122.42514766493 | (37.7258152443728, -122.42514766493) | ||||
41431 | 41431 | 132390 | Undocumented 2 | Pittosporum eugenioides :: Tarata 110 | 1468 Greenwich St | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 2ft | 6005781.1261599995 | 2119669.33652 | 37.8005343437344 | -122.42413375038099 | (37.8005343437344, -122.424133750381) | |||
46330 | 46330 | 178393 | Undocumented 2 | Pittosporum eugenioides :: Tarata 110 | 73 Capistrano Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | 6001400.33163 | 2093764.0907400001 | 37.729156597198795 | -122.437436967259 | (37.7291565971988, -122.437436967259) | ||||
46631 | 46631 | 132401 | Undocumented 2 | Pittosporum eugenioides :: Tarata 110 | 2745 Larkin St | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | 6006539.0247599995 | 2120646.9147799998 | 37.8032612878284 | -122.421580578682 | (37.8032612878284, -122.421580578682) | ||||
46960 | 46960 | 132377 | Undocumented 2 | Pittosporum eugenioides :: Tarata 110 | 20 Reed St | 9 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | 6008207.47508 | 2117062.00893 | 37.793511965045205 | -122.415552871766 | (37.7935119650452, -122.415552871766) | ||||
54276 | 54276 | 194583 | Undocumented 2 | Pittosporum eugenioides :: Tarata 110 | 1698 Galvez Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Width 8ft | 6015441.64874 | 2098018.63828 | 37.7416270022859 | -122.38919150780899 | (37.7416270022859, -122.389191507809) | |||
54754 | 54754 | 178398 | Undocumented 2 | Pittosporum eugenioides :: Tarata 110 | 300 Gaven St | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 4ft | 6008862.12496 | 2094845.7594299999 | 37.732548023354504 | -122.41171723086501 | (37.7325480233545, -122.411717230865) | |||
57415 | 57415 | 194585 | Undocumented 2 | Pittosporum eugenioides :: Tarata 110 | 1698 Galvez Ave | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Width 8ft | 6015429.91647 | 2098027.47569 | 37.741650617592 | -122.389232691343 | (37.741650617592, -122.389232691343) | |||
61763 | 61763 | 132373 | Undocumented 2 | Pittosporum eugenioides :: Tarata 110 | 20 Reed St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | 6008208.92851 | 2117034.44521 | 37.793436363556204 | -122.415545890356 | (37.7934363635562, -122.415545890356) | ||||
62614 | 62614 | 178399 | Undocumented 2 | Pittosporum eugenioides :: Tarata 110 | 339 Athens St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 2ft | 6004188.88481 | 2091298.12563 | 37.7225437445683 | -122.42762108566002 | (37.7225437445683, -122.42762108566) | |||
64368 | 64368 | 249601 | Undocumented 2 | Pittosporum eugenioides :: Tarata 110 | 2200 Golden Gate Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 17 | Width 3ft | 5998898.09787 | 2111497.4092 | 37.777705355751294 | -122.447363215433 | (37.7777053557513, -122.447363215433) | |||
64626 | 64626 | 132374 | Undocumented 2 | Pittosporum eugenioides :: Tarata 110 | 20 Reed St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 14 | 6008210.17068 | 2117040.38905 | 37.7934527536983 | -122.41554201335899 | (37.7934527536983, -122.415542013359) | ||||
69840 | 69840 | 132367 | Undocumented 2 | Pittosporum eugenioides :: Tarata 110 | 3100 Lyon St | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 15 | Width 10ft | 5999061.27495 | 2119513.94993 | 37.7997259908076 | -122.44737587699801 | (37.7997259908076, -122.447375876998) | |||
69854 | 69854 | 132400 | Undocumented 2 | Pittosporum eugenioides :: Tarata 110 | 2745 Larkin St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | 6006513.749919999 | 2120658.41667 | 37.8032914438996 | -122.421668860656 | (37.8032914438996, -122.421668860656) | ||||
70254 | 70254 | 122245 | Undocumented 2 | Pittosporum eugenioides :: Tarata 110 | 47 Lake St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Width 3ft | 5990779.800559999 | 2114787.3723 | 37.7862714344884 | -122.47568719317199 | (37.7862714344884, -122.475687193172) | |||
71019 | 71019 | 132386 | Undocumented 2 | Pittosporum eugenioides :: Tarata 110 | 1468 Greenwich St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 2ft | 6005813.32494 | 2119673.13314 | 37.8005465862138 | -122.42402259955799 | (37.8005465862138, -122.424022599558) | |||
73279 | 73279 | 132378 | Undocumented 2 | Pittosporum eugenioides :: Tarata 110 | 20 Reed St | 10 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 14 | 6008205.50053 | 2117066.58011 | 37.7935244053907 | -122.415560027676 | (37.7935244053907, -122.415560027676) | ||||
75547 | 75547 | 132405 | Undocumented 2 | Pittosporum eugenioides :: Tarata 110 | 2671 Leavenworth St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 14 | 6007317.65081 | 2121868.01026 | 37.8066579786473 | -122.418972771382 | (37.8066579786473, -122.418972771382) | ||||
75850 | 75850 | 132406 | Undocumented 2 | Pittosporum eugenioides :: Tarata 110 | 2671 Leavenworth St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 25 | 6007315.11916 | 2121861.5465700002 | 37.8066400884465 | -122.41898107391701 | (37.8066400884465, -122.418981073917) | ||||
89513 | 89513 | 132372 | Undocumented 2 | Pittosporum eugenioides :: Tarata 110 | 20 Reed St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | 6008211.08199 | 2117028.50784 | 37.793420182046 | -122.41553801857401 | (37.793420182046, -122.415538018574) | ||||
93214 | 93214 | 132388 | Undocumented 2 | Pittosporum eugenioides :: Tarata 110 | 1468 Greenwich St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 2ft | 6005798.70292 | 2119672.07683 | 37.800542860316 | -122.424073122581 | (37.800542860316, -122.424073122581) | |||
130402 | 130402 | 132376 | Undocumented 2 | Pittosporum eugenioides :: Tarata 110 | 20 Reed St | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | 6008205.53038 | 2117047.83844 | 37.793472947059605 | -122.41555859686001 | (37.7934729470596, -122.41555859686) | ||||
133226 | 133226 | 122244 | Undocumented 2 | Pittosporum eugenioides :: Tarata 110 | 47 Lake St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 3ft | 5990784.64686 | 2114787.2699700003 | 37.7862714344765 | -122.475670418927 | (37.7862714344765, -122.475670418927) | |||
148064 | 148064 | 132371 | Undocumented 2 | Pittosporum eugenioides :: Tarata 110 | 20 Reed St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | 6008212.2961800005 | 2117019.5633099996 | 37.7933956908179 | -122.41553318381399 | (37.7933956908179, -122.415533183814) | ||||
155205 | 155205 | 132370 | Undocumented 2 | Pittosporum eugenioides :: Tarata 110 | 20 Reed St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 14 | 6008212.89333 | 2117013.5005900003 | 37.793379077646996 | -122.415530688191 | (37.793379077647, -122.415530688191) | ||||
155644 | 155644 | 194584 | Undocumented 2 | Pittosporum eugenioides :: Tarata 110 | 1698 Galvez Ave | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 8ft | 6015435.57046 | 2098024.5169599997 | 37.7416428069711 | -122.389212935026 | (37.7416428069711, -122.389212935026) | |||
163158 | 163158 | 132375 | Undocumented 2 | Pittosporum eugenioides :: Tarata 110 | 20 Reed St | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | 6008208.36982 | 2117045.10307 | 37.793465596010996 | -122.41554857839701 | (37.793465596011, -122.415548578397) | ||||
166409 | 166409 | 187083 | Undocumented 2 | Pittosporum eugenioides :: Tarata 110 | 2600 Sunset Blvd | 19 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 0ft | 5985170.5104 | 2097012.8962 | 37.7371408955553 | -122.49378330233499 | (37.7371408955553, -122.493783302335) | |||
168536 | 168536 | 132404 | Undocumented 2 | Pittosporum eugenioides :: Tarata 110 | 2671 Leavenworth St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 14 | 6007312.64985 | 2121879.37275 | 37.806688895542294 | -122.418990884623 | (37.8066888955423, -122.418990884623) | ||||
178667 | 178667 | 123936 | Undocumented 2 | Pittosporum eugenioides :: Tarata 110 | 1 08th Ave | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 31 | Width 3ft | 5993306.8177 | 2114889.70076 | 37.786698577308705 | -122.466951883723 | (37.7866985773087, -122.466951883723) | |||
180543 | 180543 | 194589 | Undocumented 2 | Pittosporum eugenioides :: Tarata 110 | 11 Bridgeview Way | 17 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | 6016121.54622 | 2108188.95403 | 37.7695902108346 | -122.387549998659 | (37.7695902108346, -122.387549998659) | ||||
183631 | 183631 | 194586 | Undocumented 2 | Pittosporum eugenioides :: Tarata 110 | 1698 Galvez Ave | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Width 8ft | 6015412.99907 | 2098039.7697 | 37.7416834365362 | -122.38929204481701 | (37.7416834365362, -122.389292044817) | |||
185315 | 185315 | 132360 | Undocumented 2 | Pittosporum eugenioides :: Tarata 110 | 2801 Pierce St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 2ft | 6001534.76184 | 2118041.80057 | 37.795824887369896 | -122.43871117439 | (37.7958248873699, -122.43871117439) | |||
185912 | 185912 | 178400 | Undocumented 2 | Pittosporum eugenioides :: Tarata 110 | 802 Excelsior Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 6ft | 6004451.61665 | 2091406.41613 | 37.7228559442383 | -122.426720588195 | (37.7228559442383, -122.426720588195) | |||
188984 | 188984 | 132403 | Undocumented 2 | Pittosporum eugenioides :: Tarata 110 | 93 MacOndray Ln | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 17 | 6008160.59399 | 2119098.20458 | 37.799100218256704 | -122.415859337341 | (37.7991002182567, -122.415859337341) |
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");