Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, qCareAssistant, DBH
| Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 240 | 240 | 251249 | Private 5 | Private shrub :: Private Shrub 64 | 161 Lundys Ln | 1 | Front Yard : Yard 7 | Landscaping 2 | Private 1 | 3x3 | 6006716.0 | 2098685.0 | 37.7429691002686 | -122.41940918518 | (37.7429691002686, -122.41940918518) | ||||
| 443 | 443 | 251293 | Undocumented 2 | :: 54 | 3789 Market St | 1 | Sidewalk: Property side : Cutout 5 | Landscaping 2 | Private 1 | 3x3 | 6000208.0 | 2102740.0 | 37.753734455764 | -122.44220302061701 | (37.753734455764, -122.442203020617) | ||||
| 452 | 452 | 221749 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 275 Grattan St | 3 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | 24 | Width 4ft | 5997432.91763 | 2106413.5715 | 37.763662611962 | -122.452064861225 | (37.763662611962, -122.452064861225) | |||
| 458 | 458 | 221750 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 275 Grattan St | 2 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | 11 | Width 4ft | 5997409.41415 | 2106414.31665 | 37.7636633116224 | -122.45214620578699 | (37.7636633116224, -122.452146205787) | |||
| 496 | 496 | 245474 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 275 Grattan St | 1 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | 19 | Width 4ft | 5997377.53226 | 2106405.56262 | 37.7636374489232 | -122.452255843041 | (37.7636374489232, -122.452255843041) | |||
| 963 | 963 | 251419 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 39 Jones St | 2 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | 04/14/2015 12:00:00 AM | 3x3 | 6009068.0 | 2112723.0 | 37.781646426577 | -122.412268559085 | (37.781646426577, -122.412268559085) | |||
| 970 | 970 | 251418 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 39 Jones St | 1 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | 04/14/2015 12:00:00 AM | 3x3 | 6009068.0 | 2112723.0 | 37.781646426577 | -122.412268559085 | (37.781646426577, -122.412268559085) | |||
| 1361 | 1361 | 16698 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 950X Noriega St | 2 | Median : Cutout 11 | Landscaping 2 | DPW 2 | 12 | 8 | 5991017.9677099995 | 2103156.31666 | 37.7543495107367 | -122.47401428523999 | (37.7543495107367, -122.47401428524) | |||
| 1389 | 1389 | 251532 | Permitted Site 1 | :: 54 | 2100X 20th St | 4 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | 05/15/2017 12:00:00 AM | 3 | 4x11 | |||||||
| 1391 | 1391 | 251531 | Permitted Site 1 | :: 54 | 2100X 20th St | 2 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | 05/15/2017 12:00:00 AM | 3 | 4x11 | |||||||
| 1666 | 1666 | 251642 | Undocumented 2 | Shrub :: Shrub 98 | 2253 Broderick St | 4 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | 3x3 | 6000298.51737 | 2116393.24113 | 37.7912279703404 | -122.442870356286 | (37.7912279703404, -122.442870356286) | ||||
| 1800 | 1800 | 251700 | Permitted Site 1 | :: 54 | 1560 Sanchez St | 1 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | 06/05/2017 12:00:00 AM | 3 | 410x11 | Permit Number 780193 | 6003924.0 | 2099150.0 | 37.7440882334859 | -122.429096301435 | (37.7440882334859, -122.429096301435) | |
| 2270 | 2270 | 253008 | Permitted Site 1 | :: 54 | 1201 Tennessee St | 1 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | 07/10/2017 12:00:00 AM | 3 | 11x477 | 6015595.17459 | 2103370.35297 | 37.756330202721 | -122.389034232236 | (37.756330202721, -122.389034232236) | ||
| 3170 | 3170 | 208471 | Permitted Site 1 | Cordyline australis :: Dracena Palm 141 | 1175 Kirkham St | 1 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | 08/23/2017 12:00:00 AM | 3 | Width 2ft | Permit Number 780657 | 5991201.16474 | 2105172.16858 | 37.7598951180952 | -122.473527781682 | (37.7598951180952, -122.473527781682) | |
| 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) | |
| 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) | |
| 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) | |
| 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) | |
| 3598 | 3598 | 225282 | Undocumented 2 | Pittosporum crassifolium :: Karo Tree 108 | 101 Rivoli St | 2 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | 6 | Width 3ft | 5998123.1152 | 2105954.07554 | 37.762440462975 | -122.44964458054 | (37.762440462975, -122.44964458054) | |||
| 3639 | 3639 | 253517 | Permitted Site 1 | :: 54 | 559 24th Ave | 2 | Sidewalk: Property side : Cutout 5 | Landscaping 2 | Private 1 | 09/15/2017 12:00:00 AM | 3 | 2x4.5 | 5988391.0 | 2112180.0 | 37.7789735494402 | -122.483760479148 | (37.7789735494402, -122.483760479148) | ||
| 3643 | 3643 | 253515 | Permitted Site 1 | :: 54 | 559 24th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | 09/15/2017 12:00:00 AM | 3 | 7x9.5 | 5988391.0 | 2112180.0 | 37.7789735494402 | -122.483760479148 | (37.7789735494402, -122.483760479148) | ||
| 3650 | 3650 | 253518 | Permitted Site 1 | :: 54 | 559 24th Ave | 3 | Sidewalk: Property side : Cutout 5 | Landscaping 2 | Private 1 | 09/15/2017 12:00:00 AM | 3 | 2x1 | 5988391.0 | 2112180.0 | 37.7789735494402 | -122.483760479148 | (37.7789735494402, -122.483760479148) | ||
| 3660 | 3660 | 253516 | Permitted Site 1 | :: 54 | 559 24th Ave | 1 | Sidewalk: Property side : Cutout 5 | Landscaping 2 | Private 1 | 09/15/2017 12:00:00 AM | 3 | 2x2 | 5988392.0 | 2112177.0 | 37.778965370493495 | -122.483756799769 | (37.7789653704935, -122.483756799769) | ||
| 4723 | 4723 | 253676 | Permitted Site 1 | :: 54 | 2975 Van Ness Ave | 6 | Sidewalk: Property side : Cutout 5 | Landscaping 2 | Private 1 | 10/24/2017 12:00:00 AM | 3 | 3.2x3.75 | 6005536.30746 | 2120557.52588 | 37.8029592583559 | -122.42504415389 | (37.8029592583559, -122.42504415389) | ||
| 4726 | 4726 | 253675 | Permitted Site 1 | :: 54 | 2975 Van Ness Ave | 1 | Sidewalk: Property side : Cutout 5 | Landscaping 2 | Private 1 | 10/24/2017 12:00:00 AM | 3 | 3.2x14.2 | 6005536.30746 | 2120557.52588 | 37.8029592583559 | -122.42504415389 | (37.8029592583559, -122.42504415389) | ||
| 10092 | 10092 | 173852 | Permitted Site 1 | :: 54 | 450 Toland St | 7 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | 01/27/2017 12:00:00 AM | 3 | 8.5x4 | 6012768.71675 | 2099101.44192 | 37.74445161113729 | -122.39850962968201 | (37.7444516111373, -122.398509629682) | ||
| 10093 | 10093 | 173849 | Permitted Site 1 | :: 54 | 450 Toland St | 4 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | 01/27/2017 12:00:00 AM | 3 | 17.6x4 | 6012768.71675 | 2099101.44192 | 37.74445161113729 | -122.39850962968201 | (37.7444516111373, -122.398509629682) | ||
| 10096 | 10096 | 173850 | Permitted Site 1 | :: 54 | 450 Toland St | 5 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | 01/27/2017 12:00:00 AM | 3 | 13.9x4 | 6012768.71675 | 2099101.44192 | 37.74445161113729 | -122.39850962968201 | (37.7444516111373, -122.398509629682) | ||
| 10097 | 10097 | 173851 | Permitted Site 1 | :: 54 | 450 Toland St | 6 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | 01/27/2017 12:00:00 AM | 3 | 27.75x4 | 6012768.71675 | 2099101.44192 | 37.74445161113729 | -122.39850962968201 | (37.7444516111373, -122.398509629682) | ||
| 10098 | 10098 | 173848 | Permitted Site 1 | :: 54 | 450 Toland St | 3 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | 01/27/2017 12:00:00 AM | 3 | 19.5x4 | 6012768.71675 | 2099101.44192 | 37.74445161113729 | -122.39850962968201 | (37.7444516111373, -122.398509629682) | ||
| 10101 | 10101 | 173846 | Permitted Site 1 | :: 54 | 450 Toland St | 1 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | 01/27/2017 12:00:00 AM | 3 | 15x4 | 6012768.71675 | 2099101.44192 | 37.74445161113729 | -122.39850962968201 | (37.7444516111373, -122.398509629682) | ||
| 10104 | 10104 | 173847 | Permitted Site 1 | :: 54 | 450 Toland St | 2 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | 01/27/2017 12:00:00 AM | 3 | 11.85x4 | 6012768.71675 | 2099101.44192 | 37.74445161113729 | -122.39850962968201 | (37.7444516111373, -122.398509629682) | ||
| 10106 | 10106 | 173853 | Permitted Site 1 | :: 54 | 450 Toland St | 8 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | 01/27/2017 12:00:00 AM | 3 | 26.75x4 | 6012768.71675 | 2099101.44192 | 37.74445161113729 | -122.39850962968201 | (37.7444516111373, -122.398509629682) | ||
| 10638 | 10638 | 96234 | Permitted Site 1 | Tree(s) :: 17 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | 04/15/2011 12:00:00 AM | Permit Number 767856 | ||||||||||
| 11641 | 11641 | 96232 | Permitted Site 1 | Tree(s) :: 17 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | ||||||||||||
| 13970 | 13970 | 17450 | DPW Maintained 3 | Ligustrum ovalifolium :: California privet 284 | 1967 Palou Ave | 4 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | DPW 2 | 42 | 3X3 | 6012966.10245 | 2096645.10936 | 37.7377180333685 | -122.397654855789 | (37.7377180333685, -122.397654855789) | |||
| 16044 | 16044 | 96231 | Permitted Site 1 | Tree(s) :: 17 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | ||||||||||||
| 20483 | 20483 | 109769 | Permitted Site 1 | :: 54 | 2502X Bush St | 2 | Sidewalk: Property side : Cutout 5 | Landscaping 2 | Private 1 | 1.5x12.75 | 6001313.62368 | 2114572.17699 | 37.786285618589204 | -122.43922754338101 | (37.7862856185892, -122.439227543381) | ||||
| 24006 | 24006 | 191506 | Undocumented 2 | Ligustrum ovalifolium :: California privet 284 | 725 18th St | 1 | Sidewalk: Property side : Yard 9 | Landscaping 2 | Private 1 | 12 | Width 2ft | 6015277.21856 | 2105757.38147 | 37.7628668405556 | -122.390300611982 | (37.7628668405556, -122.390300611982) | |||
| 25407 | 25407 | 95032 | Tree(s) :: 17 | 211 Maynard St | Front Yard : Cutout 8 | Landscaping 2 | Private 1 | 6004772.0 | 2093802.0 | 37.729451797878205 | -122.425783519869 | (37.7294517978782, -122.425783519869) | |||||||
| 34525 | 34525 | 191507 | Undocumented 2 | Ligustrum ovalifolium :: California privet 284 | 725 18th St | 3 | Sidewalk: Property side : Yard 9 | Landscaping 2 | Private 1 | 6 | Width 2ft | 6015301.62259 | 2105759.06622 | 37.7628728201497 | -122.39021632394699 | (37.7628728201497, -122.390216323947) | |||
| 41228 | 41228 | 117919 | Undocumented 2 | Ligustrum ovalifolium :: California privet 284 | 727 41st Ave | 2 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | 3 | Width 3ft | 5983193.78874 | 2110818.2250200002 | 37.774930606826 | -122.501638652158 | (37.774930606826, -122.501638652158) | |||
| 42994 | 42994 | 109343 | Permitted Site 1 | :: 54 | 3211 Baker St | 2 | Sidewalk: Property side : Yard 9 | Landscaping 2 | Private 1 | 02/11/2015 12:00:00 AM | 3 | 4x13 | 5999315.1 | 2119860.5 | 37.8006920253414 | -122.446522498385 | (37.8006920253414, -122.446522498385) | ||
| 46600 | 46600 | 116804 | DPW Maintained 3 | Juniperus chinensis :: Juniper 19 | 131 LAKESHORE DR | 1 | Median : Yard 3 | Landscaping 2 | DPW 2 | 10x100 | 5984782.0 | 2094243.0 | 37.7295127607338 | -122.494922366174 | (37.7295127607338, -122.494922366174) | ||||
| 49594 | 49594 | 112605 | Permitted Site 1 | :: 54 | 1534 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | 08/10/2015 12:00:00 AM | 5.6x12 | 6000465.0 | 2110329.2 | 37.7745871625182 | -122.441858914128 | (37.7745871625182, -122.441858914128) | |||
| 50491 | 50491 | 107717 | Undocumented 2 | Tree(s) :: 17 | 2400X 25th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | Port 11 | 10/16/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773973 | 5985789.0 | 2098909.0 | 37.7423832554664 | -122.49178447783899 | (37.7423832554664, -122.491784477839) |
| 52224 | 52224 | 227520 | Undocumented 2 | Ligustrum ovalifolium :: California privet 284 | 16 Tiffany Ave | 1 | : 4 | Landscaping 2 | Private 1 | 4 | Width 2ft | 6006374.41145 | 2099856.22866 | 37.746165784439896 | -122.420673433456 | (37.7461657844399, -122.420673433456) | |||
| 79071 | 79071 | 95369 | Tree(s) :: 17 | 27 Hartford St | Front Yard : Cutout 8 | Landscaping 2 | Private 1 | 02/18/2011 12:00:00 AM | 6002651.0 | 2105744.0 | 37.7621216467866 | -122.433969295968 | (37.7621216467866, -122.433969295968) | ||||||
| 79103 | 79103 | 120636 | Private 5 | Private shrub :: Private Shrub 64 | 385 Nevada St | 1 | Sidewalk: Property side : Cutout 5 | Landscaping 2 | Private 1 | 3x3 | 6008960.0 | 2096519.0 | 37.7371478708762 | -122.411497024701 | (37.7371478708762, -122.411497024701) | ||||
| 79393 | 79393 | 106516 | Permitted Site 1 | Tree(s) :: 17 | 366 Hill St | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | 05/07/2014 12:00:00 AM | 3X3 | Permit Number 772751 | 6003996.2 | 2103381.7 | 37.755711581068795 | -122.42914832014 | (37.7557115810688, -122.42914832014) | |||
| 79432 | 79432 | 106576 | Private 5 | Private shrub :: Private Shrub 64 | 507 STEINER ST | 1 | Front Yard : Yard 7 | Landscaping 2 | Private 1 | 6003113.3 | 2110111.6 | 37.7741402349502 | -122.432682383122 | (37.7741402349502, -122.432682383122) | |||||
| 79753 | 79753 | 107409 | Undocumented 2 | Shrub :: Shrub 98 | 125 VILLA TER | 1 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | 5999028.2 | 2104385.8 | 37.758186107000796 | -122.44640141076401 | (37.7581861070008, -122.446401410764) | |||||
| 80289 | 80289 | 79468 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 606 Webster St | 1 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | 07/07/2009 12:00:00 AM | 3x3 | Permit Number 52423 | 6004042.90191121 | 2110875.50885644 | 37.7762904169609 | -122.42952121696301 | (37.7762904169609, -122.429521216963) | ||
| 80534 | 80534 | 96292 | Permitted Site 1 | Tree(s) :: 17 | 1294 Union St | Sidewalk: Property side : Pot 6 | Landscaping 2 | Private 1 | 03/21/2011 12:00:00 AM | 6006773.0 | 2119090.0 | 37.7989995844362 | -122.420660308797 | (37.7989995844362, -122.420660308797) | |||||
| 80672 | 80672 | 98502 | Property Tree 7 | Tree(s) :: 17 | 244 Glenview Dr | Back Yard : Yard 13 | Landscaping 2 | Private 1 | 5999066.0 | 2100737.0 | 37.7481695560511 | -122.44600824337601 | (37.7481695560511, -122.446008243376) | ||||||
| 80680 | 80680 | 117478 | Undocumented 2 | Private shrub :: Private Shrub 64 | 400 PERALTA AVE | 1 | Front Yard : Yard 7 | Landscaping 2 | Private 1 | 3x3 | 6009762.0 | 2099359.0 | 37.7449908466617 | -122.40892445167499 | (37.7449908466617, -122.408924451675) | ||||
| 81163 | 81163 | 104152 | Permitted Site 1 | :: 54 | 525X Church St | 2 | Sidewalk: Property side : Cutout 5 | Landscaping 2 | SFUSD 4 | DPW 4 | 2x68 | 6004243.11162 | 2105844.84418 | 37.7624887647889 | -122.428469979895 | (37.7624887647889, -122.428469979895) | |||
| 81298 | 81298 | 104856 | Permitted Site 1 | :: 54 | 739 27th St | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | 02/12/2015 12:00:00 AM | 3 | 6001722.3 | 2099959.7 | 37.746186600460604 | -122.43676722664301 | (37.7461866004606, -122.436767226643) | ||||
| 81307 | 81307 | 20137 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 898 Steiner St | 1 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | 01/11/2011 12:00:00 AM | 3 | 8x4 | Permit Number 54088 | 6003009.7075288 | 2111327.5412022998 | 37.777473032235704 | -122.433127623561 | (37.7774730322357, -122.433127623561) | |
| 81443 | 81443 | 100355 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 591 Waller St | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | 12/30/2014 12:00:00 AM | 3 | 27x6 | Permit Number 769031 | 6002899.6 | 2108847.2 | 37.770656382716396 | -122.43333123962 | (37.7706563827164, -122.43333123962) | ||
| 81722 | 81722 | 104155 | Permitted Site 1 | :: 54 | 525X Church St | 3 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | SFUSD 4 | DPW 4 | 5x17 | 6004243.11162 | 2105844.84418 | 37.7624887647889 | -122.428469979895 | (37.7624887647889, -122.428469979895) | |||
| 82393 | 82393 | 108910 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 129 Ellert St | 1 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | FUF 1 | 01/09/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773054 | 6007361.2 | 2097016.9 | 37.7384251864379 | -122.417060086005 | (37.7384251864379, -122.417060086005) |
| 82677 | 82677 | 99536 | Permitted Site 1 | Tree(s) :: 17 | 188 Spear St | 4 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | 5x9 | 6014774.7 | 2116168.9 | 37.791426646732894 | -122.39276706915899 | (37.7914266467329, -122.392767069159) | ||||
| 82720 | 82720 | 98465 | Property Tree 7 | Tree(s) :: 17 | 190 Portola Dr | Back Yard : Yard 13 | Landscaping 2 | Private 1 | 5999550.3 | 2100620.3 | 37.7478767693988 | -122.444325170302 | (37.7478767693988, -122.444325170302) | ||||||
| 83041 | 83041 | 109366 | Permitted Site 1 | :: 54 | 1205 Filbert St | 3 | Sidewalk: Property side : Cutout 5 | Landscaping 2 | Private 1 | FUF 1 | 02/11/2015 12:00:00 AM | 3 | 3.125x22 | 6007075.4 | 2119431.2 | 37.7999534721279 | -122.419638123127 | (37.7999534721279, -122.419638123127) | |
| 83840 | 83840 | 107144 | Undocumented 2 | :: 54 | 360 Spear St | 1 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | 6015708.0 | 2115219.0 | 37.7888702311939 | -122.38947147438 | (37.7888702311939, -122.38947147438) | |||||
| 84066 | 84066 | 83339 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2233 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | 07/01/2009 12:00:00 AM | 3x3 | Permit Number 52332 | 5987590.2167451 | 2100087.03718588 | 37.7457229434205 | -122.485642930331 | (37.7457229434205, -122.485642930331) | ||
| 84402 | 84402 | 109353 | Private 5 | Ficus Spp. :: 253 | 2505 Pacific Ave | 6 | Sidewalk: Property side : Cutout 5 | Landscaping 2 | Private 1 | 02/11/2015 12:00:00 AM | 3 | .5x1 | 6002092.0 | 2116990.0 | 37.7929686009801 | -122.43670770268999 | (37.7929686009801, -122.43670770269) | ||
| 84751 | 84751 | 82096 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1363 Francisco St | 1 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | 07/01/2009 12:00:00 AM | 3x3 | Permit Number 52338 | 6004802.97001971 | 2120513.88344233 | 37.802797975517294 | -122.42757877147899 | (37.8027979755173, -122.427578771479) | ||
| 85124 | 85124 | 85121 | Permitted Site 1 | Juniperus chinensis :: Juniper 19 | 1403 11th Ave | 2 | Sidewalk: Property side : Cutout 5 | Landscaping 2 | Private 1 | 02/27/2007 12:00:00 AM | 7 | 2x2 | Tree 2. Permit Number 49495. | 5992673.9 | 2105865.8 | 37.7618848250494 | -122.46848481907499 | (37.7618848250494, -122.468484819075) | |
| 85310 | 85310 | 105043 | Permitted Site 1 | :: 54 | 2660 Harrison St | 5 | Sidewalk: Property side : Cutout 5 | Landscaping 2 | Private 1 | 2x4 | 6008902.0 | 2102968.0 | 37.754852144595795 | -122.41215320319701 | (37.7548521445958, -122.412153203197) | ||||
| 85779 | 85779 | 110615 | Permitted Site 1 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 134 | 200 McAllister St | 3 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | 12/31/2015 12:00:00 AM | 3 | 13.2x7.8 | Permit Number 773269 | 6008108.0 | 2112443.0 | 37.7808236983351 | -122.415569883338 | (37.7808236983351, -122.415569883338) | |
| 85839 | 85839 | 105039 | Permitted Site 1 | :: 54 | 2660 Harrison St | 1 | Sidewalk: Property side : Cutout 5 | Landscaping 2 | Private 1 | 2x7 | 6008868.4 | 2102978.1 | 37.7548779915591 | -122.412270115586 | (37.7548779915591, -122.412270115586) | ||||
| 86139 | 86139 | 89139 | Permitted Site 1 | Tree(s) :: 17 | 3170 23rd St | Sidewalk: Property side : Cutout 5 | Landscaping 2 | Private 1 | 10/06/2008 12:00:00 AM | Permit Number 770875 | 6007866.1 | 2102749.5 | 37.7541940143569 | -122.41572017373001 | (37.7541940143569, -122.41572017373) | ||||
| 86307 | 86307 | 93162 | Permitted Site 1 | Tree(s) :: 17 | 201 Upper Ter | 3 | Sidewalk: Property side : Cutout 5 | Landscaping 2 | Private 1 | 12/22/2009 12:00:00 AM | 3x3 | 5999670.5 | 2106448.3 | 37.763885884820205 | -122.444328283325 | (37.7638858848202, -122.444328283325) | |||
| 86544 | 86544 | 99529 | Permitted Site 1 | Tree(s) :: 17 | 120 Howard St | 3 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | 4x9 | 6014737.1 | 2116083.2 | 37.7911892459774 | -122.392891167069 | (37.7911892459774, -122.392891167069) | ||||
| 87250 | 87250 | 93936 | Permitted Site 1 | Tree(s) :: 17 | 230 Seacliff Ave | Sidewalk: Curb side : 21 | Landscaping 2 | Private 1 | 04/26/2010 12:00:00 AM | 37x6 | 5987086.7 | 2115743.7 | 37.7886824393648 | -122.488534508212 | (37.7886824393648, -122.488534508212) | ||||
| 87791 | 87791 | 99527 | Permitted Site 1 | Tree(s) :: 17 | 120 Howard St | 1 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | 4x9 | 6014737.1 | 2116083.2 | 37.7911892459774 | -122.392891167069 | (37.7911892459774, -122.392891167069) | ||||
| 87925 | 87925 | 104864 | Permitted Site 1 | :: 54 | 45 Hoffman Ave | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | 6000629.3 | 2102650.0 | 37.7535113392088 | -122.440739618385 | (37.7535113392088, -122.440739618385) | ||||||
| 88689 | 88689 | 109762 | Permitted Site 1 | :: 54 | 1801 Scott St | 1 | Sidewalk: Property side : Cutout 5 | Landscaping 2 | Private 1 | 1.5x6.5 | 6001511.7 | 2114646.3 | 37.786500410729104 | -122.43854756475099 | (37.7865004107291, -122.438547564751) | ||||
| 88984 | 88984 | 109756 | Permitted Site 1 | :: 54 | 601 Steiner St | 3 | Sidewalk: Property side : Cutout 5 | Landscaping 2 | Private 1 | 1x12 | 6003025.4 | 2110381.6 | 37.774876602731204 | -122.433005738531 | (37.7748766027312, -122.433005738531) | ||||
| 89166 | 89166 | 102275 | Property Tree 7 | Tree(s) :: 17 | 267 Topaz Way | Back Yard : Yard 13 | Landscaping 2 | Private 1 | 6001225.6 | 2097744.2 | 37.740075118911705 | -122.438326054857 | (37.7400751189117, -122.438326054857) | ||||||
| 89308 | 89308 | 103623 | Permitted Site 1 | Taxus baccata :: Irish Yew 241 | 333 El Camino Del Mar | 1 | Sidewalk: Property side : Cutout 5 | Landscaping 2 | Private 1 | 06/04/2013 12:00:00 AM | 13x2 | Permit Number 770205 | 5987603.5 | 2115303.5 | 37.787503918723395 | -122.48671414227199 | (37.7875039187234, -122.486714142272) | ||
| 90472 | 90472 | 120871 | Undocumented 2 | Shrub :: Shrub 98 | 1387 08th Ave | 1 | Sidewalk: Curb side : Pot 10 | Landscaping 2 | Private 1 | 5993606.0 | 2106068.0 | 37.762493810072606 | -122.465275766733 | (37.7624938100726, -122.465275766733) | |||||
| 91008 | 91008 | 120156 | Significant Tree 6 | Ficus nitida :: Laurel Fig 43 | 758 10th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | 10 | 5992930.0 | 2110298.0 | 37.77406925887279 | -122.467921468059 | (37.7740692588728, -122.467921468059) | ||||
| 91154 | 91154 | 109365 | Permitted Site 1 | :: 54 | 1205 Filbert St | 2 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | FUF 1 | 02/11/2015 12:00:00 AM | 3 | 4.5x16 | 6007075.4 | 2119431.2 | 37.7999534721279 | -122.419638123127 | (37.7999534721279, -122.419638123127) | |
| 91444 | 91444 | 107078 | Undocumented 2 | Tree(s) :: 17 | 92 Homestead St | Sidewalk: Property side : Cutout 5 | Landscaping 2 | Private 1 | 07/25/2014 12:00:00 AM | 3x3.5 | Permit Number 773562 | 6000948.33481 | 2101213.46128 | 37.7495851129185 | -122.439533357227 | (37.7495851129185, -122.439533357227) | |||
| 92261 | 92261 | 117511 | DPW Maintained 3 | Shrub :: Shrub 98 | 2634 37TH AVE | 1 | Median : Yard 3 | Landscaping 2 | DPW 2 | 20 | 3x3 | 5984921.0 | 2097163.0 | 37.737538439530795 | -122.49465702329901 | (37.7375384395308, -122.494657023299) | |||
| 92510 | 92510 | 88654 | Permitted Site 1 | Ginkgo biloba 'Autumn Sentinel' :: Autumn Sentinel Ginkgo 461 | 94 Danton St | Sidewalk: Property side : Cutout 5 | Landscaping 2 | Private 1 | 08/05/2008 12:00:00 AM | Permit Number 51634 | 6002844.0 | 2094598.0 | 37.7315282931893 | -122.43250562955099 | (37.7315282931893, -122.432505629551) | ||||
| 92559 | 92559 | 92776 | Permitted Site 1 | Ligustrum japonicum :: Japanese Privet 4 | 2701 Pacific Ave | Sidewalk: Property side : Cutout 5 | Landscaping 2 | Private 1 | 10/15/2009 12:00:00 AM | Permit Number 52996 | 6001178.5 | 2116864.5 | 37.7925720539586 | -122.43985945141 | (37.7925720539586, -122.43985945141) | ||||
| 92708 | 92708 | 85104 | Permitted Site 1 | Juniperus chinensis :: Juniper 19 | 1403 11th Ave | 1 | Sidewalk: Property side : Cutout 5 | Landscaping 2 | Private 1 | 9 | 2x2 | Tree 1 | 5992673.9 | 2105865.8 | 37.7618848250494 | -122.46848481907499 | (37.7618848250494, -122.468484819075) | ||
| 92935 | 92935 | 104156 | Permitted Site 1 | :: 54 | 525X Church St | 4 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | SFUSD 4 | DPW 4 | 5x20 | 6004243.11162 | 2105844.84418 | 37.7624887647889 | -122.428469979895 | (37.7624887647889, -122.428469979895) | |||
| 94304 | 94304 | 94961 | Permitted Site 1 | Tree(s) :: 17 | 3098 PACIFIC AVE | 1 | Sidewalk: Property side : Cutout 5 | Landscaping 2 | Private 1 | 10/25/2010 12:00:00 AM | 5999362.0 | 2116697.0 | 37.792008575714 | -122.446132526841 | (37.792008575714, -122.446132526841) | ||||
| 94709 | 94709 | 117610 | Undocumented 2 | Shrub :: Shrub 98 | 391 NEVADA ST | 1 | Unaccepted Street : Yard 14 | Landscaping 2 | Private 1 | 3x3 | 6008958.0 | 2096497.0 | 37.737087351465796 | -122.41150238578501 | (37.7370873514658, -122.411502385785) | ||||
| 94734 | 94734 | 98893 | Property Tree 7 | Tree(s) :: 17 | 216 Glenview Dr | Back Yard : Yard 13 | Landscaping 2 | Private 1 | 5998910.0 | 2100761.0 | 37.7482265448319 | -122.44654941060699 | (37.7482265448319, -122.446549410607) | ||||||
| 94853 | 94853 | 104637 | Permitted Site 1 | :: 54 | 217 Montcalm St | Front Yard : Yard 7 | Landscaping 2 | Private 1 | 16x16 | 6010036.0 | 2099691.0 | 37.7459177905176 | -122.40800041337499 | (37.7459177905176, -122.408000413375) | |||||
| 95495 | 95495 | 104151 | Permitted Site 1 | :: 54 | 525X Church St | 1 | Sidewalk: Property side : Cutout 5 | Landscaping 2 | SFUSD 4 | DPW 4 | 2x58 | 6004243.11162 | 2105844.84418 | 37.7624887647889 | -122.428469979895 | (37.7624887647889, -122.428469979895) | |||
| 95556 | 95556 | 104158 | Permitted Site 1 | :: 54 | 525X Church St | 6 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | SFUSD 4 | DPW 4 | 5x20 | 6004243.11162 | 2105844.84418 | 37.7624887647889 | -122.428469979895 | (37.7624887647889, -122.428469979895) | |||
| 96077 | 96077 | 104157 | Permitted Site 1 | :: 54 | 525X Church St | 5 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | SFUSD 4 | DPW 4 | 5x20 | 6004243.11162 | 2105844.84418 | 37.7624887647889 | -122.428469979895 | (37.7624887647889, -122.428469979895) | |||
| 96456 | 96456 | 5412 | Permitted Site 1 | Tree(s) :: 17 | 414 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | 07/07/2008 12:00:00 AM | 3x3 | 6004849.3785887 | 2105949.0211321 | 37.7628090992038 | -122.426380541105 | (37.7628090992038, -122.426380541105) |
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");