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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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) | |||
| 101187 | 101187 | 5485 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 700X Dolores St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 100 | 6 | 6004966.5668947 | 2104283.6095193 | 37.7582428963987 | -122.425856676166 | (37.7582428963987, -122.425856676166) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 17579 | 17579 | 27481 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 850X Dolores St | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 10/04/1999 12:00:00 AM | 90 | 20 | 6005053.38343 | 2103172.36846 | 37.755196594762 | -122.425477343801 | (37.755196594762, -122.425477343801) | ||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 20817 | 20817 | 25112 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1450 Dolores St | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 90 | 20 | 6005235.506709999 | 2099747.61613 | 37.7458033045753 | -122.42460390154699 | (37.7458033045753, -122.424603901547) | |||
| 20892 | 20892 | 25110 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1450 Dolores St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 90 | 20 | 6005236.31225 | 2099800.23492 | 37.7459478292265 | -122.42460485845301 | (37.7459478292265, -122.424604858453) | |||
| 20929 | 20929 | 25087 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1250X Dolores St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 90 | 20 | 6005179.035519999 | 2100967.22192 | 37.7491488725392 | -122.42488592444401 | (37.7491488725392, -122.424885924444) | |||
| 21135 | 21135 | 25089 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1250X Dolores St | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 90 | 20 | 6005180.26353 | 2100884.10883 | 37.748920732509 | -122.424875765702 | (37.748920732509, -122.424875765702) | |||
| 21419 | 21419 | 25138 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1700X Dolores St | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 90 | 20 | 6005319.278030001 | 2098285.9295200002 | 37.7417945765605 | -122.424210295287 | (37.7417945765605, -122.424210295287) | |||
| 21462 | 21462 | 25153 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 50X Dolores St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 90 | 20 | 6004788.48534 | 2107965.7019599997 | 37.768342979778204 | -122.426734771418 | (37.7683429797782, -122.426734771418) | |||
| 21512 | 21512 | 25120 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1550 Dolores St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 90 | 20 | 6005269.99247 | 2099258.02767 | 37.744460954018 | -122.424449836913 | (37.744460954018, -122.424449836913) | |||
| 21632 | 21632 | 25036 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 750X Dolores St | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 90 | 20 | 6005017.04415 | 2103831.36773 | 37.7570039991458 | -122.42564991650801 | (37.7570039991458, -122.425649916508) | |||
| 21636 | 21636 | 24991 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 340 Dolores St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 90 | 20 | 6004880.84753 | 2106292.81252 | 37.763754847342206 | -122.42629617923299 | (37.7637548473422, -122.426296179233) | |||
| 21855 | 21855 | 25111 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1450 Dolores St | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 90 | 20 | 6005242.59316 | 2099769.2409599996 | 37.745863081619895 | -122.424580935573 | (37.7458630816199, -122.424580935573) | |||
| 21891 | 21891 | 25037 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 800X Dolores St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 90 | 20 | 6005031.31461 | 2103614.04185 | 37.7564080795924 | -122.425585096976 | (37.7564080795924, -122.425585096976) | |||
| 21959 | 21959 | 25083 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1200X Dolores St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 90 | 20 | 6005162.35719 | 2101213.31575 | 37.74982364735521 | -122.424961105075 | (37.7498236473552, -122.424961105075) | |||
| 21986 | 21986 | 25118 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1500X Dolores St | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 90 | 20 | 6005257.61936 | 2099436.85892 | 37.74495128509079 | -122.42450533857 | (37.7449512850908, -122.42450533857) | |||
| 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) | ||
| 22048 | 22048 | 25106 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1450X Dolores St | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 90 | 20 | 6005241.17775 | 2099713.8788799997 | 37.74571099007721 | -122.424581892451 | (37.7457109900772, -122.424581892451) | |||
| 27176 | 27176 | 24980 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 292 Dolores St | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 90 | 20 | 6004817.953366901 | 2106647.0197827998 | 37.7647238606763 | -122.42653893424699 | (37.7647238606763, -122.426538934247) | |||
| 82856 | 82856 | 25006 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 470X Dolores St | 12 | Median : Cutout 11 | Tree 1 | DPW 2 | 90 | 20 | 6004864.935087999 | 2105663.9116336997 | 37.762027135623605 | -122.426306436493 | (37.7620271356236, -122.426306436493) | |||
| 82993 | 82993 | 24964 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 198 Dolores St | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 90 | 20 | 6004804.6555297 | 2107199.7616194002 | 37.766240805753604 | -122.426624291348 | (37.7662408057536, -122.426624291348) | |||
| 86637 | 86637 | 24981 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 292 Dolores St | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 90 | 20 | 6004817.953366901 | 2106647.0197827998 | 37.7647238606763 | -122.42653893424699 | (37.7647238606763, -122.426538934247) | |||
| 86700 | 86700 | 25109 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1496 Dolores St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 90 | 20 | 6005218.8222955 | 2099617.195839 | 37.7454442580108 | -122.424652317948 | (37.7454442580108, -122.424652317948) | |||
| 90899 | 90899 | 25044 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 892X Dolores St | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 90 | 20 | 6005007.5951373 | 2103153.9131268 | 37.755143333537205 | -122.425634379859 | (37.7551433335372, -122.425634379859) | |||
| 92821 | 92821 | 25014 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 500X Dolores St | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 90 | 20 | 6004896.4850004995 | 2105439.5076575 | 37.7614127588524 | -122.426181340905 | (37.7614127588524, -122.426181340905) | |||
| 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) | |||
| 100281 | 100281 | 24985 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 292 Dolores St | 12 | Median : Cutout 11 | Tree 1 | DPW 2 | 90 | 20 | 6004817.953366901 | 2106647.0197827998 | 37.7647238606763 | -122.42653893424699 | (37.7647238606763, -122.426538934247) | |||
| 103351 | 103351 | 25147 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1798X Dolores St | 13 | Median : Cutout 11 | Tree 1 | DPW 2 | 90 | 20 | 6005303.475850901 | 2097774.014097 | 37.740388080432204 | -122.42422853472999 | (37.7403880804322, -122.42422853473) | |||
| 108461 | 108461 | 24995 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 398 Dolores St | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 90 | 20 | 6004868.194201699 | 2106023.8985612 | 37.7630157583963 | -122.42632079587099 | (37.7630157583963, -122.426320795871) | |||
| 109140 | 109140 | 25155 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 60X Dolores St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 90 | 20 | 6004737.5115877995 | 2107959.1242988 | 37.768322037027 | -122.426910616409 | (37.768322037027, -122.426910616409) | |||
| 109462 | 109462 | 25117 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1548X Dolores St | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 90 | 20 | 6005242.6409807 | 2099315.8732106998 | 37.7446182400704 | -122.42454852673201 | (37.7446182400704, -122.424548526732) | |||
| 113614 | 113614 | 24982 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 292 Dolores St | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 90 | 20 | 6004817.953366901 | 2106647.0197827998 | 37.7647238606763 | -122.42653893424699 | (37.7647238606763, -122.426538934247) | |||
| 114876 | 114876 | 25046 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 892X Dolores St | 11 | Median : Cutout 11 | Tree 1 | DPW 2 | 90 | 20 | 6005007.5951373 | 2103153.9131268 | 37.755143333537205 | -122.425634379859 | (37.7551433335372, -122.425634379859) | |||
| 117814 | 117814 | 24973 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 198 Dolores St | 14 | Median : Cutout 11 | Tree 1 | DPW 2 | 90 | 20 | 6004804.6555297 | 2107199.7616194002 | 37.766240805753604 | -122.426624291348 | (37.7662408057536, -122.426624291348) | |||
| 117928 | 117928 | 25097 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1388X Dolores St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 90 | 20 | 6005167.2006822 | 2100254.8047856004 | 37.747192070496 | -122.424876171578 | (37.747192070496, -122.424876171578) | |||
| 122371 | 122371 | 25145 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1798X Dolores St | 11 | Median : Cutout 11 | Tree 1 | DPW 2 | 90 | 20 | 6005303.475850901 | 2097774.014097 | 37.740388080432204 | -122.42422853472999 | (37.7403880804322, -122.42422853473) | |||
| 124852 | 124852 | 25043 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 892X Dolores St | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 90 | 20 | 6005007.5951373 | 2103153.9131268 | 37.755143333537205 | -122.425634379859 | (37.7551433335372, -122.425634379859) | |||
| 142252 | 142252 | 24972 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 198 Dolores St | 13 | Median : Cutout 11 | Tree 1 | DPW 2 | 90 | 20 | 6004804.6555297 | 2107199.7616194002 | 37.766240805753604 | -122.426624291348 | (37.7662408057536, -122.426624291348) | |||
| 146068 | 146068 | 5446 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 500X Dolores St | 14 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/20/1990 12:00:00 AM | 90 | 6 | 6004896.4850004995 | 2105439.5076575 | 37.7614127588524 | -122.426181340905 | (37.7614127588524, -122.426181340905) | ||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 20790 | 20790 | 25095 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1300 Dolores St | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 80 | 20 | 6005196.77931 | 2100544.39428 | 37.7479888873864 | -122.424794489489 | (37.7479888873864, -122.424794489489) | |||
| 20879 | 20879 | 25092 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1300 Dolores St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 80 | 20 | 6005189.02223 | 2100681.47449 | 37.7483648399821 | -122.424831064022 | (37.7483648399821, -122.424831064022) | |||
| 21503 | 21503 | 25093 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1300 Dolores St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 80 | 20 | 6005193.32199 | 2100633.40551 | 37.7482330964805 | -122.424812776293 | (37.7482330964805, -122.424812776293) | |||
| 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) | |||
| 24676 | 24676 | 25027 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 740X Dolores St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 80 | 20 | 6004958.5167563 | 2104022.9997464 | 37.75752686832129 | -122.425865966748 | (37.7575268683213, -122.425865966748) | |||
| 81675 | 81675 | 25075 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1198 DOLORES ST | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 80 | 20 | 6005087.7 | 2101404.7 | 37.7503449269028 | -122.425232889951 | (37.7503449269028, -122.425232889951) | |||
| 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) |
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");