Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, PlantType, qCaretaker, PlantDate, PlotSize
PermitNotes ✖
| Link | rowid | TreeID | qLegalStatus ▲ | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 909 | 909 | 234895 | Property Tree 7 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 3255x 24th St | 6 | Side Yard : Cutout 18 | Tree 1 | Private 1 | 40 | Width 10ft | 6007298.0 | 2102020.0 | 37.7521590216883 | -122.417633107694 | (37.7521590216883, -122.417633107694) | |||
| 86843 | 86843 | 109377 | Property Tree 7 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 111 BAY ST | 4 | Back Yard : Yard 13 | Tree 1 | Private 1 | 6010193.2 | 2121519.2 | 37.8058617340589 | -122.40899671325899 | (37.8058617340589, -122.408996713259) | |||||
| 96460 | 96460 | 109375 | Property Tree 7 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 111 BAY ST | 2 | Back Yard : Yard 13 | Tree 1 | Private 1 | 6010193.2 | 2121519.2 | 37.8058617340589 | -122.40899671325899 | (37.8058617340589, -122.408996713259) | |||||
| 112237 | 112237 | 109378 | Property Tree 7 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 111 BAY ST | 5 | Back Yard : Yard 13 | Tree 1 | Private 1 | 6010193.2 | 2121519.2 | 37.8058617340589 | -122.40899671325899 | (37.8058617340589, -122.408996713259) | |||||
| 118325 | 118325 | 109374 | Property Tree 7 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 111 BAY ST | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 6010193.2 | 2121519.2 | 37.8058617340589 | -122.40899671325899 | (37.8058617340589, -122.408996713259) | |||||
| 127758 | 127758 | 109376 | Property Tree 7 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 111 BAY ST | 3 | Back Yard : Yard 13 | Tree 1 | Private 1 | 6010193.2 | 2121519.2 | 37.8058617340589 | -122.40899671325899 | (37.8058617340589, -122.408996713259) | |||||
| 85674 | 85674 | 113134 | Significant Tree 6 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 50 03rd St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 09/09/2015 12:00:00 AM | 10x10 | Permit Number 775860 | 6011822.9 | 2114512.2 | 37.7867133521926 | -122.402863731968 | (37.7867133521926, -122.402863731968) | ||
| 89334 | 89334 | 116094 | Significant Tree 6 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 300x EXECUTIVE PARK BLVD | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6014482.0 | 2086919.0 | 37.7110963749119 | -122.39173377323799 | (37.7110963749119, -122.391733773238) | ||||
| 92450 | 92450 | 116095 | Significant Tree 6 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 300x EXECUTIVE PARK BLVD | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6014482.0 | 2086919.0 | 37.7110963749119 | -122.39173377323799 | (37.7110963749119, -122.391733773238) | ||||
| 106195 | 106195 | 116091 | Significant Tree 6 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 300x EXECUTIVE PARK BLVD | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 30 | 3x3 | 6014482.0 | 2086919.0 | 37.7110963749119 | -122.39173377323799 | (37.7110963749119, -122.391733773238) | |||
| 114742 | 114742 | 116093 | Significant Tree 6 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 300x EXECUTIVE PARK BLVD | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6014482.0 | 2086919.0 | 37.7110963749119 | -122.39173377323799 | (37.7110963749119, -122.391733773238) | ||||
| 118020 | 118020 | 116097 | Significant Tree 6 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 300x EXECUTIVE PARK BLVD | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6014482.0 | 2086919.0 | 37.7110963749119 | -122.39173377323799 | (37.7110963749119, -122.391733773238) | ||||
| 119705 | 119705 | 116096 | Significant Tree 6 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 300x EXECUTIVE PARK BLVD | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6014482.0 | 2086919.0 | 37.7110963749119 | -122.39173377323799 | (37.7110963749119, -122.391733773238) | ||||
| 140337 | 140337 | 113133 | Significant Tree 6 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 50 03rd St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 09/09/2015 12:00:00 AM | 10x10 | Permit Number 775860 | 6011822.9 | 2114512.2 | 37.7867133521926 | -122.402863731968 | (37.7867133521926, -122.402863731968) | ||
| 144536 | 144536 | 116092 | Significant Tree 6 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 300x EXECUTIVE PARK BLVD | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6014482.0 | 2086919.0 | 37.7110963749119 | -122.39173377323799 | (37.7110963749119, -122.391733773238) | ||||
| 5897 | 5897 | 19904 | DPW Maintained 3 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 100 STAIRWAY34 | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 6X6 | ||||||||
| 6788 | 6788 | 19903 | DPW Maintained 3 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 100 STAIRWAY34 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 6X6 | ||||||||
| 7574 | 7574 | 19781 | DPW Maintained 3 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 100 STAIRWAY19 | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 36 | 50ST | ||||||||
| 13863 | 13863 | 19841 | DPW Maintained 3 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 100 STAIRWAY25 | 25 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 60X | ||||||||
| 16741 | 16741 | 20051 | DPW Maintained 3 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 100 STAIRWAY52 | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 10 | ||||||||
| 18395 | 18395 | 6096 | DPW Maintained 3 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 106X Saint Joseph's Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6000733.8426241 | 2112435.5369559 | 37.780385944611204 | -122.44108008458001 | (37.7803859446112, -122.44108008458) | |||
| 25404 | 25404 | 119731 | DPW Maintained 3 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 104x Octavia St | 11 | Median : Cutout 11 | Tree 1 | DPW 2 | 2109391.0 | 6005718.0 | 47.269987373868105 | -138.2836696503 | (47.2699873738681, -138.2836696503) | |||||
| 28694 | 28694 | 246559 | DPW Maintained 3 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 2x Octavia St | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 6 | Width 7ft | 6005723.21879 | 2109372.62983 | 37.7722588698898 | -122.42360165389299 | (37.7722588698898, -122.423601653893) | |||
| 28854 | 28854 | 246564 | DPW Maintained 3 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 2x Octavia St | 8 | Median : Yard 3 | Tree 1 | DPW 2 | 9 | Width 7ft | 6005706.72335 | 2109459.01828 | 37.7724951406584 | -122.423664856449 | (37.7724951406584, -122.423664856449) | |||
| 30102 | 30102 | 246567 | DPW Maintained 3 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 2x Octavia St | 11 | Median : Yard 3 | Tree 1 | DPW 2 | 10 | Width 7ft | 6005696.09569 | 2109523.68249 | 37.7726720930872 | -122.423706217176 | (37.7726720930872, -122.423706217176) | |||
| 30532 | 30532 | 119696 | DPW Maintained 3 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 4x Octavia St | 14 | Median : Cutout 11 | Tree 1 | DPW 2 | 2109391.0 | 6005718.0 | 47.269987373868105 | -138.2836696503 | (47.2699873738681, -138.2836696503) | |||||
| 32751 | 32751 | 246565 | DPW Maintained 3 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 2x Octavia St | 9 | Median : Yard 3 | Tree 1 | DPW 2 | 11 | Width 7ft | 6005706.10974 | 2109468.40026 | 37.772520866678796 | -122.423667646169 | (37.7725208666788, -122.423667646169) | |||
| 36823 | 36823 | 246562 | DPW Maintained 3 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 2x Octavia St | 6 | Median : Yard 3 | Tree 1 | DPW 2 | 16 | Width 7ft | 6005708.50416 | 2109443.88838 | 37.7724536981194 | -122.423657620518 | (37.7724536981194, -122.423657620518) | |||
| 37654 | 37654 | 244429 | DPW Maintained 3 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 102x Octavia St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 9 | Width 0ft | 6005659.2973 | 2109696.7034 | 37.773145089481794 | -122.4238458121 | (37.7731450894818, -122.4238458121) | |||
| 46046 | 46046 | 244430 | DPW Maintained 3 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 102x Octavia St | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 7 | Width 0ft | 6005657.927 | 2109705.6102 | 37.7731694680478 | -122.42385118560499 | (37.7731694680478, -122.423851185605) | |||
| 46340 | 46340 | 244263 | DPW Maintained 3 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 202x Octavia St | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 5 | Width 0ft | 6005610.4338 | 2110073.0988 | 37.7741758216851 | -122.424041609468 | (37.7741758216851, -122.424041609468) | |||
| 47891 | 47891 | 244336 | DPW Maintained 3 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 102x Octavia St | 13 | Median : Cutout 11 | Tree 1 | DPW 2 | 13 | Width 0ft | 6005628.4661 | 2109884.4314 | 37.7736588046762 | -122.423965813403 | (37.7736588046762, -122.423965813403) | |||
| 53575 | 53575 | 244407 | DPW Maintained 3 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 202x Octavia St | 13 | Median : Cutout 11 | Tree 1 | DPW 2 | 8 | Width 0ft | 6005584.4651 | 2110232.73 | 37.774612664125 | -122.424142794808 | (37.774612664125, -122.424142794808) | |||
| 58148 | 58148 | 246560 | DPW Maintained 3 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 2x Octavia St | 4 | Median : Yard 3 | Tree 1 | DPW 2 | 5 | Width 7ft | 6005720.56075 | 2109380.70244 | 37.772280885298 | -122.423611422347 | (37.772280885298, -122.423611422347) | |||
| 59788 | 59788 | 244335 | DPW Maintained 3 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 102x Octavia St | 12 | Median : Cutout 11 | Tree 1 | DPW 2 | 13 | Width 0ft | 6005630.5215 | 2109874.8395 | 37.7736325836766 | -122.42395802123 | (37.7736325836766, -122.42395802123) | |||
| 61692 | 61692 | 119780 | DPW Maintained 3 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 204x Octavia St | 15 | Median : Cutout 11 | Tree 1 | DPW 2 | 2109391.0 | 6005718.0 | 47.269987373868105 | -138.2836696503 | (47.2699873738681, -138.2836696503) | |||||
| 62755 | 62755 | 246558 | DPW Maintained 3 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 2x Octavia St | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 7 | Width 7ft | 6005725.55596 | 2109365.49138 | 37.772239401347605 | -122.423593061791 | (37.7722394013476, -122.423593061791) | |||
| 64205 | 64205 | 244403 | DPW Maintained 3 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 202x Octavia St | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 7 | Width 0ft | 6005596.6857 | 2110150.2412 | 37.7743868598384 | -122.424094653801 | (37.7743868598384, -122.424094653801) | |||
| 65982 | 65982 | 244266 | DPW Maintained 3 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 202x Octavia St | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 4 | Width 0ft | 6005600.5046 | 2110125.0362 | 37.7743178686238 | -122.42407965066499 | (37.7743178686238, -122.424079650665) | |||
| 66652 | 66652 | 246571 | DPW Maintained 3 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 2x Octavia St | 15 | Median : Yard 3 | Tree 1 | DPW 2 | 10 | Width 7ft | 6005693.03742 | 2109551.27371 | 37.7727476792916 | -122.423718758221 | (37.7727476792916, -122.423718758221) | |||
| 66890 | 66890 | 244431 | DPW Maintained 3 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 102x Octavia St | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 9 | Width 0ft | 6005656.5567 | 2109717.2576 | 37.77320137163979 | -122.42385675402599 | (37.7732013716398, -122.423856754026) | |||
| 69195 | 69195 | 246561 | DPW Maintained 3 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 2x Octavia St | 5 | Median : Yard 3 | Tree 1 | DPW 2 | 8 | Width 7ft | 6005718.25772 | 2109387.68034 | 37.7722999149342 | -122.42361988494801 | (37.7722999149342, -122.423619884948) | |||
| 73006 | 73006 | 244339 | DPW Maintained 3 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 102x Octavia St | 16 | Median : Cutout 11 | Tree 1 | DPW 2 | 14 | Width 0ft | 6005625.7255 | 2109918.6883 | 37.7737527111209 | -122.42397773010799 | (37.7737527111209, -122.423977730108) | |||
| 76412 | 76412 | 244404 | DPW Maintained 3 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 202x Octavia St | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 8 | Width 0ft | 6005594.3943 | 2110164.7531 | 37.7744265766299 | -122.424103612435 | (37.7744265766299, -122.424103612435) | |||
| 78042 | 78042 | 6095 | DPW Maintained 3 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 106X Saint Joseph's Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/19/2015 12:00:00 AM | 12 | 3X3 | 6000733.8426241 | 2112435.5369559 | 37.780385944611204 | -122.44108008458001 | (37.7803859446112, -122.44108008458) | ||
| 79566 | 79566 | 119689 | DPW Maintained 3 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 4x Octavia St | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 2109391.0 | 6005718.0 | 47.269987373868105 | -138.2836696503 | (47.2699873738681, -138.2836696503) | |||||
| 80683 | 80683 | 119723 | DPW Maintained 3 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 104x Octavia St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 2109391.0 | 6005718.0 | 47.269987373868105 | -138.2836696503 | (47.2699873738681, -138.2836696503) | |||||
| 83899 | 83899 | 119728 | DPW Maintained 3 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 104x Octavia St | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 2109391.0 | 6005718.0 | 47.269987373868105 | -138.2836696503 | (47.2699873738681, -138.2836696503) | |||||
| 84867 | 84867 | 119767 | DPW Maintained 3 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 204x Octavia St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 2109391.0 | 6005718.0 | 47.269987373868105 | -138.2836696503 | (47.2699873738681, -138.2836696503) | |||||
| 85011 | 85011 | 119690 | DPW Maintained 3 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 4x Octavia St | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 2109391.0 | 6005718.0 | 47.269987373868105 | -138.2836696503 | (47.2699873738681, -138.2836696503) | |||||
| 86483 | 86483 | 119684 | DPW Maintained 3 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 4x Octavia St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 2109391.0 | 6005718.0 | 47.269987373868105 | -138.2836696503 | (47.2699873738681, -138.2836696503) | |||||
| 86543 | 86543 | 119734 | DPW Maintained 3 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 104x Octavia St | 14 | Median : Cutout 11 | Tree 1 | DPW 2 | 2109391.0 | 6005718.0 | 47.269987373868105 | -138.2836696503 | (47.2699873738681, -138.2836696503) | |||||
| 87621 | 87621 | 119685 | DPW Maintained 3 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 4x Octavia St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 2109391.0 | 6005718.0 | 47.269987373868105 | -138.2836696503 | (47.2699873738681, -138.2836696503) | |||||
| 87630 | 87630 | 119692 | DPW Maintained 3 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 4x Octavia St | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 2109391.0 | 6005718.0 | 47.269987373868105 | -138.2836696503 | (47.2699873738681, -138.2836696503) | |||||
| 88222 | 88222 | 119683 | DPW Maintained 3 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 4x Octavia St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 2109391.0 | 6005718.0 | 47.269987373868105 | -138.2836696503 | (47.2699873738681, -138.2836696503) | |||||
| 89139 | 89139 | 119727 | DPW Maintained 3 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 104x Octavia St | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 2109391.0 | 6005718.0 | 47.269987373868105 | -138.2836696503 | (47.2699873738681, -138.2836696503) | |||||
| 90805 | 90805 | 119770 | DPW Maintained 3 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 204x Octavia St | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 2109391.0 | 6005718.0 | 47.269987373868105 | -138.2836696503 | (47.2699873738681, -138.2836696503) | |||||
| 90928 | 90928 | 244261 | DPW Maintained 3 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 202x Octavia St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 5 | Width 0ft | 6005613.489 | 2110034.9096 | 37.7740711358709 | -122.424028324662 | (37.7740711358709, -122.424028324662) | |||
| 92703 | 92703 | 119766 | DPW Maintained 3 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 204x Octavia St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 2109391.0 | 6005718.0 | 47.269987373868105 | -138.2836696503 | (47.2699873738681, -138.2836696503) | |||||
| 92884 | 92884 | 119733 | DPW Maintained 3 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 104x Octavia St | 13 | Median : Cutout 11 | Tree 1 | DPW 2 | 2109391.0 | 6005718.0 | 47.269987373868105 | -138.2836696503 | (47.2699873738681, -138.2836696503) | |||||
| 96316 | 96316 | 119697 | DPW Maintained 3 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 4x Octavia St | 15 | Median : Cutout 11 | Tree 1 | DPW 2 | 2109391.0 | 6005718.0 | 47.269987373868105 | -138.2836696503 | (47.2699873738681, -138.2836696503) | |||||
| 97979 | 97979 | 119772 | DPW Maintained 3 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 204x Octavia St | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 2109391.0 | 6005718.0 | 47.269987373868105 | -138.2836696503 | (47.2699873738681, -138.2836696503) | |||||
| 99317 | 99317 | 119769 | DPW Maintained 3 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 204x Octavia St | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 2109391.0 | 6005718.0 | 47.269987373868105 | -138.2836696503 | (47.2699873738681, -138.2836696503) | |||||
| 100173 | 100173 | 119722 | DPW Maintained 3 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 104x Octavia St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 2109391.0 | 6005718.0 | 47.269987373868105 | -138.2836696503 | (47.2699873738681, -138.2836696503) | |||||
| 100653 | 100653 | 119693 | DPW Maintained 3 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 4x Octavia St | 11 | Median : Cutout 11 | Tree 1 | DPW 2 | 2109391.0 | 6005718.0 | 47.269987373868105 | -138.2836696503 | (47.2699873738681, -138.2836696503) | |||||
| 101391 | 101391 | 119774 | DPW Maintained 3 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 204x Octavia St | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 2109391.0 | 6005718.0 | 47.269987373868105 | -138.2836696503 | (47.2699873738681, -138.2836696503) | |||||
| 103536 | 103536 | 119694 | DPW Maintained 3 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 4x Octavia St | 12 | Median : Cutout 11 | Tree 1 | DPW 2 | 2109391.0 | 6005718.0 | 47.269987373868105 | -138.2836696503 | (47.2699873738681, -138.2836696503) | |||||
| 103992 | 103992 | 119729 | DPW Maintained 3 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 104x Octavia St | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 2109391.0 | 6005718.0 | 47.269987373868105 | -138.2836696503 | (47.2699873738681, -138.2836696503) | |||||
| 105008 | 105008 | 119726 | DPW Maintained 3 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 104x Octavia St | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 2109391.0 | 6005718.0 | 47.269987373868105 | -138.2836696503 | (47.2699873738681, -138.2836696503) | |||||
| 106450 | 106450 | 119771 | DPW Maintained 3 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 204x Octavia St | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 2109391.0 | 6005718.0 | 47.269987373868105 | -138.2836696503 | (47.2699873738681, -138.2836696503) | |||||
| 108312 | 108312 | 6094 | DPW Maintained 3 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 106X Saint Joseph's Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 20 | 3X3 | 6000733.8426241 | 2112435.5369559 | 37.780385944611204 | -122.44108008458001 | (37.7803859446112, -122.44108008458) | |||
| 112632 | 112632 | 6098 | DPW Maintained 3 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 106X Saint Joseph's Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 3X3 | 6000733.8426241 | 2112435.5369559 | 37.780385944611204 | -122.44108008458001 | (37.7803859446112, -122.44108008458) | |||
| 115597 | 115597 | 119725 | DPW Maintained 3 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 104x Octavia St | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 2109391.0 | 6005718.0 | 47.269987373868105 | -138.2836696503 | (47.2699873738681, -138.2836696503) | |||||
| 116487 | 116487 | 244265 | DPW Maintained 3 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 202x Octavia St | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 9 | Width 0ft | 6005602.0322 | 2110112.8157 | 37.7742844003359 | -122.42407349716999 | (37.7742844003359, -122.42407349717) | |||
| 117272 | 117272 | 119768 | DPW Maintained 3 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 204x Octavia St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 2109391.0 | 6005718.0 | 47.269987373868105 | -138.2836696503 | (47.2699873738681, -138.2836696503) | |||||
| 118707 | 118707 | 119686 | DPW Maintained 3 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 4x Octavia St | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 2109391.0 | 6005718.0 | 47.269987373868105 | -138.2836696503 | (47.2699873738681, -138.2836696503) | |||||
| 120366 | 120366 | 119775 | DPW Maintained 3 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 204x Octavia St | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 2109391.0 | 6005718.0 | 47.269987373868105 | -138.2836696503 | (47.2699873738681, -138.2836696503) | |||||
| 120707 | 120707 | 119721 | DPW Maintained 3 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 104x Octavia St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 2109391.0 | 6005718.0 | 47.269987373868105 | -138.2836696503 | (47.2699873738681, -138.2836696503) | |||||
| 120772 | 120772 | 119778 | DPW Maintained 3 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 204x Octavia St | 13 | Median : Cutout 11 | Tree 1 | DPW 2 | 2109391.0 | 6005718.0 | 47.269987373868105 | -138.2836696503 | (47.2699873738681, -138.2836696503) | |||||
| 120932 | 120932 | 119687 | DPW Maintained 3 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 4x Octavia St | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 2109391.0 | 6005718.0 | 47.269987373868105 | -138.2836696503 | (47.2699873738681, -138.2836696503) | |||||
| 123249 | 123249 | 24282 | DPW Maintained 3 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 300X Winding Way | 20 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 8 | 6001646.2933309 | 2086550.8578367 | 37.7093646550959 | -122.436070699117 | (37.7093646550959, -122.436070699117) | |||
| 123390 | 123390 | 119724 | DPW Maintained 3 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 104x Octavia St | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 2109391.0 | 6005718.0 | 47.269987373868105 | -138.2836696503 | (47.2699873738681, -138.2836696503) | |||||
| 123532 | 123532 | 119777 | DPW Maintained 3 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 204x Octavia St | 12 | Median : Cutout 11 | Tree 1 | DPW 2 | 2109391.0 | 6005718.0 | 47.269987373868105 | -138.2836696503 | (47.2699873738681, -138.2836696503) | |||||
| 124714 | 124714 | 119691 | DPW Maintained 3 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 4x Octavia St | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 2109391.0 | 6005718.0 | 47.269987373868105 | -138.2836696503 | (47.2699873738681, -138.2836696503) | |||||
| 126370 | 126370 | 119730 | DPW Maintained 3 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 104x Octavia St | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 2109391.0 | 6005718.0 | 47.269987373868105 | -138.2836696503 | (47.2699873738681, -138.2836696503) | |||||
| 129094 | 129094 | 119732 | DPW Maintained 3 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 104x Octavia St | 12 | Median : Cutout 11 | Tree 1 | DPW 2 | 2109391.0 | 6005718.0 | 47.269987373868105 | -138.2836696503 | (47.2699873738681, -138.2836696503) | |||||
| 129623 | 129623 | 244406 | DPW Maintained 3 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 202x Octavia St | 12 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | Width 0ft | 6005586.7565 | 2110217.4543 | 37.7745708501281 | -122.42413378179899 | (37.7745708501281, -122.424133781799) | |||
| 130105 | 130105 | 246569 | DPW Maintained 3 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 2x Octavia St | 13 | Median : Yard 3 | Tree 1 | DPW 2 | 9 | Width 7ft | 6005694.6084199995 | 2109539.50826 | 37.772715462883 | -122.42371248725401 | (37.772715462883, -122.423712487254) | |||
| 136078 | 136078 | 244264 | DPW Maintained 3 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 202x Octavia St | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | Width 0ft | 6005607.3787 | 2110087.6108 | 37.7742154956389 | -122.42405320983299 | (37.7742154956389, -122.424053209833) | |||
| 136569 | 136569 | 244337 | DPW Maintained 3 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 102x Octavia St | 14 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | Width 0ft | 6005627.7809 | 2109896.0788 | 37.7736907469384 | -122.423969012041 | (37.7736907469384, -122.423969012041) | |||
| 138816 | 138816 | 119735 | DPW Maintained 3 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 104x Octavia St | 15 | Median : Cutout 11 | Tree 1 | DPW 2 | 2109391.0 | 6005718.0 | 47.269987373868105 | -138.2836696503 | (47.2699873738681, -138.2836696503) | |||||
| 139912 | 139912 | 119688 | DPW Maintained 3 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 4x Octavia St | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 2109391.0 | 6005718.0 | 47.269987373868105 | -138.2836696503 | (47.2699873738681, -138.2836696503) | |||||
| 140489 | 140489 | 119773 | DPW Maintained 3 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 204x Octavia St | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 2109391.0 | 6005718.0 | 47.269987373868105 | -138.2836696503 | (47.2699873738681, -138.2836696503) | |||||
| 141892 | 141892 | 119779 | DPW Maintained 3 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 204x Octavia St | 14 | Median : Cutout 11 | Tree 1 | DPW 2 | 2109391.0 | 6005718.0 | 47.269987373868105 | -138.2836696503 | (47.2699873738681, -138.2836696503) | |||||
| 142187 | 142187 | 119776 | DPW Maintained 3 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 204x Octavia St | 11 | Median : Cutout 11 | Tree 1 | DPW 2 | 2109391.0 | 6005718.0 | 47.269987373868105 | -138.2836696503 | (47.2699873738681, -138.2836696503) | |||||
| 142339 | 142339 | 119695 | DPW Maintained 3 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 4x Octavia St | 13 | Median : Cutout 11 | Tree 1 | DPW 2 | 2109391.0 | 6005718.0 | 47.269987373868105 | -138.2836696503 | (47.2699873738681, -138.2836696503) | |||||
| 147500 | 147500 | 244428 | DPW Maintained 3 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 102x Octavia St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | Width 0ft | 6005659.9824 | 2109685.0561 | 37.7731131474821 | -122.423842613892 | (37.7731131474821, -122.423842613892) | |||
| 147941 | 147941 | 244402 | DPW Maintained 3 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 202x Octavia St | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 5 | Width 0ft | 6005599.7408 | 2110138.7844 | 37.774355574729796 | -122.424083270702 | (37.7743555747298, -122.424083270702) | |||
| 150135 | 150135 | 244433 | DPW Maintained 3 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 102x Octavia St | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 8 | Width 0ft | 6005647.6499 | 2109776.1795 | 37.7733626541324 | -122.42389175449499 | (37.7733626541324, -122.423891754495) | |||
| 152207 | 152207 | 244334 | DPW Maintained 3 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 102x Octavia St | 11 | Median : Cutout 11 | Tree 1 | DPW 2 | 13 | Width 0ft | 6005631.2066 | 2109866.6178 | 37.77361004755279 | -122.423955066597 | (37.7736100475528, -122.423955066597) |
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");