trees
430 rows where qSpecies_id = 99 sorted by Longitude
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 | |||||||||||||
| 150449 | 116138 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1601X Armstrong Ave | 10 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 30 | 6014404.0852 | 2092434.1919 | 37.7262356791342 | -122.392388573996 | (37.7262356791342, -122.392388573996) | 10 | 3 | 8 | 58 | 1 | ||||
| 5897 | 199851 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1601 Armstrong Ave | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 30 | Width 0ft | 6014366.3226 | 2092462.8184 | 37.7263121847089 | -122.392521119846 | (37.7263121847089, -122.392521119846) | 10 | 3 | 8 | 58 | 1 | |||
| 122123 | 199849 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1601 Armstrong Ave | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 28 | Width 0ft | 6014322.4694 | 2092498.1446 | 37.7264067479006 | -122.392675189528 | (37.7264067479006, -122.392675189528) | 10 | 3 | 8 | 58 | 1 | |||
| 154944 | 199847 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1601 Armstrong Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 30 | Width 0ft | 6014254.2532 | 2092550.5249 | 37.7265467847844 | -122.392914674805 | (37.7265467847844, -122.392914674805) | 10 | 3 | 8 | 58 | 1 | |||
| 153823 | 199846 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1601 Armstrong Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 30 | Width 0ft | 6014210.3999 | 2092579.1513 | 37.7266229511494 | -122.393068277245 | (37.7266229511494, -122.393068277245) | 10 | 3 | 8 | 58 | 1 | |||
| 30014 | 199844 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1601 Armstrong Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 32 | Width 0ft | 6014142.1837 | 2092625.4409 | 37.7267462633936 | -122.393307337928 | (37.7267462633936, -122.393307337928) | 10 | 3 | 8 | 58 | 1 | |||
| 38772 | 58907 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 354 Peninsula Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/07/1980 12:00:00 AM | 29 | Permit Number 18182 | 6012260.63611 | 2086890.34143 | 37.7108941228427 | -122.399409385456 | (37.7108941228427, -122.399409385456) | 10 | 3 | 8 | 309 | 1 | ||
| 48438 | 26629 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1099X Bay Shore Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/02/2017 12:00:00 AM | 6 | 3x3 | 6011248.5682 | 2094191.84655 | 37.7308861005042 | -122.403420689108 | (37.7308861005042, -122.403420689108) | 10 | 3 | 8 | 58 | 1 | ||
| 155029 | 180579 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 2500 Bay Shore Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | Width 4ft | 6010790.74354 | 2086511.28723 | 37.7097712796836 | -122.404463040238 | (37.7097712796836, -122.404463040238) | 10 | 3 | 8 | 309 | 1 | |||
| 146878 | 16359 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1306x Montgomery St | 3 | Median : Cutout | Tree | DPW 1 | 18 | 8 | 6011459.70542 | 2119848.6083 | 37.8013455628052 | -122.404496083149 | (37.8013455628052, -122.404496083149) | 3 | 1 | 10 | 308 | 23 | |||
| 159593 | 107483 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1306x Montgomery St | 6 | Median : Cutout | Tree | DPW 1 | 17 | 6011458.52251 | 2119859.64432 | 37.8013757989196 | -122.404500953851 | (37.8013757989196, -122.404500953851) | 3 | 1 | 10 | 308 | 23 | ||||
| 56459 | 1867 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 2555 Bay Shore Blvd | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6010748.9210869 | 2086419.1045134 | 37.7095158271004 | -122.404601102054 | (37.7095158271004, -122.404601102054) | 10 | 3 | 8 | 309 | 1 | |||
| 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 | |||
| 160279 | 142976 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 392 CHESTNUT ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 0ft | 6009963.6556 | 2120937.6931 | 37.8042521996842 | -122.409750018417 | (37.8042521996842, -122.409750018417) | 3 | 1 | 10 | 308 | 23 | |||
| 123836 | 102615 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 392 Chestnut St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | 3x3 | 6009946.866 | 2120935.8276 | 37.8042461365953 | -122.409807988636 | (37.8042461365953, -122.409807988636) | 3 | 1 | 10 | 308 | 23 | |||
| 117175 | 142975 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 2000 Stockton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 0ft | 6009927.4614 | 2120951.259 | 37.8042874199173 | -122.409876230033 | (37.8042874199173, -122.409876230033) | 3 | 1 | 10 | 308 | 23 | |||
| 73351 | 142972 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 2010 Stockton St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 0ft | 6009915.1882 | 2121025.8734 | 37.8044916046862 | -122.409923973004 | (37.8044916046862, -122.409923973004) | 3 | 1 | 10 | 308 | 23 | |||
| 174305 | 137082 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1627 Taylor St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6008777.37552 | 2118389.76877 | 37.7971896841052 | -122.413674921875 | (37.7971896841052, -122.413674921875) | 5 | 1 | 10 | 308 | 21 | |||
| 56066 | 137081 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1627 Taylor St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6008775.75798 | 2118410.46159 | 37.7972464106437 | -122.413681983361 | (37.7972464106437, -122.413681983361) | 5 | 1 | 10 | 308 | 21 | |||
| 74287 | 137080 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1639 Taylor St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6008758.62885 | 2118554.07509 | 37.7976397759128 | -122.41375141819 | (37.7976397759128, -122.41375141819) | 5 | 1 | 10 | 308 | 21 | |||
| 27130 | 137079 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1639 Taylor St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6008755.55812 | 2118570.22529 | 37.7976839479247 | -122.413763186745 | (37.7976839479247, -122.413763186745) | 5 | 1 | 10 | 308 | 21 | |||
| 191892 | 137078 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1639 Taylor St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6008753.16727 | 2118586.36158 | 37.7977281199218 | -122.413772601749 | (37.7977281199218, -122.413772601749) | 5 | 1 | 10 | 308 | 21 | |||
| 8385 | 83273 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1639X Taylor St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3 | 6008750.42598 | 2118601.99703 | 37.7977708970553 | -122.413783193943 | (37.7977708970553, -122.413783193943) | 5 | 1 | 10 | 308 | 21 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |
| 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 | |
| 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 | |
| 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 | ||||
| 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 | |||
| 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 | ||
| 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 | ||||
| 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 | |||
| 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 | ||||
| 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 | ||||
| 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 | |||
| 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 | ||||
| 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 | ||
| 74694 | 51907 | Permitted Site 7 | Ulmus pumila :: Siberian Elm 99 | 157 Day St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/18/2005 12:00:00 AM | Permit Number 48113 | 6004926.17092668 | 2098691.36646376 | 37.7428856098168 | -122.425598379966 | (37.7428856098168, -122.425598379966) | 2 | 7 | 5 | 63 | 22 | |||
| 113992 | 51906 | Permitted Site 7 | Ulmus pumila :: Siberian Elm 99 | 157 Day St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/18/2005 12:00:00 AM | Permit Number 48113 | 6004926.17092668 | 2098691.36646376 | 37.7428856098168 | -122.425598379966 | (37.7428856098168, -122.425598379966) | 2 | 7 | 5 | 63 | 22 | |||
| 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 | |||
| 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 | |||
| 193226 | 242792 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1200 San Jose Ave | 12 | Front Yard : Yard | Tree | Private 2 | 37 | 6003987.76148 | 2095934.32271 | 37.7352623274905 | -122.428646648224 | (37.7352623274905, -122.428646648224) | 2 | 7 | 5 | 28861 | 7 | ||||
| 101438 | 108311 | Undocumented 4 | Ulmus pumila :: Siberian Elm 99 | 439x ARLINGTON ST | 1 | Back Yard : Yard | Tree | Private 2 | 6003949.9 | 2096014.9 | 37.7354814316621 | -122.42878329169 | (37.7354814316621, -122.42878329169) | 2 | 7 | 5 | 63 | 7 | |||||
| 123890 | 253385 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1100 Golden Gate Ave | 1 | Front Yard : Yard | Tree | Private 2 | 6004275 | 2112509 | 37.7807887188922 | -122.428834805692 | (37.7807887188922, -122.428834805692) | 7 | 9 | 11 | 29490 | 41 | |||||
| 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 | |||
| 151809 | 180583 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1114 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 25 | Width 4ft | 6003761.56491 | 2094470.84041 | 37.7312311316907 | -122.429324366526 | (37.7312311316907, -122.429324366526) | 9 | 7 | 5 | 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 | |||
| 149879 | 5927 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1335 Eddy St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 07/26/2016 12:00:00 AM | 12 | 4X4 | 6004029.33456 | 2112693.29822 | 37.781280848415 | -122.429697830179 | (37.781280848415, -122.429697830179) | 7 | 9 | 11 | 29490 | 41 | ||
| 68307 | 6271 | Permitted Site 7 | Ulmus pumila :: Siberian Elm 99 | 1420X Ellis St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 4X4 | 6004021.46971 | 2113238.82139 | 37.7827782737541 | -122.429763959937 | (37.7827782737541, -122.429763959937) | 7 | 9 | 11 | 29490 | 41 | |||
| 136001 | 180590 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1159 Alemany Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 24 | Width 4ft | 6003628.44812 | 2094335.41976 | 37.7308517598817 | -122.429774919684 | (37.7308517598817, -122.429774919684) | 9 | 7 | 6 | 28861 | 25 | |||
| 68771 | 6272 | Permitted Site 7 | Ulmus pumila :: Siberian Elm 99 | 1420X Ellis St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 4X4 | 6003992.00537 | 2113234.021 | 37.782763424573 | -122.429865551596 | (37.782763424573, -122.429865551596) | 7 | 9 | 11 | 29490 | 41 | |||
| 89806 | 6273 | Permitted Site 7 | Ulmus pumila :: Siberian Elm 99 | 1420X Ellis St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 4X4 | 6003962.57834 | 2113230.61655 | 37.78275241032 | -122.429967113747 | (37.78275241032, -122.429967113747) | 7 | 9 | 11 | 29490 | 41 | |||
| 118533 | 6276 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1421X Ellis St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6003957.21776 | 2113179.66455 | 37.7826122052638 | -122.429982023346 | (37.7826122052638, -122.429982023346) | 7 | 9 | 11 | 29490 | 41 | |||
| 131369 | 6275 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1421X Ellis St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6003957.21776 | 2113179.66455 | 37.7826122052638 | -122.429982023346 | (37.7826122052638, -122.429982023346) | 7 | 9 | 11 | 29490 | 41 | |||
| 32925 | 10723 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 50X Hollis St | 10 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 4X4 | 6003939.0547033 | 2113373.9919105 | 37.7831447510095 | -122.430058726681 | (37.7831447510095, -122.430058726681) | 7 | 9 | 11 | 29490 | 41 | |||
| 37400 | 10722 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 50X Hollis St | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6003939.0547033 | 2113373.9919105 | 37.7831447510095 | -122.430058726681 | (37.7831447510095, -122.430058726681) | 7 | 9 | 11 | 29490 | 41 | |||
| 41457 | 10719 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 50X Hollis St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6003939.0547033 | 2113373.9919105 | 37.7831447510095 | -122.430058726681 | (37.7831447510095, -122.430058726681) | 7 | 9 | 11 | 29490 | 41 | |||
| 53699 | 10721 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 50X Hollis St | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6003939.0547033 | 2113373.9919105 | 37.7831447510095 | -122.430058726681 | (37.7831447510095, -122.430058726681) | 7 | 9 | 11 | 29490 | 41 | |||
| 76530 | 10718 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 50X Hollis St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6003939.0547033 | 2113373.9919105 | 37.7831447510095 | -122.430058726681 | (37.7831447510095, -122.430058726681) | 7 | 9 | 11 | 29490 | 41 | |||
| 94192 | 10715 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 50X Hollis St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6003939.0547033 | 2113373.9919105 | 37.7831447510095 | -122.430058726681 | (37.7831447510095, -122.430058726681) | 7 | 9 | 11 | 29490 | 41 | |||
| 96176 | 10720 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 50X Hollis St | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6003939.0547033 | 2113373.9919105 | 37.7831447510095 | -122.430058726681 | (37.7831447510095, -122.430058726681) | 7 | 9 | 11 | 29490 | 41 | |||
| 104079 | 10714 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 50X Hollis St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6003939.0547033 | 2113373.9919105 | 37.7831447510095 | -122.430058726681 | (37.7831447510095, -122.430058726681) | 7 | 9 | 11 | 29490 | 41 | |||
| 135722 | 10716 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 50X Hollis St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6003939.0547033 | 2113373.9919105 | 37.7831447510095 | -122.430058726681 | (37.7831447510095, -122.430058726681) | 7 | 9 | 11 | 29490 | 41 | |||
| 168595 | 10717 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 50X Hollis St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6003939.0547033 | 2113373.9919105 | 37.7831447510095 | -122.430058726681 | (37.7831447510095, -122.430058726681) | 7 | 9 | 11 | 29490 | 41 | |||
| 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 | |||
| 191151 | 900 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1167 Alemany Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 25 | 3X3 | 6003509.89866 | 2094295.64409 | 37.7307358309933 | -122.43018192766 | (37.7307358309933, -122.43018192766) | 9 | 7 | 6 | 28861 | 25 | |||
| 68509 | 6281 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1475 Ellis St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6003892.9969 | 2113024.38483 | 37.7821822086902 | -122.430193118546 | (37.7821822086902, -122.430193118546) | 7 | 9 | 11 | 29490 | 41 | |||
| 76992 | 6280 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1475 Ellis St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6003892.9969 | 2113024.38483 | 37.7821822086902 | -122.430193118546 | (37.7821822086902, -122.430193118546) | 7 | 9 | 11 | 29490 | 41 | |||
| 98627 | 6282 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1475 Ellis St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6003892.9969 | 2113024.38483 | 37.7821822086902 | -122.430193118546 | (37.7821822086902, -122.430193118546) | 7 | 9 | 11 | 29490 | 41 | |||
| 107344 | 6284 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1475 Ellis St | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6003892.9969 | 2113024.38483 | 37.7821822086902 | -122.430193118546 | (37.7821822086902, -122.430193118546) | 7 | 9 | 11 | 29490 | 41 | |||
| 142481 | 26486 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1475 Ellis St | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6003892.9969 | 2113024.38483 | 37.7821822086902 | -122.430193118546 | (37.7821822086902, -122.430193118546) | 7 | 9 | 11 | 29490 | 41 | |||
| 192958 | 6278 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1475 Ellis St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6003892.9969 | 2113024.38483 | 37.7821822086902 | -122.430193118546 | (37.7821822086902, -122.430193118546) | 7 | 9 | 11 | 29490 | 41 | |||
| 137453 | 6274 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1420X Ellis St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 4X4 | 6003886.01337 | 2113219.41254 | 37.7827173105424 | -122.430231196525 | (37.7827173105424, -122.430231196525) | 7 | 9 | 11 | 29490 | 41 | |||
| 46485 | 6279 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1475 Ellis St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6003832.24761 | 2113162.85488 | 37.7825589718872 | -122.430413166544 | (37.7825589718872, -122.430413166544) | 7 | 9 | 11 | 29490 | 41 | |||
| 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 | |||
| 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 | ||||
| 147678 | 884 | Permitted Site 7 | Ulmus pumila :: Siberian Elm 99 | 1100X ALEMANY BLVD | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/22/2008 12:00:00 AM | 24 | 3X6 | 6003437 | 2094359 | 37.7309056628368 | -122.430438468366 | (37.7309056628368, -122.430438468366) | 9 | 7 | 5 | 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 | |||
| 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 | |||
| 136804 | 106867 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1974 Union St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | 3x3 | 6003576.11959 | 2118663.726 | 37.7976484534674 | -122.431692125901 | (37.7976484534674, -122.431692125901) | 13 | 9 | 1 | 57 | 17 | |||
| 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 |
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) );