trees
897 rows where qSpecies_id = 160 sorted by SiteOrder
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 55917 | 86731 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 2 Pico Ave | Front Yard : Cutout | Tree | Private 2 | Permit Number 49705 | 5994102.9 | 2092171.9 | 37.7243672527805 | -122.462549157922 | (37.7243672527805, -122.462549157922) | 9 | 8 | 4 | 59 | 40 | |||||
| 3088 | 261629 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 620x The Embarcadero | 1 | Sidewalk: Property side : Yard | Tree | DPW 1 | 3x3 | 6012640 | 2120258 | 37.8025355435841 | -122.400440487668 | (37.8025355435841, -122.400440487668) | 3 | 1 | 10 | 28860 | 6 | ||||
| 4101 | 261179 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 205 Leland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6009827 | 2087549 | 37.7125667222905 | -122.407867055005 | (37.7125667222905, -122.407867055005) | 9 | 7 | 8 | 309 | 39 | ||||
| 4408 | 234354 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 650x Dolores St | 1 | Median : Yard | Tree | DPW 1 | 23 | 6004979.81363 | 2104508.34972 | 37.7588607286626 | -122.425826859935 | (37.7588607286626, -122.425826859935) | 2 | 4 | 5 | 28862 | 3 | ||||
| 4871 | 132103 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1400x The Embarcadero | 1 | Median : Yard | Tree | DPW 1 | 18 | Width 10ft | 6012095.78368 | 2120981.89347 | 37.8044928149639 | -122.402374687645 | (37.8044928149639, -122.402374687645) | 3 | 1 | 10 | 28860 | 6 | |||
| 6713 | 25016 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 710X Dolores St | 1 | Median : Cutout | Tree | DPW 1 | 70 | 20 | 6004949.2547318 | 2104210.5607703 | 37.7580413433618 | -122.425911349448 | (37.7580413433618, -122.425911349448) | 2 | 4 | 5 | 28862 | 3 | |||
| 7512 | 234395 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 599X Ogden Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 15 | Width 4ft | 6008504 | 2096098 | 37.7359663084052 | -122.413043870385 | (37.7359663084052, -122.413043870385) | 10 | 7 | 7 | 28859 | 2 | |||
| 9423 | 25058 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1000X Dolores St | 1 | Median : Cutout | Tree | DPW 1 | 90 | 20 | 6005092.48697 | 2102458.1018 | 37.753237594342 | -122.425291287561 | (37.753237594342, -122.425291287561) | 2 | 4 | 5 | 28862 | 22 | |||
| 9494 | 259411 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 201x The Embarcadero | 1 | Median : Cutout | Tree | Private 2 | 3x3 | 6013700 | 2118549 | 37.7979020921151 | -122.396652459006 | (37.7979020921151, -122.396652459006) | 3 | 1 | 10 | 28860 | 6 | ||||
| 12943 | 246349 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 2190x Market St | 1 | Median : Cutout | Tree | DPW 1 | 31 | Width 0ft | 6003723.2107 | 2107266.4094 | 37.7663626060268 | -122.430369556243 | (37.7663626060268, -122.430369556243) | 8 | 4 | 5 | 28862 | 3 | |||
| 15348 | 264739 | Landmark tree 11 | Phoenix canariensis :: Canary Island Date Palm 160 | 2040 Sutter St | 1 | Back Yard : Yard | Tree | Private 2 | 6002832.74822 | 2114456.05498 | 37.7860531044459 | -122.433963466929 | (37.7860531044459, -122.433963466929) | 13 | 9 | 11 | 29490 | 27 | |||||
| 16574 | 25108 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1400 Dolores St | 1 | Median : Cutout | Tree | DPW 1 | 30 | 20 | 6005223.67149 | 2100130.84124 | 37.7468548845426 | -122.424672082757 | (37.7468548845426, -122.424672082757) | 2 | 7 | 5 | 63 | 22 | |||
| 18148 | 27929 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 799 The Embarcadero | 1 | Median : Cutout | Tree | Port 6 | 02/01/2001 12:00:00 AM | 24 | 10 | 6012635.1983488 | 2120084.4698961 | 37.8020588041016 | -122.400444907677 | (37.8020588041016, -122.400444907677) | 3 | 1 | 10 | 28860 | 6 | ||
| 18521 | 25799 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1300X The Embarcadero | 1 | Median : Cutout | Tree | Port 6 | 08/30/1996 12:00:00 AM | 36 | 10 | 6012220.09673 | 2120843.1378 | 37.8041187644177 | -122.401934728525 | (37.8041187644177, -122.401934728525) | 3 | 1 | 10 | 28860 | 6 | ||
| 20118 | 173670 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 251x Lathrop Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6012236 | 2086860 | 37.7108094381203 | -122.399492405366 | (37.7108094381203, -122.399492405366) | 10 | 3 | 8 | 309 | 1 | ||||
| 20512 | 25787 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 800X The Embarcadero | 1 | Median : Cutout | Tree | Port 6 | 08/30/1996 12:00:00 AM | 36 | 10 | 6012271.38601 | 2120709.84401 | 37.8037556344242 | -122.401747862284 | (37.8037556344242, -122.401747862284) | 3 | 1 | 10 | 28860 | 6 | ||
| 20670 | 24996 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 400X Dolores St | 1 | Median : Cutout | Tree | DPW 1 | 90 | 20 | 6004898.74738 | 2105973.30508 | 37.7628785677218 | -122.42621152066 | (37.7628785677218, -122.42621152066) | 8 | 4 | 5 | 28859 | 3 | |||
| 20887 | 210907 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1009 Kirkham St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 32 | Width 3ft | 5991740.69924 | 2105187.89339 | 37.7599695243799 | -122.471662958305 | (37.7599695243799, -122.471662958305) | 1 | 8 | 4 | 56 | 12 | |||
| 21114 | 28183 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 299X King St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 6 | 6014324.7762427 | 2110655.258445 | 37.7762624487031 | -122.393937678457 | (37.7762624487031, -122.393937678457) | 6 | 2 | 9 | 28856 | 20 | |||
| 21377 | 210922 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 380 Kingston St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 39 | Width 4ft | 5994038.37723 | 2099205.21989 | 37.7436752972852 | -122.463282329909 | (37.7436752972852, -122.463282329909) | 1 | 8 | 4 | 59 | 40 | |||
| 21739 | 25033 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 700X Dolores St | 1 | Median : Cutout | Tree | DPW 1 | 70 | 20 | 6004995.41159 | 2104224.22732 | 37.7580814768833 | -122.425752691957 | (37.7580814768833, -122.425752691957) | 2 | 4 | 5 | 28862 | 3 | |||
| 21850 | 143058 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 426 GREENWICH ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 30 | Width 0ft | 6010776.1378 | 2120354.2833 | 37.8026957973236 | -122.406897202115 | (37.8026957973236, -122.406897202115) | 3 | 1 | 10 | 308 | 23 | |||
| 23067 | 100537 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 2010X Market St | 1 | Median : Cutout | Tree | DPW 1 | 36 | 8 | 6004815.4 | 2108376.1 | 37.7694713555808 | -122.426670904591 | (37.7694713555808, -122.426670904591) | 7 | 4 | 5 | 28862 | 3 | |||
| 23418 | 248619 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1801x Market St | 1 | Median : Cutout | Tree | DPW 1 | 25 | Width 0ft | 6005765.0052 | 2109117.0426 | 37.7715594473913 | -122.423438937501 | (37.7715594473913, -122.423438937501) | 8 | 2 | 5 | 28853 | 19 | |||
| 23927 | 27766 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 399X The Embarcadero | 1 | Median : Cutout | Tree | Port 6 | 12/01/2000 12:00:00 AM | 24 | 6013580.1568022 | 2118681.7167588 | 37.7982598302065 | -122.397076463892 | (37.7982598302065, -122.397076463892) | 3 | 1 | 10 | 28860 | 6 | |||
| 27783 | 25501 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1900X Market St | 1 | Median : Cutout | Tree | DPW 1 | 04/01/1993 12:00:00 AM | 36 | 8 | 6005202.0445 | 2108688.1512 | 37.7703500248187 | -122.425355725564 | (37.7703500248187, -122.425355725564) | 7 | 2 | 5 | 28853 | 19 | ||
| 28610 | 25736 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 801X The Embarcadero | 1 | Median : Cutout | Tree | Port 6 | 08/15/1996 12:00:00 AM | 24 | 10 | 6012632.1664062 | 2120088.9827256 | 37.8020710261606 | -122.400455716884 | (37.8020710261606, -122.400455716884) | 3 | 1 | 10 | 28860 | 6 | ||
| 28715 | 5503 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 773 Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 5x5 | 6005056.9343 | 2103834.44184 | 37.7570146938877 | -122.425512179943 | (37.7570146938877, -122.425512179943) | 2 | 4 | 5 | 28859 | 19 | |||
| 28718 | 194364 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 310x The Embarcadero | 1 | Median : Yard | Tree | DPW 1 | 30 | Width 8ft | 6016200.86003 | 2114659.13107 | 37.7873602722118 | -122.387727152497 | (37.7873602722118, -122.387727152497) | 6 | 2 | 9 | 28855 | 6 | |||
| 28783 | 234372 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 3782 26th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 32 | Width 3ft | 6005314.45638 | 2100807.30331 | 37.7487174209867 | -122.424406263843 | (37.7487174209867, -122.424406263843) | 2 | 4 | 5 | 28859 | 19 | |||
| 29089 | 27944 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 999 The Embarcadero | 1 | Median : Cutout | Tree | Port 6 | 24 | 4X4 | 6012331.2461069 | 2120536.8810451 | 37.8032840604314 | -122.401528548359 | (37.8032840604314, -122.401528548359) | 3 | 1 | 10 | 28860 | 6 | |||
| 30604 | 246402 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 2000x Market St | 1 | Median : Cutout | Tree | DPW 1 | 30 | Width 0ft | 6004659.311 | 2108158.3365 | 37.7688646036969 | -122.427195296669 | (37.7688646036969, -122.427195296669) | 8 | 4 | 5 | 28862 | 3 | |||
| 31694 | 234402 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 667 Waller St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 23 | Width 3ft | 6002514.48058 | 2108813.73054 | 37.7705426279609 | -122.434660977745 | (37.7705426279609, -122.434660977745) | 15 | 5 | 5 | 29492 | 9 | |||
| 32855 | 25683 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 100 The Embarcadero | 1 | Median : Cutout | Tree | Port 6 | 12/18/2000 12:00:00 AM | 12 | 3X3 | 6015960.62101 | 2112553.15201 | 37.781564418481 | -122.388411289639 | (37.781564418481, -122.388411289639) | 6 | 2 | 9 | 28856 | 20 | ||
| 33867 | 25096 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1300X Dolores St | 1 | Median : Cutout | Tree | DPW 1 | 90 | 20 | 6005188.03023 | 2100718.94336 | 37.7484676648463 | -122.42483715961 | (37.7484676648463, -122.42483715961) | 2 | 4 | 5 | 28859 | 19 | |||
| 35031 | 194386 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1031 Key Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 32 | 6013080.03152 | 2089934.31035 | 37.7192978943535 | -122.396790608192 | (37.7192978943535, -122.396790608192) | 10 | 3 | 8 | 58 | 1 | ||||
| 35617 | 5707 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1600 Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 100 | 3X3 | 6005241.86416 | 2098983.9941 | 37.7437069318227 | -122.424527610259 | (37.7437069318227, -122.424527610259) | 2 | 7 | 5 | 63 | 22 | |||
| 36361 | 25026 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 750X Dolores St | 1 | Median : Cutout | Tree | DPW 1 | 70 | 20 | 6005011.77925 | 2103932.39938 | 37.7572811108424 | -122.425675315185 | (37.7572811108424, -122.425675315185) | 2 | 4 | 5 | 28862 | 3 | |||
| 36707 | 25526 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 2300X Market St | 1 | Median : Cutout | Tree | DPW 1 | 04/01/1993 12:00:00 AM | 36 | 10 | 6002746.7355 | 2106338.4868 | 37.7637593960329 | -122.433680673672 | (37.7637593960329, -122.433680673672) | 15 | 4 | 5 | 28862 | 3 | ||
| 38982 | 60467 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 152 MAJESTIC AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/24/1982 12:00:00 AM | Permit Number 20060 | 5996883 | 2089135 | 37.7161883486769 | -122.452719710267 | (37.7161883486769, -122.452719710267) | 9 | 8 | 6 | 28861 | 24 | |||
| 44069 | 25731 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 501X The Embarcadero | 1 | Median : Cutout | Tree | Port 6 | 08/15/1996 12:00:00 AM | 16 | 10 | 6013387.7643744 | 2119020.8269614 | 37.7991802341421 | -122.39776600259 | (37.7991802341421, -122.39776600259) | 3 | 1 | 10 | 28860 | 6 | ||
| 44354 | 194295 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1942 Quesada Ave | 1 | Front Yard : Yard | Tree | Private 2 | 30 | Width 10ft | 6013443.13195 | 2096013.71128 | 37.7360108970885 | -122.395961290278 | (37.7360108970885, -122.395961290278) | 10 | 3 | 8 | 58 | 1 | |||
| 48553 | 28021 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 100 The Embarcadero | 1 | Median : Cutout | Tree | Port 6 | 02/05/2001 12:00:00 AM | 24 | 4x4 | 6014080.19501 | 2118017.56101 | 37.7964640385194 | -122.395299619332 | (37.7964640385194, -122.395299619332) | 3 | 2 | 10 | 28860 | 6 | ||
| 49036 | 25075 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1198 DOLORES ST | 1 | Median : Cutout | Tree | DPW 1 | 80 | 20 | 6005087.7 | 2101404.7 | 37.7503449269028 | -122.425232889951 | (37.7503449269028, -122.425232889951) | 2 | 4 | 5 | 28862 | 22 | |||
| 51227 | 194309 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 380 The Embarcadero | 1 | : | Tree | Private 2 | 24 | Width 7ft | 6015233.93882 | 2116624.33128 | 37.7927026516602 | -122.39120994708 | (37.7927026516602, -122.39120994708) | 12 | 2 | 9 | 28855 | 6 | |||
| 52518 | 13388 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 218 Marietta Dr | 1 | Median : Cutout | Tree | DPW 1 | 6 | 5 | 5997667.52153 | 2098758.8322 | 37.7426580336411 | -122.45070150969 | (37.7426580336411, -122.45070150969) | 9 | 7 | 4 | 59 | 40 | |||
| 53587 | 24987 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 340X Dolores St | 1 | Median : Cutout | Tree | DPW 1 | 40 | 20 | 6004879.52665 | 2106321.34538 | 37.7638331171148 | -122.426302779348 | (37.7638331171148, -122.426302779348) | 8 | 4 | 5 | 28859 | 3 | |||
| 54034 | 210911 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 443 Gennessee St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 32 | 5997433.82925 | 2094957.55837 | 37.7322072729454 | -122.451235463261 | (37.7322072729454, -122.451235463261) | 9 | 7 | 4 | 59 | 40 | ||||
| 55170 | 25007 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 500X Dolores St | 1 | Median : Cutout | Tree | DPW 1 | 90 | 20 | 6004931.59557 | 2105384.62551 | 37.7612640499245 | -122.426056000898 | (37.7612640499245, -122.426056000898) | 2 | 4 | 5 | 28862 | 3 | |||
| 56236 | 118759 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 544 45th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 43 | Width 5ft | 5981951.74748 | 2112030.16523 | 37.7781852088244 | -122.506024939755 | (37.7781852088244, -122.506024939755) | 11 | 6 | 2 | 55 | 26 | |||
| 57209 | 194341 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 418x The Embarcadero | 1 | Median : Yard | Tree | DPW 1 | 25 | Width 8ft | 6016036.61123 | 2112738.53497 | 37.7820776491035 | -122.388161338867 | (37.7820776491035, -122.388161338867) | 6 | 2 | 9 | 28856 | 6 | |||
| 57913 | 234378 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1 Bird St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 37 | Width 5ft | 6005998.07456 | 2105729.78745 | 37.7622720010628 | -122.422392021673 | (37.7622720010628, -122.422392021673) | 8 | 4 | 5 | 28859 | 19 | |||
| 58771 | 25047 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 900X Dolores St | 1 | Median : Cutout | Tree | DPW 1 | 90 | 20 | 6005062.19129 | 2103039.48532 | 37.7548322263474 | -122.425437427413 | (37.7548322263474, -122.425437427413) | 2 | 4 | 5 | 28862 | 22 | |||
| 60479 | 124659 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 199 Arguello Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 37 | Width 8ft | 5995478.86593 | 2115238.56038 | 37.7877815776324 | -122.459462441459 | (37.7877815776324, -122.459462441459) | 11 | 6 | 1 | 54 | 11 | |||
| 61170 | 25079 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1162 DOLORES ST | 1 | Median : Cutout | Tree | DPW 1 | 80 | 20 | 6005068.3 | 2101554.8 | 37.7507559707678 | -122.425310656505 | (37.7507559707678, -122.425310656505) | 2 | 4 | 5 | 28862 | 22 | |||
| 63037 | 118547 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 8140 Geary Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 26 | Width 5ft | 5981731.05099 | 2112390.85514 | 37.7791625633163 | -122.506815156259 | (37.7791625633163, -122.506815156259) | 11 | 6 | 2 | 55 | 26 | |||
| 63944 | 25748 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 1301X The Embarcadero | 1 | Median : Cutout | Tree | Port 6 | 08/30/1996 12:00:00 AM | 36 | 10 | 6011423.5148387 | 2121491.4283584 | 37.805854321699 | -122.404737040358 | (37.805854321699, -122.404737040358) | 3 | 1 | 10 | 28860 | 23 | ||
| 68051 | 255454 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 218 Joost Ave | 1 | Front Yard : Cutout | Tree | Private 2 | 3x3 | 6000622 | 2094989 | 37.7324756340381 | -122.440215522188 | (37.7324756340381, -122.440215522188) | 9 | 7 | 5 | 63 | 40 | ||||
| 69989 | 178087 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 201 Chicago Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 28 | Width 3ft | 6003003.32466 | 2086943.97699 | 37.7105210777575 | -122.431408625424 | (37.7105210777575, -122.431408625424) | 9 | 7 | 6 | 28861 | 5 | |||
| 71640 | 25070 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1100X Dolores St | 1 | Median : Cutout | Tree | DPW 1 | 80 | 20 | 6005125.72632 | 2101888.99536 | 37.7516768380284 | -122.425135847862 | (37.7516768380284, -122.425135847862) | 2 | 4 | 5 | 28862 | 22 | |||
| 73081 | 132070 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1000x The Embarcadero | 1 | Median : Cutout | Tree | DPW 1 | 23 | Width 5ft | 6013297.80252 | 2119184.84583 | 37.7996255806051 | -122.398088816445 | (37.7996255806051, -122.398088816445) | 3 | 1 | 10 | 28860 | 6 | |||
| 74638 | 246348 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 2150x Market St | 1 | Median : Cutout | Tree | DPW 1 | 32 | Width 0ft | 6003809.2361 | 2107348.5599 | 37.766593043924 | -122.430077871393 | (37.766593043924, -122.430077871393) | 8 | 4 | 5 | 28862 | 3 | |||
| 74716 | 27997 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 300 The Embarcadero | 1 | Median : Cutout | Tree | Port 6 | 02/05/2001 12:00:00 AM | 24 | 4X4 | 6013890.7555668 | 2118454.3638402 | 37.7976528582722 | -122.395985750709 | (37.7976528582722, -122.395985750709) | 3 | 1 | 10 | 28860 | 6 | ||
| 75350 | 178084 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 210 Tocoloma Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 3ft | 6012735.74773 | 2087515.03594 | 37.7126358803078 | -122.397811068042 | (37.7126358803078, -122.397811068042) | 10 | 3 | 8 | 309 | 1 | |||
| 75860 | 26029 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 499X The Embarcadero | 1 | Median : Cutout | Tree | Port 6 | 12/01/2000 12:00:00 AM | 36 | 10 | 6013385.9217822 | 2119009.0450001 | 37.7991477810775 | -122.397771551765 | (37.7991477810775, -122.397771551765) | 3 | 1 | 10 | 28860 | 6 | ||
| 76048 | 246535 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1x Octavia St | 1 | Median : Yard | Tree | DPW 1 | 29 | Width 8ft | 6005703.30857 | 2109325.61851 | 37.7721286642513 | -122.423667182089 | (37.7721286642513, -122.423667182089) | 7 | 9 | 11 | 28852 | 10 | |||
| 77150 | 182268 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1466 35th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 37 | Width 0ft | 5985290.7143 | 2105238.2671 | 37.759732554956 | -122.493973725026 | (37.759732554956, -122.493973725026) | 1 | 8 | 3 | 56 | 35 | |||
| 77645 | 210925 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 43 Melrose Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 36 | Width 10ft | 5999799.64358 | 2095482.91454 | 37.7337849536105 | -122.443094053648 | (37.7337849536105, -122.443094053648) | 9 | 7 | 4 | 63 | 40 | |||
| 82561 | 5679 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1470 Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/08/2003 12:00:00 AM | 6 | 3x3 | 6005190.57812 | 2099817.17219 | 37.7459917521253 | -122.424764205708 | (37.7459917521253, -122.424764205708) | 2 | 7 | 5 | 63 | 22 | ||
| 82878 | 178086 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 364 Capistrano Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 43 | Width 3ft | 6001063.00753 | 2092653.59806 | 37.7260882551546 | -122.438523588412 | (37.7260882551546, -122.438523588412) | 9 | 7 | 6 | 28861 | 25 | |||
| 82936 | 124656 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1 Presidio Ter | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 24 | Width 7ft | 5995441.43994 | 2115441.36584 | 37.7883362746058 | -122.459606621954 | (37.7883362746058, -122.459606621954) | 11 | 6 | 1 | 54 | 11 | |||
| 83322 | 233939 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 270x Dolores St | 1 | Median : Yard | Tree | DPW 1 | 32 | 6004850.2917 | 2106826.33652 | 37.7652180496996 | -122.426439853137 | (37.7652180496996, -122.426439853137) | 8 | 4 | 5 | 28862 | 3 | ||||
| 86619 | 95065 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 4801 03rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 6014916.5089 | 2095299.5463 | 37.7341318071091 | -122.390817297505 | (37.7341318071091, -122.390817297505) | 10 | 3 | 8 | 58 | 1 | |||
| 87181 | 106114 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1752X DOLORES ST | 1 | Median : Yard | Tree | DPW 1 | 6005197 | 2098194.1 | 37.7415355284645 | -122.424626562024 | (37.7415355284645, -122.424626562024) | 2 | 7 | 5 | 63 | 7 | |||||
| 88609 | 25076 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1184 DOLORES ST | 1 | Median : Cutout | Tree | DPW 1 | 80 | 20 | 6005073.9 | 2101453.9 | 37.7504792390956 | -122.425284111983 | (37.7504792390956, -122.425284111983) | 2 | 4 | 5 | 28862 | 22 | |||
| 88702 | 194283 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 2 Tulare St | 1 | Front Yard : Yard | Tree | Private 2 | 44 | 6016255.79944 | 2100318.37917 | 37.7479867182066 | -122.386536741486 | (37.7479867182066, -122.386536741486) | 3 | 8 | 58 | 1 | |||||
| 89748 | 96821 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 610X Dolores St | 1 | Median : Cutout | Tree | DPW 1 | 24 | 20x225 | 6004926.4 | 2104659.4 | 37.7592724584905 | -122.426022342006 | (37.7592724584905, -122.426022342006) | 2 | 4 | 5 | 28862 | 3 | |||
| 90761 | 28372 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 199X The Embarcadero | 1 | Median : Cutout | Tree | Port 6 | 18 | 6014015.4653372 | 2118064.3876984 | 37.7965890133894 | -122.395526881953 | (37.7965890133894, -122.395526881953) | 3 | 1 | 10 | 28860 | 6 | ||||
| 90790 | 25077 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1178 DOLORES ST | 1 | Median : Cutout | Tree | DPW 1 | 80 | 20 | 6005072.5 | 2101478.6 | 37.7505469804869 | -122.42529071074 | (37.7505469804869, -122.42529071074) | 2 | 4 | 5 | 28862 | 22 | |||
| 91496 | 26017 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 899X The Embarcadero | 1 | Median : Cutout | Tree | Port 6 | 12/01/2000 12:00:00 AM | 36 | 10 | 6012483.6012207 | 2120310.1113669 | 37.8026699057947 | -122.400985372375 | (37.8026699057947, -122.400985372375) | 3 | 1 | 10 | 28860 | 6 | ||
| 91562 | 25148 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 2X Dolores St | 1 | Median : Cutout | Tree | DPW 1 | 80 | 20 | 6004781.85822 | 2108123.31219 | 37.7687753648286 | -122.426768919571 | (37.7687753648286, -122.426768919571) | 8 | 4 | 5 | 28862 | 3 | |||
| 93163 | 25628 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 650 The Embarcadero | 1 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 12/18/2000 12:00:00 AM | 12 | 4X4 | 6014034.02503 | 2117986.25531 | 37.796375512586 | -122.395457184304 | (37.796375512586, -122.395457184304) | 3 | 2 | 10 | 28860 | 6 | ||
| 94064 | 27767 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 299X The Embarcadero | 1 | Median : Cutout | Tree | Port 6 | 12/10/2000 12:00:00 AM | 26 | 6013785.1217042 | 2118375.8431165 | 37.797431381421 | -122.396345768748 | (37.797431381421, -122.396345768748) | 3 | 1 | 10 | 28860 | 6 | |||
| 94559 | 25135 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1700X Dolores St | 1 | Median : Cutout | Tree | DPW 1 | 90 | 20 | 6005318.69069 | 2098391.09531 | 37.7420833048092 | -122.424219803815 | (37.7420833048092, -122.424219803815) | 2 | 7 | 5 | 63 | 7 | |||
| 94663 | 132082 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1200x The Embarcadero | 1 | Median : Yard | Tree | DPW 1 | 21 | Width 10ft | 6012375.04896 | 2120549.19866 | 37.8033203256223 | -122.40137783234 | (37.8033203256223, -122.40137783234) | 3 | 1 | 10 | 28860 | 6 | |||
| 95609 | 25080 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1156 DOLORES ST | 1 | Median : Cutout | Tree | DPW 1 | 90 | 20 | 6005077.9 | 2101580.2 | 37.7508262556468 | -122.425279266089 | (37.7508262556468, -122.425279266089) | 2 | 4 | 5 | 28862 | 22 | |||
| 97718 | 27717 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 307X The Embarcadero | 1 | Median : Cutout | Tree | Port 6 | 09/11/2000 12:00:00 AM | 18 | 6013768.7522982 | 2118400.6344275 | 37.7974985415834 | -122.396404150152 | (37.7974985415834, -122.396404150152) | 3 | 1 | 10 | 28860 | 6 | |||
| 98562 | 234368 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1750x Dolores St | 1 | Median : Yard | Tree | DPW 1 | 21 | 6005333.75186 | 2098133.92444 | 37.7413780222889 | -122.42414944174 | (37.7413780222889, -122.42414944174) | 2 | 7 | 5 | 63 | 7 | ||||
| 99109 | 194297 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 2198 Revere Ave | 1 | Side Yard : Yard | Tree | Private 2 | 31 | 6011968.87844 | 2096761.78456 | 37.7379828180593 | -122.401110955803 | (37.7379828180593, -122.401110955803) | 10 | 3 | 8 | 58 | 1 | ||||
| 100339 | 247642 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 632 Banks St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 20 | Width 4ft | 6008490.96565 | 2095907.56445 | 37.7354426820387 | -122.413075474255 | (37.7354426820387, -122.413075474255) | 10 | 7 | 7 | 28859 | 2 | |||
| 101092 | 120801 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 4400 Fulton St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 39 | Width 5ft | 5989725.4481 | 2109944.43454 | 37.7729128936687 | -122.478980576929 | (37.7729128936687, -122.478980576929) | 11 | 6 | 2 | 55 | 26 | |||
| 103103 | 234347 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 550x Dolores St | 1 | Median : Yard | Tree | DPW 1 | 28 | 6004944.62757 | 2105117.25917 | 37.760530661773 | -122.425991895418 | (37.760530661773, -122.425991895418) | 2 | 4 | 5 | 28862 | 3 | ||||
| 103251 | 25091 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1350 Dolores St | 1 | Median : Cutout | Tree | DPW 1 | 80 | 20 | 6005204.68058 | 2100428.03656 | 37.7476698420965 | -122.424758890703 | (37.7476698420965, -122.424758890703) | 2 | 7 | 5 | 63 | 22 | |||
| 103758 | 233928 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 8 Octavia St Frontage East | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 29 | Width 8ft | 6005775.18179 | 2109348.30824 | 37.7721950216148 | -122.423420179704 | (37.7721950216148, -122.423420179704) | 7 | 9 | 11 | 28852 | 10 | |||
| 103858 | 194320 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 400x The Embarcadero | 1 | Median : Yard | Tree | DPW 1 | 23 | Width 7ft | 6014831.89764 | 2117081.36813 | 37.7939352489635 | -122.392633022622 | (37.7939352489635, -122.392633022622) | 12 | 2 | 10 | 28855 | 6 | |||
| 103953 | 194378 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 300x The Embarcadero | 1 | Median : Yard | Tree | DPW 1 | 27 | Width 8ft | 6015852.13367 | 2115594.9283 | 37.7899104347693 | -122.388999044794 | (37.7899104347693, -122.388999044794) | 6 | 2 | 9 | 28855 | 6 | |||
| 104220 | 109174 | Undocumented 4 | Phoenix canariensis :: Canary Island Date Palm 160 | 63 KEYSTONE WAY | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 05/04/2015 12:00:00 AM | 3 | 3x3 | Permit Number 775282 | 5994095.9 | 2093146.9 | 37.7270439629203 | -122.462644049637 | (37.7270439629203, -122.462644049637) | 9 | 8 | 4 | 59 | 40 | |
| 106229 | 24338 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 2020X Market St | 1 | Median : Cutout | Tree | DPW 1 | 05/07/1993 12:00:00 AM | 36 | 8 | 6004443.4589 | 2107950.1478 | 37.7682807587207 | -122.42792707731 | (37.7682807587207, -122.42792707731) | 8 | 4 | 5 | 28862 | 3 | ||
| 106305 | 5683 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1488 Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/08/1997 12:00:00 AM | 12 | 6 | 6005201.38668 | 2099720.63053 | 37.7457272812867 | -122.424719964463 | (37.7457272812867, -122.424719964463) | 2 | 7 | 5 | 63 | 22 | ||
| 106557 | 119450 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 800 33rd Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 32 | 5985749.05602 | 2110390.9661 | 37.7739072286205 | -122.492768088777 | (37.7739072286205, -122.492768088777) | 11 | 6 | 2 | 55 | 26 |
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) );