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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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) | |||
| 17235 | 17235 | 708 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1504X Dolores St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/06/2015 02:27:00 PM | 3 | 6x6 | 6005213.6425 | 2099570.03766 | 37.745314479891896 | -122.42466687479799 | (37.7453144798919, -122.424666874798) | ||
| 139986 | 139986 | 1443 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 151X Arguello Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 36 | 3X5 | 5995492.27499 | 2115135.20138 | 37.7874985527143 | -122.459408560713 | (37.7874985527143, -122.459408560713) | |||
| 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) | ||
| 21228 | 21228 | 5457 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 581 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 5 | 8 | 6004998.45452 | 2104996.17843 | 37.760201244618294 | -122.42579711395099 | (37.7602012446183, -122.425797113951) | |||
| 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) | |||
| 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) | |||
| 20528 | 20528 | 5557 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 977 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/26/2006 12:00:00 AM | 32 | 3x3 | 6005125.10547 | 2102657.90315 | 37.753788045101 | -122.42519270209499 | (37.753788045101, -122.425192702095) | ||
| 20932 | 20932 | 5679 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 1470 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/08/2003 12:00:00 AM | 6 | 3x3 | 6005190.57812 | 2099817.1721900003 | 37.7459917521253 | -122.424764205708 | (37.7459917521253, -122.424764205708) | ||
| 19857 | 19857 | 5683 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1488 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/08/1997 12:00:00 AM | 12 | 6 | 6005201.38668 | 2099720.6305299997 | 37.745727281286705 | -122.42471996446301 | (37.7457272812867, -122.424719964463) | ||
| 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) | |||
| 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) | |||
| 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) | |||
| 104182 | 104182 | 14173 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1797X Market St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 0 | 4X4 | 6005740.867306 | 2109154.5344128003 | 37.7716610284995 | -122.423525097847 | (37.7716610284995, -122.423525097847) | |||
| 129459 | 129459 | 14174 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1797X Market St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 0 | 4X4 | 6005740.867306 | 2109154.5344128003 | 37.7716610284995 | -122.423525097847 | (37.7716610284995, -122.423525097847) | |||
| 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) | |||
| 94802 | 94802 | 18548 | Landmark tree 9 | Phoenix canariensis :: Canary Island Date Palm 100 | 1700X Quesada Ave | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 30 | 19 | 6014793.6967997 | 2095004.1424748 | 37.7333138733401 | -122.39122125893199 | (37.7333138733401, -122.391221258932) | |||
| 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) | |||
| 86395 | 86395 | 18554 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1700X Quesada Ave | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 19 | 6014793.6967997 | 2095004.1424748 | 37.7333138733401 | -122.39122125893199 | (37.7333138733401, -122.391221258932) | |||
| 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) | |||
| 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) | |||
| 85028 | 85028 | 18558 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1700X Quesada Ave | 13 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 19 | 6014793.6967997 | 2095004.1424748 | 37.7333138733401 | -122.39122125893199 | (37.7333138733401, -122.391221258932) | |||
| 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) | |||
| 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) | |||
| 80229 | 80229 | 18563 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1700X Quesada Ave | 18 | Median : Cutout 11 | Tree 1 | DPW 2 | 30 | 19 | 6014793.6967997 | 2095004.1424748 | 37.7333138733401 | -122.39122125893199 | (37.7333138733401, -122.391221258932) | |||
| 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 | ||||||||
| 78381 | 78381 | 23674 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 319 Virginia Ave | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 12 | 6006936.2458165 | 2098250.5638735 | 37.741788638281996 | -122.418616833275 | (37.741788638282, -122.418616833275) | |||
| 138478 | 138478 | 24290 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 386 Winding Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X17 | 6000963.19469 | 2086697.3561200001 | 37.709728074949204 | -122.43844208303699 | (37.7097280749492, -122.438442083037) | |||
| 17405 | 17405 | 24337 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 2020X Market St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 05/07/1993 12:00:00 AM | 36 | 8 | 6004420.4688 | 2107930.9893 | 37.7682268534635 | -122.428005232451 | (37.7682268534635, -122.428005232451) | ||
| 19585 | 19585 | 24338 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 2020X Market St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 05/07/1993 12:00:00 AM | 36 | 8 | 6004443.4589 | 2107950.1478 | 37.76828075872071 | -122.42792707731 | (37.7682807587207, -122.42792707731) | ||
| 18461 | 18461 | 24339 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 2020X Market St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 05/07/1993 12:00:00 AM | 36 | 8 | 6004378.3201 | 2107887.5635 | 37.7681052320451 | -122.42814792550399 | (37.7681052320451, -122.428147925504) | ||
| 20710 | 20710 | 24340 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 2000X Market St | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 05/07/1993 12:00:00 AM | 36 | 8 | 6004586.5088 | 2108095.7522 | 37.7686886449818 | -122.42744265544201 | (37.7686886449818, -122.427442655442) | ||
| 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) | ||
| 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) | ||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 97883 | 97883 | 24986 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 292 Dolores St | 13 | Median : Cutout 11 | Tree 1 | DPW 2 | 70 | 20 | 6004817.953366901 | 2106647.0197827998 | 37.7647238606763 | -122.42653893424699 | (37.7647238606763, -122.426538934247) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 20169 | 20169 | 24997 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 400X Dolores St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 10/04/1999 12:00:00 AM | 70 | 20 | 6004897.70828 | 2105945.4375400003 | 37.7628019913498 | -122.426213130441 | (37.7628019913498, -122.426213130441) | ||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 81505 | 81505 | 25003 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 470X Dolores St | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 40 | 20 | 6004864.935087999 | 2105663.9116336997 | 37.762027135623605 | -122.426306436493 | (37.7620271356236, -122.426306436493) | |||
| 21453 | 21453 | 25004 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 400X Dolores St | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 60 | 20 | 6004910.30478 | 2105777.27345 | 37.762340964691504 | -122.42615759100599 | (37.7623409646915, -122.426157591006) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 113929 | 113929 | 25012 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 500X Dolores St | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 24 | 20 | 6004896.4850004995 | 2105439.5076575 | 37.7614127588524 | -122.426181340905 | (37.7614127588524, -122.426181340905) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 77825 | 77825 | 25016 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 710X Dolores St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 70 | 20 | 6004949.2547318 | 2104210.5607702998 | 37.758041343361796 | -122.425911349448 | (37.7580413433618, -122.425911349448) | |||
| 88715 | 88715 | 25017 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 710X Dolores St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 70 | 20 | 6004949.2547318 | 2104210.5607702998 | 37.758041343361796 | -122.425911349448 | (37.7580413433618, -122.425911349448) | |||
| 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) | |||
| 85048 | 85048 | 25019 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 710X Dolores St | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 70 | 20 | 6004949.2547318 | 2104210.5607702998 | 37.758041343361796 | -122.425911349448 | (37.7580413433618, -122.425911349448) | |||
| 96774 | 96774 | 25020 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 710X Dolores St | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 70 | 20 | 6004949.2547318 | 2104210.5607702998 | 37.758041343361796 | -122.425911349448 | (37.7580413433618, -122.425911349448) | |||
| 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) | |||
| 21311 | 21311 | 25022 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 700X Dolores St | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 70 | 20 | 6004995.79572 | 2104126.38242 | 37.75781283950229 | -122.425744399279 | (37.7578128395023, -122.425744399279) | |||
| 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) | |||
| 80924 | 80924 | 25025 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 710X Dolores St | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 70 | 20 | 6004949.2547318 | 2104210.5607702998 | 37.758041343361796 | -122.425911349448 | (37.7580413433618, -122.425911349448) | |||
| 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) | |||
| 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) | |||
| 19160 | 19160 | 25028 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 700X Dolores St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 06/23/1997 12:00:00 AM | 70 | 20 | 6005001.93677 | 2104182.12883 | 37.75796625306 | -122.425727128704 | (37.75796625306, -122.425727128704) | ||
| 69271 | 69271 | 25030 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 740X Dolores St | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 70 | 20 | 6004958.5167563 | 2104022.9997464 | 37.75752686832129 | -122.425865966748 | (37.7575268683213, -122.425865966748) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 108592 | 108592 | 25034 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 794X Dolores St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 70 | 20 | 6004985.41588 | 2103704.6857762 | 37.7566543729812 | -122.425750282521 | (37.7566543729812, -122.425750282521) | |||
| 123535 | 123535 | 25035 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 794X Dolores St | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 60 | 20 | 6004985.41588 | 2103704.6857762 | 37.7566543729812 | -122.425750282521 | (37.7566543729812, -122.425750282521) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) |
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");