trees
6,714 rows where qSpecies_id = 7 sorted by qCareAssistant
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 6396 | 36746 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 5555 Woodward St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/26/1998 12:00:00 AM | Permit Number 39516 | |||||||||||||
| 6466 | 261198 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 690x Benton Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007331 | 2095336 | 37.7338081055982 | -122.417045435619 | (37.7338081055982, -122.417045435619) | 2 | 7 | 7 | 28859 | 2 | ||||
| 6471 | 237657 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 4187 20th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | Permit Number 784809 | 6002500.86643 | 2104117.7916 | 37.7576479497003 | -122.434372278263 | (37.7576479497003, -122.434372278263) | 2 | 4 | 5 | 28862 | 3 | ||
| 6595 | 236574 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 2928 19th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 6009184.64361 | 2105006.14989 | 37.7604642981045 | -122.41131971344 | (37.7604642981045, -122.41131971344) | 2 | 4 | 7 | 28859 | 19 | |||
| 6598 | 261578 | Planning Code 138.1 required 2 | Prunus cerasifera :: Cherry Plum 7 | 496 Urbano Dr | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 5992575 | 2091875 | 37.7234639294961 | -122.467809264789 | (37.7234639294961, -122.467809264789) | 9 | 8 | 4 | 59 | 40 | ||||
| 6743 | 237502 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 3707 21st St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6003619.47904 | 2103592.43752 | 37.7562688834292 | -122.430466176382 | (37.7562688834292, -122.430466176382) | 2 | 4 | 5 | 28862 | 22 | |||
| 6844 | 235670 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 69 Elgin Park | 2 | : | Tree | Private 2 | 9 | Width 3ft | 6005833.06667 | 2108709.07327 | 37.7704431026896 | -122.423174504696 | (37.7704431026896, -122.423174504696) | 8 | 2 | 5 | 28853 | 19 | |||
| 6867 | 260482 | Significant Tree 6 | Prunus cerasifera :: Cherry Plum 7 | 3333 California St | 4 | Sidewalk: Property side : Cutout | Tree | DPW 1 | 3X3 | 5998571 | 2114839 | 37.7868617958727 | -122.448735497123 | (37.7868617958727, -122.448735497123) | 15 | 6 | 1 | 54 | 31 | ||||
| 7033 | 214228 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 714 Detroit St | 16 | Side Yard : Yard | Tree | Private 2 | 5 | 5999467.54728 | 2095443.9032 | 37.733658896535 | -122.444239403229 | (37.733658896535, -122.444239403229) | 9 | 7 | 4 | 63 | 40 | ||||
| 7114 | 20035 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 100 STAIRWAY51 | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | ST | |||||||||||||
| 7158 | 261760 | Undocumented 4 | Prunus cerasifera :: Cherry Plum 7 | 45 Bache St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007217 | 2095455 | 37.7341284399303 | -122.417447999393 | (37.7341284399303, -122.417447999393) | 2 | 7 | 7 | 28859 | 2 | ||||
| 7227 | 181941 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 2338 Taraval St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 5985894.7639 | 2098931.5489 | 37.7424513496728 | -122.49142044264 | (37.7424513496728, -122.49142044264) | 1 | 8 | 3 | 29491 | 35 | |||
| 7286 | 33084 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/05/1996 12:00:00 AM | Permit Number 37336 | ||||||||||||||
| 7292 | 139423 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 2683 SUTTER ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 5999790.4795 | 2113984.7901 | 37.7845860157612 | -122.444454981067 | (37.7845860157612, -122.444454981067) | 15 | 6 | 11 | 29490 | 31 | |||
| 7355 | 218024 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 2439 Funston Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5992321.61488 | 2098826.36929 | 37.7425360172282 | -122.469190857781 | (37.7425360172282, -122.469190857781) | 1 | 8 | 4 | 29491 | 40 | |||
| 7394 | 236442 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1098 Clayton St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5998931 | 2106271 | 37.7633568442315 | -122.446873221995 | (37.7633568442315, -122.446873221995) | 15 | 5 | 11 | 29492 | 9 | |||
| 7481 | 236548 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1199x Eugenia Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6008197.38645 | 2097705.34234 | 37.7403625015365 | -122.414217644728 | (37.7403625015365, -122.414217644728) | 2 | 7 | 7 | 28859 | 2 | |||
| 7520 | 236941 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 42 Putnam St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6009158.27721 | 2097193.88285 | 37.7390120723534 | -122.410859138235 | (37.7390120723534, -122.410859138235) | 10 | 7 | 7 | 28859 | 2 | |||
| 7579 | 72318 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 539 02nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | 9x6 | 5995283.47328 | 2111879.02377 | 37.7785459545642 | -122.459895003637 | (37.7785459545642, -122.459895003637) | 11 | 6 | 2 | 54 | 11 | |||
| 7595 | 178710 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 500 London St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6001568.61805 | 2090782.47378 | 37.720979319025 | -122.43664185145 | (37.720979319025, -122.43664185145) | 9 | 7 | 6 | 28861 | 5 | |||
| 7618 | 235999 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 365 Day St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 2ft | 6003615.09862 | 2098623.52813 | 37.7426251724083 | -122.43012686309 | (37.7426251724083, -122.43012686309) | 2 | 7 | 5 | 63 | 22 | |||
| 7843 | 202011 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 35 Wheat St | 1 | : | Tree | Private 2 | 10 | Width 3ft | 6012102.79015 | 2091227.84985 | 37.7227952498849 | -122.400259388686 | (37.7227952498849, -122.400259388686) | 10 | 3 | 8 | 58 | 1 | |||
| 7922 | 135849 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 2456 Leavenworth St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6007515.30382 | 2120841.49853 | 37.8038505659037 | -122.418215928918 | (37.8038505659037, -122.418215928918) | 5 | 1 | 1 | 308 | 32 | |||
| 7976 | 20040 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 100 STAIRWAY51 | 11 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | ST | |||||||||||||
| 8113 | 46806 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 170 San Felipe Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/25/2002 12:00:00 AM | Permit Number 44891 | 5994047.88467272 | 2095052.68932043 | 37.7322740285646 | -122.462948245202 | (37.7322740285646, -122.462948245202) | 9 | 8 | 4 | 59 | 40 | |||
| 8216 | 261364 | Undocumented 4 | Prunus cerasifera :: Cherry Plum 7 | 37 Bache St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007227 | 2095555 | 37.734403580666 | -122.417420510703 | (37.734403580666, -122.417420510703) | 2 | 7 | 7 | 28859 | 2 | ||||
| 8220 | 212707 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1439 05th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 2ft | 5994565.98091 | 2105717.62937 | 37.7615870971916 | -122.461930160547 | (37.7615870971916, -122.461930160547) | 1 | 5 | 11 | 56 | 12 | |||
| 8262 | 236009 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 342 Day St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 6003704.29788 | 2098672.67135 | 37.7427651599925 | -122.429821942527 | (37.7427651599925, -122.429821942527) | 2 | 7 | 5 | 63 | 22 | |||
| 8287 | 196310 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 928 Clara St | 3 | : | Tree | Private 2 | 1 | Width 3ft | 6011726.41935 | 2111671.91567 | 37.7789092071182 | -122.402997684908 | (37.7789092071182, -122.402997684908) | 14 | 2 | 9 | 28856 | 34 | |||
| 8299 | 82782 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 285 Cumberland St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/29/2008 12:00:00 AM | 3x3 | Permit Number 50432 | 6003797.68520335 | 2104478.00644987 | 37.758710538762 | -122.429913044242 | (37.758710538762, -122.429913044242) | 2 | 4 | 5 | 28862 | 3 | ||
| 8491 | 84919 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 215 Hale St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/25/2007 12:00:00 AM | 3 | Permit Number 49339 | 6009512.67609 | 2094567.40157 | 37.731820184958 | -122.409448471593 | (37.731820184958, -122.409448471593) | 9 | 3 | 7 | 309 | 28 | ||
| 8553 | 214289 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 46 Staples Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/23/2000 12:00:00 AM | 6 | Width 2ft | Permit Number 42620 | 5999770.30024 | 2093799.89409 | 37.7291620992362 | -122.443074673282 | (37.7291620992362, -122.443074673282) | 9 | 7 | 4 | 63 | 40 | |
| 8662 | 236510 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 281 Nevada St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | Permit Number 783074 | 6008991.12721 | 2097033.14308 | 37.7385613420185 | -122.411425715645 | (37.7385613420185, -122.411425715645) | 10 | 7 | 7 | 28859 | 2 | ||
| 8768 | 246988 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 70 Clipper St | 2 | : | Tree | Private 2 | 9 | Width 3ft | 6004704.08454 | 2101068.96131 | 37.7494013868777 | -122.426535555381 | (37.7494013868777, -122.426535555381) | 2 | 4 | 5 | 28862 | 22 | |||
| 8823 | 217937 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 2035 15th Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 04/26/2004 12:00:00 AM | 4 | Width 3ft | Permit Number 47390 | 5991588.27788 | 2101560.12813 | 37.7499998119378 | -122.471925697939 | (37.7499998119378, -122.471925697939) | 1 | 8 | 4 | 29491 | 12 | |
| 8841 | 178711 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 500 London St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6001558.80757 | 2090766.26793 | 37.7209342638804 | -122.436674603871 | (37.7209342638804, -122.436674603871) | 9 | 7 | 6 | 28861 | 5 | |||
| 8864 | 236310 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 3186 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6007726.45399 | 2102693.43972 | 37.7540322344234 | -122.416199135408 | (37.7540322344234, -122.416199135408) | 2 | 4 | 7 | 28859 | 19 | |||
| 8879 | 59473 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1615 Fulton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/19/2008 12:00:00 AM | 5 | 3x3 | Permit Number 51005 | 5999993.3242 | 2110893.3383 | 37.7761092547589 | -122.443531061203 | (37.7761092547589, -122.443531061203) | 15 | 5 | 11 | 29492 | 16 | |
| 9007 | 23899 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1600X Webster St | 1 | Median : Cutout | Tree | DPW 1 | 12 | 6 | 6003605.1476962 | 2114190.7261663 | 37.785368381567 | -122.431272227533 | (37.785368381567, -122.431272227533) | 13 | 9 | 11 | 29490 | 13 | |||
| 9021 | 236620 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 3031 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6008725.435 | 2102707.57209 | 37.7541271596615 | -122.412745405998 | (37.7541271596615, -122.412745405998) | 2 | 4 | 7 | 28859 | 19 | |||
| 9045 | 217860 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1525 Willard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | Permit Number 784373 | 5996862.66566 | 2105957.03699 | 37.7623764033599 | -122.454004200645 | (37.7623764033599, -122.454004200645) | 15 | 5 | 11 | 29492 | 12 | ||
| 9072 | 235773 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1449 15th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6007770.63381 | 2107353.8886 | 37.7668312365099 | -122.416376430431 | (37.7668312365099, -122.416376430431) | 8 | 4 | 7 | 28853 | 19 | |||
| 9103 | 236319 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 2870 22nd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 5ft | 6008996.29845 | 2103350.92649 | 37.7559088650107 | -122.411854149066 | (37.7559088650107, -122.411854149066) | 2 | 4 | 7 | 28859 | 19 | |||
| 9239 | 236546 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1199x Eugenia Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 6008220.5972 | 2097704.41619 | 37.7403612622727 | -122.414137325379 | (37.7403612622727, -122.414137325379) | 2 | 7 | 7 | 28859 | 2 | |||
| 9256 | 236946 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 147 Wool St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6007380.39816 | 2097532.19381 | 37.7398411492515 | -122.417030208789 | (37.7398411492515, -122.417030208789) | 2 | 7 | 7 | 28859 | 2 | |||
| 9331 | 236995 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 290X Ogden Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6007943.27798 | 2096094.30116 | 37.7359246593032 | -122.414982254625 | (37.7359246593032, -122.414982254625) | 2 | 7 | 7 | 28859 | 2 | |||
| 9446 | 56421 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 232 18th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/13/2020 12:00:00 AM | 3 | 5x5 | Permit Number 12581 | 5990270.93478 | 2113836.22748 | 37.7836303428936 | -122.47737817827 | (37.7836303428936, -122.47737817827) | 11 | 6 | 2 | 55 | 26 | |
| 9521 | 35167 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 240 Walter St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/02/1998 12:00:00 AM | Permit Number 38700 | |||||||||||||
| 9610 | 196158 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 390x Hampshire St | 4 | Median : Cutout | Tree | DPW 1 | 8 | Width 5ft | 6010042.15672 | 2106501.92637 | 37.7646194177702 | -122.408459468244 | (37.7646194177702, -122.408459468244) | 8 | 4 | 8 | 28853 | 19 | |||
| 9652 | 178811 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 19 Colby St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 2ft | 6007941.79133 | 2094126.71346 | 37.7305220072776 | -122.414848183713 | (37.7305220072776, -122.414848183713) | 9 | 3 | 7 | 309 | 28 | |||
| 9776 | 236304 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 128 Bartlett St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6006662 | 2102868 | 37.7544516263091 | -122.419892666236 | (37.7544516263091, -122.419892666236) | 2 | 4 | 7 | 28859 | 19 | |||
| 9836 | 218111 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 70 Lopez Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 0ft | 5993944.94512 | 2100501.16931 | 37.747228264177 | -122.463699432805 | (37.747228264177, -122.463699432805) | 1 | 8 | 4 | 29491 | 40 | |||
| 9968 | 31847 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/19/1995 12:00:00 AM | Permit Number 35298 | ||||||||||||||
| 10055 | 43124 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 306 Elsie St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/11/2000 12:00:00 AM | Permit Number 42942 | 6006590.61283403 | 2097446.1617065 | 37.7395604645493 | -122.41975485718 | (37.7395604645493, -122.41975485718) | 2 | 7 | 7 | 28859 | 2 | |||
| 10094 | 212393 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 55 San Rafael Way | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 6ft | 5991911.35138 | 2095658.63831 | 37.7338145152114 | -122.470378772281 | (37.7338145152114, -122.470378772281) | 9 | 8 | 4 | 59 | 40 | |||
| 10115 | 236996 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1100 Eugenia Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6008130 | 2097670 | 37.7402616738659 | -122.414448140958 | (37.7402616738659, -122.414448140958) | 2 | 7 | 7 | 28859 | 2 | |||
| 10164 | 212975 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1350 07th Ave | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 5993969.17632 | 2106486.34131 | 37.7636634033545 | -122.46405005237 | (37.7636634033545, -122.46405005237) | 1 | 5 | 11 | 56 | 12 | |||
| 10194 | 236545 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 103x Tompkins Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6007706 | 2096609 | 37.7373245731641 | -122.41583905613 | (37.7373245731641, -122.41583905613) | 2 | 7 | 7 | 28859 | 2 | |||
| 10306 | 445 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 700X 23rd Ave | 6 | Median : Cutout | Tree | DPW 1 | 3 | 8-HOA | 5988818.92542 | 2110381.03816 | 37.7740590021472 | -122.482148301598 | (37.7740590021472, -122.482148301598) | 11 | 6 | 2 | 55 | 26 | |||
| 10314 | 64840 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 840 De Haro St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/12/1989 12:00:00 AM | 10 | Permit Number 25852 | 6012110.52355 | 2104463.76565 | 37.7591386965208 | -122.401162267538 | (37.7591386965208, -122.401162267538) | 10 | 3 | 8 | 28856 | 29 | ||
| 10335 | 218324 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 430 Castenada Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 0ft | 5993138.3267 | 2099955.06168 | 37.7456822792311 | -122.466448948955 | (37.7456822792311, -122.466448948955) | 1 | 8 | 4 | 29491 | 40 | |||
| 10367 | 119574 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 341 30th Ave | 6 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 3ft | 5986512.99612 | 2113510.70001 | 37.782517772266 | -122.490355077371 | (37.782517772266, -122.490355077371) | 11 | 6 | 2 | 55 | 26 | |||
| 10449 | 212420 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 380 San Leandro Way | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 5992233.05036 | 2094370.31481 | 37.7302956955751 | -122.469172838073 | (37.7302956955751, -122.469172838073) | 9 | 8 | 4 | 59 | 40 | |||
| 10485 | 236999 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1100 Eugenia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6008130 | 2097670 | 37.7402616738659 | -122.414448140958 | (37.7402616738659, -122.414448140958) | 2 | 7 | 7 | 28859 | 2 | |||
| 10556 | 212523 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 50 Juanita Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 2ft | 5997152.58172 | 2099268.39938 | 37.7440276912283 | -122.452518778745 | (37.7440276912283, -122.452518778745) | 9 | 7 | 4 | 59 | 40 | |||
| 10619 | 47101 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 2851 Turk Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/03/2002 12:00:00 AM | Permit Number 45082 | 5997430.51737904 | 2111586.3633718 | 37.7778656294862 | -122.452446473008 | (37.7778656294862, -122.452446473008) | 15 | 6 | 2 | 54 | 16 | |||
| 10684 | 236904 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 251 Alma St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 5997463.02622 | 2106112.38029 | 37.7628373418849 | -122.451938994804 | (37.7628373418849, -122.451938994804) | 15 | 5 | 11 | 29492 | 9 | |||
| 10699 | 50602 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 1700 Buchanan St | 15 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/26/2003 12:00:00 AM | Permit Number 47204 | 6004061.24207522 | 2114267.02341516 | 37.7856037113433 | -122.429699722138 | (37.7856037113433, -122.429699722138) | 13 | 9 | 11 | 29490 | 13 | |||
| 10828 | 196319 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 83 Lafayette St | 1 | : | Tree | Private 2 | 10 | Width 3ft | 6007736.57644 | 2109492.64153 | 37.7727018336483 | -122.416645755806 | (37.7727018336483, -122.416645755806) | 8 | 2 | 9 | 28853 | 19 | |||
| 11106 | 212530 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 207 Dorado Ter | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 5994534.99402 | 2092797.08318 | 37.7261087291241 | -122.461100774292 | (37.7261087291241, -122.461100774292) | 9 | 8 | 4 | 28861 | 40 | |||
| 11123 | 236331 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 3382 18th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6006990.19245 | 2105581.09043 | 37.7619196296031 | -122.418950104878 | (37.7619196296031, -122.418950104878) | 8 | 4 | 7 | 28859 | 19 | |||
| 11129 | 236516 | Significant Tree 6 | Prunus cerasifera :: Cherry Plum 7 | 63 Bronte St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 4 | Width 3ft | 6009359.84862 | 2097078.24448 | 37.7387058549889 | -122.410154031979 | (37.7387058549889, -122.410154031979) | 10 | 7 | 7 | 28859 | 2 | |||
| 11152 | 212892 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1485 16th Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 5ft | 5991130.51563 | 2105331.7867 | 37.7603292954688 | -122.473783764707 | (37.7603292954688, -122.473783764707) | 1 | 8 | 4 | 56 | 12 | |||
| 11258 | 237764 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 192 States St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6001006.59969 | 2106396.99375 | 37.7638211498476 | -122.439703449459 | (37.7638211498476, -122.439703449459) | 15 | 5 | 5 | 28862 | 3 | |||
| 11265 | 218415 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 200 Castenada Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 0ft | 5994285.79928 | 2100659.94042 | 37.7476838445316 | -122.462532308839 | (37.7476838445316, -122.462532308839) | 1 | 8 | 4 | 29491 | 40 | |||
| 11344 | 196242 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 463 Natoma St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 6010684.26644 | 2112432.48387 | 37.7809392989608 | -122.406656537094 | (37.7809392989608, -122.406656537094) | 14 | 2 | 9 | 28853 | 34 | |||
| 11393 | 212890 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1391 17th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 5990805.53929 | 2105956.91364 | 37.7620268998548 | -122.474953326735 | (37.7620268998548, -122.474953326735) | 1 | 8 | 3 | 56 | 12 | |||
| 11425 | 261363 | Undocumented 4 | Prunus cerasifera :: Cherry Plum 7 | 35 Bache St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007229 | 2095580 | 37.7344723377146 | -122.417415367168 | (37.7344723377146, -122.417415367168) | 2 | 7 | 7 | 28859 | 2 | ||||
| 11576 | 235961 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 104 Peralta Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6010187 | 2100252 | 37.7474666267998 | -122.407517818984 | (37.7474666267998, -122.407517818984) | 2 | 7 | 7 | 28859 | 2 | |||
| 11664 | 218081 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 401 Darien Way | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5992710.23093 | 2094925.06457 | 37.7318464622281 | -122.467563501267 | (37.7318464622281, -122.467563501267) | 9 | 8 | 4 | 59 | 40 | |||
| 11672 | 261357 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 2x Bache St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007175 | 2095707 | 37.7348180134015 | -122.417611061749 | (37.7348180134015, -122.417611061749) | 2 | 7 | 7 | 28859 | 2 | ||||
| 11700 | 212947 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 418 Hugo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 5994502.34493 | 2107040.0504 | 37.7652144578121 | -122.462246162554 | (37.7652144578121, -122.462246162554) | 11 | 5 | 11 | 56 | 12 | |||
| 11827 | 135735 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1900 Lyon St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 5999505.71531 | 2115426.21656 | 37.7885275445481 | -122.445543851863 | (37.7885275445481, -122.445543851863) | 13 | 6 | 1 | 29490 | 27 | |||
| 11836 | 235813 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 736 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6007481.97929 | 2105347.92078 | 37.7613070797842 | -122.417232679439 | (37.7613070797842, -122.417232679439) | 2 | 4 | 7 | 28859 | 19 | |||
| 11892 | 178787 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 527 Avalon Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6004156.37561 | 2092428.97971 | 37.7256469812202 | -122.42781400012 | (37.7256469812202, -122.42781400012) | 9 | 7 | 6 | 28861 | 5 | |||
| 11913 | 218048 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 76 San Rafael Way | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 3ft | 5991882.76001 | 2095565.36531 | 37.7335567578307 | -122.470470829562 | (37.7335567578307, -122.470470829562) | 9 | 8 | 4 | 59 | 40 | |||
| 11975 | 236804 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1336 Willard St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 5996826.68272 | 2106751.79717 | 37.764556548859 | -122.454186057934 | (37.764556548859, -122.454186057934) | 15 | 5 | 11 | 29492 | 12 | |||
| 11992 | 212328 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 2008 15th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 5991630.07361 | 2101733.92656 | 37.7504794356741 | -122.471793832122 | (37.7504794356741, -122.471793832122) | 1 | 8 | 4 | 29491 | 12 | |||
| 12057 | 213002 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1684 09th Ave | 2 | Front Yard : Yard | Tree | Private 2 | 7 | Width 6ft | 5993433.63561 | 2104037.38887 | 37.7569083391631 | -122.465724367884 | (37.7569083391631, -122.465724367884) | 1 | 8 | 4 | 56 | 12 | |||
| 12073 | 201265 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 15 Orsi Cir | 1 | : | Tree | Private 2 | 7 | Width 2ft | 6013080.9244 | 2093125.28837 | 37.728059724652 | -122.397011137269 | (37.728059724652, -122.397011137269) | 10 | 3 | 8 | 58 | 1 | |||
| 12142 | 47373 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 800 Shields St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/13/2002 12:00:00 AM | Permit Number 45290 | 5991938.31220881 | 2089883.64331253 | 37.7179593670507 | -122.469865242758 | (37.7179593670507, -122.469865242758) | 9 | 8 | 6 | 64 | 24 | |||
| 12181 | 212499 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 65 Sotelo Ave | 7 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 4ft | 5993890.56554 | 2101313.40966 | 37.7494553362962 | -122.463946421708 | (37.7494553362962, -122.463946421708) | 1 | 8 | 4 | 29491 | 40 | |||
| 12184 | 243309 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 780 South Van Ness Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/03/2017 10:07:00 AM | 0 | Width 3ft | Permit Number 779025 | 6007491.90913 | 2105126.68883 | 37.7607001866898 | -122.417182659168 | (37.7607001866898, -122.417182659168) | 2 | 4 | 7 | 28859 | 19 | |
| 12281 | 214263 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 516 Mangels Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 2ft | 5998027.33278 | 2095272.17551 | 37.73310510121 | -122.449206255476 | (37.73310510121, -122.449206255476) | 9 | 7 | 4 | 59 | 40 | |||
| 12301 | 81771 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 118 Jones St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/20/2007 12:00:00 AM | 7 | 3x3 | Permit Number 50018 | 6009093.57763 | 2112998.11082 | 37.7824032504549 | -122.41219952199 | (37.7824032504549, -122.41219952199) | 14 | 10 | 9 | 28852 | 36 | |
| 12329 | 236272 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 99 Shotwell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/26/2019 12:00:00 AM | 3 | Width 3ft | 6007737.48047 | 2107411.94537 | 37.7669887824256 | -122.416495215585 | (37.7669887824256, -122.416495215585) | 8 | 4 | 7 | 28853 | 19 | ||
| 12459 | 236572 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 2928 19th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 6009215.21954 | 2105007.07785 | 37.7604685608946 | -122.41121403052 | (37.7604685608946, -122.41121403052) | 2 | 4 | 7 | 28859 | 19 | |||
| 12487 | 236445 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 994 Clayton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5998851.72609 | 2106478.89575 | 37.7639231446737 | -122.447162366272 | (37.7639231446737, -122.447162366272) | 15 | 5 | 11 | 29492 | 9 | |||
| 12498 | 236755 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 3931 22nd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6002286.00217 | 2102939.78415 | 37.7544012253481 | -122.435031116186 | (37.7544012253481, -122.435031116186) | 2 | 4 | 5 | 28862 | 22 | |||
| 12521 | 217929 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1882 18th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/08/2020 12:00:00 AM | 3 | Width 3ft | 5990657.38608 | 2102600.85975 | 37.7528034790046 | -122.475220706895 | (37.7528034790046, -122.475220706895) | 1 | 8 | 4 | 56 | 12 |
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) );