trees
430 rows where qSpecies_id = 99 sorted by Zip Codes
This data as json, CSV (advanced)
| rowid | TreeID | qLegalStatus_id | qSpecies_id | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker_id | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location | Fire Prevention Districts | Police Districts | Supervisor Districts | Zip Codes ▼ | Neighborhoods (old) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4126 | 115471 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 10X Junipero Serra Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | ||||||||||||||
| 16067 | 19787 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 100 STAIRWAY19 | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 50ST | |||||||||||||
| 16487 | 19779 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 100 STAIRWAY19 | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 50ST | |||||||||||||
| 102768 | 142234 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 689 HAYES ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 22 | Width 0ft | 6004609.2702 | 2110836.2012 | 37.7762145389853 | -122.427559190874 | (37.7762145389853, -122.427559190874) | 7 | 9 | 11 | 28852 | 10 | |||
| 154835 | 137076 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 689 Hayes St | 4 | : | Tree | Private 2 | 19 | Width 4ft | 6004731.62731 | 2110853.90859 | 37.7762700791404 | -122.427137185641 | (37.7762700791404, -122.427137185641) | 7 | 9 | 11 | 28852 | 10 | |||
| 162496 | 142237 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 689 HAYES ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 0ft | 6004726.9033 | 2110859.9695 | 37.7762864537737 | -122.427153959111 | (37.7762864537737, -122.427153959111) | 7 | 9 | 11 | 28852 | 10 | |||
| 189616 | 137075 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 689 Hayes St | 1 | : | Tree | Private 2 | 24 | Width 5ft | 6004617.55273 | 2110839.21576 | 37.776223284701 | -122.42753075415 | (37.776223284701, -122.42753075415) | 7 | 9 | 11 | 28852 | 10 | |||
| 12392 | 97505 | Undocumented 4 | Ulmus pumila :: Siberian Elm 99 | 20X 10th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/18/2011 12:00:00 AM | 12 | 3x3 | Permit Number 768079 | 6007672 | 2110712 | 37.7760462700595 | -122.416955543158 | (37.7760462700595, -122.416955543158) | 8 | 2 | 9 | 28853 | 34 | |
| 172121 | 97504 | Undocumented 4 | Ulmus pumila :: Siberian Elm 99 | 20X 10th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/18/2011 12:00:00 AM | 12 | 3x3 | Permit Number 768079 | 6007672 | 2110712 | 37.7760462700595 | -122.416955543158 | (37.7760462700595, -122.416955543158) | 8 | 2 | 9 | 28853 | 34 | |
| 4371 | 45657 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1330 Union St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/13/2001 12:00:00 AM | 18 | Permit Number 44353 | 6006599 | 2119096 | 37.7990062508654 | -122.421262834262 | (37.7990062508654, -122.421262834262) | 13 | 9 | 1 | 28858 | 32 | ||
| 76840 | 117189 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1335 Washington St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6008262.17379 | 2117224.41185 | 37.7939609578909 | -122.415375111785 | (37.7939609578909, -122.415375111785) | 5 | 1 | 10 | 28858 | 21 | |||
| 112007 | 39229 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1335 Washington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/04/1998 12:00:00 AM | 15 | 3x3 | Permit Number 40871 | 6008226.63206 | 2117220.68496 | 37.793948727108 | -122.415497826087 | (37.793948727108, -122.415497826087) | 5 | 1 | 10 | 28858 | 21 | |
| 164727 | 99894 | Significant Tree 6 | Ulmus pumila :: Siberian Elm 99 | 1636 Bush St | 1 | Front Yard : Yard | Tree | Private 2 | 07/11/2012 12:00:00 AM | Permit Number 768849 | 6005665 | 2115204 | 37.7882670981083 | -122.424217840789 | (37.7882670981083, -122.424217840789) | 13 | 9 | 1 | 28858 | 41 | |||
| 183694 | 2933 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1834 California St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/29/1997 12:00:00 AM | 7 | 3X3 | 6005503.04257 | 2115905.51621 | 37.7901841403418 | -122.424828114668 | (37.7901841403418, -122.424828114668) | 13 | 9 | 1 | 28858 | 27 | ||
| 1798 | 242795 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1671 Peralta Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6009731.24755 | 2099988.43526 | 37.7467174150944 | -122.409075193563 | (37.7467174150944, -122.409075193563) | 2 | 7 | 7 | 28859 | 2 | |||
| 5204 | 7475 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 2650X Folsom St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 60 | 3x3 | 6008254.1361302 | 2102990.9843832 | 37.7548788814664 | -122.414395330099 | (37.7548788814664, -122.414395330099) | 2 | 4 | 7 | 28859 | 19 | |||
| 15951 | 39175 | Permitted Site 7 | Ulmus pumila :: Siberian Elm 99 | 750 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/27/2002 12:00:00 AM | 10 | Permit Number 40836 | 6007492.94598473 | 2105289.21429212 | 37.7611465023321 | -122.417190590059 | (37.7611465023321, -122.417190590059) | 2 | 4 | 7 | 28859 | 19 | |
| 18105 | 99912 | Undocumented 4 | Ulmus pumila :: Siberian Elm 99 | 3751X Fair Oaks St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6005509.05056 | 2101091.11643 | 37.7495076933522 | -122.42375353502 | (37.7495076933522, -122.42375353502) | 2 | 4 | 5 | 28859 | 19 | ||||
| 21872 | 7486 | Permitted Site 7 | Ulmus pumila :: Siberian Elm 99 | 2679X Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 3X3 | 6008312.8272 | 2102836.8814 | 37.754459046451 | -122.414181457232 | (37.754459046451, -122.414181457232) | 2 | 4 | 7 | 28859 | 19 | |||
| 22161 | 7482 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 2650X Folsom St | 10 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 60 | 3x3 | 6008254.1361302 | 2102990.9843832 | 37.7548788814664 | -122.414395330099 | (37.7548788814664, -122.414395330099) | 2 | 4 | 7 | 28859 | 19 | |||
| 31355 | 99913 | Undocumented 4 | Ulmus pumila :: Siberian Elm 99 | 3751X Fair Oaks St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 768933 | 6005509.05056 | 2101091.11643 | 37.7495076933522 | -122.42375353502 | (37.7495076933522, -122.42375353502) | 2 | 4 | 5 | 28859 | 19 | |||
| 51308 | 242791 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1001 San Jose Ave | 14 | Front Yard : Yard | Tree | Private 2 | 5 | 6005175.70924 | 2096892.88162 | 37.7379614744454 | -122.424607638258 | (37.7379614744454, -122.424607638258) | 2 | 7 | 5 | 28859 | 2 | ||||
| 58765 | 242794 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 2x Coso Ave | 4 | Median : Yard | Tree | DPW 1 | 30 | 6007112.52178 | 2099889.35747 | 37.746298321115 | -122.418123483128 | (37.746298321115, -122.418123483128) | 2 | 7 | 7 | 28859 | 2 | ||||
| 61984 | 7476 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 2650X Folsom St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 60 | 3x3 | 6008254.1361302 | 2102990.9843832 | 37.7548788814664 | -122.414395330099 | (37.7548788814664, -122.414395330099) | 2 | 4 | 7 | 28859 | 19 | |||
| 70264 | 7477 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 2650X Folsom St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 60 | 3x3 | 6008254.1361302 | 2102990.9843832 | 37.7548788814664 | -122.414395330099 | (37.7548788814664, -122.414395330099) | 2 | 4 | 7 | 28859 | 19 | |||
| 70794 | 242793 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 2x Coso Ave | 1 | Median : Yard | Tree | DPW 1 | 30 | Width 9ft | 6007083.58829 | 2099965.0449 | 37.746504513177 | -122.418228897148 | (37.746504513177, -122.418228897148) | 2 | 7 | 7 | 28859 | 2 | |||
| 75417 | 7464 | Permitted Site 7 | Ulmus pumila :: Siberian Elm 99 | 2599 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 60 | 3X3 | 6008286.46562 | 2103308.5385 | 37.7557526290701 | -122.414305992303 | (37.7557526290701, -122.414305992303) | 2 | 4 | 7 | 28859 | 19 | |||
| 76484 | 7472 | Permitted Site 7 | Ulmus pumila :: Siberian Elm 99 | 2637 Folsom St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 60 | 4X4 | 6008329.44308 | 2103061.47825 | 37.7550766717901 | -122.414139883786 | (37.7550766717901, -122.414139883786) | 2 | 4 | 7 | 28859 | 19 | |||
| 77661 | 7425 | Permitted Site 7 | Ulmus pumila :: Siberian Elm 99 | 2501 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 60 | 3X3 | 6008288.6679 | 2103807.30911 | 37.7571222633799 | -122.414333665067 | (37.7571222633799, -122.414333665067) | 2 | 4 | 7 | 28859 | 19 | |||
| 86222 | 7473 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 2650X Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 60 | 3x3 | 6008254.1361302 | 2102990.9843832 | 37.7548788814664 | -122.414395330099 | (37.7548788814664, -122.414395330099) | 2 | 4 | 7 | 28859 | 19 | |||
| 129130 | 7479 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 2650X Folsom St | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 60 | 3x3 | 6008254.1361302 | 2102990.9843832 | 37.7548788814664 | -122.414395330099 | (37.7548788814664, -122.414395330099) | 2 | 4 | 7 | 28859 | 19 | |||
| 132451 | 99911 | Undocumented 4 | Ulmus pumila :: Siberian Elm 99 | 400 Fair Oaks St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6005460.7 | 2101331.3 | 37.7501644526018 | -122.423937810125 | (37.7501644526018, -122.423937810125) | 2 | 4 | 5 | 28859 | 19 | ||||
| 134673 | 7481 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 2650X Folsom St | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 60 | 3x3 | 6008254.1361302 | 2102990.9843832 | 37.7548788814664 | -122.414395330099 | (37.7548788814664, -122.414395330099) | 2 | 4 | 7 | 28859 | 19 | |||
| 138539 | 7474 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 2650X Folsom St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 60 | 3x3 | 6008254.1361302 | 2102990.9843832 | 37.7548788814664 | -122.414395330099 | (37.7548788814664, -122.414395330099) | 2 | 4 | 7 | 28859 | 19 | |||
| 160951 | 93024 | Permitted Site 7 | Ulmus pumila :: Siberian Elm 99 | 394 Fair Oaks St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Tree 3 on 25th St | 6005476 | 2101410 | 37.7503814084322 | -122.423890497296 | (37.7503814084322, -122.423890497296) | 2 | 4 | 5 | 28859 | 19 | ||||
| 190541 | 93023 | Permitted Site 7 | Ulmus pumila :: Siberian Elm 99 | 394 Fair Oaks St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Tree 2 on 25th St | 6005476 | 2101410 | 37.7503814084322 | -122.423890497296 | (37.7503814084322, -122.423890497296) | 2 | 4 | 5 | 28859 | 19 | ||||
| 1332 | 215594 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 260 Sagamore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 4ft | 5994385 | 2087488 | 37.7115226229707 | -122.461234615187 | (37.7115226229707, -122.461234615187) | 9 | 8 | 6 | 28861 | 24 | |||
| 2820 | 899 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1161 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 4X5 | 6003541.15178 | 2094307.19105 | 37.7307693064514 | -122.43007470418 | (37.7307693064514, -122.43007470418) | 9 | 7 | 6 | 28861 | 25 | |||
| 3714 | 19086 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 235 Sagamore St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 25 | 3X3 | 5994700.7848896 | 2087405.1340273 | 37.7113132610353 | -122.460137187577 | (37.7113132610353, -122.460137187577) | 9 | 8 | 6 | 28861 | 24 | |||
| 5701 | 215593 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 103 Sagamore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 3ft | 5995757.42889 | 2087376.90008 | 37.7112964570463 | -122.456483140498 | (37.7112964570463, -122.456483140498) | 9 | 8 | 6 | 28861 | 24 | |||
| 6012 | 16704 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1677X Alemany Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 29 | 5x6 | 6001608.07304 | 2092347.28192 | 37.7252781710498 | -122.43661741688 | (37.7252781710498, -122.43661741688) | 9 | 7 | 6 | 28861 | 25 | |||
| 6804 | 1081 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 2144 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 30 | 3x3 | 5999999.92726 | 2089842.39347 | 37.718308800511 | -122.441996891163 | (37.718308800511, -122.441996891163) | 9 | 7 | 6 | 28861 | 25 | |||
| 9727 | 25337 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 260 Sagamore St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/21/2000 12:00:00 AM | 15 | 3X3 | 5994336.66394 | 2087473.55865 | 37.7114801885417 | -122.461400629858 | (37.7114801885417, -122.461400629858) | 9 | 8 | 6 | 28861 | 24 | ||
| 9808 | 262587 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 203 Sagamore St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3X3 | 5994963 | 2087365 | 37.7112181411096 | -122.459228007495 | (37.7112181411096, -122.459228007495) | 9 | 8 | 6 | 28861 | 24 | ||||
| 10682 | 978 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1601 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 30 | 3x3 | 6001786.79947 | 2092741.59351 | 37.7263710164051 | -122.436027780876 | (37.7263710164051, -122.436027780876) | 9 | 7 | 6 | 28861 | 25 | |||
| 12102 | 180591 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1830 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 22 | Width 4ft | 6001183.24158 | 2091479.89441 | 37.7228723703333 | -122.438023911598 | (37.7228723703333, -122.438023911598) | 9 | 7 | 6 | 28861 | 25 | |||
| 12178 | 1048 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 2029X Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3X3 | 6000595.57615 | 2090275.75201 | 37.719532630863 | -122.439969044998 | (37.719532630863, -122.439969044998) | 9 | 7 | 6 | 28861 | 25 | ||||
| 14050 | 180592 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1830 Alemany Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 33 | Width 4ft | 6001143.73267 | 2091406.40414 | 37.72266833577 | -122.438155223402 | (37.72266833577, -122.438155223402) | 9 | 7 | 6 | 28861 | 25 | |||
| 15479 | 896 | Permitted Site 7 | Ulmus pumila :: Siberian Elm 99 | 1155X Alemany Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | 4X4 | 6003365.90456 | 2094243.14139 | 37.7305835136383 | -122.43067599245 | (37.7305835136383, -122.43067599245) | 9 | 7 | 6 | 28861 | 25 | |||
| 22805 | 914 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1233 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 25 | 3X5 | 6003058.45033 | 2094142.01954 | 37.7302884326438 | -122.431731689776 | (37.7302884326438, -122.431731689776) | 9 | 7 | 6 | 28861 | 25 | |||
| 23482 | 19082 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 227 Sagamore St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 25 | 3X3 | 5994691.47902 | 2087389.19966 | 37.7112689737437 | -122.460168197108 | (37.7112689737437, -122.460168197108) | 9 | 8 | 6 | 28861 | 24 | |||
| 23519 | 180581 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1394 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 22 | Width 5ft | 6002394.23037 | 2093854.80651 | 37.7294621373592 | -122.434007462878 | (37.7294621373592, -122.434007462878) | 9 | 7 | 5 | 28861 | 25 | |||
| 26642 | 1061 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 2061X Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 40 | 3X3 | 6000441.22371 | 2090128.46046 | 37.7191194136535 | -122.440492025318 | (37.7191194136535, -122.440492025318) | 9 | 7 | 6 | 28861 | 25 | |||
| 27401 | 912 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1229 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 25 | 4X4 | 6003089.95028 | 2094152.43682 | 37.7303188216593 | -122.431623533692 | (37.7303188216593, -122.431623533692) | 9 | 7 | 6 | 28861 | 25 | |||
| 28708 | 1010 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1840X Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 35 | 3X3 | 6001180.26428 | 2091487.57144 | 37.7228932804007 | -122.438034753125 | (37.7228932804007, -122.438034753125) | 9 | 7 | 6 | 28861 | 25 | |||
| 30682 | 970 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1599 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 38 | 4X4 | 6001869.51123 | 2092911.87236 | 37.7268432620915 | -122.435754028151 | (37.7268432620915, -122.435754028151) | 9 | 7 | 6 | 28861 | 25 | |||
| 32172 | 215592 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 177 Sagamore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 5995226.8577 | 2087383.90223 | 37.7112852083174 | -122.458317422904 | (37.7112852083174, -122.458317422904) | 9 | 8 | 6 | 28861 | 24 | |||
| 32835 | 1054 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 2045X Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 25 | 3X3 | 6000521.13381 | 2090206.39855 | 37.7193379639287 | -122.440221393554 | (37.7193379639287, -122.440221393554) | 9 | 7 | 6 | 28861 | 25 | |||
| 32871 | 26823 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 260 Sagamore St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 30 | 3X3 | 5994408.88806 | 2087459.5005113 | 37.7114457448338 | -122.461149987895 | (37.7114457448338, -122.461149987895) | 9 | 8 | 6 | 28861 | 24 | |||
| 35213 | 1085 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 2156 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 25 | 3X3 | 5999963.70084 | 2089791.48987 | 37.7181669663093 | -122.442118458302 | (37.7181669663093, -122.442118458302) | 9 | 7 | 6 | 28861 | 25 | |||
| 35965 | 19053 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 141 Sagamore St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 25 | 3X3 | 5995501.70307 | 2087378.49279 | 37.7112861454175 | -122.457367103015 | (37.7112861454175, -122.457367103015) | 9 | 8 | 6 | 28861 | 24 | |||
| 45289 | 19085 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 231 Sagamore St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 25 | 3X3 | 5994662.28634 | 2087388.84238 | 37.7112663135508 | -122.460269067765 | (37.7112663135508, -122.460269067765) | 9 | 8 | 6 | 28861 | 24 | |||
| 46333 | 21830 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1419X Alemany Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X6 | 6002361.46709 | 2093663.80125 | 37.7289358208429 | -122.434107079856 | (37.7289358208429, -122.434107079856) | 9 | 7 | 6 | 28861 | 25 | |||
| 47119 | 180584 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1114 Alemany Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 22 | Width 4ft | 6003732.95256 | 2094463.14814 | 37.7312083905422 | -122.429422736186 | (37.7312083905422, -122.429422736186) | 9 | 7 | 5 | 28861 | 25 | |||
| 49035 | 1182 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 3003 Alemany Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 3x3 | 5996737.10872 | 2087300.2249 | 37.7111421206036 | -122.45309160658 | (37.7111421206036, -122.45309160658) | 9 | 7 | 6 | 28861 | 25 | |||
| 49417 | 997 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1693 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 45 | 3X6 | 6001548.3914 | 2092219.76431 | 37.7249246448287 | -122.436814605813 | (37.7249246448287, -122.436814605813) | 9 | 7 | 6 | 28861 | 25 | |||
| 52619 | 1032 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1989X Alemany Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 60 | 3X6 | 6000752.12664 | 2090469.86783 | 37.7200745396752 | -122.439441815719 | (37.7200745396752, -122.439441815719) | 9 | 7 | 6 | 28861 | 25 | |||
| 54348 | 933 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1294X Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 30 | 3x3 | 6002802.17626 | 2094143.63343 | 37.7302783338422 | -122.432617778446 | (37.7302783338422, -122.432617778446) | 9 | 7 | 5 | 28861 | 25 | |||
| 55899 | 180586 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 177 Santa Rosa Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 6001346.13618 | 2093162.98872 | 37.7275030272355 | -122.437581294937 | (37.7275030272355, -122.437581294937) | 9 | 7 | 6 | 28861 | 25 | |||
| 56237 | 1042 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1999X Alemany Blvd | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 40 | 4X4 | 6000738.08152 | 2090455.78835 | 37.7200350812737 | -122.439489356062 | (37.7200350812737, -122.439489356062) | 9 | 7 | 6 | 28861 | 25 | |||
| 56999 | 929 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1286X Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 25 | 3x3 | 6002834.53778 | 2094157.03866 | 37.7303169767627 | -122.432506857514 | (37.7303169767627, -122.432506857514) | 9 | 7 | 5 | 28861 | 25 | |||
| 60286 | 19057 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 155 Sagamore St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 35 | 3X3 | 5995437.65535 | 2087381.53973 | 37.7112908326789 | -122.457588686968 | (37.7112908326789, -122.457588686968) | 9 | 8 | 6 | 28861 | 24 | |||
| 61972 | 19303 | Permitted Site 7 | Ulmus pumila :: Siberian Elm 99 | 2087X Alemany Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 35 | 3X3 | 6000281.49897 | 2089976.15715 | 37.7186921269443 | -122.441033210291 | (37.7186921269443, -122.441033210291) | 9 | 7 | 6 | 28861 | 25 | |||
| 62520 | 936 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1309 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/09/2016 12:00:00 AM | 3 | 3X3 | 6002560.70092 | 2093898.03009 | 37.7295902655741 | -122.433435046188 | (37.7295902655741, -122.433435046188) | 9 | 7 | 6 | 28861 | 25 | ||
| 63749 | 938 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1319 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 22 | 3X3 | 6002521.94299 | 2093864.98404 | 37.7294973296157 | -122.433566675476 | (37.7294973296157, -122.433566675476) | 9 | 7 | 6 | 28861 | 25 | |||
| 65775 | 180589 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1241 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | Width 4ft | 6003010.99045 | 2094126.19284 | 37.7302422857354 | -122.431894635246 | (37.7302422857354, -122.431894635246) | 9 | 7 | 6 | 28861 | 25 | |||
| 66372 | 883 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1100X ALEMANY BLVD | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 30 | 3X6 | 6003437 | 2094359 | 37.7309056628368 | -122.430438468366 | (37.7309056628368, -122.430438468366) | 9 | 7 | 5 | 28861 | 25 | |||
| 68192 | 19105 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 3155X Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 32 | 3x3 | 5995592.56281 | 2086919.93217 | 37.7100322629968 | -122.457019923286 | (37.7100322629968, -122.457019923286) | 9 | 8 | 6 | 28861 | 25 | |||
| 68937 | 19072 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 204 Sagamore St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 40 | 3x3 | 5994955.69063 | 2087466.73543 | 37.7114970625193 | -122.459260632792 | (37.7114970625193, -122.459260632792) | 9 | 8 | 6 | 28861 | 24 | |||
| 69092 | 885 | Permitted Site 7 | Ulmus pumila :: Siberian Elm 99 | 1100X ALEMANY BLVD | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | 6003437 | 2094359 | 37.7309056628368 | -122.430438468366 | (37.7309056628368, -122.430438468366) | 9 | 7 | 5 | 28861 | 25 | ||||
| 69972 | 180587 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1473 Alemany Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 23 | Width 4ft | 6002172.86661 | 2093413.14517 | 37.7282368704302 | -122.434741167586 | (37.7282368704302, -122.434741167586) | 9 | 7 | 6 | 28861 | 25 | |||
| 73537 | 19097 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 276 Sagamore St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 25 | 2X2 | 5994245.51556 | 2087475.81103 | 37.711481126537 | -122.461715823343 | (37.711481126537, -122.461715823343) | 9 | 8 | 6 | 28861 | 24 | |||
| 74945 | 16703 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1677X Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 43 | 5x6 | 6001597.82921 | 2092328.38749 | 37.7252257090852 | -122.436651476894 | (37.7252257090852, -122.436651476894) | 9 | 7 | 6 | 28861 | 25 | |||
| 84065 | 19069 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 200 Sagamore St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 5994992.35128 | 2087465.62621 | 37.711496124512 | -122.459133844577 | (37.711496124512, -122.459133844577) | 9 | 8 | 6 | 28861 | 24 | |||
| 85776 | 19045 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 111 Sagamore St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 35 | 3X3 | 5995778.7610227 | 2087391.1107423 | 37.7113367008986 | -122.456410438628 | (37.7113367008986, -122.456410438628) | 9 | 8 | 6 | 28861 | 24 | |||
| 91731 | 940 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1331 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 4x4 | 6002472.82123 | 2093812.78737 | 37.7293512221746 | -122.433732764948 | (37.7293512221746, -122.433732764948) | 9 | 7 | 6 | 28861 | 25 | |||
| 93616 | 19090 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 260 Sagamore St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 25 | 3X4 | 5994507.8215972 | 2087458.0224559 | 37.7114473793836 | -122.460807943318 | (37.7114473793836, -122.460807943318) | 9 | 8 | 6 | 28861 | 24 | |||
| 95286 | 180588 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1447 Alemany Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 5ft | 6002392.55611 | 2093716.48474 | 37.7290822421508 | -122.434003367375 | (37.7290822421508, -122.434003367375) | 9 | 7 | 6 | 28861 | 25 | |||
| 98027 | 19106 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 3155X Alemany Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 3x3 | 5995592.56281 | 2086919.93217 | 37.7100322629968 | -122.457019923286 | (37.7100322629968, -122.457019923286) | 9 | 8 | 6 | 28861 | 25 | |||
| 98146 | 915 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1237 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 30 | 3X3 | 6003037.51053 | 2094134.66319 | 37.7302670467787 | -122.431803556408 | (37.7302670467787, -122.431803556408) | 9 | 7 | 6 | 28861 | 25 | |||
| 107664 | 1035 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1989X Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 45 | 3X6 | 6000752.12664 | 2090469.86783 | 37.7200745396752 | -122.439441815719 | (37.7200745396752, -122.439441815719) | 9 | 7 | 6 | 28861 | 25 | |||
| 107794 | 180585 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 177 Santa Rosa Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 2ft | 6001325.27813 | 2093179.51545 | 37.7275472199251 | -122.43765458429 | (37.7275472199251, -122.43765458429) | 9 | 7 | 6 | 28861 | 25 | |||
| 115808 | 19088 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 238 Sagamore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | 3X3 | 5994602.31297 | 2087471.0641 | 37.7114886250695 | -122.460482303322 | (37.7114886250695, -122.460482303322) | 9 | 8 | 6 | 28861 | 24 | |||
| 119308 | 180582 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1110 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 26 | Width 4ft | 6003793.49913 | 2094480.4258 | 37.7312592588934 | -122.429214647441 | (37.7312592588934, -122.429214647441) | 9 | 7 | 5 | 28861 | 25 | |||
| 121303 | 4850 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1499X ALEMANY BLVD | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 6x6 | 6002180 | 2093376 | 37.7281352832027 | -122.43471385212 | (37.7281352832027, -122.43471385212) | 9 | 7 | 6 | 28861 | 25 | |||
| 127111 | 256855 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1777 Alemany Blvd | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6001446 | 2091921 | 37.7240984859228 | -122.437147179411 | (37.7240984859228, -122.437147179411) | 9 | 7 | 6 | 28861 | 25 | ||||
| 128474 | 974 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1599 Alemany Blvd | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 40 | 3X5 | 6001933.92809 | 2093061.63022 | 37.7272581220521 | -122.435542049851 | (37.7272581220521, -122.435542049851) | 9 | 7 | 6 | 28861 | 25 | |||
| 135020 | 979 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1601 Alemany Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 45 | 3X3 | 6001800.3284 | 2092768.49495 | 37.7264456502383 | -122.435982936161 | (37.7264456502383, -122.435982936161) | 9 | 7 | 6 | 28861 | 25 | |||
| 135732 | 4849 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1469X Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | 3X6 | 6002249.52444 | 2093516.68285 | 37.7285255132222 | -122.434483558574 | (37.7285255132222, -122.434483558574) | 9 | 7 | 6 | 28861 | 25 | |||
| 135925 | 1181 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 3003 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 45 | 3x3 | 5996737.10872 | 2087300.2249 | 37.7111421206036 | -122.45309160658 | (37.7111421206036, -122.45309160658) | 9 | 7 | 6 | 28861 | 25 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "trees" ( [rowid] INTEGER PRIMARY KEY, [TreeID] TEXT, [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]), [qSpecies_id] INTEGER, [qAddress] TEXT, [SiteOrder] TEXT, [qSiteInfo] TEXT, [PlantType] TEXT, [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]), [qCareAssistant] TEXT, [PlantDate] TEXT, [DBH] TEXT, [PlotSize] TEXT, [PermitNotes] TEXT, [XCoord] TEXT, [YCoord] TEXT, [Latitude] TEXT, [Longitude] TEXT, [Location] TEXT, [Fire Prevention Districts] TEXT, [Police Districts] TEXT, [Supervisor Districts] TEXT, [Zip Codes] TEXT, [Neighborhoods (old)] TEXT, FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id) );