Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, PlantDate, DBH, PlotSize, PermitNotes
Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
10019 | 10019 | 173629 | Significant Tree 6 | Tibochina urvilleana :: Princess Flower 260 | 10X Junipero Serra Blvd Off Ramp | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 01/20/2017 12:00:00 AM | 3 | 3x3 | Permit Number 779383 | 5991168.0 | 2088425.0 | 37.713909732222 | -122.472421570074 | (37.713909732222, -122.472421570074) | |
19446 | 19446 | 4273 | Permitted Site 1 | Tibochina urvilleana :: Princess Flower 260 | 4203 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X3 | 6002547.21339 | 2100318.00727 | 37.747217275370005 | -122.43394038965599 | (37.74721727537, -122.433940389656) | |||
22401 | 22401 | 29571 | Permitted Site 1 | Tibochina urvilleana :: Princess Flower 260 | 195 Virginia Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3X3 | 6006671.740619999 | 2098479.46548 | 37.7424022556491 | -122.419547643218 | (37.7424022556491, -122.419547643218) | |||
24953 | 24953 | 215396 | Undocumented 2 | Tibochina urvilleana :: Princess Flower 260 | 338 Judson Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 2ft | 5997834.21693 | 2093590.2083700001 | 37.7284757708279 | -122.449752738393 | (37.7284757708279, -122.449752738393) | |||
24984 | 24984 | 215393 | Undocumented 2 | Tibochina urvilleana :: Princess Flower 260 | 442 Joost Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 10ft | 5999150.62225 | 2095003.22641 | 37.732430815627296 | -122.445303428036 | (37.7324308156273, -122.445303428036) | |||
26859 | 26859 | 215391 | Undocumented 2 | Tibochina urvilleana :: Princess Flower 260 | 906 Teresita Blvd | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 10ft | 5998840.72166 | 2095590.64849 | 37.7340260429642 | -122.446417067495 | (37.7340260429642, -122.446417067495) | |||
27076 | 27076 | 215380 | Undocumented 2 | Tibochina urvilleana :: Princess Flower 260 | 1209 Capitol Ave | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 3ft | 5995031.01707 | 2091921.9891099997 | 37.7237344631626 | -122.459322719284 | (37.7237344631626, -122.459322719284) | |||
28989 | 28989 | 241150 | Undocumented 2 | Tibochina urvilleana :: Princess Flower 260 | 1320 Diamond St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 3ft | 6001948.39861 | 2100174.85862 | 37.7467902223906 | -122.436000800312 | (37.7467902223906, -122.436000800312) | |||
31631 | 31631 | 215392 | Undocumented 2 | Tibochina urvilleana :: Princess Flower 260 | 371 Joost Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 2ft | 5999641.26044 | 2094937.86119 | 37.7322793329212 | -122.443602488063 | (37.7322793329212, -122.443602488063) | |||
32493 | 32493 | 215383 | Undocumented 2 | Tibochina urvilleana :: Princess Flower 260 | 270 Arch St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3 | Width 4ft | 5992739.059780001 | 2088994.50565 | 37.7155642635536 | -122.467032825702 | (37.7155642635536, -122.467032825702) | |||
33937 | 33937 | 179947 | Undocumented 2 | Tibochina urvilleana :: Princess Flower 260 | 371 Mount Vernon Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | 5998328.35697 | 2089789.74311 | 37.718068836793705 | -122.44777099236299 | (37.7180688367937, -122.447770992363) | ||||
40361 | 40361 | 179945 | Undocumented 2 | Tibochina urvilleana :: Princess Flower 260 | 229 Delano Ave | 15 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 4ft | 6000116.24367 | 2092335.5613400002 | 37.7251610981841 | -122.44177366991998 | (37.7251610981841, -122.44177366992) | |||
47211 | 47211 | 73458 | Undocumented 2 | Tibochina urvilleana :: Princess Flower 260 | 1111 Jones St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/13/1994 12:00:00 AM | 2 | 6008560.293219999 | 2116488.33177 | 37.7919566136559 | -122.41429148087299 | (37.7919566136559, -122.414291480873) | ||
51022 | 51022 | 179938 | Undocumented 2 | Tibochina urvilleana :: Princess Flower 260 | 1 Moneta Ct | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 4ft | 5997974.23427 | 2088065.64877 | 37.7133146238397 | -122.448870915378 | (37.7133146238397, -122.448870915378) | |||
56848 | 56848 | 215382 | Undocumented 2 | Tibochina urvilleana :: Princess Flower 260 | 272 Sadowa St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 4ft | 5994227.37153 | 2087794.2054299999 | 37.7123543178716 | -122.461801605154 | (37.7123543178716, -122.461801605154) | |||
58298 | 58298 | 53949 | Permitted Site 1 | Tibochina urvilleana :: Princess Flower 260 | 110 Gaven St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/01/2012 12:00:00 AM | 3 | Permit Number 769120 | 6009957.91529 | 2095221.76807 | 37.7336418732748 | -122.407955309198 | (37.7336418732748, -122.407955309198) | ||
63183 | 63183 | 179942 | Undocumented 2 | Tibochina urvilleana :: Princess Flower 260 | 200 Concord St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 1ft | 5999892.98718 | 2087090.8216799998 | 37.710747509960896 | -122.44216912700001 | (37.7107475099609, -122.442169127) | |||
65255 | 65255 | 78221 | Undocumented 2 | Tibochina urvilleana :: Princess Flower 260 | 1181 Bowdoin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/05/2000 12:00:00 AM | 5 | 6009695.80374 | 2090736.0766900002 | 37.721310432317 | -122.408545191616 | (37.721310432317, -122.408545191616) | ||
65256 | 65256 | 179946 | Undocumented 2 | Tibochina urvilleana :: Princess Flower 260 | 243 Ottawa Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 8ft | 5998318.770690001 | 2089304.69123 | 37.7167364480014 | -122.44776922787901 | (37.7167364480014, -122.447769227879) | |||
66384 | 66384 | 241149 | Undocumented 2 | Tibochina urvilleana :: Princess Flower 260 | 786 27th St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 6ft | 6001406.64604 | 2100012.02434 | 37.7463123262701 | -122.43786246348301 | (37.7463123262701, -122.437862463483) | |||
71669 | 71669 | 215378 | Undocumented 2 | Tibochina urvilleana :: Princess Flower 260 | 100 Vista Verde Ct | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 10ft | 5999253.01585 | 2096016.0483099998 | 37.7352176302864 | -122.44502221540199 | (37.7352176302864, -122.445022215402) | |||
72070 | 72070 | 179943 | Undocumented 2 | Tibochina urvilleana :: Princess Flower 260 | 200 Concord St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 1ft | 5999899.21161 | 2087069.2504599998 | 37.710688634952 | -122.442146066583 | (37.710688634952, -122.442146066583) | |||
72086 | 72086 | 179952 | Undocumented 2 | Tibochina urvilleana :: Princess Flower 260 | 607 Brussels St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 2ft | 6010912.05171 | 2091894.6102200001 | 37.7245595668681 | -122.404422449363 | (37.7245595668681, -122.404422449363) | |||
72303 | 72303 | 215379 | Undocumented 2 | Tibochina urvilleana :: Princess Flower 260 | 414 Detroit St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | 5999451.2824800005 | 2094469.70482 | 37.730983048317206 | -122.444225653487 | (37.7309830483172, -122.444225653487) | ||||
73783 | 73783 | 215385 | Undocumented 2 | Tibochina urvilleana :: Princess Flower 260 | 522 Bright St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 6 | Width 3ft | 5993803.26709 | 2090640.69025 | 37.7201456609819 | -122.46347386933701 | (37.7201456609819, -122.463473869337) | |||
79637 | 79637 | 94556 | Permitted Site 1 | Tibochina urvilleana :: Princess Flower 260 | 370X Mississippi St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/15/2010 12:00:00 AM | 2 | 3x3 | Permit Number 53731 | 6014056.0 | 2105274.0 | 37.761471765277 | -122.394490563972 | (37.761471765277, -122.394490563972) | |
88815 | 88815 | 101381 | Permitted Site 1 | Tibochina urvilleana :: Princess Flower 260 | 875 43rd Ave | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 10/18/2012 12:00:00 AM | Permit Number 769418 | 5982591.7 | 2109836.4 | 37.772199418349295 | -122.50364864512899 | (37.7721994183493, -122.503648645129) | |||
92631 | 92631 | 94557 | Permitted Site 1 | Tibochina urvilleana :: Princess Flower 260 | 370X Mississippi St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/15/2010 12:00:00 AM | 2 | 3x3 | Permit Number 53731 | 6014056.0 | 2105274.0 | 37.761471765277 | -122.394490563972 | (37.761471765277, -122.394490563972) | |
100672 | 100672 | 94554 | Permitted Site 1 | Tibochina urvilleana :: Princess Flower 260 | 1200 19th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/15/2010 12:00:00 AM | 2 | 3x3 | Permit Number 53731 | 6014056.0 | 2105274.0 | 37.761471765277 | -122.394490563972 | (37.761471765277, -122.394490563972) | |
112969 | 112969 | 94555 | Permitted Site 1 | Tibochina urvilleana :: Princess Flower 260 | 370X Mississippi St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/15/2010 12:00:00 AM | 2 | 3x3 | Permit Number 53731 | 6014056.0 | 2105274.0 | 37.761471765277 | -122.394490563972 | (37.761471765277, -122.394490563972) | |
117883 | 117883 | 94558 | Permitted Site 1 | Tibochina urvilleana :: Princess Flower 260 | 370X Mississippi St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/15/2010 12:00:00 AM | 2 | 3x3 | Permit Number 53731 | 6014056.0 | 2105274.0 | 37.761471765277 | -122.394490563972 | (37.761471765277, -122.394490563972) | |
127988 | 127988 | 96652 | Permitted Site 1 | Tibochina urvilleana :: Princess Flower 260 | 731 Clement St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/31/2012 12:00:00 AM | 3x3 | Permit Number 769486 | 5993295.0 | 2113455.0 | 37.7827585989517 | -122.46688843218901 | (37.7827585989517, -122.466888432189) | ||
131200 | 131200 | 215395 | Undocumented 2 | Tibochina urvilleana :: Princess Flower 260 | 582 Mangels Ave | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 10ft | 5997512.21245 | 2095297.31547 | 37.73314465248679 | -122.45098896718001 | (37.7331446524868, -122.45098896718) | |||
131436 | 131436 | 215388 | Undocumented 2 | Tibochina urvilleana :: Princess Flower 260 | 723 Detroit St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 10ft | 5999419.309780001 | 2095287.76027 | 37.7332274126104 | -122.444394956256 | (37.7332274126104, -122.444394956256) | |||
134677 | 134677 | 179944 | Undocumented 2 | Tibochina urvilleana :: Princess Flower 260 | 386 Teddy Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6009114.43117 | 2088706.36258 | 37.715704682790395 | -122.41041159512301 | (37.7157046827904, -122.410411595123) | |||
137638 | 137638 | 241148 | Undocumented 2 | Tibochina urvilleana :: Princess Flower 260 | 766 27th St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 10ft | 6001560.46361 | 2100021.36204 | 37.746346710948295 | -122.43733125015301 | (37.7463467109483, -122.437331250153) | |||
144440 | 144440 | 115766 | Permitted Site 1 | Tibochina urvilleana :: Princess Flower 260 | 161 De Soto St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/24/2016 12:00:00 AM | 3 | Permit Number 768395 | 5993291.8 | 2092241.0 | 37.7245102406902 | -122.46535801148501 | (37.7245102406902, -122.465358011485) | ||
145911 | 145911 | 215384 | Undocumented 2 | Tibochina urvilleana :: Princess Flower 260 | 724 Head St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 5ft | 5993537.5589 | 2090646.74234 | 37.72014696588 | -122.46439276513 | (37.72014696588, -122.46439276513) | |||
148002 | 148002 | 179948 | Undocumented 2 | Tibochina urvilleana :: Princess Flower 260 | 437 Peru Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 5ft | 6004719.22426 | 2092865.50598 | 37.7268774102596 | -122.425899335399 | (37.7268774102596, -122.425899335399) | |||
148021 | 148021 | 179940 | Undocumented 2 | Tibochina urvilleana :: Princess Flower 260 | 200 Concord St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 1ft | 5999884.04631 | 2087117.21058 | 37.7108194584206 | -122.442201921678 | (37.7108194584206, -122.442201921678) | |||
149817 | 149817 | 241151 | Undocumented 2 | Tibochina urvilleana :: Princess Flower 260 | 75 Whitney St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6004313.08095 | 2097743.41481 | 37.740248089789205 | -122.427650750683 | (37.7402480897892, -122.427650750683) | |||
154918 | 154918 | 179939 | Undocumented 2 | Tibochina urvilleana :: Princess Flower 260 | 102 France Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 1ft | 6001352.27901 | 2090234.00625 | 37.7194610538624 | -122.437350416488 | (37.7194610538624, -122.437350416488) | |||
158375 | 158375 | 241152 | Undocumented 2 | Tibochina urvilleana :: Princess Flower 260 | 3 Ohlone Way | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 4 | Width 3ft | 6002150.14382 | 2096511.4000799998 | 37.736742679035004 | -122.435041217385 | (37.736742679035, -122.435041217385) | |||
167837 | 167837 | 179949 | Undocumented 2 | Tibochina urvilleana :: Princess Flower 260 | 669 University St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 5ft | 6008688.540709999 | 2090962.7431 | 37.7218763478091 | -122.412043039082 | (37.7218763478091, -122.412043039082) | |||
168808 | 168808 | 215390 | Undocumented 2 | Tibochina urvilleana :: Princess Flower 260 | 833 Teresita Blvd | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 10ft | 5999141.71949 | 2095614.88342 | 37.7341097734514 | -122.445378170666 | (37.7341097734514, -122.445378170666) | |||
169690 | 169690 | 215394 | Undocumented 2 | Tibochina urvilleana :: Princess Flower 260 | 470 Joost Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | 5998974.60602 | 2094996.6587900002 | 37.732402733387204 | -122.445911483039 | (37.7324027333872, -122.445911483039) | ||||
174044 | 174044 | 78773 | Undocumented 2 | Tibochina urvilleana :: Princess Flower 260 | 820 Huron Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/21/2000 12:00:00 AM | 12 | 5997287.64063 | 2087195.26407 | 37.7108854587791 | -122.45118127819299 | (37.7108854587791, -122.451181278193) | ||
175589 | 175589 | 179951 | Undocumented 2 | Tibochina urvilleana :: Princess Flower 260 | 607 Brussels St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 2ft | 6010914.44854 | 2091887.55595 | 37.7245403312462 | -122.404413667483 | (37.7245403312462, -122.404413667483) | |||
178594 | 178594 | 136722 | Undocumented 2 | Tibochina urvilleana :: Princess Flower 260 | 420 Vallejo St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 10ft | 6011459.3679 | 2119062.9933700003 | 37.7991884363485 | -122.404441920581 | (37.7991884363485, -122.404441920581) | |||
179432 | 179432 | 179950 | Undocumented 2 | Tibochina urvilleana :: Princess Flower 260 | 100 Sweeny St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6010078.698580001 | 2095042.7198299998 | 37.733157006493 | -122.40752510501301 | (37.733157006493, -122.407525105013) | |||
180248 | 180248 | 215389 | Undocumented 2 | Tibochina urvilleana :: Princess Flower 260 | 83 Melrose Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | 5999561.07911 | 2095471.2143299999 | 37.7337392221924 | -122.443917999028 | (37.7337392221924, -122.443917999028) | ||||
182279 | 182279 | 215386 | Undocumented 2 | Tibochina urvilleana :: Princess Flower 260 | 425 Ulloa St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 3ft | 5995486.64342 | 2098345.49842 | 37.7413980438947 | -122.458212397395 | (37.7413980438947, -122.458212397395) | |||
182563 | 182563 | 179941 | Undocumented 2 | Tibochina urvilleana :: Princess Flower 260 | 200 Concord St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 1ft | 5999888.95629 | 2087101.1733900001 | 37.7107757037144 | -122.442183801236 | (37.7107757037144, -122.442183801236) | |||
182979 | 182979 | 215381 | Undocumented 2 | Tibochina urvilleana :: Princess Flower 260 | 750 Lakeview Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Width 4ft | 5994524.37821 | 2089948.25925 | 37.718285932216 | -122.460931089315 | (37.718285932216, -122.460931089315) | |||
184643 | 184643 | 215387 | Undocumented 2 | Tibochina urvilleana :: Princess Flower 260 | 139 Mangels Ave | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 10ft | 6000497.24486 | 2095192.00099 | 37.7330259239913 | -122.440661384821 | (37.7330259239913, -122.440661384821) |
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");