trees
897 rows where qSpecies_id = 160 sorted by DBH descending
This data as json, CSV (advanced)
| rowid | TreeID | qLegalStatus_id | qSpecies_id | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker_id | qCareAssistant | PlantDate | DBH ▲ | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location | Fire Prevention Districts | Police Districts | Supervisor Districts | Zip Codes | Neighborhoods (old) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1012 | 24992 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 340 Dolores St | 3 | Median : Cutout | Tree | DPW 1 | 90 | 20 | 6004882.50848 | 2106257.62148 | 37.7636583150142 | -122.426287928865 | (37.7636583150142, -122.426287928865) | 8 | 4 | 5 | 28859 | 3 | |||
| 9423 | 25058 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1000X Dolores St | 1 | Median : Cutout | Tree | DPW 1 | 90 | 20 | 6005092.48697 | 2102458.1018 | 37.753237594342 | -122.425291287561 | (37.753237594342, -122.425291287561) | 2 | 4 | 5 | 28862 | 22 | |||
| 15633 | 25139 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1700X Dolores St | 5 | Median : Cutout | Tree | DPW 1 | 90 | 20 | 6005326.84877 | 2098252.91312 | 37.7417043484808 | -122.424181770586 | (37.7417043484808, -122.424181770586) | 2 | 7 | 5 | 63 | 7 | |||
| 17335 | 24980 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 292 Dolores St | 7 | Median : Cutout | Tree | DPW 1 | 90 | 20 | 6004817.9533669 | 2106647.0197828 | 37.7647238606763 | -122.426538934247 | (37.7647238606763, -122.426538934247) | 8 | 4 | 5 | 28862 | 3 | |||
| 18928 | 25136 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1700X Dolores St | 2 | Median : Cutout | Tree | DPW 1 | 90 | 20 | 6005320.97591 | 2098341.7574 | 37.7419479631307 | -122.424208394127 | (37.7419479631307, -122.424208394127) | 2 | 7 | 5 | 63 | 7 | |||
| 19729 | 25157 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 2X Dolores St | 5 | Median : Cutout | Tree | DPW 1 | 90 | 20 | 6004782.44605 | 2108032.94108 | 37.7685272607631 | -122.426760449752 | (37.7685272607631, -122.426760449752) | 8 | 4 | 5 | 28862 | 3 | |||
| 20670 | 24996 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 400X Dolores St | 1 | Median : Cutout | Tree | DPW 1 | 90 | 20 | 6004898.74738 | 2105973.30508 | 37.7628785677218 | -122.42621152066 | (37.7628785677218, -122.42621152066) | 8 | 4 | 5 | 28859 | 3 | |||
| 21370 | 25043 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 892X Dolores St | 8 | Median : Cutout | Tree | DPW 1 | 90 | 20 | 6005007.5951373 | 2103153.9131268 | 37.7551433335372 | -122.425634379859 | (37.7551433335372, -122.425634379859) | 2 | 4 | 5 | 28862 | 22 | |||
| 23966 | 25090 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1250X Dolores St | 5 | Median : Cutout | Tree | DPW 1 | 90 | 20 | 6005182.99372 | 2100845.43458 | 37.7488146961375 | -122.424863573617 | (37.7488146961375, -122.424863573617) | 2 | 4 | 5 | 28859 | 22 | |||
| 25582 | 25084 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1200X Dolores St | 4 | Median : Cutout | Tree | DPW 1 | 90 | 20 | 6005164.22411 | 2101175.53736 | 37.7497200220711 | -122.424951961675 | (37.7497200220711, -122.424951961675) | 2 | 4 | 5 | 28859 | 22 | |||
| 27682 | 27481 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 850X Dolores St | 6 | Median : Cutout | Tree | DPW 1 | 10/04/1999 12:00:00 AM | 90 | 20 | 6005053.38343 | 2103172.36846 | 37.755196594762 | -122.425477343801 | (37.755196594762, -122.425477343801) | 2 | 4 | 5 | 28862 | 22 | ||
| 33867 | 25096 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1300X Dolores St | 1 | Median : Cutout | Tree | DPW 1 | 90 | 20 | 6005188.03023 | 2100718.94336 | 37.7484676648463 | -122.42483715961 | (37.7484676648463, -122.42483715961) | 2 | 4 | 5 | 28859 | 19 | |||
| 33986 | 24963 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 100 Dolores St | 4 | Median : Cutout | Tree | DPW 1 | 90 | 20 | 6004800.73696 | 2107633.50365 | 37.7674315357679 | -122.42666873509 | (37.7674315357679, -122.42666873509) | 8 | 4 | 5 | 28862 | 3 | |||
| 37137 | 24994 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 300 Dolores St | 5 | Median : Cutout | Tree | DPW 1 | 90 | 20 | 6004873.5625 | 2106448.79257 | 37.7641827195917 | -122.426332482174 | (37.7641827195917, -122.426332482174) | 8 | 4 | 5 | 28859 | 3 | |||
| 39095 | 25102 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1400X Dolores St | 2 | Median : Cutout | Tree | DPW 1 | 90 | 20 | 6005226.05485 | 2100086.94121 | 37.7467344797311 | -122.424660718923 | (37.7467344797311, -122.424660718923) | 2 | 7 | 5 | 63 | 22 | |||
| 40411 | 25151 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 2X Dolores St | 4 | Median : Cutout | Tree | DPW 1 | 90 | 20 | 6004775.21348 | 2108066.24403 | 37.7686182937211 | -122.42678783859 | (37.7686182937211, -122.42678783859) | 8 | 4 | 5 | 28862 | 3 | |||
| 42605 | 25098 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1350X Dolores St | 3 | Median : Cutout | Tree | DPW 1 | 90 | 20 | 6005207.85517 | 2100363.53531 | 37.7474929157794 | -122.424743325238 | (37.7474929157794, -122.424743325238) | 2 | 7 | 5 | 63 | 22 | |||
| 42792 | 25073 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1100X Dolores St | 4 | Median : Cutout | Tree | DPW 1 | 90 | 20 | 6005132.2187 | 2101761.89405 | 37.7513282140435 | -122.425104353592 | (37.7513282140435, -122.425104353592) | 2 | 4 | 5 | 28862 | 22 | |||
| 43770 | 24998 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 450X Dolores St | 3 | Median : Cutout | Tree | DPW 1 | 90 | 20 | 6004918.80727 | 2105618.72906 | 37.7619061199926 | -122.426116896691 | (37.7619061199926, -122.426116896691) | 8 | 4 | 5 | 28862 | 3 | |||
| 46729 | 25006 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 470X Dolores St | 12 | Median : Cutout | Tree | DPW 1 | 90 | 20 | 6004864.935088 | 2105663.9116337 | 37.7620271356236 | -122.426306436493 | (37.7620271356236, -122.426306436493) | 8 | 4 | 5 | 28862 | 3 | |||
| 47545 | 24964 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 198 Dolores St | 5 | Median : Cutout | Tree | DPW 1 | 90 | 20 | 6004804.6555297 | 2107199.7616194 | 37.7662408057536 | -122.426624291348 | (37.7662408057536, -122.426624291348) | 8 | 4 | 5 | 28862 | 3 | |||
| 49369 | 25015 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 550X Dolores St | 9 | Median : Cutout | Tree | DPW 1 | 90 | 20 | 6004955.91822 | 2104917.6837 | 37.7599833128008 | -122.42593863935 | (37.7599833128008, -122.42593863935) | 2 | 4 | 5 | 28862 | 3 | |||
| 55170 | 25007 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 500X Dolores St | 1 | Median : Cutout | Tree | DPW 1 | 90 | 20 | 6004931.59557 | 2105384.62551 | 37.7612640499245 | -122.426056000898 | (37.7612640499245, -122.426056000898) | 2 | 4 | 5 | 28862 | 3 | |||
| 55390 | 25061 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1000X Dolores St | 4 | Median : Cutout | Tree | DPW 1 | 90 | 20 | 6005097.79962 | 2102345.06954 | 37.7529275341834 | -122.425264872687 | (37.7529275341834, -122.425264872687) | 2 | 4 | 5 | 28862 | 22 | |||
| 58771 | 25047 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 900X Dolores St | 1 | Median : Cutout | Tree | DPW 1 | 90 | 20 | 6005062.19129 | 2103039.48532 | 37.7548322263474 | -122.425437427413 | (37.7548322263474, -122.425437427413) | 2 | 4 | 5 | 28862 | 22 | |||
| 63593 | 25152 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 50X Dolores St | 5 | Median : Cutout | Tree | DPW 1 | 90 | 20 | 6004796.34623 | 2107853.39536 | 37.768035057311 | -122.42669958274 | (37.768035057311, -122.42669958274) | 8 | 4 | 5 | 28862 | 3 | |||
| 66930 | 25109 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1496 Dolores St | 2 | Median : Cutout | Tree | DPW 1 | 90 | 20 | 6005218.8222955 | 2099617.195839 | 37.7454442580108 | -122.424652317948 | (37.7454442580108, -122.424652317948) | 2 | 7 | 5 | 63 | 22 | |||
| 68276 | 25044 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 892X Dolores St | 9 | Median : Cutout | Tree | DPW 1 | 90 | 20 | 6005007.5951373 | 2103153.9131268 | 37.7551433335372 | -122.425634379859 | (37.7551433335372, -122.425634379859) | 2 | 4 | 5 | 28862 | 22 | |||
| 72293 | 25123 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1550 Dolores St | 4 | Median : Cutout | Tree | DPW 1 | 90 | 20 | 6005274.82817 | 2099143.28527 | 37.7441461706217 | -122.424424956245 | (37.7441461706217, -122.424424956245) | 2 | 7 | 5 | 63 | 22 | |||
| 75098 | 24975 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 200 Dolores St | 2 | Median : Cutout | Tree | DPW 1 | 90 | 20 | 6004832.79825 | 2107115.15692 | 37.7660100925102 | -122.426520926121 | (37.7660100925102, -122.426520926121) | 8 | 4 | 5 | 28862 | 3 | |||
| 75622 | 24981 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 292 Dolores St | 8 | Median : Cutout | Tree | DPW 1 | 90 | 20 | 6004817.9533669 | 2106647.0197828 | 37.7647238606763 | -122.426538934247 | (37.7647238606763, -122.426538934247) | 8 | 4 | 5 | 28862 | 3 | |||
| 82400 | 25038 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 800X Dolores St | 2 | Median : Cutout | Tree | DPW 1 | 90 | 20 | 6005033.4036 | 2103578.19486 | 37.756309770193 | -122.425575321353 | (37.756309770193, -122.425575321353) | 2 | 4 | 5 | 28862 | 22 | |||
| 83756 | 24968 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 100 Dolores St | 9 | Median : Cutout | Tree | DPW 1 | 90 | 20 | 6004810.58196 | 2107534.13104 | 37.7671592390347 | -122.426627605497 | (37.7671592390347, -122.426627605497) | 8 | 4 | 5 | 28862 | 3 | |||
| 85525 | 25154 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 50X Dolores St | 2 | Median : Cutout | Tree | DPW 1 | 90 | 20 | 6004786.45589 | 2107937.06969 | 37.7682642477152 | -122.426739751839 | (37.7682642477152, -122.426739751839) | 8 | 4 | 5 | 28862 | 3 | |||
| 86137 | 25116 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1500X Dolores St | 3 | Median : Cutout | Tree | DPW 1 | 90 | 20 | 6005256.05434 | 2099495.31423 | 37.7451117016422 | -122.424514907343 | (37.7451117016422, -122.424514907343) | 2 | 7 | 5 | 63 | 22 | |||
| 86509 | 25040 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 800X Dolores St | 4 | Median : Cutout | Tree | DPW 1 | 90 | 20 | 6005037.47438 | 2103495.56554 | 37.7560831194465 | -122.425555362685 | (37.7560831194465, -122.425555362685) | 2 | 4 | 5 | 28862 | 22 | |||
| 86521 | 25013 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 550X Dolores St | 7 | Median : Cutout | Tree | DPW 1 | 90 | 20 | 6004948.90557 | 2104970.06821 | 37.7601267519689 | -122.425966621772 | (37.7601267519689, -122.425966621772) | 2 | 4 | 5 | 28862 | 3 | |||
| 86563 | 25122 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1550 Dolores St | 3 | Median : Cutout | Tree | DPW 1 | 90 | 20 | 6005275.20405 | 2099188.47337 | 37.7442702680707 | -122.42442687003 | (37.7442702680707, -122.42442687003) | 2 | 7 | 5 | 63 | 22 | |||
| 92493 | 25140 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1750X Dolores St | 6 | Median : Cutout | Tree | DPW 1 | 90 | 20 | 6005337.96039 | 2097982.38921 | 37.7409621784698 | -122.424124115947 | (37.7409621784698, -122.424124115947) | 2 | 7 | 5 | 63 | 7 | |||
| 92711 | 25014 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 500X Dolores St | 8 | Median : Cutout | Tree | DPW 1 | 90 | 20 | 6004896.4850005 | 2105439.5076575 | 37.7614127588524 | -122.426181340905 | (37.7614127588524, -122.426181340905) | 2 | 4 | 5 | 28862 | 3 | |||
| 92746 | 25041 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 800X Dolores St | 5 | Median : Cutout | Tree | DPW 1 | 90 | 20 | 6005036.07937 | 2103453.27666 | 37.7559669252599 | -122.425557177529 | (37.7559669252599, -122.425557177529) | 2 | 4 | 5 | 28862 | 22 | |||
| 94270 | 24967 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 150 Dolores St | 8 | Median : Cutout | Tree | DPW 1 | 90 | 20 | 6004824.65889 | 2107297.38564 | 37.7665099887808 | -122.426562055705 | (37.7665099887808, -122.426562055705) | 8 | 4 | 5 | 28862 | 3 | |||
| 94559 | 25135 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1700X Dolores St | 1 | Median : Cutout | Tree | DPW 1 | 90 | 20 | 6005318.69069 | 2098391.09531 | 37.7420833048092 | -122.424219803815 | (37.7420833048092, -122.424219803815) | 2 | 7 | 5 | 63 | 7 | |||
| 95609 | 25080 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1156 DOLORES ST | 1 | Median : Cutout | Tree | DPW 1 | 90 | 20 | 6005077.9 | 2101580.2 | 37.7508262556468 | -122.425279266089 | (37.7508262556468, -122.425279266089) | 2 | 4 | 5 | 28862 | 22 | |||
| 95942 | 25088 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1250X Dolores St | 3 | Median : Cutout | Tree | DPW 1 | 90 | 20 | 6005178.85274 | 2100929.77786 | 37.7490460494561 | -122.424883892899 | (37.7490460494561, -122.424883892899) | 2 | 4 | 5 | 28859 | 22 | |||
| 101755 | 25039 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 800X Dolores St | 3 | Median : Cutout | Tree | DPW 1 | 90 | 20 | 6005035.06937 | 2103531.66337 | 37.756182099743 | -122.425566249008 | (37.756182099743, -122.425566249008) | 2 | 4 | 5 | 28862 | 22 | |||
| 104345 | 24985 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 292 Dolores St | 12 | Median : Cutout | Tree | DPW 1 | 90 | 20 | 6004817.9533669 | 2106647.0197828 | 37.7647238606763 | -122.426538934247 | (37.7647238606763, -122.426538934247) | 8 | 4 | 5 | 28862 | 3 | |||
| 105588 | 25156 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 50X Dolores St | 4 | Median : Cutout | Tree | DPW 1 | 90 | 20 | 6004792.45266 | 2107880.8578 | 37.7681102424342 | -122.426715006093 | (37.7681102424342, -122.426715006093) | 8 | 4 | 5 | 28862 | 3 | |||
| 107384 | 24965 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 100 Dolores St | 6 | Median : Cutout | Tree | DPW 1 | 90 | 20 | 6004804.04595 | 2107595.6918 | 37.767327900586 | -122.426654596838 | (37.767327900586, -122.426654596838) | 8 | 4 | 5 | 28862 | 3 | |||
| 113629 | 25147 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1798X Dolores St | 13 | Median : Cutout | Tree | DPW 1 | 90 | 20 | 6005303.4758509 | 2097774.014097 | 37.7403880804322 | -122.42422853473 | (37.7403880804322, -122.42422853473) | 2 | 7 | 5 | 28859 | 7 | |||
| 114567 | 25117 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1548X Dolores St | 4 | Median : Cutout | Tree | DPW 1 | 90 | 20 | 6005242.6409807 | 2099315.8732107 | 37.7446182400704 | -122.424548526732 | (37.7446182400704, -122.424548526732) | 2 | 7 | 5 | 63 | 22 | |||
| 116655 | 24966 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 100 Dolores St | 7 | Median : Cutout | Tree | DPW 1 | 90 | 20 | 6004812.73188 | 2107584.41194 | 37.7672974198587 | -122.426623750096 | (37.7672974198587, -122.426623750096) | 8 | 4 | 5 | 28862 | 3 | |||
| 123929 | 25115 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1550X Dolores St | 2 | Median : Cutout | Tree | DPW 1 | 90 | 20 | 6005272.16967 | 2099229.32207 | 37.7443822579348 | -122.424440267208 | (37.7443822579348, -122.424440267208) | 2 | 7 | 5 | 63 | 22 | |||
| 125362 | 24995 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 398 Dolores St | 6 | Median : Cutout | Tree | DPW 1 | 90 | 20 | 6004868.1942017 | 2106023.8985612 | 37.7630157583963 | -122.426320795871 | (37.7630157583963, -122.426320795871) | 8 | 4 | 5 | 28859 | 3 | |||
| 125619 | 24978 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 270 Dolores St | 5 | Median : Cutout | Tree | DPW 1 | 90 | 20 | 6004857.55515 | 2106727.96369 | 37.764948352008 | -122.426407725736 | (37.764948352008, -122.426407725736) | 8 | 4 | 5 | 28862 | 3 | |||
| 128527 | 25155 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 60X Dolores St | 3 | Median : Cutout | Tree | DPW 1 | 90 | 20 | 6004737.5115878 | 2107959.1242988 | 37.768322037027 | -122.426910616409 | (37.768322037027, -122.426910616409) | 8 | 4 | 5 | 28862 | 3 | |||
| 128737 | 25149 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 2X Dolores St | 2 | Median : Cutout | Tree | DPW 1 | 90 | 20x10 | 6004775.29887 | 2108114.09165 | 37.7687496765872 | -122.42679095116 | (37.7687496765872, -122.42679095116) | 8 | 4 | 5 | 28862 | 3 | |||
| 129311 | 25137 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1700X Dolores St | 3 | Median : Cutout | Tree | DPW 1 | 90 | 20 | 6005325.64048 | 2098301.13362 | 37.7418366828201 | -122.424189377061 | (37.7418366828201, -122.424189377061) | 2 | 7 | 5 | 63 | 7 | |||
| 129665 | 25000 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 450X Dolores St | 5 | Median : Cutout | Tree | DPW 1 | 90 | 20 | 6004920.85287 | 2105575.60223 | 37.7617878195642 | -122.426106751438 | (37.7617878195642, -122.426106751438) | 8 | 4 | 5 | 28862 | 3 | |||
| 130751 | 25001 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 400X Dolores St | 6 | Median : Cutout | Tree | DPW 1 | 90 | 20 | 6004908.38314 | 2105867.13213 | 37.7625875866685 | -122.426170634793 | (37.7625875866685, -122.426170634793) | 8 | 4 | 5 | 28859 | 3 | |||
| 132526 | 24974 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 200 Dolores St | 1 | Median : Cutout | Tree | DPW 1 | 90 | 20 | 6004833.67989 | 2107139.93189 | 37.7660781684855 | -122.426519640982 | (37.7660781684855, -122.426519640982) | 8 | 4 | 5 | 28862 | 3 | |||
| 134215 | 25112 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1450 Dolores St | 5 | Median : Cutout | Tree | DPW 1 | 90 | 20 | 6005235.50671 | 2099747.61613 | 37.7458033045753 | -122.424603901547 | (37.7458033045753, -122.424603901547) | 2 | 7 | 5 | 63 | 22 | |||
| 134480 | 25110 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1450 Dolores St | 3 | Median : Cutout | Tree | DPW 1 | 90 | 20 | 6005236.31225 | 2099800.23492 | 37.7459478292265 | -122.424604858453 | (37.7459478292265, -122.424604858453) | 2 | 7 | 5 | 63 | 22 | |||
| 134624 | 25087 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1250X Dolores St | 2 | Median : Cutout | Tree | DPW 1 | 90 | 20 | 6005179.03552 | 2100967.22192 | 37.7491488725392 | -122.424885924444 | (37.7491488725392, -122.424885924444) | 2 | 4 | 5 | 28859 | 22 | |||
| 135164 | 25089 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1250X Dolores St | 4 | Median : Cutout | Tree | DPW 1 | 90 | 20 | 6005180.26353 | 2100884.10883 | 37.748920732509 | -122.424875765702 | (37.748920732509, -122.424875765702) | 2 | 4 | 5 | 28859 | 22 | |||
| 135911 | 25046 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 892X Dolores St | 11 | Median : Cutout | Tree | DPW 1 | 90 | 20 | 6005007.5951373 | 2103153.9131268 | 37.7551433335372 | -122.425634379859 | (37.7551433335372, -122.425634379859) | 2 | 4 | 5 | 28862 | 22 | |||
| 138865 | 25082 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1200X Dolores St | 2 | Median : Cutout | Tree | DPW 1 | 90 | 20 | 6005158.72228 | 2101250.83835 | 37.7499264704292 | -122.424976344106 | (37.7499264704292, -122.424976344106) | 2 | 4 | 5 | 28862 | 22 | |||
| 141627 | 24999 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 400X Dolores St | 4 | Median : Cutout | Tree | DPW 1 | 90 | 20 | 6004906.6428 | 2105904.72298 | 37.7626907038434 | -122.426179330329 | (37.7626907038434, -122.426179330329) | 8 | 4 | 5 | 28859 | 3 | |||
| 144309 | 24979 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 270 Dolores St | 6 | Median : Cutout | Tree | DPW 1 | 90 | 20 | 6004857.88642 | 2106701.08852 | 37.7648745779366 | -122.426404666261 | (37.7648745779366, -122.426404666261) | 8 | 4 | 5 | 28862 | 3 | |||
| 146743 | 24982 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 292 Dolores St | 9 | Median : Cutout | Tree | DPW 1 | 90 | 20 | 6004817.9533669 | 2106647.0197828 | 37.7647238606763 | -122.426538934247 | (37.7647238606763, -122.426538934247) | 8 | 4 | 5 | 28862 | 3 | |||
| 152799 | 24973 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 198 Dolores St | 14 | Median : Cutout | Tree | DPW 1 | 90 | 20 | 6004804.6555297 | 2107199.7616194 | 37.7662408057536 | -122.426624291348 | (37.7662408057536, -122.426624291348) | 8 | 4 | 5 | 28862 | 3 | |||
| 153555 | 25097 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1388X Dolores St | 2 | Median : Cutout | Tree | DPW 1 | 90 | 20 | 6005167.2006822 | 2100254.8047856 | 37.747192070496 | -122.424876171578 | (37.747192070496, -122.424876171578) | 2 | 7 | 5 | 63 | 22 | |||
| 160711 | 25138 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1700X Dolores St | 4 | Median : Cutout | Tree | DPW 1 | 90 | 20 | 6005319.27803 | 2098285.92952 | 37.7417945765605 | -122.424210295287 | (37.7417945765605, -122.424210295287) | 2 | 7 | 5 | 63 | 7 | |||
| 163302 | 25153 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 50X Dolores St | 1 | Median : Cutout | Tree | DPW 1 | 90 | 20 | 6004788.48534 | 2107965.70196 | 37.7683429797782 | -122.426734771418 | (37.7683429797782, -122.426734771418) | 8 | 4 | 5 | 28862 | 3 | |||
| 164534 | 25145 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1798X Dolores St | 11 | Median : Cutout | Tree | DPW 1 | 90 | 20 | 6005303.4758509 | 2097774.014097 | 37.7403880804322 | -122.42422853473 | (37.7403880804322, -122.42422853473) | 2 | 7 | 5 | 28859 | 7 | |||
| 165681 | 24991 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 340 Dolores St | 2 | Median : Cutout | Tree | DPW 1 | 90 | 20 | 6004880.84753 | 2106292.81252 | 37.7637548473422 | -122.426296179233 | (37.7637548473422, -122.426296179233) | 8 | 4 | 5 | 28859 | 3 | |||
| 167494 | 25036 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 750X Dolores St | 5 | Median : Cutout | Tree | DPW 1 | 90 | 20 | 6005017.04415 | 2103831.36773 | 37.7570039991458 | -122.425649916508 | (37.7570039991458, -122.425649916508) | 2 | 4 | 5 | 28862 | 3 | |||
| 167549 | 25120 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1550 Dolores St | 1 | Median : Cutout | Tree | DPW 1 | 90 | 20 | 6005269.99247 | 2099258.02767 | 37.744460954018 | -122.424449836913 | (37.744460954018, -122.424449836913) | 2 | 7 | 5 | 63 | 22 | |||
| 172032 | 25111 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1450 Dolores St | 4 | Median : Cutout | Tree | DPW 1 | 90 | 20 | 6005242.59316 | 2099769.24096 | 37.7458630816199 | -122.424580935573 | (37.7458630816199, -122.424580935573) | 2 | 7 | 5 | 63 | 22 | |||
| 179404 | 25118 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1500X Dolores St | 5 | Median : Cutout | Tree | DPW 1 | 90 | 20 | 6005257.61936 | 2099436.85892 | 37.7449512850908 | -122.42450533857 | (37.7449512850908, -122.42450533857) | 2 | 7 | 5 | 63 | 22 | |||
| 180593 | 25037 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 800X Dolores St | 1 | Median : Cutout | Tree | DPW 1 | 90 | 20 | 6005031.31461 | 2103614.04185 | 37.7564080795924 | -122.425585096976 | (37.7564080795924, -122.425585096976) | 2 | 4 | 5 | 28862 | 22 | |||
| 183670 | 24972 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 198 Dolores St | 13 | Median : Cutout | Tree | DPW 1 | 90 | 20 | 6004804.6555297 | 2107199.7616194 | 37.7662408057536 | -122.426624291348 | (37.7662408057536, -122.426624291348) | 8 | 4 | 5 | 28862 | 3 | |||
| 185165 | 24961 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 100 Dolores St | 1 | Median : Cutout | Tree | DPW 1 | 04/21/2005 12:00:00 AM | 90 | 20 | 6004800.95891 | 2107734.51921 | 37.7677089127708 | -122.42667516164 | (37.7677089127708, -122.42667516164) | 8 | 4 | 5 | 28862 | 3 | ||
| 185850 | 25106 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1450X Dolores St | 6 | Median : Cutout | Tree | DPW 1 | 90 | 20 | 6005241.17775 | 2099713.87888 | 37.7457109900772 | -122.424581892451 | (37.7457109900772, -122.424581892451) | 2 | 7 | 5 | 63 | 22 | |||
| 186891 | 25083 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1200X Dolores St | 3 | Median : Cutout | Tree | DPW 1 | 90 | 20 | 6005162.35719 | 2101213.31575 | 37.7498236473552 | -122.424961105075 | (37.7498236473552, -122.424961105075) | 2 | 4 | 5 | 28859 | 22 | |||
| 192759 | 5446 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 500X Dolores St | 14 | Median : Cutout | Tree | DPW 1 | 03/20/1990 12:00:00 AM | 90 | 6 | 6004896.4850005 | 2105439.5076575 | 37.7614127588524 | -122.426181340905 | (37.7614127588524, -122.426181340905) | 2 | 4 | 5 | 28862 | 3 | ||
| 20896 | 187504 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 100 Walbridge St | 10 | Front Yard : Yard | Tree | Private 2 | 9 | 6005101.69485 | 2086503.71935 | 37.7094309267755 | -122.424124907354 | (37.7094309267755, -122.424124907354) | 9 | 7 | 6 | 309 | 5 | ||||
| 105070 | 234380 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1001 San Jose Ave | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | Width 3ft | 6005142.82168 | 2096774.43039 | 37.7376343766353 | -122.424712922782 | (37.7376343766353, -122.424712922782) | 2 | 7 | 5 | 28859 | 2 | |||
| 167872 | 194272 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1022 Minna St | 2 | : | Tree | Private 2 | 9 | Width 3ft | 6007547.68753 | 2109714.25342 | 37.7732997020571 | -122.417314852308 | (37.7732997020571, -122.417314852308) | 8 | 2 | 9 | 28853 | 19 | |||
| 2957 | 25027 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 740X Dolores St | 2 | Median : Cutout | Tree | DPW 1 | 80 | 20 | 6004958.5167563 | 2104022.9997464 | 37.7575268683213 | -122.425865966748 | (37.7575268683213, -122.425865966748) | 2 | 4 | 5 | 28862 | 3 | |||
| 5116 | 25071 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1100X Dolores St | 2 | Median : Cutout | Tree | DPW 1 | 80 | 20 | 6005127.37654 | 2101840.69033 | 37.7515442968352 | -122.42512670443 | (37.7515442968352, -122.42512670443) | 2 | 4 | 5 | 28862 | 22 | |||
| 48677 | 25052 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 900X Dolores St | 7 | Median : Cutout | Tree | DPW 1 | 80 | 20 | 6005070.62845 | 2102872.02457 | 37.7543728949014 | -122.42539633287 | (37.7543728949014, -122.42539633287) | 2 | 4 | 5 | 28862 | 22 | |||
| 49036 | 25075 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1198 DOLORES ST | 1 | Median : Cutout | Tree | DPW 1 | 80 | 20 | 6005087.7 | 2101404.7 | 37.7503449269028 | -122.425232889951 | (37.7503449269028, -122.425232889951) | 2 | 4 | 5 | 28862 | 22 | |||
| 61170 | 25079 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1162 DOLORES ST | 1 | Median : Cutout | Tree | DPW 1 | 80 | 20 | 6005068.3 | 2101554.8 | 37.7507559707678 | -122.425310656505 | (37.7507559707678, -122.425310656505) | 2 | 4 | 5 | 28862 | 22 | |||
| 71640 | 25070 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1100X Dolores St | 1 | Median : Cutout | Tree | DPW 1 | 80 | 20 | 6005125.72632 | 2101888.99536 | 37.7516768380284 | -122.425135847862 | (37.7516768380284, -122.425135847862) | 2 | 4 | 5 | 28862 | 22 | |||
| 88609 | 25076 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1184 DOLORES ST | 1 | Median : Cutout | Tree | DPW 1 | 80 | 20 | 6005073.9 | 2101453.9 | 37.7504792390956 | -122.425284111983 | (37.7504792390956, -122.425284111983) | 2 | 4 | 5 | 28862 | 22 | |||
| 90790 | 25077 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1178 DOLORES ST | 1 | Median : Cutout | Tree | DPW 1 | 80 | 20 | 6005072.5 | 2101478.6 | 37.7505469804869 | -122.42529071074 | (37.7505469804869, -122.42529071074) | 2 | 4 | 5 | 28862 | 22 | |||
| 91562 | 25148 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 2X Dolores St | 1 | Median : Cutout | Tree | DPW 1 | 80 | 20 | 6004781.85822 | 2108123.31219 | 37.7687753648286 | -122.426768919571 | (37.7687753648286, -122.426768919571) | 8 | 4 | 5 | 28862 | 3 | |||
| 103251 | 25091 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1350 Dolores St | 1 | Median : Cutout | Tree | DPW 1 | 80 | 20 | 6005204.68058 | 2100428.03656 | 37.7476698420965 | -122.424758890703 | (37.7476698420965, -122.424758890703) | 2 | 7 | 5 | 63 | 22 | |||
| 137557 | 25095 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1300 Dolores St | 5 | Median : Cutout | Tree | DPW 1 | 80 | 20 | 6005196.77931 | 2100544.39428 | 37.7479888873864 | -122.424794489489 | (37.7479888873864, -122.424794489489) | 2 | 4 | 5 | 63 | 19 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "trees" ( [rowid] INTEGER PRIMARY KEY, [TreeID] TEXT, [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]), [qSpecies_id] INTEGER, [qAddress] TEXT, [SiteOrder] TEXT, [qSiteInfo] TEXT, [PlantType] TEXT, [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]), [qCareAssistant] TEXT, [PlantDate] TEXT, [DBH] TEXT, [PlotSize] TEXT, [PermitNotes] TEXT, [XCoord] TEXT, [YCoord] TEXT, [Latitude] TEXT, [Longitude] TEXT, [Location] TEXT, [Fire Prevention Districts] TEXT, [Police Districts] TEXT, [Supervisor Districts] TEXT, [Zip Codes] TEXT, [Neighborhoods (old)] TEXT, FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id) );