Data source: data.sfgov.org
This data as json, CSV (advanced)
Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
138989 | 138989 | 211449 | Undocumented 2 | Pittosporum eugenioides :: Tarata 110 | 1554 10th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5993091.38036 | 2104901.42473 | 37.759261008817 | -122.466970818352 | (37.759261008817, -122.466970818352) | |||
147932 | 147932 | 233969 | Undocumented 2 | Pittosporum eugenioides :: Tarata 110 | 59 Parnassus Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 4ft | 5998431.96444 | 2106860.6202700003 | 37.7649472710115 | -122.448641684483 | (37.7649472710115, -122.448641684483) | |||
147937 | 147937 | 30820 | DPW Maintained 3 | Pittosporum eugenioides :: Tarata 110 | 151 Lippard Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/06/1995 12:00:00 AM | 7 | Permit Number 34679 | 6001842.2487 | 2095205.8891900002 | 37.7331405596841 | -122.43601235390601 | (37.7331405596841, -122.436012353906) | ||
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) | ||||
151839 | 151839 | 211443 | DPW Maintained 3 | Pittosporum eugenioides :: Tarata 110 | 200x Terrace Dr | 29 | Median : Yard 3 | Tree 1 | DPW 2 | 15 | 5993804.85557 | 2096543.20667 | 37.7363526187711 | -122.46389659834601 | (37.7363526187711, -122.463896598346) | ||||
154786 | 154786 | 211435 | Undocumented 2 | Pittosporum eugenioides :: Tarata 110 | 29 Madrone Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5992967.24158 | 2098952.48262 | 37.742919578079096 | -122.466967656341 | (37.7429195780791, -122.466967656341) | |||
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) | ||||
155600 | 155600 | 247629 | Undocumented 2 | Pittosporum eugenioides :: Tarata 110 | 286 Bradford St | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | 12 | 6009493.3855 | 2096955.4623099999 | 37.738376205786096 | -122.409683658684 | (37.7383762057861, -122.409683658684) | ||||
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) | |||
155855 | 155855 | 132392 | Undocumented 2 | Pittosporum eugenioides :: Tarata 110 | 2833 Larkin St | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 16 | 6006479.362930001 | 2120932.81603 | 37.8040429353981 | -122.421807360741 | (37.8040429353981, -122.421807360741) | ||||
157645 | 157645 | 233961 | Undocumented 2 | Pittosporum eugenioides :: Tarata 110 | 107 Valley St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 4ft | 6005126.403519999 | 2099291.88165 | 37.744545799654006 | -122.424948746605 | (37.744545799654, -122.424948746605) | |||
159996 | 159996 | 194590 | Undocumented 2 | Pittosporum eugenioides :: Tarata 110 | 13 Bridgeview Way | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 6ft | 6016094.38858 | 2108337.40723 | 37.7699963267064 | -122.387654295729 | (37.7699963267064, -122.387654295729) | |||
160795 | 160795 | 211447 | Undocumented 2 | Pittosporum eugenioides :: Tarata 110 | 4140 19th Ave | 1 | : 4 | Tree 1 | Private 1 | 8 | Width 3ft | 5992076.98829 | 2088316.96105 | 37.7136656526261 | -122.46927193614599 | (37.7136656526261, -122.469271936146) | |||
160987 | 160987 | 132361 | Undocumented 2 | Pittosporum eugenioides :: Tarata 110 | 3455 Washington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5998256.938519999 | 2115827.3267200002 | 37.7895575156245 | -122.449893326728 | (37.7895575156245, -122.449893326728) | |||
162232 | 162232 | 211438 | DPW Maintained 3 | Pittosporum eugenioides :: Tarata 110 | 200x Terrace Dr | 18 | Median : Yard 3 | Tree 1 | DPW 2 | 14 | 5993827.4148 | 2096523.2728799998 | 37.736299185562004 | -122.463817155848 | (37.736299185562, -122.463817155848) | ||||
162959 | 162959 | 132382 | Undocumented 2 | Pittosporum eugenioides :: Tarata 110 | 1713 Taylor St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 4ft | 6008728.03476 | 2118737.75818 | 37.798142406100396 | -122.413870282493 | (37.7981424061004, -122.413870282493) | |||
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) | ||||
164737 | 164737 | 211437 | DPW Maintained 3 | Pittosporum eugenioides :: Tarata 110 | 200x Terrace Dr | 13 | Median : Yard 3 | Tree 1 | DPW 2 | 15 | 5993819.380340001 | 2096502.3277900002 | 37.736241212547796 | -122.463843414267 | (37.7362412125478, -122.463843414267) | ||||
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) | |||
167782 | 167782 | 233962 | Undocumented 2 | Pittosporum eugenioides :: Tarata 110 | 341 Day St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6003741.086630001 | 2098630.21283 | 37.7426506619089 | -122.429691709917 | (37.7426506619089, -122.429691709917) | |||
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) | ||||
168962 | 168962 | 194577 | Undocumented 2 | Pittosporum eugenioides :: Tarata 110 | 580 Missouri St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 9 | Width 4ft | 6013511.640380001 | 2104375.7087 | 37.7589749767275 | -122.396310329764 | (37.7589749767275, -122.396310329764) | |||
170091 | 170091 | 200714 | Undocumented 2 | Pittosporum eugenioides :: Tarata 110 | 1494 Newcomb Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 6015811.8614 | 2095290.2381 | 37.7341558860556 | -122.38772110560801 | (37.7341558860556, -122.387721105608) | |||
170256 | 170256 | 211446 | Undocumented 2 | Pittosporum eugenioides :: Tarata 110 | 1313 Bosworth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6000201.81389 | 2096459.5971 | 37.736489617908504 | -122.441773706798 | (37.7364896179085, -122.441773706798) | |||
170663 | 170663 | 178394 | Undocumented 2 | Pittosporum eugenioides :: Tarata 110 | 25 Capistrano Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6001248.99944 | 2093921.6644099997 | 37.7295806536223 | -122.437971416359 | (37.7295806536223, -122.437971416359) | |||
172452 | 172452 | 132380 | Undocumented 2 | Pittosporum eugenioides :: Tarata 110 | 1680 Taylor St | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 3ft | 6008764.121730001 | 2118820.69014 | 37.7983721433051 | -122.4137512797 | (37.7983721433051, -122.4137512797) | |||
174727 | 174727 | 120791 | Undocumented 2 | Pittosporum eugenioides :: Tarata 110 | 539 21st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5989368.66682 | 2111666.19394 | 37.7776196433358 | -122.48034075829901 | (37.7776196433358, -122.480340758299) | |||
174774 | 174774 | 247626 | Undocumented 2 | Pittosporum eugenioides :: Tarata 110 | 286 Bradford St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 8 | 6009494.96271 | 2096975.4044400002 | 37.7384310509429 | -122.40967961262501 | (37.7384310509429, -122.409679612625) | ||||
176305 | 176305 | 123898 | Undocumented 2 | Pittosporum eugenioides :: Tarata 110 | 107 11th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 5992390.460969999 | 2114751.88478 | 37.786267240143204 | -122.47011219103901 | (37.7862672401432, -122.470112191039) | |||
176993 | 176993 | 132379 | Undocumented 2 | Pittosporum eugenioides :: Tarata 110 | 1680 Taylor St | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 3ft | 6008770.01559 | 2118776.57909 | 37.7982513562644 | -122.41372776333401 | (37.7982513562644, -122.413727763334) | |||
177265 | 177265 | 132399 | Undocumented 2 | Pittosporum eugenioides :: Tarata 110 | 2836 Larkin St | 5 | Side Yard : Yard 17 | Tree 1 | Private 1 | 12 | 6006512.34183 | 2120961.63143 | 37.8041239148476 | -122.421695282708 | (37.8041239148476, -122.421695282708) | ||||
177634 | 177634 | 132387 | Undocumented 2 | Pittosporum eugenioides :: Tarata 110 | 1468 Greenwich St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 6005806.0966 | 2119662.42569 | 37.8005167781868 | -122.424046850703 | (37.8005167781868, -122.424046850703) | |||
177814 | 177814 | 233970 | Undocumented 2 | Pittosporum eugenioides :: Tarata 110 | 59 Parnassus Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 4ft | 5998449.53316 | 2106863.1940099997 | 37.7649553424266 | -122.448581104347 | (37.7649553424266, -122.448581104347) | |||
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) | |||
179351 | 179351 | 211452 | Undocumented 2 | Pittosporum eugenioides :: Tarata 110 | 151 Lippard Ave | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6001868.44075 | 2095314.06759 | 37.7334390806456 | -122.435929538915 | (37.7334390806456, -122.435929538915) | |||
179438 | 179438 | 123101 | Undocumented 2 | Pittosporum eugenioides :: Tarata 110 | 507 11th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5992491.93935 | 2111979.1338299997 | 37.7786598912114 | -122.469559186337 | (37.7786598912114, -122.469559186337) | |||
179658 | 179658 | 211444 | Undocumented 2 | Pittosporum eugenioides :: Tarata 110 | 230 Terrace Walk | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5993933.81499 | 2096496.4597200002 | 37.7362316941337 | -122.46344734382299 | (37.7362316941337, -122.463447343823) | |||
180280 | 180280 | 132362 | Undocumented 2 | Pittosporum eugenioides :: Tarata 110 | 3455 Washington St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5998243.11414 | 2115825.0285900002 | 37.7895504145686 | -122.449940991703 | (37.7895504145686, -122.449940991703) | |||
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) | ||||
182363 | 182363 | 178396 | Undocumented 2 | Pittosporum eugenioides :: Tarata 110 | 55 Lisbon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6003704.97004 | 2093083.05909 | 37.7274173910959 | -122.42942109582899 | (37.7274173910959, -122.429421095829) | |||
182684 | 182684 | 233967 | Undocumented 2 | Pittosporum eugenioides :: Tarata 110 | 26 Parnassus Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 4ft | 5998528.05079 | 2106918.36073 | 37.765111305559294 | -122.448313505688 | (37.7651113055593, -122.448313505688) | |||
183127 | 183127 | 132384 | Undocumented 2 | Pittosporum eugenioides :: Tarata 110 | 1468 Greenwich St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 2ft | 6005841.24215 | 2119667.51872 | 37.80053274655629 | -122.4239255951 | (37.8005327465563, -122.4239255951) | |||
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) | |||
184440 | 184440 | 247639 | Undocumented 2 | Pittosporum eugenioides :: Tarata 110 | 360 Bradford St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 8ft | 6009456.29127 | 2096556.43991 | 37.7372784977969 | -122.409783755028 | (37.7372784977969, -122.409783755028) | |||
185008 | 185008 | 233968 | Undocumented 2 | Pittosporum eugenioides :: Tarata 110 | 59 Parnassus Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 4ft | 5998414.25263 | 2106859.15364 | 37.7649422312277 | -122.448702839263 | (37.7649422312277, -122.448702839263) | |||
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");