Data source: data.sfgov.org
This data as json, CSV (advanced)
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder ▼ | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 429 | 429 | 142788 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 733 POLK ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | Polk St Scape will replant | 6007029.0497 | 2113497.6534 | 37.7836588132661 | -122.419377346786 | (37.7836588132661, -122.419377346786) | ||
| 3425 | 3425 | 159220 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 372 Ellington Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5998655.59562 | 2087744.29121 | 37.71247119106079 | -122.446492798529 | (37.7124711910608, -122.446492798529) | |||
| 3814 | 3814 | 193324 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1398 Tennessee St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 5ft | 6015583.67362 | 2102658.4010900003 | 37.7543746962452 | -122.38902430045499 | (37.7543746962452, -122.389024300455) | |||
| 3834 | 3834 | 244219 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 588 Cole St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 5998052.0 | 2108644.0 | 37.76982224415679 | -122.450084429151 | (37.7698222441568, -122.450084429151) | |||
| 3987 | 3987 | 159341 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 40 Whipple Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/05/2017 01:44:00 PM | 3 | Width 0ft | 5998211.297780001 | 2087238.08175 | 37.7110558677139 | -122.44799199802799 | (37.7110558677139, -122.447991998028) | ||
| 4003 | 4003 | 159298 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 122 Whipple Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/05/2017 02:11:00 PM | 3 | Width 0ft | 5998090.67137 | 2087368.5047400002 | 37.711407083550704 | -122.448418296488 | (37.7114070835507, -122.448418296488) | ||
| 4390 | 4390 | 175420 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 211 Edinburgh St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 5 | Width 3ft | 6003926.56795 | 2092414.35505 | 37.7255938222743 | -122.428607384746 | (37.7255938222743, -122.428607384746) | |||
| 5178 | 5178 | 104043 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1405 Greenwich St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6006090.81059 | 2119657.4034599997 | 37.800519058872396 | -122.42306126657199 | (37.8005190588724, -122.423061266572) | |||
| 10316 | 10316 | 110495 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 230 Madrid St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 6003598.79471 | 2092490.0157299999 | 37.7257830144685 | -122.429745863482 | (37.7257830144685, -122.429745863482) | |||
| 11111 | 11111 | 110496 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 234 Madrid St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 6003585.89382 | 2092469.97138 | 37.7257272466074 | -122.429789031845 | (37.7257272466074, -122.429789031845) | |||
| 14406 | 14406 | 120561 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 245 Mississippi St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | 3x3 | 6014054.5814 | 2105863.37396 | 37.7630899785332 | -122.394536741704 | (37.7630899785332, -122.394536741704) | |||
| 22361 | 22361 | 213977 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 271 Faxon Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5994717.86147 | 2090376.1855099997 | 37.719472047173205 | -122.460293291905 | (37.7194720471732, -122.460293291905) | |||
| 22370 | 22370 | 244046 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 401 Clayton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 5998376.5126 | 2109253.6935 | 37.771514871030995 | -122.44900587960699 | (37.771514871031, -122.449005879607) | |||
| 23538 | 23538 | 213933 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 2176 16th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 3ft | 5991344.08373 | 2100608.05246 | 37.7473715261751 | -122.472700716564 | (37.7473715261751, -122.472700716564) | |||
| 23669 | 23669 | 138324 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 2492 Bush St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6001634.5236 | 2114647.8572 | 37.7865116723619 | -122.438122738022 | (37.7865116723619, -122.438122738022) | |||
| 23795 | 23795 | 239276 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 313 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 4ft | 6007404.6677 | 2107881.43658 | 37.768259172860105 | -122.41767964611 | (37.7682591728601, -122.41767964611) | |||
| 23815 | 23815 | 239298 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1475 York St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 10ft | 6010135.52625 | 2100699.74587 | 37.7486931572616 | -122.407727378721 | (37.7486931572616, -122.407727378721) | |||
| 23839 | 23839 | 239303 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 827 York St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6009943.30832 | 2104181.7840400003 | 37.7582432964097 | -122.408637674287 | (37.7582432964097, -122.408637674287) | |||
| 23855 | 23855 | 213936 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 15 Forest Side Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5992721.86042 | 2099019.1696099997 | 37.7430885175375 | -122.46782095827801 | (37.7430885175375, -122.467820958278) | |||
| 23930 | 23930 | 246508 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 241 Duncan St | 1 | : 4 | Tree 1 | Private 1 | 8 | Width 6ft | 6004932.15845 | 2099866.5422 | 37.7461127118493 | -122.425661300149 | (37.7461127118493, -122.425661300149) | |||
| 24603 | 24603 | 239251 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 3741 26th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 3ft | 6005376.329919999 | 2100765.1364700003 | 37.748605134322794 | -122.42418930690901 | (37.7486051343228, -122.424189306909) | |||
| 24904 | 24904 | 136239 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1679 Washington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6006621.33402 | 2116991.57937 | 37.7932292991375 | -122.4210360509 | (37.7932292991375, -122.4210360509) | |||
| 25009 | 25009 | 197076 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1101 23rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 4ft | 6014915.77906 | 2102946.7050400004 | 37.7551292724085 | -122.39135422264098 | (37.7551292724085, -122.391354222641) | |||
| 25023 | 25023 | 213915 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1221 07th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5993897.03256 | 2107168.07527 | 37.7655311082052 | -122.464349072465 | (37.7655311082052, -122.464349072465) | |||
| 25141 | 25141 | 213923 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 20 Hill Point Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5996379.96302 | 2106767.55131 | 37.76457417918571 | -122.455732270441 | (37.7645741791857, -122.455732270441) | |||
| 25291 | 25291 | 179283 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 126 Prague St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6004517.28509 | 2090394.86473 | 37.7200821580385 | -122.426421596896 | (37.7200821580385, -122.426421596896) | |||
| 25584 | 25584 | 123293 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 566 06th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 5994099.84027 | 2111646.79244 | 37.7778401670229 | -122.46397274776301 | (37.7778401670229, -122.463972747763) | |||
| 25963 | 25963 | 179311 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 427 Cambridge St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 2ft | 6006943.30245 | 2092535.62338 | 37.7260970640242 | -122.418187352968 | (37.7260970640242, -122.418187352968) | |||
| 26041 | 26041 | 239277 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 150 Lexington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6006452.39888 | 2105218.17632 | 37.760892854741996 | -122.420784359417 | (37.760892854742, -122.420784359417) | |||
| 26335 | 26335 | 239363 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 3995 26th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6003937.45795 | 2100690.36733 | 37.748318487114894 | -122.429159577477 | (37.7483184871149, -122.429159577477) | |||
| 26386 | 26386 | 136222 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 3159 Baker St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5999346.78651 | 2119715.31037 | 37.8002951834309 | -122.446402399571 | (37.8002951834309, -122.446402399571) | |||
| 26447 | 26447 | 213937 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 155 Wawona St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 5992856.26396 | 2098093.99646 | 37.740555986160494 | -122.467288974202 | (37.7405559861605, -122.467288974202) | |||
| 26489 | 26489 | 139379 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1409 LYON ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5999686.4389 | 2113792.3684 | 37.7840517388464 | -122.44480108896799 | (37.7840517388464, -122.444801088968) | |||
| 26493 | 26493 | 239366 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 3544 22nd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6004780.37134 | 2103118.67558 | 37.7550337374315 | -122.426417677652 | (37.7550337374315, -122.426417677652) | |||
| 26558 | 26558 | 136248 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 2023 Taylor St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6008588.60584 | 2119742.27726 | 37.800892734360296 | -122.414423864695 | (37.8008927343603, -122.414423864695) | |||
| 26777 | 26777 | 138037 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1928 FILLMORE ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 6002982.5354 | 2114995.4141 | 37.7875425469434 | -122.433483802199 | (37.7875425469434, -122.433483802199) | |||
| 26848 | 26848 | 239353 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 333 Day St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 2ft | 6003763.4516900005 | 2098632.19433 | 37.7426573690441 | -122.429614519315 | (37.7426573690441, -122.429614519315) | |||
| 26988 | 26988 | 248441 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 739 Clayton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 5998553.128 | 2108007.4759 | 37.7681031739849 | -122.44830520423099 | (37.7681031739849, -122.448305204231) | |||
| 27228 | 27228 | 239271 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 400 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6007373.17462 | 2107313.6356599997 | 37.7666983526646 | -122.417748326439 | (37.7666983526646, -122.417748326439) | |||
| 27611 | 27611 | 239367 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 17 Chattanooga St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 2ft | 6004711.71138 | 2103517.26847 | 37.756124298509896 | -122.42668350644101 | (37.7561242985099, -122.426683506441) | |||
| 27910 | 27910 | 183007 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 2440 22nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 5989549.7088 | 2098739.1145 | 37.742135877465294 | -122.478768805014 | (37.7421358774653, -122.478768805014) | |||
| 27916 | 27916 | 197079 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 690 18th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 4ft | 6015561.72583 | 2105828.91514 | 37.763079033783605 | -122.389321587544 | (37.7630790337836, -122.389321587544) | |||
| 28029 | 28029 | 124413 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 3900 Clay St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 4ft | 5996133.62205 | 2115253.7929599998 | 37.787861027515895 | -122.45719822521299 | (37.7878610275159, -122.457198225213) | |||
| 28339 | 28339 | 73442 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 314 Athens St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/06/1994 12:00:00 AM | 8 | 6004223.020830001 | 2091452.87155 | 37.72297057362721 | -122.42751410409402 | (37.7229705736272, -122.427514104094) | ||
| 28424 | 28424 | 239318 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 2765 23rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6010143.74039 | 2102787.8018900002 | 37.7544269567524 | -122.407846193561 | (37.7544269567524, -122.407846193561) | |||
| 28756 | 28756 | 213918 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 50 Hill Point Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5996378.4642199995 | 2106655.73366 | 37.76426707058221 | -122.455729371032 | (37.7642670705822, -122.455729371032) | |||
| 29126 | 29126 | 140884 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 642 SPRUCE ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5997209.5584 | 2113437.661 | 37.782936144733 | -122.453344534721 | (37.782936144733, -122.453344534721) | |||
| 29245 | 29245 | 240195 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1787 Sanchez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 3ft | 6004009.05897 | 2097810.30767 | 37.7404145605961 | -122.42870670406401 | (37.7404145605961, -122.428706704064) | |||
| 29555 | 29555 | 142821 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1760 POLK ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 6006596.1444 | 2116951.8546 | 37.7931188048508 | -122.421120386791 | (37.7931188048508, -122.421120386791) | |||
| 29644 | 29644 | 239343 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 225 Mullen Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6010133.75357 | 2099974.1699200002 | 37.7467007857307 | -122.407682355972 | (37.7467007857307, -122.407682355972) | |||
| 30247 | 30247 | 179306 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 272 Edinburgh St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 2ft | 6003680.49546 | 2092115.04602 | 37.7247580571263 | -122.429436701757 | (37.7247580571263, -122.429436701757) | |||
| 30825 | 30825 | 240180 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 415 Gates St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6008254.09787 | 2096890.0031299999 | 37.738126944293796 | -122.413963894722 | (37.7381269442938, -122.413963894722) | |||
| 30852 | 30852 | 240192 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 15 Whitney St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 6004287.41019 | 2098213.31975 | 37.7415368893219 | -122.42777298295401 | (37.7415368893219, -122.427772982954) | |||
| 30857 | 30857 | 239336 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 3206 Harrison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6008986.81884 | 2099989.0905299997 | 37.74667748337421 | -122.41164940941201 | (37.7466774833742, -122.411649409412) | |||
| 30859 | 30859 | 136223 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 3699 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6000162.373980001 | 2120896.2706299997 | 37.8035843324119 | -122.44366504043501 | (37.8035843324119, -122.443665040435) | |||
| 31164 | 31164 | 240161 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 504 Belvedere St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 4ft | 5998591.56873 | 2106281.83073 | 37.7633671855679 | -122.448047979048 | (37.7633671855679, -122.448047979048) | |||
| 31491 | 31491 | 239296 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1114 York St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 3ft | 6009989.84018 | 2102603.83852 | 37.753913217229 | -122.408365447707 | (37.753913217229, -122.408365447707) | |||
| 32020 | 32020 | 197170 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1440 Galvez Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6016200.17093 | 2097456.77974 | 37.740126273917 | -122.386529601766 | (37.740126273917, -122.386529601766) | |||
| 33654 | 33654 | 141285 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 303 Anza St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 0ft | 5998264.5884 | 2112604.2973 | 37.780708361851396 | -122.449634513412 | (37.7807083618514, -122.449634513412) | |||
| 33655 | 33655 | 239250 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 3743 26th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6005344.37171 | 2100764.27917 | 37.7486009758548 | -122.42429975714701 | (37.7486009758548, -122.424299757147) | |||
| 34193 | 34193 | 122096 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 515 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 5990911.764769999 | 2111862.01127 | 37.778246853274105 | -122.475017013162 | (37.7782468532741, -122.475017013162) | |||
| 34718 | 34718 | 139271 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 765 FULTON ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6004149.5758 | 2111471.3855 | 37.7779325866279 | -122.42919470092698 | (37.7779325866279, -122.429194700927) | |||
| 34771 | 34771 | 200748 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1667 Quesada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 6014912.0282 | 2094835.2906 | 37.73285680655879 | -122.39080035501699 | (37.7328568065588, -122.390800355017) | |||
| 35019 | 35019 | 239374 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 3517 21st St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 4ft | 6004914.04474 | 2103668.95392 | 37.7565522283139 | -122.425994566404 | (37.7565522283139, -122.425994566404) | |||
| 35422 | 35422 | 239293 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 936 York St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 6ft | 6009925.69316 | 2103743.6378599997 | 37.757039258881 | -122.40866768648199 | (37.757039258881, -122.408667686482) | |||
| 35505 | 35505 | 240160 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 4903 17th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 5997783.51169 | 2105613.08498 | 37.7614847543311 | -122.450794550851 | (37.7614847543311, -122.450794550851) | |||
| 35804 | 35804 | 239300 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 927 York St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 6009964.45155 | 2103786.9298 | 37.757160299531996 | -122.408536698407 | (37.757160299532, -122.408536698407) | |||
| 36074 | 36074 | 240200 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 57 Sussex St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6002464.85342 | 2096514.646 | 37.736769456354 | -122.43395336236401 | (37.736769456354, -122.433953362364) | |||
| 36489 | 36489 | 213993 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 95 Martha Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 2ft | 6000354.21561 | 2095866.7572 | 37.7348705009689 | -122.441204268679 | (37.7348705009689, -122.441204268679) | |||
| 36909 | 36909 | 141968 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 600 FULTON ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 6004837.9618 | 2111622.5068 | 37.778386474037205 | -122.426824094864 | (37.7783864740372, -122.426824094864) | |||
| 37471 | 37471 | 137830 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 2000 FILLMORE ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 6002959.8323 | 2115200.8411 | 37.7881053091283 | -122.433577037034 | (37.7881053091283, -122.433577037034) | |||
| 37577 | 37577 | 213945 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 2612 17th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5991136.47615 | 2097605.20115 | 37.739114449377496 | -122.473199637055 | (37.7391144493775, -122.473199637055) | |||
| 38315 | 38315 | 179295 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 103 Edinburgh St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6004297.98606 | 2093012.3139099998 | 37.727256697520204 | -122.42736600014 | (37.7272566975202, -122.42736600014) | |||
| 38486 | 38486 | 239256 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 3425 26th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6006919.52972 | 2100855.25708 | 37.748939598501394 | -122.418859320098 | (37.7489395985014, -122.418859320098) | |||
| 38945 | 38945 | 239368 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 7 Chattanooga St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 2ft | 6004707.84944 | 2103578.58278 | 37.7562924348615 | -122.426701228489 | (37.7562924348615, -122.426701228489) | |||
| 39057 | 39057 | 120310 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 120 23rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 5988691.601840001 | 2114529.40052 | 37.7854418348342 | -122.482892819932 | (37.7854418348342, -122.482892819932) | |||
| 39170 | 39170 | 75389 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 376 Utah St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/17/1994 12:00:00 AM | 1 | 6010589.86723 | 2106590.9300700002 | 37.7648944592258 | -122.40657134700199 | (37.7648944592258, -122.406571347002) | ||
| 39213 | 39213 | 239316 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1100 Hampshire St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 6ft | 6010239.40016 | 2102763.26328 | 37.7543649341213 | -122.407513645861 | (37.7543649341213, -122.407513645861) | |||
| 39329 | 39329 | 213917 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1651 11th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 4ft | 5992756.585530001 | 2104219.0263799997 | 37.7573679916487 | -122.46807905201 | (37.7573679916487, -122.46807905201) | |||
| 39442 | 39442 | 140393 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1795 O'Farrell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 6002743.2077 | 2113356.8165 | 37.7830297920416 | -122.43419464062299 | (37.7830297920416, -122.434194640623) | |||
| 39948 | 39948 | 239313 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 496 Fair Oaks St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6005503.510559999 | 2100853.22302 | 37.7488541799866 | -122.423755779701 | (37.7488541799866, -122.423755779701) | |||
| 40711 | 40711 | 179300 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 318 Avalon Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 2ft | 6003594.26211 | 2092734.45611 | 37.7264539365874 | -122.42977895945499 | (37.7264539365874, -122.429778959455) | |||
| 40754 | 40754 | 247569 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 326 Alemany Blvd | 1 | : 4 | Tree 1 | Private 1 | 4 | Width 4ft | 6008658.24946 | 2095385.97007 | 37.7340198862064 | -122.41246025166299 | (37.7340198862064, -122.412460251663) | |||
| 40781 | 40781 | 101046 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1050 Sansome St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | 3x3 | Permit Number 774347 | 6012049.4869099995 | 2119300.00717 | 37.799872179210894 | -122.40241656909201 | (37.7998721792109, -122.402416569092) | ||
| 41034 | 41034 | 239281 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 356 Lexington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6006523.17494 | 2104019.48467 | 37.7576055152006 | -122.420454489001 | (37.7576055152006, -122.420454489001) | |||
| 41318 | 41318 | 240143 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 109 Cole St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 2ft | 5998171.35185 | 2106192.58759 | 37.763098116497204 | -122.449494935145 | (37.7630981164972, -122.449494935145) | |||
| 42163 | 42163 | 239262 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1515 15th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6007244.80682 | 2107321.6134599997 | 37.766713033200105 | -122.41819289551 | (37.7667130332001, -122.41819289551) | |||
| 42220 | 42220 | 213980 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 258 Faxon Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5994759.30681 | 2090307.0454 | 37.7192845888893 | -122.460145025196 | (37.7192845888893, -122.460145025196) | |||
| 42229 | 42229 | 240207 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 71 Miguel St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6003881.31618 | 2097271.66945 | 37.738928352668 | -122.429109992458 | (37.738928352668, -122.429109992458) | |||
| 42316 | 42316 | 213920 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 38 Hill Point Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5996379.163369999 | 2106706.8374799998 | 37.764407428690795 | -122.455730647179 | (37.7644074286908, -122.455730647179) | |||
| 43340 | 43340 | 239340 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 255 Mullen Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6010272.59019 | 2100048.52485 | 37.746912719065 | -122.407207511226 | (37.746912719065, -122.407207511226) | |||
| 43382 | 43382 | 246032 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 11 Belvedere St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5998172.7746 | 2108470.8044 | 37.7693536035765 | -122.44965419238501 | (37.7693536035765, -122.449654192385) | |||
| 43844 | 43844 | 245441 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 2911 16th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 6007346.0609 | 2106731.0495 | 37.7650971816433 | -122.417800808591 | (37.7650971816433, -122.417800808591) | |||
| 44044 | 44044 | 197100 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 372 Pennsylvania Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 4ft | 6014303.71981 | 2105387.22588 | 37.7617964269902 | -122.393641721993 | (37.7617964269902, -122.393641721993) | |||
| 44126 | 44126 | 139470 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 718 BRODERICK ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 6001058.4613 | 2111279.9264 | 37.7772314157742 | -122.439874199844 | (37.7772314157742, -122.439874199844) | |||
| 44193 | 44193 | 240203 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 50 Sussex St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6002560.6439 | 2096455.85562 | 37.736613467133004 | -122.433617972817 | (37.736613467133, -122.433617972817) | |||
| 44291 | 44291 | 247563 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 316 Alemany Blvd | 1 | : 4 | Tree 1 | Private 1 | 5 | Width 4ft | 6008788.9631 | 2095462.99791 | 37.734238722726495 | -122.41201377422199 | (37.7342387227265, -122.412013774222) | |||
| 44326 | 44326 | 239263 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1511 15th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6007270.56824 | 2107323.19533 | 37.766718826649296 | -122.418103903074 | (37.7667188266493, -122.418103903074) | |||
| 44502 | 44502 | 202037 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 75 Crane St | 1 | : 4 | Tree 1 | Private 1 | 2 | Width 3ft | 6012270.3118199995 | 2090901.9422 | 37.7219097135375 | -122.399657426574 | (37.7219097135375, -122.399657426574) | |||
| 44521 | 44521 | 136250 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 2711 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6006868.56519 | 2121594.39083 | 37.8058813915667 | -122.420507486038 | (37.8058813915667, -122.420507486038) |
JSON shape: default, array, newline-delimited
CREATE TABLE "Street_Tree_List" (
"TreeID" INTEGER,
"qLegalStatus" INTEGER,
"qSpecies" INTEGER,
"qAddress" TEXT,
"SiteOrder" INTEGER,
"qSiteInfo" INTEGER,
"PlantType" INTEGER,
"qCaretaker" INTEGER,
"qCareAssistant" INTEGER,
"PlantDate" TEXT,
"DBH" INTEGER,
"PlotSize" TEXT,
"PermitNotes" TEXT,
"XCoord" REAL,
"YCoord" REAL,
"Latitude" REAL,
"Longitude" REAL,
"Location" TEXT
,
FOREIGN KEY ("PlantType") REFERENCES [PlantType](id),
FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id),
FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id),
FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id),
FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id),
FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id));
CREATE INDEX ["Street_Tree_List_PlantType"] ON [Street_Tree_List]("PlantType");
CREATE INDEX ["Street_Tree_List_qCaretaker"] ON [Street_Tree_List]("qCaretaker");
CREATE INDEX ["Street_Tree_List_qSpecies"] ON [Street_Tree_List]("qSpecies");
CREATE INDEX ["Street_Tree_List_qSiteInfo"] ON [Street_Tree_List]("qSiteInfo");
CREATE INDEX ["Street_Tree_List_qCareAssistant"] ON [Street_Tree_List]("qCareAssistant");
CREATE INDEX ["Street_Tree_List_qLegalStatus"] ON [Street_Tree_List]("qLegalStatus");