Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, PlantDate, PermitNotes
qSiteInfo ✖
Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress ▼ | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
134605 | 134605 | 194275 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 1 01st St | 34 | : Yard 23 | Tree 1 | Private 1 | 8 | 6014376.659969999 | 2105881.88915 | 37.76315871732 | -122.39342406806101 | (37.76315871732, -122.393424068061) | ||||
26354 | 26354 | 234378 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 1 Bird St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 37 | Width 5ft | 6005998.07456 | 2105729.78745 | 37.7622720010628 | -122.42239202167299 | (37.7622720010628, -122.422392021673) | |||
25380 | 25380 | 124656 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 1 Presidio Ter | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 24 | Width 7ft | 5995441.43994 | 2115441.36584 | 37.7883362746058 | -122.45960662195401 | (37.7883362746058, -122.459606621954) | |||
17252 | 17252 | 24963 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 100 Dolores St | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 90 | 20 | 6004800.736959999 | 2107633.50365 | 37.7674315357679 | -122.42666873508999 | (37.7674315357679, -122.42666873509) | |||
19333 | 19333 | 24968 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 100 Dolores St | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 90 | 20 | 6004810.58196 | 2107534.1310400004 | 37.767159239034704 | -122.426627605497 | (37.7671592390347, -122.426627605497) | |||
19334 | 19334 | 24962 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 100 Dolores St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/21/2005 12:00:00 AM | 30 | 20 | 6004805.8872 | 2107667.07109 | 37.76752399506629 | -122.42665331171999 | (37.7675239950663, -122.42665331172) | ||
19826 | 19826 | 24965 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 100 Dolores St | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 90 | 20 | 6004804.04595 | 2107595.6918 | 37.767327900586 | -122.42665459683799 | (37.767327900586, -122.426654596838) | |||
20452 | 20452 | 24966 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 100 Dolores St | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 90 | 20 | 6004812.73188 | 2107584.41194 | 37.76729741985871 | -122.426623750096 | (37.7672974198587, -122.426623750096) | |||
22009 | 22009 | 24961 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 100 Dolores St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/21/2005 12:00:00 AM | 90 | 20 | 6004800.95891 | 2107734.51921 | 37.76770891277079 | -122.42667516163999 | (37.7677089127708, -122.42667516164) | ||
15304 | 15304 | 19794 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 100 STAIRWAY19 | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 50ST | ||||||||
11148 | 11148 | 20065 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 100 STAIRWAY54 | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 15ST | ||||||||
77877 | 77877 | 28025 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 100 The Embarcadero | 5 | Median : Cutout 11 | Tree 1 | Port 9 | 02/05/2001 12:00:00 AM | 24 | 4X4 | 6014170.25601 | 2117873.24701 | 37.796072794607895 | -122.39497787369301 | (37.7960727946079, -122.394977873693) | ||
78636 | 78636 | 28030 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 100 The Embarcadero | 10 | Median : Cutout 11 | Tree 1 | Port 9 | 02/05/2001 12:00:00 AM | 24 | 4X4 | 6014322.16601 | 2117689.8700099997 | 37.795577730351205 | -122.39443938464899 | (37.7955777303512, -122.394439384649) | ||
78875 | 78875 | 27848 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 100 The Embarcadero | 3 | Median : Cutout 11 | Tree 1 | Port 9 | 07/15/1994 12:00:00 AM | 12 | 3X3 | 6015938.91901 | 2112416.43301 | 37.7811878161514 | -122.388476823036 | (37.7811878161514, -122.388476823036) | ||
78913 | 78913 | 25684 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 100 The Embarcadero | 2 | Median : Cutout 11 | Tree 1 | Port 9 | 12/18/2000 12:00:00 AM | 12 | 3X3 | 6015953.02501 | 2112484.79201 | 37.781376296324 | -122.388432795571 | (37.781376296324, -122.388432795571) | ||
81297 | 81297 | 28024 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 100 The Embarcadero | 4 | Median : Cutout 11 | Tree 1 | Port 9 | 02/05/2001 12:00:00 AM | 24 | 4X4 | 6014145.300009999 | 2117911.2250099997 | 37.7961756855245 | -122.39506688844999 | (37.7961756855245, -122.39506688845) | ||
81526 | 81526 | 103927 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 100 The Embarcadero | 13 | Median : Cutout 11 | Tree 1 | DPW 2 | 02/05/2001 12:00:00 AM | 4x4 | 6014859.0 | 2117030.0 | 37.793795709183996 | -122.392535650186 | (37.793795709184, -122.392535650186) | |||
82580 | 82580 | 28021 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 100 The Embarcadero | 1 | Median : Cutout 11 | Tree 1 | Port 9 | 02/05/2001 12:00:00 AM | 24 | 4x4 | 6014080.19501 | 2118017.56101 | 37.796464038519396 | -122.39529961933201 | (37.7964640385194, -122.395299619332) | ||
92971 | 92971 | 28023 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 100 The Embarcadero | 3 | Median : Cutout 11 | Tree 1 | Port 9 | 02/05/2001 12:00:00 AM | 24 | 4x4 | 6014119.25801 | 2117944.86201 | 37.7962665966149 | -122.395159357042 | (37.7962665966149, -122.395159357042) | ||
94898 | 94898 | 28032 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 100 The Embarcadero | 12 | Median : Cutout 11 | Tree 1 | Port 9 | 02/05/2001 12:00:00 AM | 24 | 4X4 | 6014349.29301 | 2117643.21201 | 37.7954511263865 | -122.394342251353 | (37.7954511263865, -122.394342251353) | ||
102648 | 102648 | 28027 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 100 The Embarcadero | 7 | Median : Cutout 11 | Tree 1 | Port 9 | 02/05/2001 12:00:00 AM | 24 | 4X4 | 6014263.57201 | 2117754.9750099997 | 37.795753235969 | -122.394646693031 | (37.795753235969, -122.394646693031) | ||
104388 | 104388 | 28031 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 100 The Embarcadero | 11 | Median : Cutout 11 | Tree 1 | Port 9 | 02/05/2001 12:00:00 AM | 24 | 4X4 | 6014334.10201 | 2117669.25401 | 37.7955217871698 | -122.394396639485 | (37.7955217871698, -122.394396639485) | ||
109189 | 109189 | 27850 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 100 The Embarcadero | 5 | Median : Cutout 11 | Tree 1 | Port 9 | 07/15/1994 12:00:00 AM | 12 | 3X3 | 6015895.51701 | 2112292.73501 | 37.7808457639334 | -122.38861833648701 | (37.7808457639334, -122.388618336487) | ||
115397 | 115397 | 28022 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 100 The Embarcadero | 2 | Median : Cutout 11 | Tree 1 | Port 9 | 02/05/2001 12:00:00 AM | 24 | 4X4 | 6014106.23701 | 2117977.41401 | 37.796355252616294 | -122.39520669408002 | (37.7963552526163, -122.39520669408) | ||
117445 | 117445 | 27852 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 100 The Embarcadero | 7 | Median : Cutout 11 | Tree 1 | Port 9 | 07/15/1994 12:00:00 AM | 12 | 3X3 | 6015817.39201 | 2112182.05801 | 37.780537539741395 | -122.388880882265 | (37.7805375397414, -122.388880882265) | ||
120266 | 120266 | 27849 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 100 The Embarcadero | 4 | Median : Cutout 11 | Tree 1 | Port 9 | 07/15/1994 12:00:00 AM | 12 | 3X3 | 6015921.55801 | 2112354.58401 | 37.7810170305764 | -122.388532565578 | (37.7810170305764, -122.388532565578) | ||
123608 | 123608 | 28026 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 100 The Embarcadero | 6 | Median : Cutout 11 | Tree 1 | Port 9 | 02/05/2001 12:00:00 AM | 24 | 4X4 | 6014253.80701 | 2117776.67601 | 37.795812278914 | -122.39468200241699 | (37.795812278914, -122.394682002417) | ||
126124 | 126124 | 25683 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 100 The Embarcadero | 1 | Median : Cutout 11 | Tree 1 | Port 9 | 12/18/2000 12:00:00 AM | 12 | 3X3 | 6015960.62101 | 2112553.15201 | 37.781564418481004 | -122.388411289639 | (37.781564418481, -122.388411289639) | ||
139779 | 139779 | 27853 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 100 The Embarcadero | 8 | Median : Cutout 11 | Tree 1 | Port 9 | 07/15/1994 12:00:00 AM | 12 | 3X3 | 6015772.90401 | 2112134.31501 | 37.780403982219205 | -122.389031454309 | (37.7804039822192, -122.389031454309) | ||
139983 | 139983 | 27851 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 100 The Embarcadero | 6 | Median : Cutout 11 | Tree 1 | Port 9 | 07/15/1994 12:00:00 AM | 12 | 3X3 | 6015857.5390099995 | 2112236.31101 | 37.7806887314792 | -122.388745782008 | (37.7806887314792, -122.388745782008) | ||
142211 | 142211 | 28029 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 100 The Embarcadero | 9 | Median : Cutout 11 | Tree 1 | Port 9 | 02/05/2001 12:00:00 AM | 24 | 4X4 | 6014304.80501 | 2117713.7420099997 | 37.7956423121436 | -122.394501129585 | (37.7956423121436, -122.394501129585) | ||
144979 | 144979 | 28028 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 100 The Embarcadero | 8 | Median : Cutout 11 | Tree 1 | Port 9 | 02/05/2001 12:00:00 AM | 24 | 4X4 | 6014289.61401 | 2117737.61301 | 37.7957070117951 | -122.394555365911 | (37.7957070117951, -122.394555365911) | ||
9337 | 9337 | 113319 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 100 VALENCIA ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3x3 | 6005986.0 | 2109035.0 | 37.7713466487942 | -122.42266867187 | (37.7713466487942, -122.42266867187) | |||
46040 | 46040 | 187495 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 100 Walbridge St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 8 | 6005184.36761 | 2086469.76682 | 37.709342367834395 | -122.423836763664 | (37.7093423678344, -122.423836763664) | ||||
48420 | 48420 | 187504 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 100 Walbridge St | 10 | Front Yard : Yard 7 | Tree 1 | Private 1 | 9 | 6005101.69485 | 2086503.71935 | 37.7094309267755 | -122.424124907354 | (37.7094309267755, -122.424124907354) | ||||
59904 | 59904 | 187497 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 100 Walbridge St | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6 | 6005151.09396 | 2086478.68565 | 37.7093649785846 | -122.42395239669399 | (37.7093649785846, -122.423952396694) | ||||
163407 | 163407 | 187499 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 100 Walbridge St | 5 | Front Yard : Yard 7 | Tree 1 | Private 1 | 8 | 6005135.10052 | 2086491.02363 | 37.7093979531098 | -122.42400854947999 | (37.7093979531098, -122.42400854948) | ||||
17056 | 17056 | 25058 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1000X Dolores St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 90 | 20 | 6005092.48697 | 2102458.1018 | 37.753237594341996 | -122.425291287561 | (37.753237594342, -122.425291287561) | |||
17722 | 17722 | 25061 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1000X Dolores St | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 90 | 20 | 6005097.79962 | 2102345.06954 | 37.7529275341834 | -122.425264872687 | (37.7529275341834, -122.425264872687) | |||
21757 | 21757 | 25064 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1000X Dolores St | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 40 | 20 | 6005102.4225699995 | 2102227.07793 | 37.7526038178156 | -122.425240490271 | (37.7526038178156, -122.425240490271) | |||
22227 | 22227 | 25067 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1000X Dolores St | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 40 | 20 | 6005110.57075 | 2102123.34784 | 37.7523194593995 | -122.425204931964 | (37.7523194593995, -122.425204931964) | |||
47801 | 47801 | 234359 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1000x Dolores St | 13 | Median : Yard 3 | Tree 1 | DPW 2 | 31 | 6005116.63925 | 2102018.48994 | 37.752031886768705 | -122.42517648553302 | (37.7520318867687, -122.425176485533) | ||||
27286 | 27286 | 132113 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1000x The Embarcadero | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 21 | Width 10ft | 6013330.52243 | 2119204.92075 | 37.7996825238869 | -122.39797700193701 | (37.7996825238869, -122.397977001937) | |||
58367 | 58367 | 132070 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1000x The Embarcadero | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 23 | Width 5ft | 6013297.802519999 | 2119184.84583 | 37.7996255806051 | -122.39808881644501 | (37.7996255806051, -122.398088816445) | |||
62709 | 62709 | 132071 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1000x The Embarcadero | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 23 | Width 10ft | 6013261.919290001 | 2119233.02284 | 37.7997558644996 | -122.39821636821199 | (37.7997558644996, -122.398216368212) | |||
66065 | 66065 | 132114 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1000x The Embarcadero | 4 | Median : Yard 3 | Tree 1 | DPW 2 | 20 | Width 10ft | 6013298.81612 | 2119255.09608 | 37.799818527453105 | -122.39809024008001 | (37.7998185274531, -122.39809024008) | |||
68393 | 68393 | 132116 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1000x The Embarcadero | 8 | Median : Yard 3 | Tree 1 | DPW 2 | 23 | Width 10ft | 6013189.6161 | 2119421.22304 | 37.800268589579204 | -122.39847977871901 | (37.8002685895792, -122.398479778719) | |||
115831 | 115831 | 132073 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1000x The Embarcadero | 7 | Median : Yard 3 | Tree 1 | DPW 2 | 24 | Width 10ft | 6013155.58738 | 2119398.1180000002 | 37.800203252927105 | -122.39859590999501 | (37.8002032529271, -122.398595909995) | |||
131771 | 131771 | 132074 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1000x The Embarcadero | 9 | Median : Yard 3 | Tree 1 | DPW 2 | 20 | Width 10ft | 6013098.86351 | 2119482.52775 | 37.800431861502396 | -122.39879812525601 | (37.8004318615024, -122.398798125256) | |||
133036 | 133036 | 132072 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1000x The Embarcadero | 5 | Median : Yard 3 | Tree 1 | DPW 2 | 24 | Width 10ft | 6013209.184309999 | 2119314.66631 | 37.799977100409 | -122.39840458371201 | (37.799977100409, -122.398404583712) | |||
137882 | 137882 | 132117 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1000x The Embarcadero | 10 | Median : Yard 3 | Tree 1 | DPW 2 | 17 | Width 10ft | 6013132.776319999 | 2119506.7755299998 | 37.800500329583 | -122.398682475136 | (37.800500329583, -122.398682475136) | |||
147998 | 147998 | 132115 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1000x The Embarcadero | 6 | Median : Yard 3 | Tree 1 | DPW 2 | 23 | Width 10ft | 6013243.85901 | 2119336.7003900004 | 37.8000395322586 | -122.398286142085 | (37.8000395322586, -122.398286142085) | |||
149367 | 149367 | 234380 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 1001 San Jose Ave | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 9 | Width 3ft | 6005142.82168 | 2096774.43039 | 37.7376343766353 | -122.424712922782 | (37.7376343766353, -122.424712922782) | |||
176402 | 176402 | 210907 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 1009 Kirkham St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 32 | Width 3ft | 5991740.69924 | 2105187.8933900003 | 37.7599695243799 | -122.47166295830499 | (37.7599695243799, -122.471662958305) | |||
157078 | 157078 | 120819 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 101 20th Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 22 | Width 5ft | 5989573.42956 | 2114582.3778 | 37.7856385654779 | -122.47984587101999 | (37.7856385654779, -122.47984587102) | |||
43396 | 43396 | 194272 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 1022 Minna St | 2 | : 4 | Tree 1 | Private 1 | 9 | Width 3ft | 6007547.687530001 | 2109714.25342 | 37.7732997020571 | -122.41731485230801 | (37.7732997020571, -122.417314852308) | |||
39528 | 39528 | 194389 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 1031 Key Ave | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 36 | 6013123.75243 | 2089902.89375 | 37.7192140640518 | -122.396637279208 | (37.7192140640518, -122.396637279208) | ||||
42834 | 42834 | 194390 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 1031 Key Ave | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 29 | 6013152.66051 | 2089880.8718700001 | 37.719155205216104 | -122.396535811395 | (37.7191552052161, -122.396535811395) | ||||
48345 | 48345 | 194388 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 1031 Key Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 40 | 6013107.94825 | 2089911.6587099999 | 37.7192372512804 | -122.39669252276501 | (37.7192372512804, -122.396692522765) | ||||
162443 | 162443 | 194387 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 1031 Key Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 31 | 6013093.20116 | 2089924.2998099998 | 37.7192711404238 | -122.39674438396099 | (37.7192711404238, -122.396744383961) | ||||
186407 | 186407 | 194386 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 1031 Key Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 32 | 6013080.03152 | 2089934.31035 | 37.7192978943535 | -122.396790608192 | (37.7192978943535, -122.396790608192) | ||||
132845 | 132845 | 234388 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 1069 Dolores St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 30 | Width 5ft | 6005149.23502 | 2102137.71701 | 37.7523610979942 | -122.425072246905 | (37.7523610979942, -122.425072246905) | |||
16962 | 16962 | 25071 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1100X Dolores St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 80 | 20 | 6005127.376540001 | 2101840.69033 | 37.751544296835206 | -122.42512670443001 | (37.7515442968352, -122.42512670443) | |||
18230 | 18230 | 25073 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1100X Dolores St | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 90 | 20 | 6005132.2187 | 2101761.89405 | 37.7513282140435 | -122.42510435359199 | (37.7513282140435, -122.425104353592) | |||
18432 | 18432 | 25070 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1100X Dolores St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 80 | 20 | 6005125.726319999 | 2101888.99536 | 37.751676838028395 | -122.425135847862 | (37.7516768380284, -122.425135847862) | |||
20762 | 20762 | 25074 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1100X Dolores St | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 70 | 20 | 6005132.37065 | 2101712.1567700002 | 37.751191655576 | -122.425100289545 | (37.751191655576, -122.425100289545) | |||
21721 | 21721 | 25072 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1100X Dolores St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 80 | 20 | 6005130.36391 | 2101800.2565200003 | 37.751433443721 | -122.425113497011 | (37.751433443721, -122.425113497011) | |||
5785 | 5785 | 25798 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 1100X The Embarcadero | 1 | Median : Cutout 11 | Tree 1 | Port 9 | 08/30/1996 12:00:00 AM | 36 | 10 | 6012871.9305 | 2119823.23547 | 37.801354716114 | -122.39960734420201 | (37.801354716114, -122.399607344202) | ||
103830 | 103830 | 27697 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 1100X The Embarcadero | 2 | Median : Cutout 11 | Tree 1 | Port 9 | 36 | 10 | 6012224.999683401 | 2120852.6389045 | 37.8041451257683 | -122.401918429695 | (37.8041451257683, -122.401918429695) | |||
25390 | 25390 | 132077 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1100x The Embarcadero | 7 | Median : Yard 3 | Tree 1 | DPW 2 | 23 | Width 10ft | 6012714.4120000005 | 2120058.1365799997 | 37.8019909162964 | -122.400168938451 | (37.8019909162964, -122.400168938451) | |||
32862 | 32862 | 132075 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1100x The Embarcadero | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 23 | Width 10ft | 6012816.85763 | 2119903.53523 | 37.8015721299035 | -122.399803563704 | (37.8015721299035, -122.399803563704) | |||
37174 | 37174 | 132080 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1100x The Embarcadero | 13 | Median : Yard 3 | Tree 1 | DPW 2 | 26 | Width 10ft | 6012562.54875 | 2120282.53748 | 37.802598598112 | -122.40071023410101 | (37.802598598112, -122.400710234101) | |||
48115 | 48115 | 132100 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1100x The Embarcadero | 15 | Median : Yard 3 | Tree 1 | DPW 2 | 24 | Width 10ft | 6012551.63717 | 2120363.68822 | 37.802820809805496 | -122.400753698321 | (37.8028208098055, -122.400753698321) | |||
49479 | 49479 | 132094 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1100x The Embarcadero | 4 | Median : Yard 3 | Tree 1 | DPW 2 | 24 | Width 10ft | 6012848.0944 | 2119927.2949200002 | 37.8016391096046 | -122.39969713882601 | (37.8016391096046, -122.399697138826) | |||
56654 | 56654 | 132101 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1100x The Embarcadero | 17 | Median : Yard 3 | Tree 1 | DPW 2 | 18 | Width 10ft | 6012520.61539 | 2120407.16114 | 37.802938445615 | -122.40086410632 | (37.802938445615, -122.40086410632) | |||
59618 | 59618 | 132097 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1100x The Embarcadero | 10 | Median : Yard 3 | Tree 1 | DPW 2 | 22 | Width 10ft | 6012695.81427 | 2120154.0888900002 | 37.8022533411719 | -122.400240038841 | (37.8022533411719, -122.400240038841) | |||
61544 | 61544 | 132098 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1100x The Embarcadero | 12 | Median : Yard 3 | Tree 1 | DPW 2 | 23 | Width 10ft | 6012646.4501 | 2120224.08688 | 37.802442786052396 | -122.40041578348699 | (37.8024427860524, -122.400415783487) | |||
75574 | 75574 | 132078 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1100x The Embarcadero | 9 | Median : Yard 3 | Tree 1 | DPW 2 | 21 | Width 10ft | 6012663.130340001 | 2120132.51785 | 37.8021922897941 | -122.40035162582899 | (37.8021922897941, -122.400351625829) | |||
76777 | 76777 | 132095 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1100x The Embarcadero | 6 | Median : Yard 3 | Tree 1 | DPW 2 | 23 | Width 10ft | 6012798.77066 | 2120004.26494 | 37.801847701082394 | -122.39987323058901 | (37.8018477010824, -122.399873230589) | |||
129992 | 129992 | 132099 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1100x The Embarcadero | 14 | Median : Yard 3 | Tree 1 | DPW 2 | 22 | Width 10ft | 6012592.45443 | 2120302.68635 | 37.8026555899447 | -122.40060816104099 | (37.8026555899447, -122.400608161041) | |||
135157 | 135157 | 132081 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1100x The Embarcadero | 16 | Median : Yard 3 | Tree 1 | DPW 2 | 20 | Width 10ft | 6012501.69351 | 2120366.8481099997 | 37.802826700352995 | -122.400926752172 | (37.802826700353, -122.400926752172) | |||
150555 | 150555 | 132096 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1100x The Embarcadero | 8 | Median : Yard 3 | Tree 1 | DPW 2 | 21 | Width 10ft | 6012742.85934 | 2120080.46122 | 37.8020538004962 | -122.400072065282 | (37.8020538004962, -122.400072065282) | |||
164266 | 164266 | 132076 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1100x The Embarcadero | 5 | Median : Yard 3 | Tree 1 | DPW 2 | 25 | Width 10ft | 6012766.891340001 | 2119978.53875 | 37.8017752858665 | -122.399981740966 | (37.8017752858665, -122.399981740966) | |||
176286 | 176286 | 132079 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1100x The Embarcadero | 11 | Median : Yard 3 | Tree 1 | DPW 2 | 21 | Width 10ft | 6012611.87531 | 2120208.19637 | 37.8023972264213 | -122.40053431322399 | (37.8023972264213, -122.400534313224) | |||
186566 | 186566 | 132093 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1100x The Embarcadero | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 25 | Width 10ft | 6012902.31977 | 2119848.32419 | 37.8014252975988 | -122.39950394556699 | (37.8014252975988, -122.399503945567) | |||
81176 | 81176 | 27963 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 1101X The Embarcadero | 3 | Median : Cutout 11 | Tree 1 | Port 9 | 02/05/2001 12:00:00 AM | 36 | 10 | 6012183.0853805 | 2120808.9629681 | 37.8040228629879 | -122.402060405747 | (37.8040228629879, -122.402060405747) | ||
105106 | 105106 | 25746 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 1101X The Embarcadero | 1 | Median : Cutout 11 | Tree 1 | Port 9 | 08/30/1996 12:00:00 AM | 36 | 10 | 6012183.0853805 | 2120808.9629681 | 37.8040228629879 | -122.402060405747 | (37.8040228629879, -122.402060405747) | ||
111083 | 111083 | 25747 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 1101X The Embarcadero | 2 | Median : Cutout 11 | Tree 1 | Port 9 | 08/30/1996 12:00:00 AM | 36 | 10 | 6012183.0853805 | 2120808.9629681 | 37.8040228629879 | -122.402060405747 | (37.8040228629879, -122.402060405747) | ||
187792 | 187792 | 210906 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 1113 Kirkham St | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 5 | Width 4ft | 5991529.16752 | 2105177.12145 | 37.7599277068135 | -122.47239375186301 | (37.7599277068135, -122.472393751863) | |||
33156 | 33156 | 234362 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1150x Dolores St | 4 | Median : Yard 3 | Tree 1 | DPW 2 | 25 | 6005144.45634 | 2101528.47617 | 37.7506879938715 | -122.425045428228 | (37.7506879938715, -122.425045428228) | ||||
63890 | 63890 | 234360 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1150x Dolores St | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 21 | 6005142.56045 | 2101579.1271 | 37.7508269625113 | -122.425055587855 | (37.7508269625113, -122.425055587855) | ||||
132937 | 132937 | 234364 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1150x Dolores St | 6 | Median : Yard 3 | Tree 1 | DPW 2 | 23 | 6005148.136969999 | 2101464.62312 | 37.7505128760752 | -122.425028157637 | (37.7505128760752, -122.425028157637) | ||||
151204 | 151204 | 234363 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1150x Dolores St | 5 | Median : Yard 3 | Tree 1 | DPW 2 | 25 | 6005145.85028 | 2101496.26634 | 37.7505996318694 | -122.425038316369 | (37.7505996318694, -122.425038316369) | ||||
154721 | 154721 | 234361 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1150x Dolores St | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 27 | 6005142.97819 | 2101556.59196 | 37.75076510982829 | -122.42505254004699 | (37.7507651098283, -122.425052540047) | ||||
158301 | 158301 | 234365 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1150x Dolores St | 7 | Median : Yard 3 | Tree 1 | DPW 2 | 33 | 6005150.81264 | 2101423.31762 | 37.7503996118641 | -122.425015966416 | (37.7503996118641, -122.425015966416) | ||||
151971 | 151971 | 194274 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1150x Tennessee St | 17 | Median : Yard 3 | Tree 1 | DPW 2 | 28 | 6015578.255919999 | 2103421.32087 | 37.756469211897 | -122.389096301947 | (37.756469211897, -122.389096301947) | ||||
152917 | 152917 | 194273 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1150x Tennessee St | 16 | Median : Yard 3 | Tree 1 | DPW 2 | 20 | Width 8ft | 6015573.17514 | 2103426.7647700002 | 37.7564838780418 | -122.38911425333 | (37.7564838780418, -122.38911425333) | |||
100172 | 100172 | 25080 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1156 DOLORES ST | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 90 | 20 | 6005077.9 | 2101580.2 | 37.7508262556468 | -122.425279266089 | (37.7508262556468, -122.425279266089) | |||
85336 | 85336 | 25079 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1162 DOLORES ST | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 80 | 20 | 6005068.3 | 2101554.8 | 37.7507559707678 | -122.42531065650499 | (37.7507559707678, -122.425310656505) | |||
121975 | 121975 | 25078 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1166 DOLORES ST | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 80 | 20 | 6005069.8 | 2101528.7 | 37.7506843909536 | -122.42530361228901 | (37.7506843909536, -122.425303612289) |
JSON shape: default, array, newline-delimited
CREATE TABLE "Street_Tree_List" ( "TreeID" INTEGER, "qLegalStatus" INTEGER, "qSpecies" INTEGER, "qAddress" TEXT, "SiteOrder" INTEGER, "qSiteInfo" INTEGER, "PlantType" INTEGER, "qCaretaker" INTEGER, "qCareAssistant" INTEGER, "PlantDate" TEXT, "DBH" INTEGER, "PlotSize" TEXT, "PermitNotes" TEXT, "XCoord" REAL, "YCoord" REAL, "Latitude" REAL, "Longitude" REAL, "Location" TEXT , FOREIGN KEY ("PlantType") REFERENCES [PlantType](id), FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id), FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id), FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id), FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id), FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id)); CREATE INDEX ["Street_Tree_List_PlantType"] ON [Street_Tree_List]("PlantType"); CREATE INDEX ["Street_Tree_List_qCaretaker"] ON [Street_Tree_List]("qCaretaker"); CREATE INDEX ["Street_Tree_List_qSpecies"] ON [Street_Tree_List]("qSpecies"); CREATE INDEX ["Street_Tree_List_qSiteInfo"] ON [Street_Tree_List]("qSiteInfo"); CREATE INDEX ["Street_Tree_List_qCareAssistant"] ON [Street_Tree_List]("qCareAssistant"); CREATE INDEX ["Street_Tree_List_qLegalStatus"] ON [Street_Tree_List]("qLegalStatus");