Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, PlantType, qCaretaker, qCareAssistant
| Link | rowid | TreeID ▲ | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4992 | 4992 | 253754 | Planning Code 138.1 required 4 | Lophostemon confertus :: Brisbane Box 11 | 2x Rhode Island St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/03/2017 12:00:00 AM | 3 | 3x6 | 6011517.0 | 2108140.0 | 37.769199681039794 | -122.403473604048 | (37.7691996810398, -122.403473604048) | ||
| 4947 | 4947 | 253753 | Planning Code 138.1 required 4 | Lophostemon confertus :: Brisbane Box 11 | 2x Rhode Island St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/03/2017 12:00:00 AM | 3 | 3x6 | 6011517.0 | 2108140.0 | 37.769199681039794 | -122.403473604048 | (37.7691996810398, -122.403473604048) | ||
| 4951 | 4951 | 253752 | Planning Code 138.1 required 4 | Lophostemon confertus :: Brisbane Box 11 | 2x Rhode Island St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/03/2017 12:00:00 AM | 3 | 3x6 | 6011517.0 | 2108140.0 | 37.769199681039794 | -122.403473604048 | (37.7691996810398, -122.403473604048) | ||
| 4966 | 4966 | 253751 | Planning Code 138.1 required 4 | Lophostemon confertus :: Brisbane Box 11 | 2x Rhode Island St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/03/2017 12:00:00 AM | 3 | 3x6 | 6011517.0 | 2108140.0 | 37.769199681039794 | -122.403473604048 | (37.7691996810398, -122.403473604048) | ||
| 4961 | 4961 | 253750 | Planning Code 138.1 required 4 | Lophostemon confertus :: Brisbane Box 11 | 2x Rhode Island St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/03/2017 12:00:00 AM | 3 | 3x6 | 6011517.0 | 2108140.0 | 37.769199681039794 | -122.403473604048 | (37.7691996810398, -122.403473604048) | ||
| 5009 | 5009 | 253747 | Planning Code 138.1 required 4 | Lophostemon confertus :: Brisbane Box 11 | 2x Rhode Island St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/03/2017 12:00:00 AM | 3 | 3x6 | 6011517.0 | 2108140.0 | 37.769199681039794 | -122.403473604048 | (37.7691996810398, -122.403473604048) | ||
| 4958 | 4958 | 253746 | Planning Code 138.1 required 4 | Lophostemon confertus :: Brisbane Box 11 | 1 Henry Adams St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/03/2017 12:00:00 AM | 3 | 3x6 | 6011517.0 | 2108140.0 | 37.769199681039794 | -122.403473604048 | (37.7691996810398, -122.403473604048) | ||
| 5036 | 5036 | 253745 | Planning Code 138.1 required 4 | Lophostemon confertus :: Brisbane Box 11 | 1 Henry Adams St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/03/2017 12:00:00 AM | 3 | 3x6 | 6011517.0 | 2108140.0 | 37.769199681039794 | -122.403473604048 | (37.7691996810398, -122.403473604048) | ||
| 5026 | 5026 | 253744 | Planning Code 138.1 required 4 | Lophostemon confertus :: Brisbane Box 11 | 1 Henry Adams St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/03/2017 12:00:00 AM | 3 | 3x6 | 6011517.0 | 2108140.0 | 37.769199681039794 | -122.403473604048 | (37.7691996810398, -122.403473604048) | ||
| 4932 | 4932 | 253743 | Planning Code 138.1 required 4 | Lophostemon confertus :: Brisbane Box 11 | 1 Henry Adams St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/03/2017 12:00:00 AM | 3 | 3x6 | 6011517.0 | 2108140.0 | 37.769199681039794 | -122.403473604048 | (37.7691996810398, -122.403473604048) | ||
| 4997 | 4997 | 253742 | Planning Code 138.1 required 4 | Lophostemon confertus :: Brisbane Box 11 | 1 Henry Adams St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/03/2017 12:00:00 AM | 3 | 3x6 | 6011517.0 | 2108140.0 | 37.769199681039794 | -122.403473604048 | (37.7691996810398, -122.403473604048) | ||
| 4941 | 4941 | 253741 | Planning Code 138.1 required 4 | Lophostemon confertus :: Brisbane Box 11 | 1 Henry Adams St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/03/2017 12:00:00 AM | 3 | 3x6 | 6011517.0 | 2108140.0 | 37.769199681039794 | -122.403473604048 | (37.7691996810398, -122.403473604048) | ||
| 5032 | 5032 | 253740 | Planning Code 138.1 required 4 | Lophostemon confertus :: Brisbane Box 11 | 1 Henry Adams St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/03/2017 12:00:00 AM | 3 | 3x6 | 6011517.0 | 2108140.0 | 37.769199681039794 | -122.403473604048 | (37.7691996810398, -122.403473604048) | ||
| 4999 | 4999 | 253739 | Planning Code 138.1 required 4 | Lophostemon confertus :: Brisbane Box 11 | 1 Henry Adams St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/03/2017 12:00:00 AM | 3 | 3x6 | 6011517.0 | 2108140.0 | 37.769199681039794 | -122.403473604048 | (37.7691996810398, -122.403473604048) | ||
| 5027 | 5027 | 253738 | Planning Code 138.1 required 4 | Lophostemon confertus :: Brisbane Box 11 | 1 Henry Adams St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/03/2017 12:00:00 AM | 3 | 3x6 | 6011517.0 | 2108140.0 | 37.769199681039794 | -122.403473604048 | (37.7691996810398, -122.403473604048) | ||
| 5010 | 5010 | 253737 | Planning Code 138.1 required 4 | Lophostemon confertus :: Brisbane Box 11 | 1 Henry Adams St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/03/2017 12:00:00 AM | 3 | 3x6 | 6011517.0 | 2108140.0 | 37.769199681039794 | -122.403473604048 | (37.7691996810398, -122.403473604048) | ||
| 5024 | 5024 | 253736 | Planning Code 138.1 required 4 | Lophostemon confertus :: Brisbane Box 11 | 1 Henry Adams St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/03/2017 12:00:00 AM | 3 | 3x6 | 6011517.0 | 2108140.0 | 37.769199681039794 | -122.403473604048 | (37.7691996810398, -122.403473604048) | ||
| 4954 | 4954 | 253735 | Planning Code 138.1 required 4 | Lophostemon confertus :: Brisbane Box 11 | 1 Henry Adams St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/03/2017 12:00:00 AM | 3 | 3x6 | 6011517.0 | 2108140.0 | 37.769199681039794 | -122.403473604048 | (37.7691996810398, -122.403473604048) | ||
| 4839 | 4839 | 253523 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 134 09th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/26/2017 12:00:00 AM | 3 | 3x3 | Permit Number 780901 | 6008429.0 | 2110577.0 | 37.7757181448456 | -122.41432731709801 | (37.7757181448456, -122.414327317098) | |
| 4835 | 4835 | 253522 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 134 09th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/26/2017 12:00:00 AM | 3 | 3x3 | Permit Number 780901 | 6008429.0 | 2110577.0 | 37.7757181448456 | -122.41432731709801 | (37.7757181448456, -122.414327317098) | |
| 3670 | 3670 | 253512 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 2498 Lombard St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/03/1997 12:00:00 AM | 3x3 | 6000414.87165 | 2119245.42001 | 37.7990659347341 | -122.442672656788 | (37.7990659347341, -122.442672656788) | |||
| 3305 | 3305 | 253412 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 1321 Mission St | 4 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | 08/30/2017 12:00:00 AM | 3 | 4x12 | Permit Number 775218 | 6008256.52806819 | 2110680.03106396 | 37.775991353803896 | -122.414931236288 | (37.7759913538039, -122.414931236288) | |
| 3287 | 3287 | 253411 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 1321 Mission St | 3 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | 08/30/2017 12:00:00 AM | 3 | 4x12 | Permit Number 775218 | 6008256.52806819 | 2110680.03106396 | 37.775991353803896 | -122.414931236288 | (37.7759913538039, -122.414931236288) | |
| 3295 | 3295 | 253410 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 1321 Mission St | 2 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | 08/30/2017 12:00:00 AM | 3 | 4x12 | Permit Number 775218 | 6008256.52806819 | 2110680.03106396 | 37.775991353803896 | -122.414931236288 | (37.7759913538039, -122.414931236288) | |
| 3292 | 3292 | 253409 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 1321 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | 08/30/2017 12:00:00 AM | 3 | 4x12 | Permit Number 775218 | 6008256.52806819 | 2110680.03106396 | 37.775991353803896 | -122.414931236288 | (37.7759913538039, -122.414931236288) | |
| 3023 | 3023 | 253281 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 1775 Waller St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Width 0ft | 5997149.818 | 2108070.0101 | 37.7681945486983 | -122.453163595144 | (37.7681945486983, -122.453163595144) | ||||
| 2615 | 2615 | 253153 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 2030 03rd St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/02/2017 12:00:00 AM | Permit Number 779475 | 6015677.29531 | 2106131.10604 | 37.763915191309295 | -122.38894296750799 | (37.7639151913093, -122.388942967508) | |||
| 4809 | 4809 | 253146 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 260 Madrid St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 10/25/2017 04:29:00 PM | 3 | 3x3 | Permit Number 767495 | 6003400.64895 | 2092179.59067 | 37.7249194341684 | -122.430408699814 | (37.7249194341684, -122.430408699814) |
| 3964 | 3964 | 253117 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 1000 Cayuga Ave | 27 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/04/2017 01:31:00 PM | 3 | Width 0ft | 5999996.87806 | 2090379.50245 | 37.719783405947204 | -122.442045963044 | (37.7197834059472, -122.442045963044) | ||
| 3921 | 3921 | 253115 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 1000 Cayuga Ave | 25 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/04/2017 11:57:00 AM | 3 | Width 0ft | 5999996.87806 | 2090379.50245 | 37.719783405947204 | -122.442045963044 | (37.7197834059472, -122.442045963044) | ||
| 3980 | 3980 | 253113 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 1000 Cayuga Ave | 23 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/04/2017 11:52:00 AM | 3 | Width 0ft | 5999996.87806 | 2090379.50245 | 37.719783405947204 | -122.442045963044 | (37.7197834059472, -122.442045963044) | ||
| 3955 | 3955 | 253111 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 1000 Cayuga Ave | 21 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/04/2017 11:48:00 AM | 3 | Width 0ft | 5999996.87806 | 2090379.50245 | 37.719783405947204 | -122.442045963044 | (37.7197834059472, -122.442045963044) | ||
| 3978 | 3978 | 253109 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 1000 Cayuga Ave | 19 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/04/2017 11:43:00 AM | 3 | Width 0ft | 5999996.87806 | 2090379.50245 | 37.719783405947204 | -122.442045963044 | (37.7197834059472, -122.442045963044) | ||
| 2367 | 2367 | 253057 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 451 Donahue St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/2017 12:00:00 AM | 3 | Width 5ft | Permit Number 770566 | 6021055.26176 | 2093480.52839 | 37.729475822337605 | -122.36946777993099 | (37.7294758223376, -122.369467779931) | |
| 2464 | 2464 | 253053 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 101 Donahue St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/2017 12:00:00 AM | 3 | 3x3 | 6020868.84401 | 2093226.3884400001 | 37.728767773737104 | -122.3700946933 | (37.7287677737371, -122.3700946933) | ||
| 2397 | 2397 | 253052 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 101 Donahue St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/2017 12:00:00 AM | 3 | 3x3 | 6020868.84401 | 2093226.3884400001 | 37.728767773737104 | -122.3700946933 | (37.7287677737371, -122.3700946933) | ||
| 2392 | 2392 | 253051 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 101 Donahue St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/2017 12:00:00 AM | 3 | 3x3 | 6020868.84401 | 2093226.3884400001 | 37.728767773737104 | -122.3700946933 | (37.7287677737371, -122.3700946933) | ||
| 2448 | 2448 | 253050 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 101 Donahue St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/2017 12:00:00 AM | 3 | 3x3 | 6020868.84401 | 2093226.3884400001 | 37.728767773737104 | -122.3700946933 | (37.7287677737371, -122.3700946933) | ||
| 2414 | 2414 | 253049 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 101 Donahue St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/2017 12:00:00 AM | 3 | 3x3 | 6020868.84401 | 2093226.3884400001 | 37.728767773737104 | -122.3700946933 | (37.7287677737371, -122.3700946933) | ||
| 2413 | 2413 | 253048 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 101 Donahue St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/2017 12:00:00 AM | 3 | 3x3 | 6020868.84401 | 2093226.3884400001 | 37.728767773737104 | -122.3700946933 | (37.7287677737371, -122.3700946933) | ||
| 2312 | 2312 | 253038 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 545 Folsom St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 778941 | 6013839.0 | 2114264.0 | 37.786144219590796 | -122.395871057304 | (37.7861442195908, -122.395871057304) | |||
| 2338 | 2338 | 253037 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 545 Folsom St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6013839.0 | 2114264.0 | 37.786144219590796 | -122.395871057304 | (37.7861442195908, -122.395871057304) | ||||
| 2339 | 2339 | 253036 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 545 Folsom St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6013839.0 | 2114264.0 | 37.786144219590796 | -122.395871057304 | (37.7861442195908, -122.395871057304) | ||||
| 2328 | 2328 | 253035 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 545 Folsom St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6013839.0 | 2114264.0 | 37.786144219590796 | -122.395871057304 | (37.7861442195908, -122.395871057304) | ||||
| 2318 | 2318 | 253034 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 545 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6013839.0 | 2114264.0 | 37.786144219590796 | -122.395871057304 | (37.7861442195908, -122.395871057304) | ||||
| 2208 | 2208 | 252955 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 50 Ewing Ter | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3x3 | 5998847.0 | 2112431.0 | 37.7802658347108 | -122.44760720084999 | (37.7802658347108, -122.44760720085) | ||||
| 2206 | 2206 | 252954 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 50 Ewing Ter | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3x3 | 5998847.0 | 2112431.0 | 37.7802658347108 | -122.44760720084999 | (37.7802658347108, -122.44760720085) | ||||
| 2156 | 2156 | 252915 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 1924 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/27/2012 12:00:00 AM | 3x3 | 6007321.0 | 2118975.0 | 37.79871469295279 | -122.418755881393 | (37.7987146929528, -122.418755881393) | |||
| 2085 | 2085 | 252880 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 2 Morse St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6001313.0 | 2088154.0 | 37.7137475882422 | -122.43733732943001 | (37.7137475882422, -122.43733732943) | ||||
| 1921 | 1921 | 251811 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 2 Hangah St | 4 | Unaccepted Street : Cutout 20 | Tree 1 | DPW for City Agency 10 | Rec/Park 7 | 3x3 | 6010544.0 | 2117119.0 | 37.7937995065594 | -122.40747229387699 | (37.7937995065594, -122.407472293877) | |||
| 1905 | 1905 | 251810 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 2 Hangah St | 3 | Unaccepted Street : Cutout 20 | Tree 1 | DPW for City Agency 10 | Rec/Park 7 | 3x3 | 6010544.0 | 2117119.0 | 37.7937995065594 | -122.40747229387699 | (37.7937995065594, -122.407472293877) | |||
| 1912 | 1912 | 251809 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 2 Hangah St | 2 | Unaccepted Street : Cutout 20 | Tree 1 | DPW for City Agency 10 | Rec/Park 7 | 3x3 | 6010544.0 | 2117119.0 | 37.7937995065594 | -122.40747229387699 | (37.7937995065594, -122.407472293877) | |||
| 1801 | 1801 | 251699 | Planning Code 138.1 required 4 | Lophostemon confertus :: Brisbane Box 11 | 1230 Chestnut St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/05/2017 12:00:00 AM | 3 | 4x3 | Permit Number 778360 | 6005943.79297 | 2120373.7363400003 | 37.8024776288704 | -122.423620966152 | (37.8024776288704, -122.423620966152) |
| 1768 | 1768 | 251696 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 98 11th St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 779453 | 6007396.0 | 2110315.0 | 37.77494067377889 | -122.417882154347 | (37.7749406737789, -122.417882154347) | |||
| 1414 | 1414 | 251524 | Planning Code 138.1 required 4 | Lophostemon confertus :: Brisbane Box 11 | 173 Sanchez St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x15 | 6003549.6097 | 2107381.8851 | 37.7666698392386 | -122.430978251884 | (37.7666698392386, -122.430978251884) | ||||
| 1401 | 1401 | 251523 | Planning Code 138.1 required 4 | Lophostemon confertus :: Brisbane Box 11 | 173 Sanchez St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x15 | 6003549.6097 | 2107381.8851 | 37.7666698392386 | -122.430978251884 | (37.7666698392386, -122.430978251884) | ||||
| 1425 | 1425 | 251522 | Planning Code 138.1 required 4 | Lophostemon confertus :: Brisbane Box 11 | 173 Sanchez St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x15 | 6003549.6097 | 2107381.8851 | 37.7666698392386 | -122.430978251884 | (37.7666698392386, -122.430978251884) | ||||
| 1416 | 1416 | 251521 | Planning Code 138.1 required 4 | Lophostemon confertus :: Brisbane Box 11 | 173 Sanchez St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x15 | 6003549.6097 | 2107381.8851 | 37.7666698392386 | -122.430978251884 | (37.7666698392386, -122.430978251884) | ||||
| 1433 | 1433 | 251520 | Planning Code 138.1 required 4 | Lophostemon confertus :: Brisbane Box 11 | 173 Sanchez St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x15 | 6003549.6097 | 2107381.8851 | 37.7666698392386 | -122.430978251884 | (37.7666698392386, -122.430978251884) | ||||
| 1388 | 1388 | 251519 | Planning Code 138.1 required 4 | Lophostemon confertus :: Brisbane Box 11 | 173 Sanchez St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x15 | 6003549.6097 | 2107381.8851 | 37.7666698392386 | -122.430978251884 | (37.7666698392386, -122.430978251884) | ||||
| 1106 | 1106 | 251445 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 300 Beale St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Width 3ft | 6014884.877230001 | 2114997.01321 | 37.7882150346369 | -122.39230385636002 | (37.7882150346369, -122.39230385636) | ||||
| 372 | 372 | 251291 | Planning Code 138.1 required 4 | Lophostemon confertus :: Brisbane Box 11 | 33 08th St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/05/2017 12:00:00 AM | 3 | Width 3ft | Permit Number 771124 | 6008734.11613 | 2111298.92197 | 37.777717506500295 | -122.41332290472799 | (37.7777175065003, -122.413322904728) | |
| 412 | 412 | 251290 | Planning Code 138.1 required 4 | Lophostemon confertus :: Brisbane Box 11 | 33 08th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/05/2017 12:00:00 AM | 3 | Width 3ft | Permit Number 771124 | 6008734.11613 | 2111298.92197 | 37.777717506500295 | -122.41332290472799 | (37.7777175065003, -122.413322904728) | |
| 400 | 400 | 251289 | Planning Code 138.1 required 4 | Lophostemon confertus :: Brisbane Box 11 | 33 08th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/05/2017 12:00:00 AM | 3 | Width 3ft | Permit Number 771124 | 6008734.11613 | 2111298.92197 | 37.777717506500295 | -122.41332290472799 | (37.7777175065003, -122.413322904728) | |
| 445 | 445 | 251285 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 1299x Hudson Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Private 3 | 03/11/2006 12:00:00 AM | 3x3 | 6017207.0 | 2095414.0 | 37.7345728945406 | -122.38290623346 | (37.7345728945406, -122.38290623346) | ||
| 501 | 501 | 251171 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 201X Cargo Way | 37 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/10/2017 11:21:00 AM | 3 | ||||||||
| 22873 | 22873 | 251137 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 25x Goettingen St | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 03/10/2017 12:00:00 AM | 3 | 3x3 | Permit Number 779273 | 6009828.0 | 2094364.0 | 37.7312793503434 | -122.40834398535401 | (37.7312793503434, -122.408343985354) | |
| 22868 | 22868 | 251136 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 2x Somerset St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/10/2017 12:00:00 AM | 3 | 3x3 | Permit Number 779273 | 6009558.0 | 2094169.0 | 37.7307287985177 | -122.409263672815 | (37.7307287985177, -122.409263672815) | |
| 22872 | 22872 | 251135 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 2x Somerset St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/10/2017 12:00:00 AM | 3 | 3x3 | Permit Number 779273 | 6009558.0 | 2094169.0 | 37.7307287985177 | -122.409263672815 | (37.7307287985177, -122.409263672815) | |
| 22861 | 22861 | 251134 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 2x Somerset St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/10/2017 12:00:00 AM | 3 | 3x3 | Permit Number 779273 | 6009558.0 | 2094169.0 | 37.7307287985177 | -122.409263672815 | (37.7307287985177, -122.409263672815) | |
| 132673 | 132673 | 250933 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 258 28th Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 4ft | 5987147.60505 | 2114230.18053 | 37.78453030356079 | -122.488212522694 | (37.7845303035608, -122.488212522694) | |||
| 63322 | 63322 | 250932 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 258 28th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 9 | Width 4ft | 5987148.83529 | 2114215.58098 | 37.7844902891505 | -122.488207193321 | (37.7844902891505, -122.488207193321) | |||
| 40297 | 40297 | 250727 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 2720 Lake St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 4ft | 5986989.77084 | 2114474.42914 | 37.7851917306499 | -122.488776528028 | (37.7851917306499, -122.488776528028) | |||
| 47429 | 47429 | 250726 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 2720 Lake St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 4ft | 5987005.7157 | 2114475.31033 | 37.785195080640996 | -122.488721429273 | (37.785195080641, -122.488721429273) | |||
| 163635 | 163635 | 250611 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 2201 Golden Gate Ave | 36 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | 5998832.7511599995 | 2111418.50425 | 37.7774849687826 | -122.447583589827 | (37.7774849687826, -122.447583589827) | ||||
| 31539 | 31539 | 250610 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 2201 Golden Gate Ave | 35 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | 5998818.59622 | 2111415.77935 | 37.777476677952706 | -122.44763236005899 | (37.7774766779527, -122.447632360059) | ||||
| 185930 | 185930 | 250609 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 2201 Golden Gate Ave | 34 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | 5998802.7301 | 2111413.8391299997 | 37.7774704438335 | -122.447687106294 | (37.7774704438335, -122.447687106294) | ||||
| 166559 | 166559 | 250608 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 2201 Golden Gate Ave | 33 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | 5998787.15443 | 2111411.5145799997 | 37.777463171018205 | -122.447740820088 | (37.7774631710182, -122.447740820088) | ||||
| 169943 | 169943 | 250607 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 2201 Golden Gate Ave | 32 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | 5998769.74892 | 2111409.2448299997 | 37.7774559440593 | -122.447800867812 | (37.7774559440593, -122.447800867812) | ||||
| 186988 | 186988 | 250606 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 2201 Golden Gate Ave | 31 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | 5998755.1093 | 2111407.10323 | 37.777449227027795 | -122.447851356665 | (37.7774492270278, -122.447851356665) | ||||
| 152639 | 152639 | 250605 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 2201 Golden Gate Ave | 30 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | 5998735.90805 | 2111405.0281 | 37.777442431746 | -122.44791763041401 | (37.777442431746, -122.447917630414) | ||||
| 149775 | 149775 | 250604 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 2201 Golden Gate Ave | 29 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | 5998717.2926900005 | 2111402.6365099996 | 37.7774348009994 | -122.44798185458099 | (37.7774348009994, -122.447981854581) | ||||
| 164454 | 164454 | 250603 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 2201 Golden Gate Ave | 28 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | 5998697.83635 | 2111399.4102 | 37.7774248302192 | -122.448048927835 | (37.7774248302192, -122.448048927835) | ||||
| 45361 | 45361 | 250602 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 2201 Golden Gate Ave | 27 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | 5998679.25957 | 2111396.77415 | 37.7774165303825 | -122.448113000908 | (37.7774165303825, -122.448113000908) | ||||
| 44611 | 44611 | 250601 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 2201 Golden Gate Ave | 26 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | 5998661.06901 | 2111393.5225 | 37.7774065623113 | -122.44817569357201 | (37.7774065623113, -122.448175693572) | ||||
| 62089 | 62089 | 250488 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 236 El Camino Del Mar | 1 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 5987839.39614 | 2115354.89245 | 37.787658776979704 | -122.48590177317 | (37.7876587769797, -122.48590177317) | |||
| 162403 | 162403 | 250246 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 38 Leavenworth St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 6008691.15955 | 2112427.76884 | 37.7808146394268 | -122.413551365821 | (37.7808146394268, -122.413551365821) | |||
| 151237 | 151237 | 250245 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 38 Leavenworth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 6008696.3024 | 2112393.5916 | 37.7807210856617 | -122.413531156231 | (37.7807210856617, -122.413531156231) | |||
| 35143 | 35143 | 250124 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 1530 Franklin St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6005832.09717 | 2115488.6463200003 | 37.789058099606 | -122.423659957854 | (37.789058099606, -122.423659957854) | |||
| 157094 | 157094 | 250123 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 1530 Franklin St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6005836.9048 | 2115448.86826 | 37.7889491503335 | -122.423640494732 | (37.7889491503335, -122.423640494732) | |||
| 31650 | 31650 | 250122 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 1530 Franklin St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6005841.96186 | 2115421.22244 | 37.78887352724671 | -122.42362103159999 | (37.7888735272467, -122.4236210316) | |||
| 150820 | 150820 | 250121 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 1530 Franklin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6005843.6818 | 2115402.28094 | 37.7888216156856 | -122.423613733594 | (37.7888216156856, -122.423613733594) | |||
| 70688 | 70688 | 250100 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 1661 Pine St | 13 | : 4 | Tree 1 | Private 1 | 8 | Width 3ft | 6006110.55942 | 2115559.79196 | 37.7892691623936 | -122.42270157102101 | (37.7892691623936, -122.422701571021) | |||
| 25646 | 25646 | 250099 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 1661 Pine St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6006084.430930001 | 2115554.78406 | 37.7892539377595 | -122.422791616561 | (37.7892539377595, -122.422791616561) | |||
| 161438 | 161438 | 250095 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 1700 Gough St | 9 | : 4 | Tree 1 | Private 1 | 11 | Width 4ft | 6005324.167330001 | 2115642.15375 | 37.789450908188 | -122.425428259725 | (37.789450908188, -122.425428259725) | |||
| 38501 | 38501 | 250067 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 1600 Franklin St | 5 | : 4 | Tree 1 | Private 1 | 2 | Width 3ft | 6005802.81063 | 2115708.11007 | 37.7896590391771 | -122.423776896684 | (37.7896590391771, -122.423776896684) | |||
| 171338 | 171338 | 250066 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 1600 Franklin St | 4 | : 4 | Tree 1 | Private 1 | 2 | Width 3ft | 6005808.20486 | 2115684.74438 | 37.7895951873257 | -122.42375657110901 | (37.7895951873257, -122.423756571109) | |||
| 63155 | 63155 | 250065 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 1600 Franklin St | 3 | : 4 | Tree 1 | Private 1 | 2 | Width 3ft | 6005813.48437 | 2115655.74749 | 37.7895158671227 | -122.42373624193199 | (37.7895158671227, -122.423736241932) | |||
| 64347 | 64347 | 250064 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 1600 Franklin St | 2 | : 4 | Tree 1 | Private 1 | 2 | Width 3ft | 6005815.61833 | 2115637.88062 | 37.7894669296122 | -122.423727587757 | (37.7894669296122, -122.423727587757) | |||
| 43016 | 43016 | 250063 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 1600 Franklin St | 1 | : 4 | Tree 1 | Private 1 | 2 | Width 3ft | 6005818.540630001 | 2115612.59138 | 37.7893976566234 | -122.423715678062 | (37.7893976566234, -122.423715678062) |
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");