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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1188 | 1188 | 251477 | Undocumented 2 | Pittosporum eugenioides :: Tarata 110 | 1590 Lyon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5999686.0 | 2114300.0 | 37.785445538345996 | -122.444839109459 | (37.785445538346, -122.444839109459) | ||||
3410 | 3410 | 55823 | Permitted Site 1 | Pittosporum eugenioides :: Tarata 110 | 107 11th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/09/1973 12:00:00 AM | 9 | Permit Number 11871 | 5992391.10091 | 2114722.33212 | 37.7861861336889 | -122.470107824331 | (37.7861861336889, -122.470107824331) | ||
3467 | 3467 | 123897 | Undocumented 2 | Pittosporum eugenioides :: Tarata 110 | 107 11th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5992391.187940001 | 2114716.46428 | 37.7861700272505 | -122.47010709580299 | (37.7861700272505, -122.470107095803) | |||
7914 | 7914 | 20395 | DPW Maintained 3 | Pittosporum eugenioides :: Tarata 110 | 262X Sunset Blvd | 40 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 60 | ||||||||
10558 | 10558 | 919 | DPW Maintained 3 | Pittosporum eugenioides :: Tarata 110 | 1249 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/19/2016 10:57:00 AM | 3 | 3X3 | 6002980.09082 | 2094114.94313 | 37.730209644839896 | -122.432000656304 | (37.7302096448399, -122.432000656304) | ||
13893 | 13893 | 26015 | Permitted Site 1 | Pittosporum eugenioides :: Tarata 110 | 1638 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/05/1997 12:00:00 AM | 3 | 3X3 | 6014725.62148 | 2095748.6278099997 | 37.7353543002582 | -122.391508646128 | (37.7353543002582, -122.391508646128) | ||
21025 | 21025 | 28135 | DPW Maintained 3 | Pittosporum eugenioides :: Tarata 110 | 412 Eugenia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 8 | 3X4 | 6006927.15214 | 2097902.80661 | 37.740833262445996 | -122.418623621291 | (37.740833262446, -122.418623621291) | |||
25008 | 25008 | 233964 | Undocumented 2 | Pittosporum eugenioides :: Tarata 110 | 16 Parnassus Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 4ft | 5998642.1251 | 2106932.6031299997 | 37.7651569326801 | -122.44791997764798 | (37.7651569326801, -122.447919977648) | |||
26376 | 26376 | 233965 | Undocumented 2 | Pittosporum eugenioides :: Tarata 110 | 16 Parnassus Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 4ft | 5998630.023569999 | 2106931.63106 | 37.765153571896896 | -122.44796176374099 | (37.7651535718969, -122.447961763741) | |||
27575 | 27575 | 52011 | Permitted Site 1 | Pittosporum eugenioides :: Tarata 110 | 427 38th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Permit Number 48229 | 5984051.86025 | 2112939.27176 | 37.7808047486161 | -122.498827177749 | (37.7808047486161, -122.498827177749) | |||
31835 | 31835 | 120792 | Undocumented 2 | Pittosporum eugenioides :: Tarata 110 | 547 21st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 5989370.9651 | 2111615.14329 | 37.777479605996795 | -122.48032907033001 | (37.7774796059968, -122.48032907033) | |||
32365 | 32365 | 233960 | Undocumented 2 | Pittosporum eugenioides :: Tarata 110 | 329 Montcalm St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6009458.35232 | 2099567.9895200003 | 37.7455476723052 | -122.409989165578 | (37.7455476723052, -122.409989165578) | |||
33012 | 33012 | 211434 | Undocumented 2 | Pittosporum eugenioides :: Tarata 110 | 910 Kirkham St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 1ft | 5992028.493840001 | 2105269.75757 | 37.760210948307794 | -122.47067358802299 | (37.7602109483078, -122.470673588023) | |||
44513 | 44513 | 233959 | Undocumented 2 | Pittosporum eugenioides :: Tarata 110 | 101 Albion St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 4ft | 6005908.695780001 | 2106579.49211 | 37.7646000472828 | -122.422761537821 | (37.7646000472828, -122.422761537821) | |||
48017 | 48017 | 178395 | Undocumented 2 | Pittosporum eugenioides :: Tarata 110 | 61 Lisbon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6003678.4559 | 2093041.21797 | 37.727301003537505 | -122.429509772582 | (37.7273010035375, -122.429509772582) | |||
48727 | 48727 | 30819 | DPW Maintained 3 | Pittosporum eugenioides :: Tarata 110 | 151 Lippard Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/06/1995 12:00:00 AM | 4 | Permit Number 34679 | 6001850.40599 | 2095237.97524 | 37.733229124016496 | -122.435986447137 | (37.7332291240165, -122.435986447137) | ||
57273 | 57273 | 233963 | Undocumented 2 | Pittosporum eugenioides :: Tarata 110 | 16 Parnassus Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 4ft | 5998658.62775 | 2106938.30224 | 37.7651735242683 | -122.447863309551 | (37.7651735242683, -122.447863309551) | |||
57438 | 57438 | 62163 | Permitted Site 1 | Pittosporum eugenioides :: Tarata 110 | 80 Santa Ynez Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/30/1985 12:00:00 AM | 11 | Permit Number 22278 | 6000618.37391 | 2092117.41472 | 37.724590715777396 | -122.440022226756 | (37.7245907157774, -122.440022226756) | |
62454 | 62454 | 233971 | Undocumented 2 | Pittosporum eugenioides :: Tarata 110 | 175 Clifford Ter | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 5999325.700119999 | 2106527.04149 | 37.7640824109973 | -122.44552650036002 | (37.7640824109973, -122.44552650036) | |||
66180 | 66180 | 211450 | Undocumented 2 | Pittosporum eugenioides :: Tarata 110 | 186 Merced Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 4ft | 5994246.46565 | 2099200.24413 | 37.7436736209515 | -122.462562455004 | (37.7436736209515, -122.462562455004) | |||
66218 | 66218 | 233975 | Undocumented 2 | Pittosporum eugenioides :: Tarata 110 | 3786 16th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6001886.12679 | 2106432.54375 | 37.76396878345871 | -122.43666398285299 | (37.7639687834587, -122.436663982853) | |||
72992 | 72992 | 233966 | Undocumented 2 | Pittosporum eugenioides :: Tarata 110 | 16 Parnassus Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 4ft | 5998617.81903 | 2106930.99425 | 37.765151125749995 | -122.448003930257 | (37.76515112575, -122.448003930257) | |||
77181 | 77181 | 132389 | Undocumented 2 | Pittosporum eugenioides :: Tarata 110 | 1468 Greenwich St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 6005789.48501 | 2119659.27806 | 37.8005071977157 | -122.42410410961901 | (37.8005071977157, -122.424104109619) | |||
77572 | 77572 | 81877 | Permitted Site 1 | Pittosporum eugenioides :: Tarata 110 | 1380 12th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/23/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773644 | 5992433.71699481 | 2106077.08224854 | 37.7624510738005 | -122.46933088918699 | (37.7624510738005, -122.469330889187) |
94154 | 94154 | 9335 | DPW Maintained 3 | Pittosporum eugenioides :: Tarata 110 | 179 Gold Mine Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 20 | 3X3 | 6000859.3677258 | 2098666.8406913998 | 37.742587635250004 | -122.439658461234 | (37.74258763525, -122.439658461234) | |||
98282 | 98282 | 2776 | DPW Maintained 3 | Pittosporum eugenioides :: Tarata 110 | 331 Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 25 | 4X4 | 5994564.223130001 | 2110735.25562 | 37.775364081338 | -122.462300169147 | (37.775364081338, -122.462300169147) | |||
100796 | 100796 | 64213 | Permitted Site 1 | Pittosporum eugenioides :: Tarata 110 | 1625 Carroll Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/15/1988 12:00:00 AM | 5 | Permit Number 25004 | 6013920.481000001 | 2092092.5018 | 37.7252706002708 | -122.39403647132099 | (37.7252706002708, -122.394036471321) | ||
130991 | 130991 | 211451 | Undocumented 2 | Pittosporum eugenioides :: Tarata 110 | 151 Lippard Ave | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6001863.37782 | 2095280.7937599998 | 37.7333474307441 | -122.435944662819 | (37.7333474307441, -122.435944662819) | |||
135796 | 135796 | 233974 | Undocumented 2 | Pittosporum eugenioides :: Tarata 110 | 2315 15th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6002049.59534 | 2107034.31873 | 37.7656303987394 | -122.436141661111 | (37.7656303987394, -122.436141661111) | |||
136421 | 136421 | 211445 | Undocumented 2 | Pittosporum eugenioides :: Tarata 110 | 1313 Bosworth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6000197.7982 | 2096452.6133 | 37.736470213222 | -122.441787089628 | (37.736470213222, -122.441787089628) | |||
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) | ||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) |
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");