trees
897 rows where qSpecies_id = 160 sorted by qAddress
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 172743 | 194275 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1 01st St | 34 | : Yard | Tree | Private 2 | 8 | 6014376.65997 | 2105881.88915 | 37.76315871732 | -122.393424068061 | (37.76315871732, -122.393424068061) | 14 | 3 | 8 | 28856 | 29 | ||||
| 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 | |||
| 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 | |||
| 33986 | 24963 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 100 Dolores St | 4 | Median : Cutout | Tree | DPW 1 | 90 | 20 | 6004800.73696 | 2107633.50365 | 37.7674315357679 | -122.42666873509 | (37.7674315357679, -122.42666873509) | 8 | 4 | 5 | 28862 | 3 | |||
| 83756 | 24968 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 100 Dolores St | 9 | Median : Cutout | Tree | DPW 1 | 90 | 20 | 6004810.58196 | 2107534.13104 | 37.7671592390347 | -122.426627605497 | (37.7671592390347, -122.426627605497) | 8 | 4 | 5 | 28862 | 3 | |||
| 90075 | 24962 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 100 Dolores St | 3 | Median : Cutout | Tree | DPW 1 | 04/21/2005 12:00:00 AM | 30 | 20 | 6004805.8872 | 2107667.07109 | 37.7675239950663 | -122.42665331172 | (37.7675239950663, -122.42665331172) | 8 | 4 | 5 | 28862 | 3 | ||
| 107384 | 24965 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 100 Dolores St | 6 | Median : Cutout | Tree | DPW 1 | 90 | 20 | 6004804.04595 | 2107595.6918 | 37.767327900586 | -122.426654596838 | (37.767327900586, -122.426654596838) | 8 | 4 | 5 | 28862 | 3 | |||
| 116655 | 24966 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 100 Dolores St | 7 | Median : Cutout | Tree | DPW 1 | 90 | 20 | 6004812.73188 | 2107584.41194 | 37.7672974198587 | -122.426623750096 | (37.7672974198587, -122.426623750096) | 8 | 4 | 5 | 28862 | 3 | |||
| 185165 | 24961 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 100 Dolores St | 1 | Median : Cutout | Tree | DPW 1 | 04/21/2005 12:00:00 AM | 90 | 20 | 6004800.95891 | 2107734.51921 | 37.7677089127708 | -122.42667516164 | (37.7677089127708, -122.42667516164) | 8 | 4 | 5 | 28862 | 3 | ||
| 1504 | 19794 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 100 STAIRWAY19 | 16 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 50ST | |||||||||||||
| 1062 | 20065 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 100 STAIRWAY54 | 12 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 15ST | |||||||||||||
| 17161 | 28026 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 100 The Embarcadero | 6 | Median : Cutout | Tree | Port 6 | 02/05/2001 12:00:00 AM | 24 | 4X4 | 6014253.80701 | 2117776.67601 | 37.795812278914 | -122.394682002417 | (37.795812278914, -122.394682002417) | 4 | 2 | 10 | 28860 | 6 | ||
| 28206 | 28025 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 100 The Embarcadero | 5 | Median : Cutout | Tree | Port 6 | 02/05/2001 12:00:00 AM | 24 | 4X4 | 6014170.25601 | 2117873.24701 | 37.7960727946079 | -122.394977873693 | (37.7960727946079, -122.394977873693) | 3 | 2 | 10 | 28860 | 6 | ||
| 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 | ||
| 38999 | 103927 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 100 The Embarcadero | 13 | Median : Cutout | Tree | DPW 1 | 02/05/2001 12:00:00 AM | 4x4 | 6014859 | 2117030 | 37.793795709184 | -122.392535650186 | (37.793795709184, -122.392535650186) | 12 | 2 | 10 | 28855 | 6 | |||
| 39367 | 25684 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 100 The Embarcadero | 2 | Median : Cutout | Tree | Port 6 | 12/18/2000 12:00:00 AM | 12 | 3X3 | 6015953.02501 | 2112484.79201 | 37.781376296324 | -122.388432795571 | (37.781376296324, -122.388432795571) | 6 | 2 | 9 | 28856 | 20 | ||
| 43710 | 27848 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 100 The Embarcadero | 3 | Median : Cutout | Tree | Port 6 | 07/15/1994 12:00:00 AM | 12 | 3X3 | 6015938.91901 | 2112416.43301 | 37.7811878161514 | -122.388476823036 | (37.7811878161514, -122.388476823036) | 6 | 2 | 9 | 28856 | 20 | ||
| 43793 | 28030 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 100 The Embarcadero | 10 | Median : Cutout | Tree | Port 6 | 02/05/2001 12:00:00 AM | 24 | 4X4 | 6014322.16601 | 2117689.87001 | 37.7955777303512 | -122.394439384649 | (37.7955777303512, -122.394439384649) | 4 | 2 | 10 | 28860 | 6 | ||
| 45682 | 28024 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 100 The Embarcadero | 4 | Median : Cutout | Tree | Port 6 | 02/05/2001 12:00:00 AM | 24 | 4X4 | 6014145.30001 | 2117911.22501 | 37.7961756855245 | -122.39506688845 | (37.7961756855245, -122.39506688845) | 3 | 2 | 10 | 28860 | 6 | ||
| 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 | ||
| 77477 | 28023 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 100 The Embarcadero | 3 | Median : Cutout | Tree | Port 6 | 02/05/2001 12:00:00 AM | 24 | 4x4 | 6014119.25801 | 2117944.86201 | 37.7962665966149 | -122.395159357042 | (37.7962665966149, -122.395159357042) | 3 | 2 | 10 | 28860 | 6 | ||
| 86437 | 28032 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 100 The Embarcadero | 12 | Median : Cutout | Tree | Port 6 | 02/05/2001 12:00:00 AM | 24 | 4X4 | 6014349.29301 | 2117643.21201 | 37.7954511263865 | -122.394342251353 | (37.7954511263865, -122.394342251353) | 4 | 2 | 10 | 28860 | 6 | ||
| 111729 | 28027 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 100 The Embarcadero | 7 | Median : Cutout | Tree | Port 6 | 02/05/2001 12:00:00 AM | 24 | 4X4 | 6014263.57201 | 2117754.97501 | 37.795753235969 | -122.394646693031 | (37.795753235969, -122.394646693031) | 4 | 2 | 10 | 28860 | 6 | ||
| 132193 | 28031 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 100 The Embarcadero | 11 | Median : Cutout | Tree | Port 6 | 02/05/2001 12:00:00 AM | 24 | 4X4 | 6014334.10201 | 2117669.25401 | 37.7955217871698 | -122.394396639485 | (37.7955217871698, -122.394396639485) | 4 | 2 | 10 | 28860 | 6 | ||
| 132853 | 27850 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 100 The Embarcadero | 5 | Median : Cutout | Tree | Port 6 | 07/15/1994 12:00:00 AM | 12 | 3X3 | 6015895.51701 | 2112292.73501 | 37.7808457639334 | -122.388618336487 | (37.7808457639334, -122.388618336487) | 6 | 2 | 9 | 28856 | 20 | ||
| 144197 | 28022 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 100 The Embarcadero | 2 | Median : Cutout | Tree | Port 6 | 02/05/2001 12:00:00 AM | 24 | 4X4 | 6014106.23701 | 2117977.41401 | 37.7963552526163 | -122.39520669408 | (37.7963552526163, -122.39520669408) | 3 | 2 | 10 | 28860 | 6 | ||
| 164580 | 27849 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 100 The Embarcadero | 4 | Median : Cutout | Tree | Port 6 | 07/15/1994 12:00:00 AM | 12 | 3X3 | 6015921.55801 | 2112354.58401 | 37.7810170305764 | -122.388532565578 | (37.7810170305764, -122.388532565578) | 6 | 2 | 9 | 28856 | 20 | ||
| 167386 | 27852 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 100 The Embarcadero | 7 | Median : Cutout | Tree | Port 6 | 07/15/1994 12:00:00 AM | 12 | 3X3 | 6015817.39201 | 2112182.05801 | 37.7805375397414 | -122.388880882265 | (37.7805375397414, -122.388880882265) | 6 | 2 | 9 | 28856 | 20 | ||
| 171833 | 27851 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 100 The Embarcadero | 6 | Median : Cutout | Tree | Port 6 | 07/15/1994 12:00:00 AM | 12 | 3X3 | 6015857.53901 | 2112236.31101 | 37.7806887314792 | -122.388745782008 | (37.7806887314792, -122.388745782008) | 6 | 2 | 9 | 28856 | 20 | ||
| 172631 | 27853 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 100 The Embarcadero | 8 | Median : Cutout | Tree | Port 6 | 07/15/1994 12:00:00 AM | 12 | 3X3 | 6015772.90401 | 2112134.31501 | 37.7804039822192 | -122.389031454309 | (37.7804039822192, -122.389031454309) | 6 | 2 | 9 | 28856 | 20 | ||
| 187664 | 28029 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 100 The Embarcadero | 9 | Median : Cutout | Tree | Port 6 | 02/05/2001 12:00:00 AM | 24 | 4X4 | 6014304.80501 | 2117713.74201 | 37.7956423121436 | -122.394501129585 | (37.7956423121436, -122.394501129585) | 4 | 2 | 10 | 28860 | 6 | ||
| 191559 | 28028 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 100 The Embarcadero | 8 | Median : Cutout | Tree | Port 6 | 02/05/2001 12:00:00 AM | 24 | 4X4 | 6014289.61401 | 2117737.61301 | 37.7957070117951 | -122.394555365911 | (37.7957070117951, -122.394555365911) | 4 | 2 | 10 | 28860 | 6 | ||
| 117166 | 113319 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 100 VALENCIA ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 3x3 | 6005986 | 2109035 | 37.7713466487942 | -122.42266867187 | (37.7713466487942, -122.42266867187) | 8 | 2 | 9 | 28853 | 19 | |||
| 20896 | 187504 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 100 Walbridge St | 10 | Front Yard : Yard | Tree | Private 2 | 9 | 6005101.69485 | 2086503.71935 | 37.7094309267755 | -122.424124907354 | (37.7094309267755, -122.424124907354) | 9 | 7 | 6 | 309 | 5 | ||||
| 76464 | 187499 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 100 Walbridge St | 5 | Front Yard : Yard | Tree | Private 2 | 8 | 6005135.10052 | 2086491.02363 | 37.7093979531098 | -122.42400854948 | (37.7093979531098, -122.42400854948) | 9 | 7 | 6 | 309 | 5 | ||||
| 138819 | 187495 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 100 Walbridge St | 1 | Front Yard : Yard | Tree | Private 2 | 8 | 6005184.36761 | 2086469.76682 | 37.7093423678344 | -122.423836763664 | (37.7093423678344, -122.423836763664) | 9 | 7 | 6 | 309 | 5 | ||||
| 161340 | 187497 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 100 Walbridge St | 3 | Front Yard : Yard | Tree | Private 2 | 6 | 6005151.09396 | 2086478.68565 | 37.7093649785846 | -122.423952396694 | (37.7093649785846, -122.423952396694) | 9 | 7 | 6 | 309 | 5 | ||||
| 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 | |||
| 55390 | 25061 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1000X Dolores St | 4 | Median : Cutout | Tree | DPW 1 | 90 | 20 | 6005097.79962 | 2102345.06954 | 37.7529275341834 | -122.425264872687 | (37.7529275341834, -122.425264872687) | 2 | 4 | 5 | 28862 | 22 | |||
| 183434 | 25064 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1000X Dolores St | 7 | Median : Cutout | Tree | DPW 1 | 40 | 20 | 6005102.42257 | 2102227.07793 | 37.7526038178156 | -122.425240490271 | (37.7526038178156, -122.425240490271) | 2 | 4 | 5 | 28862 | 22 | |||
| 190485 | 25067 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1000X Dolores St | 10 | Median : Cutout | Tree | DPW 1 | 40 | 20 | 6005110.57075 | 2102123.34784 | 37.7523194593995 | -122.425204931964 | (37.7523194593995, -122.425204931964) | 2 | 4 | 5 | 28862 | 22 | |||
| 39261 | 234359 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1000x Dolores St | 13 | Median : Yard | Tree | DPW 1 | 31 | 6005116.63925 | 2102018.48994 | 37.7520318867687 | -122.425176485533 | (37.7520318867687, -122.425176485533) | 2 | 4 | 5 | 28862 | 22 | ||||
| 1977 | 132113 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1000x The Embarcadero | 2 | Median : Yard | Tree | DPW 1 | 21 | Width 10ft | 6013330.52243 | 2119204.92075 | 37.7996825238869 | -122.397977001937 | (37.7996825238869, -122.397977001937) | 3 | 1 | 10 | 28860 | 6 | |||
| 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 | |||
| 78947 | 132116 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1000x The Embarcadero | 8 | Median : Yard | Tree | DPW 1 | 23 | Width 10ft | 6013189.6161 | 2119421.22304 | 37.8002685895792 | -122.398479778719 | (37.8002685895792, -122.398479778719) | 3 | 1 | 10 | 28860 | 6 | |||
| 85425 | 132114 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1000x The Embarcadero | 4 | Median : Yard | Tree | DPW 1 | 20 | Width 10ft | 6013298.81612 | 2119255.09608 | 37.7998185274531 | -122.39809024008 | (37.7998185274531, -122.39809024008) | 3 | 1 | 10 | 28860 | 6 | |||
| 95027 | 132071 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1000x The Embarcadero | 3 | Median : Yard | Tree | DPW 1 | 23 | Width 10ft | 6013261.91929 | 2119233.02284 | 37.7997558644996 | -122.398216368212 | (37.7997558644996, -122.398216368212) | 3 | 1 | 10 | 28860 | 6 | |||
| 105728 | 132074 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1000x The Embarcadero | 9 | Median : Yard | Tree | DPW 1 | 20 | Width 10ft | 6013098.86351 | 2119482.52775 | 37.8004318615024 | -122.398798125256 | (37.8004318615024, -122.398798125256) | 3 | 1 | 10 | 28860 | 6 | |||
| 109811 | 132072 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1000x The Embarcadero | 5 | Median : Yard | Tree | DPW 1 | 24 | Width 10ft | 6013209.18431 | 2119314.66631 | 37.799977100409 | -122.398404583712 | (37.799977100409, -122.398404583712) | 3 | 1 | 10 | 28860 | 6 | |||
| 112625 | 132073 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1000x The Embarcadero | 7 | Median : Yard | Tree | DPW 1 | 24 | Width 10ft | 6013155.58738 | 2119398.118 | 37.8002032529271 | -122.398595909995 | (37.8002032529271, -122.398595909995) | 3 | 1 | 10 | 28860 | 6 | |||
| 124776 | 132117 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1000x The Embarcadero | 10 | Median : Yard | Tree | DPW 1 | 17 | Width 10ft | 6013132.77632 | 2119506.77553 | 37.800500329583 | -122.398682475136 | (37.800500329583, -122.398682475136) | 3 | 1 | 10 | 28860 | 6 | |||
| 132004 | 132115 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1000x The Embarcadero | 6 | Median : Yard | Tree | DPW 1 | 23 | Width 10ft | 6013243.85901 | 2119336.70039 | 37.8000395322586 | -122.398286142085 | (37.8000395322586, -122.398286142085) | 3 | 1 | 10 | 28860 | 6 | |||
| 105070 | 234380 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1001 San Jose Ave | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | Width 3ft | 6005142.82168 | 2096774.43039 | 37.7376343766353 | -122.424712922782 | (37.7376343766353, -122.424712922782) | 2 | 7 | 5 | 28859 | 2 | |||
| 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 | |||
| 32602 | 120819 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 101 20th Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 22 | Width 5ft | 5989573.42956 | 2114582.3778 | 37.7856385654779 | -122.47984587102 | (37.7856385654779, -122.47984587102) | 11 | 6 | 2 | 55 | 26 | |||
| 167872 | 194272 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1022 Minna St | 2 | : | Tree | Private 2 | 9 | Width 3ft | 6007547.68753 | 2109714.25342 | 37.7732997020571 | -122.417314852308 | (37.7732997020571, -122.417314852308) | 8 | 2 | 9 | 28853 | 19 | |||
| 25303 | 194388 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1031 Key Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 40 | 6013107.94825 | 2089911.65871 | 37.7192372512804 | -122.396692522765 | (37.7192372512804, -122.396692522765) | 10 | 3 | 8 | 58 | 1 | ||||
| 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 | ||||
| 57058 | 194389 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1031 Key Ave | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 36 | 6013123.75243 | 2089902.89375 | 37.7192140640518 | -122.396637279208 | (37.7192140640518, -122.396637279208) | 10 | 3 | 8 | 58 | 1 | ||||
| 66787 | 194390 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1031 Key Ave | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 29 | 6013152.66051 | 2089880.87187 | 37.7191552052161 | -122.396535811395 | (37.7191552052161, -122.396535811395) | 10 | 3 | 8 | 58 | 1 | ||||
| 102382 | 194387 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1031 Key Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 31 | 6013093.20116 | 2089924.29981 | 37.7192711404238 | -122.396744383961 | (37.7192711404238, -122.396744383961) | 10 | 3 | 8 | 58 | 1 | ||||
| 149334 | 234388 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1069 Dolores St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 30 | Width 5ft | 6005149.23502 | 2102137.71701 | 37.7523610979942 | -122.425072246905 | (37.7523610979942, -122.425072246905) | 2 | 4 | 5 | 28859 | 19 | |||
| 5116 | 25071 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1100X Dolores St | 2 | Median : Cutout | Tree | DPW 1 | 80 | 20 | 6005127.37654 | 2101840.69033 | 37.7515442968352 | -122.42512670443 | (37.7515442968352, -122.42512670443) | 2 | 4 | 5 | 28862 | 22 | |||
| 42792 | 25073 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1100X Dolores St | 4 | Median : Cutout | Tree | DPW 1 | 90 | 20 | 6005132.2187 | 2101761.89405 | 37.7513282140435 | -122.425104353592 | (37.7513282140435, -122.425104353592) | 2 | 4 | 5 | 28862 | 22 | |||
| 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 | |||
| 136289 | 25074 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1100X Dolores St | 5 | Median : Cutout | Tree | DPW 1 | 70 | 20 | 6005132.37065 | 2101712.15677 | 37.751191655576 | -122.425100289545 | (37.751191655576, -122.425100289545) | 2 | 4 | 5 | 28862 | 22 | |||
| 177506 | 25072 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1100X Dolores St | 3 | Median : Cutout | Tree | DPW 1 | 80 | 20 | 6005130.36391 | 2101800.25652 | 37.751433443721 | -122.425113497011 | (37.751433443721, -122.425113497011) | 2 | 4 | 5 | 28862 | 22 | |||
| 102544 | 27697 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 1100X The Embarcadero | 2 | Median : Cutout | Tree | Port 6 | 36 | 10 | 6012224.9996834 | 2120852.6389045 | 37.8041451257683 | -122.401918429695 | (37.8041451257683, -122.401918429695) | 3 | 1 | 10 | 28860 | 6 | |||
| 136674 | 25798 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1100X The Embarcadero | 1 | Median : Cutout | Tree | Port 6 | 08/30/1996 12:00:00 AM | 36 | 10 | 6012871.9305 | 2119823.23547 | 37.801354716114 | -122.399607344202 | (37.801354716114, -122.399607344202) | 3 | 1 | 10 | 28860 | 6 | ||
| 1681 | 132077 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1100x The Embarcadero | 7 | Median : Yard | Tree | DPW 1 | 23 | Width 10ft | 6012714.412 | 2120058.13658 | 37.8019909162964 | -122.400168938451 | (37.8019909162964, -122.400168938451) | 3 | 1 | 10 | 28860 | 6 | |||
| 23431 | 132080 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1100x The Embarcadero | 13 | Median : Yard | Tree | DPW 1 | 26 | Width 10ft | 6012562.54875 | 2120282.53748 | 37.802598598112 | -122.400710234101 | (37.802598598112, -122.400710234101) | 3 | 1 | 10 | 28860 | 6 | |||
| 31803 | 132075 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1100x The Embarcadero | 3 | Median : Yard | Tree | DPW 1 | 23 | Width 10ft | 6012816.85763 | 2119903.53523 | 37.8015721299035 | -122.399803563704 | (37.8015721299035, -122.399803563704) | 3 | 1 | 10 | 28860 | 6 | |||
| 40485 | 132100 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1100x The Embarcadero | 15 | Median : Yard | Tree | DPW 1 | 24 | Width 10ft | 6012551.63717 | 2120363.68822 | 37.8028208098055 | -122.400753698321 | (37.8028208098055, -122.400753698321) | 3 | 1 | 10 | 28860 | 6 | |||
| 44516 | 132094 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1100x The Embarcadero | 4 | Median : Yard | Tree | DPW 1 | 24 | Width 10ft | 6012848.0944 | 2119927.29492 | 37.8016391096046 | -122.399697138826 | (37.8016391096046, -122.399697138826) | 3 | 1 | 10 | 28860 | 6 | |||
| 57723 | 132097 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1100x The Embarcadero | 10 | Median : Yard | Tree | DPW 1 | 22 | Width 10ft | 6012695.81427 | 2120154.08889 | 37.8022533411719 | -122.400240038841 | (37.8022533411719, -122.400240038841) | 3 | 1 | 10 | 28860 | 6 | |||
| 69730 | 132101 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1100x The Embarcadero | 17 | Median : Yard | Tree | DPW 1 | 18 | Width 10ft | 6012520.61539 | 2120407.16114 | 37.802938445615 | -122.40086410632 | (37.802938445615, -122.40086410632) | 3 | 1 | 10 | 28860 | 6 | |||
| 74850 | 132098 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1100x The Embarcadero | 12 | Median : Yard | Tree | DPW 1 | 23 | Width 10ft | 6012646.4501 | 2120224.08688 | 37.8024427860524 | -122.400415783487 | (37.8024427860524, -122.400415783487) | 3 | 1 | 10 | 28860 | 6 | |||
| 99322 | 132095 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1100x The Embarcadero | 6 | Median : Yard | Tree | DPW 1 | 23 | Width 10ft | 6012798.77066 | 2120004.26494 | 37.8018477010824 | -122.399873230589 | (37.8018477010824, -122.399873230589) | 3 | 1 | 10 | 28860 | 6 | |||
| 105718 | 132099 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1100x The Embarcadero | 14 | Median : Yard | Tree | DPW 1 | 22 | Width 10ft | 6012592.45443 | 2120302.68635 | 37.8026555899447 | -122.400608161041 | (37.8026555899447, -122.400608161041) | 3 | 1 | 10 | 28860 | 6 | |||
| 112744 | 132078 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1100x The Embarcadero | 9 | Median : Yard | Tree | DPW 1 | 21 | Width 10ft | 6012663.13034 | 2120132.51785 | 37.8021922897941 | -122.400351625829 | (37.8021922897941, -122.400351625829) | 3 | 1 | 10 | 28860 | 6 | |||
| 119144 | 132096 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1100x The Embarcadero | 8 | Median : Yard | Tree | DPW 1 | 21 | Width 10ft | 6012742.85934 | 2120080.46122 | 37.8020538004962 | -122.400072065282 | (37.8020538004962, -122.400072065282) | 3 | 1 | 10 | 28860 | 6 | |||
| 129767 | 132081 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1100x The Embarcadero | 16 | Median : Yard | Tree | DPW 1 | 20 | Width 10ft | 6012501.69351 | 2120366.84811 | 37.802826700353 | -122.400926752172 | (37.802826700353, -122.400926752172) | 3 | 1 | 10 | 28860 | 6 | |||
| 134552 | 132076 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1100x The Embarcadero | 5 | Median : Yard | Tree | DPW 1 | 25 | Width 10ft | 6012766.89134 | 2119978.53875 | 37.8017752858665 | -122.399981740966 | (37.8017752858665, -122.399981740966) | 3 | 1 | 10 | 28860 | 6 | |||
| 172264 | 132093 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1100x The Embarcadero | 2 | Median : Yard | Tree | DPW 1 | 25 | Width 10ft | 6012902.31977 | 2119848.32419 | 37.8014252975988 | -122.399503945567 | (37.8014252975988, -122.399503945567) | 3 | 1 | 10 | 28860 | 6 | |||
| 184689 | 132079 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1100x The Embarcadero | 11 | Median : Yard | Tree | DPW 1 | 21 | Width 10ft | 6012611.87531 | 2120208.19637 | 37.8023972264213 | -122.400534313224 | (37.8023972264213, -122.400534313224) | 3 | 1 | 10 | 28860 | 6 | |||
| 54424 | 27963 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 1101X The Embarcadero | 3 | Median : Cutout | Tree | Port 6 | 02/05/2001 12:00:00 AM | 36 | 10 | 6012183.0853805 | 2120808.9629681 | 37.8040228629879 | -122.402060405747 | (37.8040228629879, -122.402060405747) | 3 | 1 | 10 | 28860 | 6 | ||
| 119938 | 25746 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 1101X The Embarcadero | 1 | Median : Cutout | Tree | Port 6 | 08/30/1996 12:00:00 AM | 36 | 10 | 6012183.0853805 | 2120808.9629681 | 37.8040228629879 | -122.402060405747 | (37.8040228629879, -122.402060405747) | 3 | 1 | 10 | 28860 | 6 | ||
| 151371 | 25747 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 1101X The Embarcadero | 2 | Median : Cutout | Tree | Port 6 | 08/30/1996 12:00:00 AM | 36 | 10 | 6012183.0853805 | 2120808.9629681 | 37.8040228629879 | -122.402060405747 | (37.8040228629879, -122.402060405747) | 3 | 1 | 10 | 28860 | 6 | ||
| 24405 | 210906 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1113 Kirkham St | 3 | Sidewalk: Curb side : Pot | Tree | Private 2 | 5 | Width 4ft | 5991529.16752 | 2105177.12145 | 37.7599277068135 | -122.472393751863 | (37.7599277068135, -122.472393751863) | 1 | 8 | 4 | 56 | 12 | |||
| 29806 | 234362 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1150x Dolores St | 4 | Median : Yard | Tree | DPW 1 | 25 | 6005144.45634 | 2101528.47617 | 37.7506879938715 | -122.425045428228 | (37.7506879938715, -122.425045428228) | 2 | 4 | 5 | 28862 | 22 | ||||
| 83784 | 234360 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1150x Dolores St | 2 | Median : Yard | Tree | DPW 1 | 21 | 6005142.56045 | 2101579.1271 | 37.7508269625113 | -122.425055587855 | (37.7508269625113, -122.425055587855) | 2 | 4 | 5 | 28862 | 22 | ||||
| 106466 | 234364 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1150x Dolores St | 6 | Median : Yard | Tree | DPW 1 | 23 | 6005148.13697 | 2101464.62312 | 37.7505128760752 | -122.425028157637 | (37.7505128760752, -122.425028157637) | 2 | 4 | 5 | 28862 | 22 | ||||
| 128783 | 234363 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1150x Dolores St | 5 | Median : Yard | Tree | DPW 1 | 25 | 6005145.85028 | 2101496.26634 | 37.7505996318694 | -122.425038316369 | (37.7505996318694, -122.425038316369) | 2 | 4 | 5 | 28862 | 22 | ||||
| 140046 | 234361 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1150x Dolores St | 3 | Median : Yard | Tree | DPW 1 | 27 | 6005142.97819 | 2101556.59196 | 37.7507651098283 | -122.425052540047 | (37.7507651098283, -122.425052540047) | 2 | 4 | 5 | 28862 | 22 | ||||
| 146552 | 234365 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1150x Dolores St | 7 | Median : Yard | Tree | DPW 1 | 33 | 6005150.81264 | 2101423.31762 | 37.7503996118641 | -122.425015966416 | (37.7503996118641, -122.425015966416) | 2 | 4 | 5 | 28859 | 22 | ||||
| 117843 | 194273 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1150x Tennessee St | 16 | Median : Yard | Tree | DPW 1 | 20 | Width 8ft | 6015573.17514 | 2103426.76477 | 37.7564838780418 | -122.38911425333 | (37.7564838780418, -122.38911425333) | 10 | 3 | 8 | 28856 | 29 | |||
| 125430 | 194274 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1150x Tennessee St | 17 | Median : Yard | Tree | DPW 1 | 28 | 6015578.25592 | 2103421.32087 | 37.756469211897 | -122.389096301947 | (37.756469211897, -122.389096301947) | 10 | 3 | 8 | 28856 | 29 | ||||
| 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 | |||
| 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 | |||
| 154348 | 25078 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1166 DOLORES ST | 1 | Median : Cutout | Tree | DPW 1 | 80 | 20 | 6005069.8 | 2101528.7 | 37.7506843909536 | -122.425303612289 | (37.7506843909536, -122.425303612289) | 2 | 4 | 5 | 28862 | 22 |
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) );