trees
1,650 rows where qSpecies_id = 64 sorted by Zip Codes
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
44994 | 245538 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 105 Manchester St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 2ft | 6008268.68724 | 2099353.97452 | 37.7448932860134 | -122.414087718783 | (37.7448932860134, -122.414087718783) | 2 | 7 | 7 | 28859 | 2 | |||
45145 | 245537 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 105 Manchester St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 2ft | 6008269.43017 | 2099349.5308 | 37.744881126273 | -122.414084835546 | (37.744881126273, -122.414084835546) | 2 | 7 | 7 | 28859 | 2 | |||
45786 | 245533 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 111 Manchester St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | Width 2ft | 6008271.8645 | 2099305.47289 | 37.7447602897607 | -122.414073301756 | (37.7447602897607, -122.414073301756) | 2 | 7 | 7 | 28859 | 2 | |||
47644 | 246733 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 100 Ripley St | 1 | : | Tree | Private 2 | 3 | Width 2ft | 6008547.21994 | 2099053.14495 | 37.7440829149855 | -122.413103333461 | (37.7440829149855, -122.413103333461) | 2 | 7 | 7 | 28859 | 2 | |||
47721 | 102066 | Permitted Site 7 | Cordyline australis :: Dracena Palm 64 | 229 Bonview St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/18/2012 12:00:00 AM | 3 | 3x3 | Permit Number 769725 | 6006956.6 | 2097728.3 | 37.7403557640328 | -122.418509430253 | (37.7403557640328, -122.418509430253) | 2 | 7 | 7 | 28859 | 2 |
47764 | 245551 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1187 South Van Ness Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6007687.46494 | 2102779.22199 | 37.7542655806185 | -122.416340044757 | (37.7542655806185, -122.416340044757) | 2 | 4 | 7 | 28859 | 19 | |||
48630 | 45274 | Permitted Site 7 | Cordyline australis :: Dracena Palm 64 | 635 Crescent Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/12/2001 12:00:00 AM | Permit Number 44117 | 6007835.54663504 | 2095717.89639114 | 37.734885079654 | -122.415328087742 | (37.734885079654, -122.415328087742) | 2 | 7 | 7 | 28859 | 2 | ||
49496 | 245480 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 168 Tiffany Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 6ft | 6006062.04873 | 2099258.29752 | 37.7445063913738 | -122.421711083797 | (37.7445063913738, -122.421711083797) | 2 | 7 | 5 | 28859 | 2 | |||
49702 | 245671 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 7 28th St | 3 | Sidewalk: Curb side : Pot | Tree | Private 2 | 3 | Width 3ft | 6005840.27881 | 2099627.45735 | 37.7455075121707 | -122.422504146459 | (37.7455075121707, -122.422504146459) | 2 | 7 | 5 | 28859 | 22 | |||
50724 | 245494 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 3426 22nd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6005526.00756 | 2103160.68885 | 37.7551912177087 | -122.423842038189 | (37.7551912177087, -122.423842038189) | 2 | 4 | 5 | 28859 | 19 | |||
51604 | 245495 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 3430 22nd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6005513.56825 | 2103160.47722 | 37.7551899343766 | -122.423885041981 | (37.7551899343766, -122.423885041981) | 2 | 4 | 5 | 28859 | 19 | |||
51828 | 248187 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 216 Esmeralda Ave | 6 | Side Yard : Yard | Tree | Private 2 | 9 | 6007416.25597 | 2098719.21061 | 37.7431024507267 | -122.416990309471 | (37.7431024507267, -122.416990309471) | 2 | 7 | 7 | 28859 | 2 | ||||
52105 | 2325 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 2298X Bryant St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/17/2004 12:00:00 AM | 3 | 3X3 | 6009629.89674 | 2103998.72024 | 37.757723086282 | -122.409708671514 | (37.757723086282, -122.409708671514) | 2 | 4 | 7 | 28859 | 19 | ||
52331 | 29994 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 681X San Jose Ave | 9 | Median : Cutout | Tree | DPW 1 | 03/24/2007 12:00:00 AM | 3 | 3x3 | 6005883.22983 | 2099389.42314 | 37.7448563472359 | -122.422338718883 | (37.7448563472359, -122.422338718883) | 2 | 7 | 5 | 28859 | 2 | ||
54169 | 247861 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 81 Bradford St | 3 | Front Yard : Yard | Tree | Private 2 | 6 | 6009580.66804 | 2098127.95413 | 37.741600504664 | -122.409464602736 | (37.741600504664, -122.409464602736) | 10 | 7 | 7 | 28859 | 2 | ||||
55309 | 30017 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 750X San Jose Ave | 9 | Median : Cutout | Tree | DPW 1 | 03/24/2007 12:00:00 AM | 3 | 3x3 | 6005697.924 | 2098794.21109 | 37.743211575362 | -122.422937177222 | (37.743211575362, -122.422937177222) | 2 | 7 | 7 | 28859 | 2 | ||
55552 | 245650 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 472 Bartlett St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | Width 3ft | 6006775.36619 | 2101056.85496 | 37.7494850220131 | -122.419372138739 | (37.7494850220131, -122.419372138739) | 2 | 4 | 7 | 28859 | 19 | |||
58409 | 29998 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 681X San Jose Ave | 12 | Median : Cutout | Tree | DPW 1 | 03/24/2007 12:00:00 AM | 3 | 3x3 | 6005888.8207 | 2099404.7215 | 37.7448986684345 | -122.422320473416 | (37.7448986684345, -122.422320473416) | 2 | 7 | 5 | 28859 | 2 | ||
58859 | 245658 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 2963 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6009084.94138 | 2102725.47948 | 37.7541965009772 | -122.411503405363 | (37.7541965009772, -122.411503405363) | 2 | 4 | 7 | 28859 | 19 | |||
60482 | 5572 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1035 Dolores St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 50 | 3x3 | 6005146.9010804 | 2102326.2346427 | 37.7528785917901 | -122.425093730386 | (37.7528785917901, -122.425093730386) | 2 | 4 | 5 | 28859 | 19 | |||
61556 | 245491 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 922 Treat Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 6ft | 6008565.0214 | 2103129.24475 | 37.7552759725092 | -122.413329975207 | (37.7552759725092, -122.413329975207) | 2 | 4 | 7 | 28859 | 19 | |||
62058 | 245500 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 290 Mullen Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6010408.82405 | 2099965.22094 | 37.7466916081328 | -122.406730554867 | (37.7466916081328, -122.406730554867) | 2 | 7 | 7 | 28859 | 2 | |||
62911 | 245547 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 2104 Folsom St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 5 | Width 2ft | 6008076.4108 | 2106131.70882 | 37.7634926050162 | -122.415232269774 | (37.7634926050162, -122.415232269774) | 8 | 4 | 7 | 28859 | 19 | |||
63182 | 245563 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 397 San Jose Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6006236.49603 | 2100892.69418 | 37.7490039090167 | -122.421223914748 | (37.7490039090167, -122.421223914748) | 2 | 4 | 5 | 28859 | 19 | |||
63326 | 245536 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 105 Manchester St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 2ft | 6008269.31698 | 2099343.99754 | 37.7448659268119 | -122.414084835556 | (37.7448659268119, -122.414084835556) | 2 | 7 | 7 | 28859 | 2 | |||
63379 | 248235 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 301 Esmeralda Ave | 1 | Side Yard : Yard | Tree | Private 2 | 29 | 6006740.56255 | 2099063.99979 | 37.7440111320042 | -122.419351135062 | (37.7440111320042, -122.419351135062) | 2 | 7 | 7 | 28859 | 2 | ||||
63427 | 105002 | Permitted Site 7 | Cordyline australis :: Dracena Palm 64 | 3418 26th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x6 | Permit Number 768912 | 6006889.6 | 2100911.6 | 37.7490926180804 | -122.418966813039 | (37.7490926180804, -122.418966813039) | 2 | 4 | 7 | 28859 | 19 | |||
65237 | 5612 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1165 Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/10/2006 12:00:00 AM | 3 | 3X3 | 6005185.44148 | 2101562.25197 | 37.7507830495093 | -122.424906100762 | (37.7507830495093, -122.424906100762) | 2 | 4 | 5 | 28859 | 19 | ||
65696 | 30012 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 738X San Jose Ave | 4 | Median : Cutout | Tree | DPW 1 | 03/24/2007 12:00:00 AM | 3 | 3x3 | 6005734.30948 | 2098905.3013 | 37.743518656953 | -122.422819258997 | (37.743518656953, -122.422819258997) | 2 | 7 | 7 | 28859 | 2 | ||
68199 | 245665 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 681x San Jose Ave | 1 | Median : Cutout | Tree | DPW 1 | 2 | Width 3ft | 6005853.52339 | 2099296.15265 | 37.744598571882 | -122.42243481233 | (37.744598571882, -122.42243481233) | 2 | 7 | 5 | 28859 | 2 | |||
68579 | 245669 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 75 Valley St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6005459.48402 | 2099310.90679 | 37.7446168470021 | -122.42379837252 | (37.7446168470021, -122.42379837252) | 2 | 7 | 5 | 28859 | 22 | |||
68759 | 245528 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 670 Ellsworth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6007943.4161 | 2095774.09425 | 37.7350454487732 | -122.414959120479 | (37.7350454487732, -122.414959120479) | 2 | 7 | 7 | 28859 | 2 | |||
70141 | 245638 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 928 Shotwell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6007977.34612 | 2102336.51034 | 37.7530662914815 | -122.415306221908 | (37.7530662914815, -122.415306221908) | 2 | 4 | 7 | 28859 | 19 | |||
71434 | 245482 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 3740 25th St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 8ft | 6005617.75744 | 2101415.76769 | 37.750405247016 | -122.4234006995 | (37.750405247016, -122.4234006995) | 2 | 4 | 5 | 28859 | 19 | |||
72188 | 108602 | Permitted Site 7 | Cordyline australis :: Dracena Palm 64 | 47 Manchester St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/2014 12:00:00 AM | 3 | 3x3 | Permit Number 774588 | 6008247.58165 | 2099751.34896 | 37.7459832024183 | -122.41418880701 | (37.7459832024183, -122.41418880701) | 2 | 7 | 7 | 28859 | 2 |
72581 | 248146 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 15 Massasoit St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 42 | Width 3ft | 6010041.64373 | 2099325.26716 | 37.7449138840691 | -122.407955111364 | (37.7449138840691, -122.407955111364) | 2 | 7 | 7 | 28859 | 2 | |||
75427 | 245656 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 3028 25th St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 2 | Width 3ft | 6009308.84232 | 2101614.09746 | 37.7511574507702 | -122.410650617835 | (37.7511574507702, -122.410650617835) | 2 | 4 | 7 | 28859 | 19 | |||
76551 | 108603 | Permitted Site 7 | Cordyline australis :: Dracena Palm 64 | 47 Manchester St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/2014 12:00:00 AM | 3 | 3x3 | Permit Number 774588 | 6008247.58165 | 2099751.34896 | 37.7459832024183 | -122.41418880701 | (37.7459832024183, -122.41418880701) | 2 | 7 | 7 | 28859 | 2 |
76944 | 245641 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 397 San Jose Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 5ft | 6006236.33597 | 2100890.63665 | 37.7489982504852 | -122.421224322153 | (37.7489982504852, -122.421224322153) | 2 | 4 | 5 | 28859 | 19 | |||
77965 | 96415 | Undocumented 4 | Cordyline australis :: Dracena Palm 64 | 2701x Harrison St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 3x3 | 6008948.88746 | 2102724.5327 | 37.7541862689808 | -122.411973848371 | (37.7541862689808, -122.411973848371) | 2 | 4 | 7 | 28859 | 19 | |||
78020 | 30011 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 795X San Jose Ave | 3 | Median : Cutout | Tree | DPW 1 | 01/02/2013 12:00:00 AM | 3 | 3x3 | 6005625.43803 | 2098570.80228 | 37.7425940549807 | -122.423171938039 | (37.7425940549807, -122.423171938039) | 2 | 7 | 7 | 28859 | 2 | ||
78446 | 245534 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 105 Manchester St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 2ft | 6008271.48377 | 2099327.62295 | 37.7448210875245 | -122.414076184968 | (37.7448210875245, -122.414076184968) | 2 | 7 | 7 | 28859 | 2 | |||
78517 | 245543 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 569 Peralta Ave | 3 | Sidewalk: Curb side : Pot | Tree | Private 2 | 3 | Width 4ft | 6009858.44464 | 2098854.68351 | 37.7436115056701 | -122.408555393522 | (37.7436115056701, -122.408555393522) | 2 | 7 | 7 | 28859 | 2 | |||
79006 | 44342 | Permitted Site 7 | Cordyline australis :: Dracena Palm 64 | 187 Peralta Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/11/2010 12:00:00 AM | 3x3 | Permit Number 53500 | 6009836.45355968 | 2099988.51839254 | 37.7467235364285 | -122.408711405987 | (37.7467235364285, -122.408711405987) | 2 | 7 | 7 | 28859 | 2 | ||
80307 | 245532 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1 Winfield St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 3ft | 6007523.94183 | 2099537.64218 | 37.745355738075 | -122.416675926256 | (37.745355738075, -122.416675926256) | 2 | 7 | 7 | 28859 | 2 | |||
81941 | 245502 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 285 Mullen Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6010380.11307 | 2100023.84637 | 37.7468509742978 | -122.406833966112 | (37.7468509742978, -122.406833966112) | 2 | 7 | 7 | 28859 | 2 | |||
82834 | 245481 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 3748 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6005574.94172 | 2100531.00581 | 37.7479734774924 | -122.423485866181 | (37.7479734774924, -122.423485866181) | 2 | 4 | 5 | 28859 | 19 | |||
84642 | 245540 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 155 Appleton Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 4ft | 6006131.39361 | 2096827.2046 | 37.7378350666424 | -122.421298698799 | (37.7378350666424, -122.421298698799) | 2 | 7 | 7 | 28859 | 2 | |||
85143 | 245490 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1001 Treat Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6008635.00283 | 2102667.8072 | 37.7540128980984 | -122.413055332141 | (37.7540128980984, -122.413055332141) | 2 | 4 | 7 | 28859 | 19 | |||
85636 | 245617 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 110 Coleridge St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6006667.13836 | 2099063.32987 | 37.7440051569251 | -122.419604972298 | (37.7440051569251, -122.419604972298) | 2 | 7 | 7 | 28859 | 2 | |||
87036 | 245655 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 3164 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6008635.32243 | 2101576.74228 | 37.7510170971771 | -122.412977088449 | (37.7510170971771, -122.412977088449) | 2 | 4 | 7 | 28859 | 19 | |||
87290 | 245535 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 105 Manchester St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 2ft | 6008270.02595 | 2099337.89362 | 37.7448492066234 | -122.414081952318 | (37.7448492066234, -122.414081952318) | 2 | 7 | 7 | 28859 | 2 | |||
90126 | 245632 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 105 Manchester St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6008270.17422 | 2099353.33031 | 37.7448916006749 | -122.414082531499 | (37.7448916006749, -122.414082531499) | 2 | 7 | 7 | 28859 | 2 | |||
91016 | 245497 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1070 Hampshire St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 6ft | 6010227.41138 | 2103002.67272 | 37.755021628064 | -122.407571984862 | (37.755021628064, -122.407571984862) | 2 | 4 | 7 | 28859 | 19 | |||
91193 | 245529 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 670 Ellsworth St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6007943.1219 | 2095759.71849 | 37.7350059595386 | -122.414959120475 | (37.7350059595386, -122.414959120475) | 2 | 7 | 7 | 28859 | 2 | |||
92837 | 245487 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 326 San Jose Ave | 2 | : | Tree | Private 2 | 4 | Width 3ft | 6006168.86774 | 2101142.03108 | 37.7496847182974 | -122.42147547943 | (37.7496847182974, -122.42147547943) | 2 | 4 | 5 | 28859 | 19 | |||
94414 | 29989 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 681X San Jose Ave | 4 | Median : Cutout | Tree | DPW 1 | 03/24/2007 12:00:00 AM | 3 | 3x3 | 6005863.98756 | 2099326.06351 | 37.7446812906148 | -122.422400754108 | (37.7446812906148, -122.422400754108) | 2 | 7 | 5 | 28859 | 2 | ||
94491 | 245609 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 669 Ellsworth St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6007969.8836 | 2095742.78818 | 37.7349609763722 | -122.414865397647 | (37.7349609763722, -122.414865397647) | 2 | 7 | 7 | 28859 | 2 | |||
95347 | 245642 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 397 San Jose Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 5ft | 6006237.12505 | 2100896.31259 | 37.7490138798065 | -122.421221996497 | (37.7490138798065, -122.421221996497) | 2 | 4 | 5 | 28859 | 19 | |||
96010 | 245545 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 2020 Folsom St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 6008041.02658 | 2106675.64917 | 37.7649841504136 | -122.41539316298 | (37.7649841504136, -122.41539316298) | 8 | 4 | 7 | 28859 | 19 | |||
96049 | 245501 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 290 Mullen Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6010418.76623 | 2099958.94073 | 37.746674920319 | -122.406695733141 | (37.746674920319, -122.406695733141) | 2 | 7 | 7 | 28859 | 2 | |||
96704 | 26510 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 2854 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 25 | 3X3 | 6008945.91858 | 2101850.94862 | 37.7517874366552 | -122.411922386923 | (37.7517874366552, -122.411922386923) | 2 | 4 | 7 | 28859 | 19 | |||
96797 | 245621 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 44 Elsie St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6007421.61476 | 2099036.4016 | 37.7439736878503 | -122.416994249397 | (37.7439736878503, -122.416994249397) | 2 | 7 | 7 | 28859 | 2 | |||
97793 | 245559 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 2895 Harrison St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6009021.46487 | 2101635.62875 | 37.751200454559 | -122.411645924521 | (37.751200454559, -122.411645924521) | 2 | 4 | 7 | 28859 | 19 | |||
100121 | 29997 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 681X San Jose Ave | 11 | Median : Cutout | Tree | DPW 1 | 03/24/2007 12:00:00 AM | 3 | 3x3 | 6005888.0743 | 2099402.63475 | 37.7448928965893 | -122.422322906097 | (37.7448928965893, -122.422322906097) | 2 | 7 | 5 | 28859 | 2 | ||
104581 | 29988 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 681X San Jose Ave | 3 | Median : Cutout | Tree | DPW 1 | 03/24/2007 12:00:00 AM | 3 | 3x3 | 6005860.9876 | 2099317.01753 | 37.7446562831756 | -122.422410484775 | (37.7446562831756, -122.422410484775) | 2 | 7 | 5 | 28859 | 2 | ||
105209 | 5712 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1617 Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 90 | 3X3 | 6005334.50752 | 2098914.22042 | 37.743520580615 | -122.424202310195 | (37.743520580615, -122.424202310195) | 2 | 7 | 5 | 28859 | 22 | |||
105358 | 247866 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 398 Mayflower St | 1 | Side Yard : Yard | Tree | Private 2 | 24 | 6009543.35492 | 2098406.93767 | 37.7423644418716 | -122.409613305631 | (37.7423644418716, -122.409613305631) | 10 | 7 | 7 | 28859 | 2 | ||||
106533 | 245561 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 2895 Harrison St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6009019.06036 | 2101672.04835 | 37.7513003197582 | -122.411656812604 | (37.7513003197582, -122.411656812604) | 2 | 4 | 7 | 28859 | 19 | |||
107427 | 105004 | Permitted Site 7 | Cordyline australis :: Dracena Palm 64 | 3418 26th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16x4 | Permit Number 768912 | 6006889.6 | 2100911.6 | 37.7490926180804 | -122.418966813039 | (37.7490926180804, -122.418966813039) | 2 | 4 | 7 | 28859 | 19 | |||
108093 | 245662 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 750x San Jose Ave | 6 | Median : Cutout | Tree | DPW 1 | 3 | Width 3ft | 6005689.97131 | 2098766.69991 | 37.743135587148 | -122.422962720654 | (37.743135587148, -122.422962720654) | 2 | 7 | 7 | 28859 | 2 | |||
108478 | 246744 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 140 Ripley St | 2 | Front Yard : Yard | Tree | Private 2 | 4 | 6008911.68213 | 2099076.13806 | 37.7441665024863 | -122.411844724161 | (37.7441665024863, -122.411844724161) | 2 | 7 | 7 | 28859 | 2 | ||||
109878 | 245651 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 468 Bartlett St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6006776.13515 | 2101068.0977 | 37.7495159353306 | -122.419370277119 | (37.7495159353306, -122.419370277119) | 2 | 4 | 7 | 28859 | 19 | |||
111564 | 245492 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 922 Treat Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 6ft | 6008565.63001 | 2103125.24366 | 37.7552650205921 | -122.413327587511 | (37.7552650205921, -122.413327587511) | 2 | 4 | 7 | 28859 | 19 | |||
111836 | 245613 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 144 Bronte St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | Width 3ft | 6009311.42661 | 2096644.159 | 37.7375112360491 | -122.410290812568 | (37.7375112360491, -122.410290812568) | 10 | 7 | 7 | 28859 | 2 | |||
113814 | 116969 | Undocumented 4 | Cordyline australis :: Dracena Palm 64 | 2648 BRYANT ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6009729 | 2101911 | 37.7519962268163 | -122.409218610644 | (37.7519962268163, -122.409218610644) | 2 | 4 | 7 | 28859 | 19 | ||||
114297 | 245555 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 939 Valencia St | 2 | Sidewalk: Curb side : Pot | Tree | Private 2 | 4 | Width 2ft | 6006339.61299 | 2104100.87998 | 37.7578186617191 | -122.421095101275 | (37.7578186617191, -122.421095101275) | 2 | 4 | 7 | 28859 | 19 | |||
114566 | 245498 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 187 Peralta Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6009821.97464 | 2099989.16006 | 37.7467244873424 | -122.408761518126 | (37.7467244873424, -122.408761518126) | 2 | 7 | 7 | 28859 | 2 | |||
114825 | 245659 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 2862 21st St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6009008.88417 | 2103936.03473 | 37.7575161459615 | -122.41185196732 | (37.7575161459615, -122.41185196732) | 2 | 4 | 7 | 28859 | 19 | |||
114941 | 245660 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 2758 Harrison St | 2 | Sidewalk: Curb side : Pot | Tree | Private 2 | 2 | Width 3ft | 6008913.58885 | 2102381.91686 | 37.7532435424601 | -122.412071708565 | (37.7532435424601, -122.412071708565) | 2 | 4 | 7 | 28859 | 19 | |||
116520 | 245633 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 105 Manchester St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6008270.76383 | 2099345.47262 | 37.7448700583192 | -122.414079936938 | (37.7448700583192, -122.414079936938) | 2 | 7 | 7 | 28859 | 2 | |||
116665 | 38307 | Permitted Site 7 | Cordyline australis :: Dracena Palm 64 | 2000 Folsom St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/27/1998 12:00:00 AM | Permit Number 40376 | 6008042.39215173 | 2106787.37094181 | 37.7652909891949 | -122.415396349695 | (37.7652909891949, -122.415396349695) | 8 | 4 | 7 | 28859 | 19 | ||
116910 | 245616 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 224 Elsie St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 5ft | 6006752.53705 | 2097829.30026 | 37.7406215980173 | -122.41922216329 | (37.7406215980173, -122.41922216329) | 2 | 7 | 7 | 28859 | 2 | |||
117380 | 245653 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 466 Bartlett St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6006774.42214 | 2101089.57784 | 37.7495748184311 | -122.419377724408 | (37.7495748184311, -122.419377724408) | 2 | 4 | 7 | 28859 | 19 | |||
118008 | 82985 | Permitted Site 7 | Cordyline australis :: Dracena Palm 64 | 460 Ellsworth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/18/2008 12:00:00 AM | 3x3 | Permit Number 50922 | 6008017.64496893 | 2096716.02509924 | 37.7376359559176 | -122.414769124009 | (37.7376359559176, -122.414769124009) | 2 | 7 | 7 | 28859 | 2 | ||
118440 | 245505 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1529 Dolores St | 2 | Sidewalk: Curb side : Pot | Tree | Private 2 | 3 | Width 2ft | 6005301.27188 | 2099453.26683 | 37.7449988025437 | -122.424355562768 | (37.7449988025437, -122.424355562768) | 2 | 7 | 5 | 28859 | 22 | |||
118831 | 245614 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 635 Crescent Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6007920.92771 | 2095707.99413 | 37.7348626885481 | -122.415032193988 | (37.7348626885481, -122.415032193988) | 2 | 7 | 7 | 28859 | 2 | |||
119000 | 245489 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 2729 Bryant St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 6ft | 6009835.72496 | 2101445.07232 | 37.7507228713762 | -122.408816669969 | (37.7507228713762, -122.408816669969) | 2 | 4 | 7 | 28859 | 19 | |||
119204 | 245672 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1594x Guerrero St | 5 | Median : Cutout | Tree | DPW 1 | 7 | Width 3ft | 6005912.3551 | 2099779.75668 | 37.7459297573535 | -122.422265736192 | (37.7459297573535, -122.422265736192) | 2 | 7 | 5 | 28859 | 22 | |||
119417 | 245531 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 561 Prentiss St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 2ft | 6008731.63346 | 2096177.96743 | 37.7361986575318 | -122.412262497924 | (37.7361986575318, -122.412262497924) | 10 | 7 | 7 | 28859 | 2 | |||
119901 | 245628 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 108 Appleton Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 3ft | 6005771.54979 | 2096974.97237 | 37.7382205097733 | -122.422553352871 | (37.7382205097733, -122.422553352871) | 2 | 7 | 7 | 28859 | 2 | |||
121440 | 245657 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 3028 25th St | 2 | Sidewalk: Curb side : Pot | Tree | Private 2 | 2 | Width 3ft | 6009300.29066 | 2101614.27208 | 37.7511574507759 | -122.410680202833 | (37.7511574507759, -122.410680202833) | 2 | 4 | 7 | 28859 | 19 | |||
121476 | 5571 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1033 Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6005142.90403 | 2102326.22826 | 37.7528783484711 | -122.425107552489 | (37.7528783484711, -122.425107552489) | 2 | 4 | 5 | 28859 | 19 | |||
121739 | 245645 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 3339 22nd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6006066.98028 | 2103142.63967 | 37.7551721835763 | -122.421969910496 | (37.7551721835763, -122.421969910496) | 2 | 4 | 5 | 28859 | 19 | |||
121784 | 245654 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 466 Bartlett St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6006770.65509 | 2101089.65511 | 37.7495748184278 | -122.419390756498 | (37.7495748184278, -122.419390756498) | 2 | 4 | 7 | 28859 | 19 | |||
123422 | 52483 | Permitted Site 7 | Cordyline australis :: Dracena Palm 64 | 650MAYFLOWER Peralta Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/28/2005 12:00:00 AM | Permit Number 48593 | 6009757.2999459 | 2098381.34570201 | 37.7423061581468 | -122.408871740084 | (37.7423061581468, -122.408871740084) | 10 | 7 | 7 | 28859 | 2 | ||
124425 | 103463 | Undocumented 4 | Cordyline australis :: Dracena Palm 64 | 2445-2449 Harrison St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | 3x3 | 6008860 | 2104228 | 37.7583094625758 | -122.412387507133 | (37.7583094625758, -122.412387507133) | 2 | 4 | 7 | 28859 | 19 | |||
124785 | 245631 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 74 Bradford St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 13 | Width 3ft | 6009564.00746 | 2098268.81598 | 37.7419863470862 | -122.409532148988 | (37.7419863470862, -122.409532148988) | 10 | 7 | 7 | 28859 | 2 | |||
125026 | 245649 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 472 Bartlett St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6006773.0486 | 2101048.86067 | 37.7494629409785 | -122.419379585994 | (37.7494629409785, -122.419379585994) | 2 | 4 | 7 | 28859 | 19 | |||
126602 | 29709 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1594X Guerrero St | 4 | Median : Cutout | Tree | DPW 1 | 03/30/2006 12:00:00 AM | 6 | 6005913.75363 | 2099762.2133 | 37.7458816661082 | -122.422259654058 | (37.7458816661082, -122.422259654058) | 2 | 7 | 5 | 28859 | 22 |
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) );