trees
897 rows where qSpecies_id = 160 sorted by qCaretaker_id
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 | |||
| 1062 | 20065 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 100 STAIRWAY54 | 12 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 15ST | |||||||||||||
| 1504 | 19794 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 100 STAIRWAY19 | 16 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 50ST | |||||||||||||
| 1681 | 132077 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1100x The Embarcadero | 7 | Median : Yard | Tree | DPW 1 | 23 | Width 10ft | 6012714.412 | 2120058.13658 | 37.8019909162964 | -122.400168938451 | (37.8019909162964, -122.400168938451) | 3 | 1 | 10 | 28860 | 6 | |||
| 1977 | 132113 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1000x The Embarcadero | 2 | Median : Yard | Tree | DPW 1 | 21 | Width 10ft | 6013330.52243 | 2119204.92075 | 37.7996825238869 | -122.397977001937 | (37.7996825238869, -122.397977001937) | 3 | 1 | 10 | 28860 | 6 | |||
| 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 | |||
| 3088 | 261629 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 620x The Embarcadero | 1 | Sidewalk: Property side : Yard | Tree | DPW 1 | 3x3 | 6012640 | 2120258 | 37.8025355435841 | -122.400440487668 | (37.8025355435841, -122.400440487668) | 3 | 1 | 10 | 28860 | 6 | ||||
| 3537 | 18548 | Landmark tree 11 | Phoenix canariensis :: Canary Island Date Palm 160 | 1700X Quesada Ave | 3 | Median : Cutout | Tree | DPW 1 | 30 | 19 | 6014665.0129 | 2095058.69239 | 37.7334565140045 | -122.391669970993 | (37.7334565140045, -122.391669970993) | 10 | 3 | 8 | 58 | 1 | |||
| 4245 | 28231 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 399X King St | 14 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 6013667.5202917 | 2110028.9140531 | 37.7745060991794 | -122.396167417116 | (37.7745060991794, -122.396167417116) | 14 | 2 | 9 | 310 | 20 | ||||
| 4408 | 234354 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 650x Dolores St | 1 | Median : Yard | Tree | DPW 1 | 23 | 6004979.81363 | 2104508.34972 | 37.7588607286626 | -122.425826859935 | (37.7588607286626, -122.425826859935) | 2 | 4 | 5 | 28862 | 3 | ||||
| 4871 | 132103 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1400x The Embarcadero | 1 | Median : Yard | Tree | DPW 1 | 18 | Width 10ft | 6012095.78368 | 2120981.89347 | 37.8044928149639 | -122.402374687645 | (37.8044928149639, -122.402374687645) | 3 | 1 | 10 | 28860 | 6 | |||
| 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 | |||
| 6713 | 25016 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 710X Dolores St | 1 | Median : Cutout | Tree | DPW 1 | 70 | 20 | 6004949.2547318 | 2104210.5607703 | 37.7580413433618 | -122.425911349448 | (37.7580413433618, -122.425911349448) | 2 | 4 | 5 | 28862 | 3 | |||
| 7075 | 25030 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 740X Dolores St | 5 | Median : Cutout | Tree | DPW 1 | 70 | 20 | 6004958.5167563 | 2104022.9997464 | 37.7575268683213 | -122.425865966748 | (37.7575268683213, -122.425865966748) | 2 | 4 | 5 | 28862 | 3 | |||
| 7222 | 25538 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 2200X Market St | 4 | Median : Cutout | Tree | DPW 1 | 04/01/1993 12:00:00 AM | 36 | 20 | 6003277.964 | 2106841.2745 | 37.7651700578839 | -122.431879221699 | (37.7651700578839, -122.431879221699) | 15 | 4 | 5 | 28862 | 3 | ||
| 8378 | 25503 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1900X Market St | 3 | Median : Cutout | Tree | DPW 1 | 04/01/1993 12:00:00 AM | 36 | 8 | 6005164.8443 | 2108651.7776 | 37.7702480498919 | -122.425481812147 | (37.7702480498919, -122.425481812147) | 7 | 2 | 5 | 28853 | 19 | ||
| 8561 | 25119 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1500X Dolores St | 6 | Median : Cutout | Tree | DPW 1 | 30 | 20 | 6005258.69008 | 2099408.1764 | 37.7448725899054 | -122.42449959639 | (37.7448725899054, -122.42449959639) | 2 | 7 | 5 | 63 | 22 | |||
| 9418 | 251108 | Landmark tree 11 | Phoenix canariensis :: Canary Island Date Palm 160 | 1700X Quesada Ave | 2 | Median : Yard | Tree | DPW 1 | |||||||||||||||
| 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 | |||
| 9507 | 132129 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 500x The Embarcadero | 9 | Median : Yard | Tree | DPW 1 | 24 | Width 10ft | 6013671.61354 | 2118630.60451 | 37.7981245788406 | -122.3967564088 | (37.7981245788406, -122.3967564088) | 3 | 1 | 10 | 28860 | 6 | |||
| 9676 | 194361 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 380x The Embarcadero | 8 | Median : Yard | Tree | DPW 1 | 28 | Width 8ft | 6016114.70966 | 2114269.45463 | 37.7862855364823 | -122.38799801482 | (37.7862855364823, -122.38799801482) | 6 | 2 | 9 | 28856 | 6 | |||
| 9755 | 194362 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 380x The Embarcadero | 9 | Median : Yard | Tree | DPW 1 | 29 | Width 8ft | 6016123.07303 | 2114362.83881 | 37.786542411639 | -122.387975598289 | (37.786542411639, -122.387975598289) | 6 | 2 | 9 | 28856 | 6 | |||
| 9943 | 25035 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 794X Dolores St | 4 | Median : Cutout | Tree | DPW 1 | 60 | 20 | 6004985.41588 | 2103704.6857762 | 37.7566543729812 | -122.425750282521 | (37.7566543729812, -122.425750282521) | 2 | 4 | 5 | 28862 | 3 | |||
| 10155 | 251115 | Landmark tree 11 | Phoenix canariensis :: Canary Island Date Palm 160 | 1700X Quesada Ave | 19 | Median : Yard | Tree | DPW 1 | |||||||||||||||
| 11271 | 194293 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1700x Quesada Ave | 46 | Median : Yard | Tree | DPW 1 | 28 | 6014318.79649 | 2095319.19207 | 37.7341525685742 | -122.392885167337 | (37.7341525685742, -122.392885167337) | 10 | 3 | 8 | 58 | 1 | ||||
| 11369 | 28185 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 299X King St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 6 | 6014324.7762427 | 2110655.258445 | 37.7762624487031 | -122.393937678457 | (37.7762624487031, -122.393937678457) | 6 | 2 | 9 | 28856 | 20 | |||
| 12943 | 246349 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 2190x Market St | 1 | Median : Cutout | Tree | DPW 1 | 31 | Width 0ft | 6003723.2107 | 2107266.4094 | 37.7663626060268 | -122.430369556243 | (37.7663626060268, -122.430369556243) | 8 | 4 | 5 | 28862 | 3 | |||
| 12966 | 251112 | Landmark tree 11 | Phoenix canariensis :: Canary Island Date Palm 160 | 1700X Quesada Ave | 14 | Median : | Tree | DPW 1 | |||||||||||||||
| 13313 | 251111 | Landmark tree 11 | Phoenix canariensis :: Canary Island Date Palm 160 | 1700X Quesada Ave | 7 | Median : Yard | Tree | DPW 1 | |||||||||||||||
| 13831 | 251113 | Landmark tree 11 | Phoenix canariensis :: Canary Island Date Palm 160 | 1700X Quesada Ave | 15 | Median : Yard | Tree | DPW 1 | |||||||||||||||
| 14024 | 194292 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1700x Quesada Ave | 43 | Median : Yard | Tree | DPW 1 | 38 | 6014354.24031 | 2095291.86255 | 37.7340794959614 | -122.392760714642 | (37.7340794959614, -122.392760714642) | 10 | 3 | 8 | 58 | 1 | ||||
| 14999 | 233935 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 150x Dolores St | 9 | Median : Yard | Tree | DPW 1 | 30 | 6004826.52958 | 2107279.95522 | 37.7664622347806 | -122.426554344032 | (37.7664622347806, -122.426554344032) | 8 | 4 | 5 | 28862 | 3 | ||||
| 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 | |||
| 15958 | 251109 | Landmark tree 11 | Phoenix canariensis :: Canary Island Date Palm 160 | 1700X Quesada Ave | 3 | Median : Yard | Tree | DPW 1 | |||||||||||||||
| 15995 | 251116 | Landmark tree 11 | Phoenix canariensis :: Canary Island Date Palm 160 | 1700X Quesada Ave | 20 | Median : Yard | Tree | DPW 1 | |||||||||||||||
| 16115 | 194311 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 380x The Embarcadero | 3 | Median : Yard | Tree | DPW 1 | 21 | Width 7ft | 6015171.22981 | 2116694.38601 | 37.7928915254696 | -122.391431824244 | (37.7928915254696, -122.391431824244) | 12 | 2 | 9 | 28855 | 6 | |||
| 16208 | 194334 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 88x King St | 10 | Median : Yard | Tree | DPW 1 | 30 | Width 8ft | 6015942.04821 | 2112270.67914 | 37.7807877820727 | -122.388455820993 | (37.7807877820727, -122.388455820993) | 6 | 2 | 9 | 28856 | 20 | |||
| 16574 | 25108 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1400 Dolores St | 1 | Median : Cutout | Tree | DPW 1 | 30 | 20 | 6005223.67149 | 2100130.84124 | 37.7468548845426 | -122.424672082757 | (37.7468548845426, -122.424672082757) | 2 | 7 | 5 | 63 | 22 | |||
| 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 | |||
| 17465 | 246342 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 2020x Market St | 4 | Median : Cutout | Tree | DPW 1 | 30 | Width 0ft | 6004356.6072 | 2107872.2367 | 37.7680619198287 | -122.428221935713 | (37.7680619198287, -122.428221935713) | 8 | 4 | 5 | 28862 | 3 | |||
| 18679 | 264760 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1501 Sunnydale Ave | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6007165 | 2087428 | 37.7120850908031 | -122.417059211527 | (37.7120850908031, -122.417059211527) | 9 | 7 | 8 | 309 | 39 | ||||
| 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 | |||
| 18950 | 25113 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1400 Dolores St | 6 | Median : Cutout | Tree | DPW 1 | 30 | 20 | 6005228.94357 | 2100007.06865 | 37.7465153311328 | -122.424645049125 | (37.7465153311328, -122.424645049125) | 2 | 7 | 5 | 63 | 22 | |||
| 19170 | 251114 | Landmark tree 11 | Phoenix canariensis :: Canary Island Date Palm 160 | 1700X Quesada Ave | 16 | Median : Yard | Tree | DPW 1 | |||||||||||||||
| 19478 | 251110 | Landmark tree 11 | Phoenix canariensis :: Canary Island Date Palm 160 | 1700X Quesada Ave | 5 | Median : Yard | Tree | DPW 1 | |||||||||||||||
| 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 | |||
| 19829 | 23674 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 319 Virginia Ave | 3 | Median : Cutout | Tree | DPW 1 | 3 | 12 | 6006936.2458165 | 2098250.5638735 | 37.741788638282 | -122.418616833275 | (37.741788638282, -122.418616833275) | 2 | 7 | 7 | 28859 | 2 | |||
| 20141 | 132092 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1500x The Embarcadero | 12 | Median : Yard | Tree | DPW 1 | 20 | Width 10ft | 6011191.46105 | 2121714.36376 | 37.806453474602 | -122.405555813649 | (37.806453474602, -122.405555813649) | 3 | 1 | 10 | 308 | 23 | |||
| 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 | |||
| 20723 | 28232 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 399X King St | 15 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 6013667.5202917 | 2110028.9140531 | 37.7745060991794 | -122.396167417116 | (37.7745060991794, -122.396167417116) | 14 | 2 | 9 | 310 | 20 | ||||
| 21114 | 28183 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 299X King St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 6 | 6014324.7762427 | 2110655.258445 | 37.7762624487031 | -122.393937678457 | (37.7762624487031, -122.393937678457) | 6 | 2 | 9 | 28856 | 20 | |||
| 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 | |||
| 21737 | 233937 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 230x Dolores St | 3 | Median : Yard | Tree | DPW 1 | 32 | 6004843.94175 | 2106947.59382 | 37.7655506342911 | -122.426470450778 | (37.7655506342911, -122.426470450778) | 8 | 4 | 5 | 28862 | 3 | ||||
| 21739 | 25033 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 700X Dolores St | 1 | Median : Cutout | Tree | DPW 1 | 70 | 20 | 6004995.41159 | 2104224.22732 | 37.7580814768833 | -122.425752691957 | (37.7580814768833, -122.425752691957) | 2 | 4 | 5 | 28862 | 3 | |||
| 21756 | 28219 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 399X King St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 6013667.5202917 | 2110028.9140531 | 37.7745060991794 | -122.396167417116 | (37.7745060991794, -122.396167417116) | 14 | 2 | 9 | 310 | 20 | ||||
| 22076 | 234356 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 650x Dolores St | 3 | Median : Yard | Tree | DPW 1 | 22 | 6004985.93046 | 2104422.99085 | 37.7586266989802 | -122.425799629353 | (37.7586266989802, -122.425799629353) | 2 | 4 | 5 | 28862 | 3 | ||||
| 22145 | 25523 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 2194X Market St | 10 | Median : Cutout | Tree | DPW 1 | 04/01/1993 12:00:00 AM | 36 | 10 | 6003574.351798 | 2107172.9273566 | 37.7660974938136 | -122.430877759148 | (37.7660974938136, -122.430877759148) | 7 | 4 | 5 | 28862 | 3 | ||
| 22376 | 194392 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 860x Jamestown Ave | 5 | Median : Cutout | Tree | DPW 1 | 17 | Width 5ft | 6014755.05221 | 2089115.57759 | 37.7171429037943 | -122.390943451878 | (37.7171429037943, -122.390943451878) | 10 | 3 | 8 | 58 | 1 | |||
| 22504 | 96822 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 610X Dolores St | 2 | Median : Cutout | Tree | DPW 1 | 24 | 20x225 | 6004926.4 | 2104659.4 | 37.7592724584905 | -122.426022342006 | (37.7592724584905, -122.426022342006) | 2 | 4 | 5 | 28862 | 3 | |||
| 22545 | 28193 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 299X King St | 11 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 6 | 6014324.7762427 | 2110655.258445 | 37.7762624487031 | -122.393937678457 | (37.7762624487031, -122.393937678457) | 6 | 2 | 9 | 28856 | 20 | |||
| 23067 | 100537 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 2010X Market St | 1 | Median : Cutout | Tree | DPW 1 | 36 | 8 | 6004815.4 | 2108376.1 | 37.7694713555808 | -122.426670904591 | (37.7694713555808, -122.426670904591) | 7 | 4 | 5 | 28862 | 3 | |||
| 23344 | 194391 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 828x Jamestown Ave | 4 | Median : Cutout | Tree | DPW 1 | 19 | Width 5ft | 6014866.8225 | 2088973.55401 | 37.7167591360948 | -122.390547193499 | (37.7167591360948, -122.390547193499) | 10 | 3 | 8 | 58 | 1 | |||
| 23418 | 248619 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1801x Market St | 1 | Median : Cutout | Tree | DPW 1 | 25 | Width 0ft | 6005765.0052 | 2109117.0426 | 37.7715594473913 | -122.423438937501 | (37.7715594473913, -122.423438937501) | 8 | 2 | 5 | 28853 | 19 | |||
| 23431 | 132080 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1100x The Embarcadero | 13 | Median : Yard | Tree | DPW 1 | 26 | Width 10ft | 6012562.54875 | 2120282.53748 | 37.802598598112 | -122.400710234101 | (37.802598598112, -122.400710234101) | 3 | 1 | 10 | 28860 | 6 | |||
| 23782 | 194377 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 310x The Embarcadero | 14 | Median : Yard | Tree | DPW 1 | 28 | Width 8ft | 6016027.16358 | 2115370.7776 | 37.7893046685309 | -122.388377800289 | (37.7893046685309, -122.388377800289) | 6 | 2 | 9 | 28855 | 6 | |||
| 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 | |||
| 24974 | 25527 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 2300X Market St | 2 | Median : Cutout | Tree | DPW 1 | 04/01/1993 12:00:00 AM | 36 | 10 | 6002730.2479 | 2106324.2376 | 37.7637193356407 | -122.433736680672 | (37.7637193356407, -122.433736680672) | 15 | 4 | 5 | 28862 | 3 | ||
| 25166 | 194288 | Landmark tree 11 | Phoenix canariensis :: Canary Island Date Palm 160 | 1700x Quesada Ave | 37 | Median : Yard | Tree | DPW 1 | 34 | 6014411.93404 | 2095259.01392 | 37.7339925045513 | -122.392558950849 | (37.7339925045513, -122.392558950849) | 10 | 3 | 8 | 58 | 1 | ||||
| 25284 | 194337 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 88x King St | 13 | Median : Yard | Tree | DPW 1 | 29 | Width 8ft | 6015953.29851 | 2112409.57048 | 37.7811697700143 | -122.388426597522 | (37.7811697700143, -122.388426597522) | 6 | 2 | 9 | 28856 | 20 | |||
| 25464 | 18556 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1700X Quesada Ave | 11 | Median : Cutout | Tree | DPW 1 | 30 | 19 | 6014603.96741 | 2095108.67042 | 37.7335903547148 | -122.391884517749 | (37.7335903547148, -122.391884517749) | 10 | 3 | 8 | 58 | 1 | |||
| 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 | |||
| 26231 | 28190 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 299X King St | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 6 | 6014324.7762427 | 2110655.258445 | 37.7762624487031 | -122.393937678457 | (37.7762624487031, -122.393937678457) | 6 | 2 | 9 | 28856 | 20 | |||
| 26524 | 25516 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 2190X Market St | 3 | Median : Cutout | Tree | DPW 1 | 04/01/1993 12:00:00 AM | 36 | 10 | 6003679.0354 | 2107225.3342 | 37.7662473210814 | -122.430519419203 | (37.7662473210814, -122.430519419203) | 8 | 4 | 5 | 28862 | 3 | ||
| 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 | ||
| 27783 | 25501 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1900X Market St | 1 | Median : Cutout | Tree | DPW 1 | 04/01/1993 12:00:00 AM | 36 | 8 | 6005202.0445 | 2108688.1512 | 37.7703500248187 | -122.425355725564 | (37.7703500248187, -122.425355725564) | 7 | 2 | 5 | 28853 | 19 | ||
| 28540 | 25054 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 900X Dolores St | 9 | Median : Cutout | Tree | DPW 1 | 35 | 20 | 6005073.8483 | 2102816.15893 | 37.7542196827988 | -122.425381222462 | (37.7542196827988, -122.425381222462) | 2 | 4 | 5 | 28862 | 22 | |||
| 28715 | 5503 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 773 Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 5x5 | 6005056.9343 | 2103834.44184 | 37.7570146938877 | -122.425512179943 | (37.7570146938877, -122.425512179943) | 2 | 4 | 5 | 28859 | 19 | |||
| 28718 | 194364 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 310x The Embarcadero | 1 | Median : Yard | Tree | DPW 1 | 30 | Width 8ft | 6016200.86003 | 2114659.13107 | 37.7873602722118 | -122.387727152497 | (37.7873602722118, -122.387727152497) | 6 | 2 | 9 | 28855 | 6 | |||
| 29806 | 234362 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1150x Dolores St | 4 | Median : Yard | Tree | DPW 1 | 25 | 6005144.45634 | 2101528.47617 | 37.7506879938715 | -122.425045428228 | (37.7506879938715, -122.425045428228) | 2 | 4 | 5 | 28862 | 22 | ||||
| 30086 | 14174 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1797X Market St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 0 | 4X4 | 6005740.867306 | 2109154.5344128 | 37.7716610284995 | -122.423525097847 | (37.7716610284995, -122.423525097847) | 8 | 2 | 5 | 28853 | 19 | |||
| 30456 | 96824 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 610X Dolores St | 4 | Median : Cutout | Tree | DPW 1 | 24 | 20x225 | 6004926.4 | 2104659.4 | 37.7592724584905 | -122.426022342006 | (37.7592724584905, -122.426022342006) | 2 | 4 | 5 | 28862 | 3 | |||
| 30604 | 246402 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 2000x Market St | 1 | Median : Cutout | Tree | DPW 1 | 30 | Width 0ft | 6004659.311 | 2108158.3365 | 37.7688646036969 | -122.427195296669 | (37.7688646036969, -122.427195296669) | 8 | 4 | 5 | 28862 | 3 | |||
| 31803 | 132075 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1100x The Embarcadero | 3 | Median : Yard | Tree | DPW 1 | 23 | Width 10ft | 6012816.85763 | 2119903.53523 | 37.8015721299035 | -122.399803563704 | (37.8015721299035, -122.399803563704) | 3 | 1 | 10 | 28860 | 6 | |||
| 32091 | 24337 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 2020X Market St | 2 | Median : Cutout | Tree | DPW 1 | 05/07/1993 12:00:00 AM | 36 | 8 | 6004420.4688 | 2107930.9893 | 37.7682268534635 | -122.428005232451 | (37.7682268534635, -122.428005232451) | 8 | 4 | 5 | 28862 | 3 | ||
| 32583 | 25100 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1350X Dolores St | 5 | Median : Cutout | Tree | DPW 1 | 60 | 20 | 6005208.52852 | 2100314.21379 | 37.7473575282405 | -122.424737488671 | (37.7473575282405, -122.424737488671) | 2 | 7 | 5 | 63 | 22 | |||
| 32680 | 119700 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 6x Octavia St Frontage West | 2 | Median : Cutout | Tree | DPW 1 | 2109337 | 6005692 | 47.2698908128932 | -138.283860688311 | (47.2698908128932, -138.283860688311) | ||||||||||
| 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 | |||
| 34128 | 194284 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1700x Quesada Ave | 20 | Median : Yard | Tree | DPW 1 | 31 | 6014504.15008 | 2095180.20764 | 37.733781239407 | -122.392234619349 | (37.733781239407, -122.392234619349) | 10 | 3 | 8 | 58 | 1 | ||||
| 35397 | 194379 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 300x The Embarcadero | 2 | Median : Yard | Tree | DPW 1 | 30 | Width 8ft | 6015888.45756 | 2115624.95631 | 37.7899948982019 | -122.388875463533 | (37.7899948982019, -122.388875463533) | 6 | 2 | 9 | 28855 | 6 | |||
| 35617 | 5707 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1600 Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 100 | 3X3 | 6005241.86416 | 2098983.9941 | 37.7437069318227 | -122.424527610259 | (37.7437069318227, -122.424527610259) | 2 | 7 | 5 | 63 | 22 | |||
| 36361 | 25026 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 750X Dolores St | 1 | Median : Cutout | Tree | DPW 1 | 70 | 20 | 6005011.77925 | 2103932.39938 | 37.7572811108424 | -122.425675315185 | (37.7572811108424, -122.425675315185) | 2 | 4 | 5 | 28862 | 3 | |||
| 36493 | 25099 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1300X Dolores St | 4 | Median : Cutout | Tree | DPW 1 | 70 | 20 | 6005195.84744 | 2100584.78774 | 37.7480997459068 | -122.424800585099 | (37.7480997459068, -122.424800585099) | 2 | 4 | 5 | 28859 | 19 | |||
| 36707 | 25526 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 2300X Market St | 1 | Median : Cutout | Tree | DPW 1 | 04/01/1993 12:00:00 AM | 36 | 10 | 6002746.7355 | 2106338.4868 | 37.7637593960329 | -122.433680673672 | (37.7637593960329, -122.433680673672) | 15 | 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 | |||
| 37457 | 194335 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 88x King St | 11 | Median : Yard | Tree | DPW 1 | 30 | Width 8ft | 6015932.5598 | 2112347.87113 | 37.7809992081901 | -122.38849403589 | (37.7809992081901, -122.38849403589) | 6 | 2 | 9 | 28856 | 20 | |||
| 38161 | 28233 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 399X King St | 16 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 6013667.5202917 | 2110028.9140531 | 37.7745060991794 | -122.396167417116 | (37.7745060991794, -122.396167417116) | 14 | 2 | 9 | 310 | 20 | ||||
| 38743 | 18563 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1700X Quesada Ave | 18 | Median : Cutout | Tree | DPW 1 | 30 | 19 | 6014793.6967997 | 2095004.1424748 | 37.7333138733401 | -122.391221258932 | (37.7333138733401, -122.391221258932) | 10 | 3 | 8 | 58 | 1 | |||
| 38943 | 25129 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1650X Dolores St | 4 | Median : Cutout | Tree | DPW 1 | 40 | 20 | 6005306.59795 | 2098578.64869 | 37.7425976010056 | -122.424274952941 | (37.7425976010056, -122.424274952941) | 2 | 7 | 5 | 63 | 22 | |||
| 38999 | 103927 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 100 The Embarcadero | 13 | Median : Cutout | Tree | DPW 1 | 02/05/2001 12:00:00 AM | 4x4 | 6014859 | 2117030 | 37.793795709184 | -122.392535650186 | (37.793795709184, -122.392535650186) | 12 | 2 | 10 | 28855 | 6 |
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) );