Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, PlantDate, PermitNotes
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate ▼ | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 608 | 608 | 233928 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 8 Octavia St Frontage East | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 29 | Width 8ft | 6005775.18179 | 2109348.30824 | 37.77219502161479 | -122.423420179704 | (37.7721950216148, -122.423420179704) | |||
| 3463 | 3463 | 25005 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 400X Dolores St | 11 | Median : Cutout 11 | Tree 1 | DPW 2 | 60 | 20 | 6004909.6221900005 | 2105744.1135299997 | 37.7622498768445 | -122.426157591005 | (37.7622498768445, -122.426157591005) | |||
| 5467 | 5467 | 27939 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 500X The Embarcadero | 8 | Median : Cutout 11 | Tree 1 | Port 9 | 36 | 4X4 | 6013788.66429 | 2118525.16075 | 37.7978415693921 | -122.396343981507 | (37.7978415693921, -122.396343981507) | |||
| 7009 | 7009 | 27938 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 500X The Embarcadero | 7 | Median : Cutout 11 | Tree 1 | Port 9 | 36 | 4X4 | 6013758.52527 | 2118508.2804400004 | 37.7977935429048 | -122.396447087875 | (37.7977935429048, -122.396447087875) | |||
| 8788 | 8788 | 27937 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 500X The Embarcadero | 6 | Median : Cutout 11 | Tree 1 | Port 9 | 36 | 4X4 | 6013847.17816 | 2118440.8928400003 | 37.797613445554205 | -122.396135596873 | (37.7976134455542, -122.396135596873) | |||
| 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) | |||
| 9471 | 9471 | 18535 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 270 PROSPECT AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 45 | 3X3 | 6006489.0 | 2098160.0 | 37.74151478014 | -122.420156839009 | (37.74151478014, -122.420156839009) | |||
| 9735 | 9735 | 173670 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 251x Lathrop Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6012236.0 | 2086860.0 | 37.7108094381203 | -122.399492405366 | (37.7108094381203, -122.399492405366) | ||||
| 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 | ||||||||
| 13621 | 13621 | 18556 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1700X Quesada Ave | 11 | Median : Cutout 11 | Tree 1 | DPW 2 | 30 | 19 | 6014603.96741 | 2095108.67042 | 37.7335903547148 | -122.391884517749 | (37.7335903547148, -122.391884517749) | |||
| 13733 | 13733 | 29537 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 2600X Ingalls St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 35 | 3X3 | 6015071.7012 | 2091079.6967 | 37.7225535544976 | -122.38998606447299 | (37.7225535544976, -122.389986064473) | |||
| 14049 | 14049 | 18560 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1700X Quesada Ave | 15 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 19 | 6014546.06488 | 2095149.2171099999 | 37.7336984729967 | -122.392087539714 | (37.7336984729967, -122.392087539714) | |||
| 14133 | 14133 | 29536 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 2600X Ingalls St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 35 | 3X3 | 6015127.6919 | 2091149.846 | 37.7227492757118 | -122.38979741293699 | (37.7227492757118, -122.389797412937) | |||
| 14829 | 14829 | 95065 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 4801 03rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6014916.5089 | 2095299.5463 | 37.7341318071091 | -122.390817297505 | (37.7341318071091, -122.390817297505) | |||
| 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 | ||||||||
| 16559 | 16559 | 18559 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1700X Quesada Ave | 14 | Median : Cutout 11 | Tree 1 | DPW 2 | 30 | 19 | 6014565.4208 | 2095135.4289 | 37.733661688034104 | -122.392019656183 | (37.7336616880341, -122.392019656183) | |||
| 16768 | 16768 | 18555 | Landmark tree 9 | Phoenix canariensis :: Canary Island Date Palm 100 | 1700X Quesada Ave | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 19 | 6014626.04256 | 2095092.9200799998 | 37.733548332979105 | -122.39180709603201 | (37.7335483329791, -122.391807096032) | |||
| 16811 | 16811 | 18551 | Landmark tree 9 | Phoenix canariensis :: Canary Island Date Palm 100 | 1700X Quesada Ave | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 30 | 19 | 6014649.71614 | 2095074.3239900002 | 37.733498586072294 | -122.391723949223 | (37.7334985860723, -122.391723949223) | |||
| 16918 | 16918 | 25119 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1500X Dolores St | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 30 | 20 | 6005258.69008 | 2099408.1764 | 37.7448725899054 | -122.42449959638999 | (37.7448725899054, -122.42449959639) | |||
| 16926 | 16926 | 24992 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 340 Dolores St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 90 | 20 | 6004882.50848 | 2106257.6214799997 | 37.763658315014204 | -122.426287928865 | (37.7636583150142, -122.426287928865) | |||
| 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) | |||
| 17004 | 17004 | 25108 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1400 Dolores St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 30 | 20 | 6005223.671490001 | 2100130.84124 | 37.7468548845426 | -122.424672082757 | (37.7468548845426, -122.424672082757) | |||
| 17005 | 17005 | 25139 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1700X Dolores St | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 90 | 20 | 6005326.84877 | 2098252.91312 | 37.741704348480795 | -122.42418177058599 | (37.7417043484808, -122.424181770586) | |||
| 17024 | 17024 | 25136 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1700X Dolores St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 90 | 20 | 6005320.97591 | 2098341.7574 | 37.741947963130706 | -122.424208394127 | (37.7419479631307, -122.424208394127) | |||
| 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) | |||
| 17078 | 17078 | 25113 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1400 Dolores St | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 30 | 20 | 6005228.94357 | 2100007.06865 | 37.7465153311328 | -122.424645049125 | (37.7465153311328, -122.424645049125) | |||
| 17224 | 17224 | 25054 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 900X Dolores St | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 35 | 20 | 6005073.8483 | 2102816.15893 | 37.7542196827988 | -122.42538122246201 | (37.7542196827988, -122.425381222462) | |||
| 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) | |||
| 17260 | 17260 | 24994 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 300 Dolores St | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 90 | 20 | 6004873.5625 | 2106448.79257 | 37.7641827195917 | -122.42633248217399 | (37.7641827195917, -122.426332482174) | |||
| 17276 | 17276 | 25090 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1250X Dolores St | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 90 | 20 | 6005182.99372 | 2100845.43458 | 37.7488146961375 | -122.424863573617 | (37.7488146961375, -122.424863573617) | |||
| 17311 | 17311 | 25026 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 750X Dolores St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 70 | 20 | 6005011.77925 | 2103932.39938 | 37.7572811108424 | -122.42567531518499 | (37.7572811108424, -122.425675315185) | |||
| 17316 | 17316 | 25084 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1200X Dolores St | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 90 | 20 | 6005164.22411 | 2101175.53736 | 37.7497200220711 | -122.42495196167499 | (37.7497200220711, -122.424951961675) | |||
| 17398 | 17398 | 5707 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1600 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 100 | 3X3 | 6005241.864159999 | 2098983.9941 | 37.74370693182271 | -122.424527610259 | (37.7437069318227, -122.424527610259) | |||
| 17425 | 17425 | 25099 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1300X Dolores St | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 70 | 20 | 6005195.84744 | 2100584.78774 | 37.7480997459068 | -122.42480058509899 | (37.7480997459068, -122.424800585099) | |||
| 17442 | 17442 | 25157 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 2X Dolores St | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 90 | 20 | 6004782.44605 | 2108032.94108 | 37.7685272607631 | -122.42676044975201 | (37.7685272607631, -122.426760449752) | |||
| 17487 | 17487 | 25100 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1350X Dolores St | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 60 | 20 | 6005208.528519999 | 2100314.21379 | 37.7473575282405 | -122.424737488671 | (37.7473575282405, -122.424737488671) | |||
| 17518 | 17518 | 25033 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 700X Dolores St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 70 | 20 | 6004995.411590001 | 2104224.22732 | 37.7580814768833 | -122.425752691957 | (37.7580814768833, -122.425752691957) | |||
| 17523 | 17523 | 5503 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 773 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 5x5 | 6005056.9343 | 2103834.44184 | 37.757014693887704 | -122.42551217994301 | (37.7570146938877, -122.425512179943) | |||
| 17575 | 17575 | 24996 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 400X Dolores St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 90 | 20 | 6004898.747380001 | 2105973.30508 | 37.7628785677218 | -122.42621152066002 | (37.7628785677218, -122.42621152066) | |||
| 17598 | 17598 | 9369 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 276 Gold Mine Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 2x2 | 6001136.50681 | 2098095.27018 | 37.7410340073111 | -122.438659251142 | (37.7410340073111, -122.438659251142) | |||
| 17620 | 17620 | 25096 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1300X Dolores St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 90 | 20 | 6005188.030230001 | 2100718.94336 | 37.748467664846295 | -122.42483715961001 | (37.7484676648463, -122.42483715961) | |||
| 17629 | 17629 | 25102 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1400X Dolores St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 90 | 20 | 6005226.05485 | 2100086.94121 | 37.7467344797311 | -122.424660718923 | (37.7467344797311, -122.424660718923) | |||
| 17694 | 17694 | 25052 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 900X Dolores St | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 80 | 20 | 6005070.62845 | 2102872.02457 | 37.7543728949014 | -122.42539633287 | (37.7543728949014, -122.42539633287) | |||
| 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) | |||
| 17756 | 17756 | 25098 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1350X Dolores St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 90 | 20 | 6005207.855169999 | 2100363.5353099997 | 37.7474929157794 | -122.424743325238 | (37.7474929157794, -122.424743325238) | |||
| 17792 | 17792 | 25085 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1200X Dolores St | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 70 | 20 | 6005165.443630001 | 2101134.8464599997 | 37.7496083631354 | -122.424944849843 | (37.7496083631354, -122.424944849843) | |||
| 17821 | 17821 | 25151 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 2X Dolores St | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 90 | 20 | 6004775.21348 | 2108066.2440299997 | 37.768618293721104 | -122.42678783858999 | (37.7686182937211, -122.42678783859) | |||
| 17847 | 17847 | 24989 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 370X Dolores St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 60 | 20 | 6004890.15326 | 2106095.93205 | 37.7632147864474 | -122.426249975677 | (37.7632147864474, -122.426249975677) | |||
| 17932 | 17932 | 24987 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 340X Dolores St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 40 | 20 | 6004879.52665 | 2106321.34538 | 37.7638331171148 | -122.42630277934799 | (37.7638331171148, -122.426302779348) | |||
| 18053 | 18053 | 24998 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 450X Dolores St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 90 | 20 | 6004918.80727 | 2105618.72906 | 37.7619061199926 | -122.426116896691 | (37.7619061199926, -122.426116896691) | |||
| 18060 | 18060 | 25021 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 750X Dolores St | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 70 | 20 | 6005015.543430001 | 2103801.2681 | 37.7569212678239 | -122.425652964336 | (37.7569212678239, -122.425652964336) | |||
| 18061 | 18061 | 25129 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1650X Dolores St | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 40 | 20 | 6005306.59795 | 2098578.64869 | 37.7425976010056 | -122.424274952941 | (37.7425976010056, -122.424274952941) | |||
| 18120 | 18120 | 25009 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 550X Dolores St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 50 | 20 | 6004942.008669999 | 2105066.11314 | 37.7603900788595 | -122.425997312043 | (37.7603900788595, -122.425997312043) | |||
| 18142 | 18142 | 13388 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 218 Marietta Dr | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | 5 | 5997667.5215300005 | 2098758.8322 | 37.7426580336411 | -122.45070150968999 | (37.7426580336411, -122.45070150969) | |||
| 18179 | 18179 | 25015 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 550X Dolores St | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 90 | 20 | 6004955.918219999 | 2104917.6837 | 37.7599833128008 | -122.42593863935 | (37.7599833128008, -122.42593863935) | |||
| 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) | |||
| 18233 | 18233 | 25024 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 700X Dolores St | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 70 | 20 | 6005003.848780001 | 2104046.64903 | 37.757594365417496 | -122.42571087345699 | (37.7575943654175, -122.425710873457) | |||
| 18236 | 18236 | 25007 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 500X Dolores St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 90 | 20 | 6004931.59557 | 2105384.6255099997 | 37.7612640499245 | -122.426056000898 | (37.7612640499245, -122.426056000898) | |||
| 18284 | 18284 | 25123 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1550 Dolores St | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 90 | 20 | 6005274.82817 | 2099143.28527 | 37.744146170621704 | -122.424424956245 | (37.7441461706217, -122.424424956245) | |||
| 18340 | 18340 | 25152 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 50X Dolores St | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 90 | 20 | 6004796.34623 | 2107853.39536 | 37.768035057311 | -122.42669958273999 | (37.768035057311, -122.42669958274) | |||
| 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) | |||
| 18527 | 18527 | 25047 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 900X Dolores St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 90 | 20 | 6005062.19129 | 2103039.48532 | 37.754832226347396 | -122.425437427413 | (37.7548322263474, -122.425437427413) | |||
| 18585 | 18585 | 25121 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1500 Dolores St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 24 | 20 | 6005252.19486 | 2099522.95164 | 37.745187369700105 | -122.424530218294 | (37.7451873697001, -122.424530218294) | |||
| 18700 | 18700 | 25031 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 700X Dolores St | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 25 | 20 | 6005006.55303 | 2104135.2293700003 | 37.7578377390251 | -122.425707825673 | (37.7578377390251, -122.425707825673) | |||
| 18703 | 18703 | 24975 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 200 Dolores St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 90 | 20 | 6004832.79825 | 2107115.15692 | 37.76601009251021 | -122.426520926121 | (37.7660100925102, -122.426520926121) | |||
| 18853 | 18853 | 24967 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 150 Dolores St | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 90 | 20 | 6004824.658890001 | 2107297.38564 | 37.7665099887808 | -122.42656205570499 | (37.7665099887808, -122.426562055705) | |||
| 18866 | 18866 | 25038 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 800X Dolores St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 90 | 20 | 6005033.4036 | 2103578.1948599997 | 37.756309770193 | -122.425575321353 | (37.756309770193, -122.425575321353) | |||
| 18925 | 18925 | 25041 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 800X Dolores St | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 90 | 20 | 6005036.0793699995 | 2103453.27666 | 37.7559669252599 | -122.42555717752899 | (37.7559669252599, -122.425557177529) | |||
| 18928 | 18928 | 25116 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1500X Dolores St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 90 | 20 | 6005256.05434 | 2099495.31423 | 37.7451117016422 | -122.42451490734301 | (37.7451117016422, -122.424514907343) | |||
| 18948 | 18948 | 25002 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 400X Dolores St | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 70 | 20 | 6004897.79092 | 2105856.39656 | 37.7625575106521 | -122.42620650513001 | (37.7625575106521, -122.42620650513) | |||
| 19053 | 19053 | 25122 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1550 Dolores St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 90 | 20 | 6005275.20405 | 2099188.4733700003 | 37.7442702680707 | -122.42442687003 | (37.7442702680707, -122.42442687003) | |||
| 19066 | 19066 | 25040 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 800X Dolores St | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 90 | 20 | 6005037.4743800005 | 2103495.5655400003 | 37.7560831194465 | -122.42555536268499 | (37.7560831194465, -122.425555362685) | |||
| 19082 | 19082 | 25127 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1650X Dolores St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 40 | 20 | 6005306.7238300005 | 2098611.50649 | 37.7426878281697 | -122.424276854096 | (37.7426878281697, -122.424276854096) | |||
| 19185 | 19185 | 25013 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 550X Dolores St | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 90 | 20 | 6004948.9055699995 | 2104970.0682099997 | 37.7601267519689 | -122.425966621772 | (37.7601267519689, -122.425966621772) | |||
| 19235 | 19235 | 24988 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 370X Dolores St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 40 | 20 | 6004888.10333 | 2106135.4070099997 | 37.7633230594236 | -122.426259876316 | (37.7633230594236, -122.426259876316) | |||
| 19258 | 19258 | 25140 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1750X Dolores St | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 90 | 20 | 6005337.960390001 | 2097982.3892099997 | 37.74096217846979 | -122.424124115947 | (37.7409621784698, -122.424124115947) | |||
| 19284 | 19284 | 25135 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1700X Dolores St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 90 | 20 | 6005318.690690001 | 2098391.09531 | 37.742083304809206 | -122.424219803815 | (37.7420833048092, -122.424219803815) | |||
| 19325 | 19325 | 25154 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 50X Dolores St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 90 | 20 | 6004786.45589 | 2107937.0696900003 | 37.7682642477152 | -122.42673975183901 | (37.7682642477152, -122.426739751839) | |||
| 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) | |||
| 19402 | 19402 | 25141 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1750X Dolores St | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 70 | 20 | 6005346.329580001 | 2097965.45382 | 37.740916150253604 | -122.424093974258 | (37.7409161502536, -122.424093974258) | |||
| 19480 | 19480 | 25039 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 800X Dolores St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 90 | 20 | 6005035.06937 | 2103531.66337 | 37.756182099743 | -122.42556624900801 | (37.756182099743, -122.425566249008) | |||
| 19492 | 19492 | 25148 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 2X Dolores St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 80 | 20 | 6004781.85822 | 2108123.31219 | 37.7687753648286 | -122.426768919571 | (37.7687753648286, -122.426768919571) | |||
| 19587 | 19587 | 25088 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1250X Dolores St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 90 | 20 | 6005178.85274 | 2100929.77786 | 37.7490460494561 | -122.424883892899 | (37.7490460494561, -122.424883892899) | |||
| 19629 | 19629 | 25032 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 750X Dolores St | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 70 | 20 | 6005021.65336 | 2103769.84125 | 37.756835322312604 | -122.42562959723 | (37.7568353223126, -122.42562959723) | |||
| 19687 | 19687 | 25091 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1350 Dolores St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 80 | 20 | 6005204.68058 | 2100428.03656 | 37.7476698420965 | -122.42475889070299 | (37.7476698420965, -122.424758890703) | |||
| 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) | |||
| 19960 | 19960 | 25156 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 50X Dolores St | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 90 | 20 | 6004792.45266 | 2107880.8578 | 37.768110242434204 | -122.426715006093 | (37.7681102424342, -122.426715006093) | |||
| 19964 | 19964 | 703 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1375X Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 70 | 3X3 | 6005257.21277 | 2100319.77841 | 37.747375556949 | -122.424569537574 | (37.747375556949, -122.424569537574) | |||
| 19989 | 19989 | 25018 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 750X Dolores St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 70 | 20 | 6005012.95019 | 2103889.3731400003 | 37.757163037054 | -122.42566820334 | (37.757163037054, -122.42566820334) | |||
| 20149 | 20149 | 25149 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 2X Dolores St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 90 | 20x10 | 6004775.29887 | 2108114.09165 | 37.768749676587205 | -122.42679095116002 | (37.7687496765872, -122.42679095116) | |||
| 20197 | 20197 | 25001 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 400X Dolores St | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 90 | 20 | 6004908.3831400005 | 2105867.13213 | 37.7625875866685 | -122.426170634793 | (37.7625875866685, -122.426170634793) | |||
| 20270 | 20270 | 25000 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 450X Dolores St | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 90 | 20 | 6004920.85287 | 2105575.60223 | 37.761787819564205 | -122.42610675143801 | (37.7617878195642, -122.426106751438) | |||
| 20326 | 20326 | 25115 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1550X Dolores St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 90 | 20 | 6005272.16967 | 2099229.32207 | 37.7443822579348 | -122.424440267208 | (37.7443822579348, -122.424440267208) | |||
| 20422 | 20422 | 24978 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 270 Dolores St | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 90 | 20 | 6004857.55515 | 2106727.96369 | 37.764948352008 | -122.42640772573601 | (37.764948352008, -122.426407725736) | |||
| 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) | |||
| 20630 | 20630 | 24974 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 200 Dolores St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 90 | 20 | 6004833.67989 | 2107139.93189 | 37.7660781684855 | -122.426519640982 | (37.7660781684855, -122.426519640982) | |||
| 20678 | 20678 | 25137 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1700X Dolores St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 90 | 20 | 6005325.6404800005 | 2098301.13362 | 37.7418366828201 | -122.424189377061 | (37.7418366828201, -122.424189377061) | |||
| 20697 | 20697 | 24979 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 270 Dolores St | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 90 | 20 | 6004857.886419999 | 2106701.08852 | 37.7648745779366 | -122.426404666261 | (37.7648745779366, -122.426404666261) | |||
| 20703 | 20703 | 24999 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 400X Dolores St | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 90 | 20 | 6004906.6428 | 2105904.72298 | 37.7626907038434 | -122.42617933032899 | (37.7626907038434, -122.426179330329) | |||
| 20716 | 20716 | 25082 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1200X Dolores St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 90 | 20 | 6005158.72228 | 2101250.83835 | 37.7499264704292 | -122.424976344106 | (37.7499264704292, -122.424976344106) |
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");